DBA Data[Home] [Help]

APPS.INV_INVTRDST_XMLP_PKG dependencies on PO_HEADERS_ALL

Line 848: from po_headers_all

844: begin
845: txn_source_id := Source;
846: org_id := P_org_id;
847: if Type_id = 1 then select segment1 into txn_source
848: from po_headers_all
849: where po_header_id = to_number(txn_source_id);
850: return(txn_source);
851: elsif Type_id = 4 then --for Bug#3919355
852: select request_number into txn_source

Line 927: from po_headers_all

923: begin
924: txn_source_id := Source1;
925: org_id := P_org_id;
926: if Type_id1 = 1 then select segment1 into txn_source
927: from po_headers_all
928: where po_header_id = to_number(txn_source_id);
929: return(txn_source);
930: elsif Type_id1 = 4 then --For Bug#3919355
931: select request_number into txn_source

Line 1006: from po_headers_all

1002: begin
1003: txn_source_id := Source2;
1004: org_id := P_org_id;
1005: if Type_id2 = 1 then select segment1 into txn_source
1006: from po_headers_all
1007: where po_header_id = to_number(txn_source_id);
1008: return(txn_source);
1009: elsif Type_id2 = 4 then --For Bug#3919355
1010: select request_number into txn_source

Line 1085: from po_headers_all

1081: begin
1082: txn_source_id := Source3;
1083: org_id := P_org_id;
1084: if Type_id3 = 1 then select segment1 into txn_source
1085: from po_headers_all
1086: where po_header_id = to_number(txn_source_id);
1087: return(txn_source);
1088: elsif Type_id3 = 4 then --For Bug#3919355
1089: select request_number into txn_source

Line 1164: from po_headers_all

1160: begin
1161: txn_source_id := Source4;
1162: org_id := P_org_id;
1163: if Type_id4 = 1 then select segment1 into txn_source
1164: from po_headers_all
1165: where po_header_id = to_number(txn_source_id);
1166: return(txn_source);
1167: elsif Type_id4 = 4 then --For Bug#3919355
1168: select request_number into txn_source