65: l_org_id_tbl l_org_id_list_type;
66: l_rowid_char_tbl l_rowid_char_tbl_type;
67:
68: --
69: -- replace po_request_action call with po_document_action_pvt.do_return call
70: l_ret_sts VARCHAR2(1);
71: l_online_report_id NUMBER;
72: l_return_code VARCHAR2(25);
73: l_error_message VARCHAR2(2000);
145: x_req_header_id_succ_tbl := PO_TBL_NUMBER();
146:
147:
148: --
149: -- Use PO_DOCUMENT_ACTION_PVT.do_return instead of po_request_action call
150:
151: FOR i IN 1..l_num_lines
152: LOOP
153:
150:
151: FOR i IN 1..l_num_lines
152: LOOP
153:
154: PO_DOCUMENT_ACTION_PVT.do_return(
155: p_document_id => p_req_header_id_tbl(i)
156: , p_document_type => 'REQUISITION'
157: , p_document_subtype => l_doc_sub_type_tbl(i)
158: , p_note => p_reason
477: --
478:
479: ELSIF (action = 'VERIFY_AUTHORITY_CHECK') THEN
480:
481: PO_DOCUMENT_ACTION_PVT.verify_authority(
482: p_document_id => document_id
483: , p_document_type => document_type
484: , p_document_subtype => document_subtype
485: , p_employee_id => employee_id
834: ** Call the document manager with the HOLD_DOCUMENT action code
835: */
836:
837: --
838: -- Use po_document_action_pvt.do_hold instead po_request_action
839:
840: PO_DOCUMENT_ACTION_PVT.do_hold(
841: p_document_id => X_Document_Id
842: , p_document_type => X_Document_Type
836:
837: --
838: -- Use po_document_action_pvt.do_hold instead po_request_action
839:
840: PO_DOCUMENT_ACTION_PVT.do_hold(
841: p_document_id => X_Document_Id
842: , p_document_type => X_Document_Type
843: , p_document_subtype => X_Document_Subtype
844: , p_reason => NULL