APPS.PA_PO_INTEGRATION_UTILS dependencies on DUAL

Line 52: FROM dual

48: BEGIN
49:
50: select 1
51: into l_uninterfaced_to_pa
52: FROM dual
53: WHERE EXISTS
54: (SELECT 1 FROM rcv_transactions rcv_txn,
55: rcv_receiving_sub_ledger rcv_sub
56: ,po_distributions_all podist/*Bug 3905697*/

Line 90: FROM dual

86: BEGIN
87:
88: select 1
89: into l_uninterfaced_to_pa
90: FROM dual
91: WHERE EXISTS
92: (SELECT 1 FROM rcv_transactions rcv_txn,
93: rcv_receiving_sub_ledger rcv_sub
94: ,po_distributions_all podist/*Bug 3905697*/

Line 714: FROM dual;

710: FOR erec IN c_transf_budg_tonewsupp(l_po_header_id, l_vendor_id) LOOP
711:
712: SELECT po_multi_mod_val_results_s.nextval
713: INTO l_multi_mod_val_result_id
714: FROM dual;
715:
716: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,
717: p_multi_mod_request_id => p_request_id,
718: p_result_type => 'WARNING',

Line 753: FROM dual;

749: FOR erec IN c_pending_receipts( l_po_header_id ) LOOP
750:
751: SELECT po_multi_mod_val_results_s.nextval
752: INTO l_multi_mod_val_result_id
753: FROM dual;
754:
755: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,
756: p_multi_mod_request_id => p_request_id,
757: p_result_type => 'WARNING',

Line 809: FROM dual;

805: FOR erec IN c_po_commitments( l_po_header_id ) LOOP
806:
807: SELECT po_multi_mod_val_results_s.nextval
808: INTO l_multi_mod_val_result_id
809: FROM dual;
810:
811: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,
812: p_multi_mod_request_id => p_request_id,
813: p_result_type => 'WARNING',

Line 847: FROM dual;

843: FOR erec IN c_check_supp_budgctrl(l_po_header_id, l_vendor_id) LOOP
844:
845: SELECT po_multi_mod_val_results_s.nextval
846: INTO l_multi_mod_val_result_id
847: FROM dual;
848:
849: l_related_document_number :=erec.segment1||'/'||erec.budget_type;
850:
851: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,

Line 886: FROM dual;

882: FOR erec IN c_pending_deliverables(l_po_header_id) LOOP
883:
884: SELECT po_multi_mod_val_results_s.nextval
885: INTO l_multi_mod_val_result_id
886: FROM dual;
887:
888: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,
889: p_multi_mod_request_id => p_request_id,
890: p_result_type => 'WARNING',

Line 925: FROM dual;

921: FOR erec IN c_update_doc(l_po_header_id) LOOP
922:
923: SELECT po_multi_mod_val_results_s.nextval
924: INTO l_multi_mod_val_result_id
925: FROM dual;
926:
927: x_validation_results.add_result (p_multi_mod_val_result_id => l_multi_mod_val_result_id,
928: p_multi_mod_request_id => p_request_id,
929: p_result_type => 'WARNING',