APPS.INV_INVTRDST_XMLP_PKG dependencies on PO_HEADERS_ALL

Line 764: from po_headers_all

760: begin
761: txn_source_id := Source;
762: org_id := P_org_id;
763: if Type_id = 1 then select segment1 into txn_source
764: from po_headers_all
765: where po_header_id = to_number(txn_source_id);
766: return(txn_source);
767: elsif Type_id = 4 then --for Bug#3919355
768: select request_number into txn_source

Line 843: from po_headers_all

839: begin
840: txn_source_id := Source1;
841: org_id := P_org_id;
842: if Type_id1 = 1 then select segment1 into txn_source
843: from po_headers_all
844: where po_header_id = to_number(txn_source_id);
845: return(txn_source);
846: elsif Type_id1 = 4 then --For Bug#3919355
847: select request_number into txn_source

Line 922: from po_headers_all

918: begin
919: txn_source_id := Source2;
920: org_id := P_org_id;
921: if Type_id2 = 1 then select segment1 into txn_source
922: from po_headers_all
923: where po_header_id = to_number(txn_source_id);
924: return(txn_source);
925: elsif Type_id2 = 4 then --For Bug#3919355
926: select request_number into txn_source

Line 1001: from po_headers_all

997: begin
998: txn_source_id := Source3;
999: org_id := P_org_id;
1000: if Type_id3 = 1 then select segment1 into txn_source
1001: from po_headers_all
1002: where po_header_id = to_number(txn_source_id);
1003: return(txn_source);
1004: elsif Type_id3 = 4 then --For Bug#3919355
1005: select request_number into txn_source

Line 1080: from po_headers_all

1076: begin
1077: txn_source_id := Source4;
1078: org_id := P_org_id;
1079: if Type_id4 = 1 then select segment1 into txn_source
1080: from po_headers_all
1081: where po_header_id = to_number(txn_source_id);
1082: return(txn_source);
1083: elsif Type_id4 = 4 then --For Bug#3919355
1084: select request_number into txn_source