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);
183: --In case of error, the txn will be rolled back.
184: --<
185:
186: --
187: -- Use PO_DOCUMENT_ACTION_PVT.do_return instead of po_request_action call
188:
189: FOR i IN 1..l_num_lines
190: LOOP
191:
188:
189: FOR i IN 1..l_num_lines
190: LOOP
191:
192: PO_DOCUMENT_ACTION_PVT.do_return(
193: p_document_id => p_req_header_id_tbl(i)
194: , p_document_type => 'REQUISITION'
195: , p_document_subtype => l_doc_sub_type_tbl(i)
196: , p_note => p_reason
515: --
516:
517: ELSIF (action = 'VERIFY_AUTHORITY_CHECK') THEN
518:
519: PO_DOCUMENT_ACTION_PVT.verify_authority(
520: p_document_id => document_id
521: , p_document_type => document_type
522: , p_document_subtype => document_subtype
523: , p_employee_id => employee_id
872: ** Call the document manager with the HOLD_DOCUMENT action code
873: */
874:
875: --
876: -- Use po_document_action_pvt.do_hold instead po_request_action
877:
878: PO_DOCUMENT_ACTION_PVT.do_hold(
879: p_document_id => X_Document_Id
880: , p_document_type => X_Document_Type
874:
875: --
876: -- Use po_document_action_pvt.do_hold instead po_request_action
877:
878: PO_DOCUMENT_ACTION_PVT.do_hold(
879: p_document_id => X_Document_Id
880: , p_document_type => X_Document_Type
881: , p_document_subtype => X_Document_Subtype
882: , p_reason => NULL