Oracle EBS: 使用 po_actions.close_po API 來 close BPA

試了試, 跟close PO相似, 不難.

    v_value := po_actions.close_po (p_docid       => r1.po_header_id,

                              p_doctyp          => 'PA',
                              p_docsubtyp       => 'BLANKET',
                              p_lineid          => r1.po_line_id, --
                              p_shipid          => null , --r1.line_location_id,--
                              p_action          => 'CLOSE',
                              p_reason          => '因應改為議價',
                              p_calling_mode    => NULL,
                              p_conc_flag       => 'N',
                              p_return_code     => v_return_code,
                              p_auto_close      => 'N',
                              p_action_date     => sysdate, --NULL,
                              p_origin_doc_id   => NULL);


但太久沒執行這類API, 忘了先執行前置動作, 多花了一些時間:

  fnd_global.apps_initialize (user_id => 1,

                              resp_id => 201,
                              resp_appl_id => 53289);


再加個cursor就批次作完了~