eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_XML_DELIVERY dependencies on PO_HEADERS_ALL

Line 84: -- if (if revision_num in po_headers_all for the document id is 0,

80: end if;
81:
82: --get the po_header_id for item passed and assign it to document_id.
83: --get the version number (in case PO Change) and assign it to PARAMETER1.
84: -- if (if revision_num in po_headers_all for the document id is 0,
85: -- it is a new PO) then
86: -- document_type = 'POO';
87: -- else
88: -- document_type = 'POCO'

Line 104: from po_headers_all poh,po_releases_all por

100:
101: select por.revision_num,poh.vendor_id,poh.vendor_site_id,
102: poh.po_header_id
103: into l_revision_num,l_vendor_id ,l_vendor_site_id,l_doc_id
104: from po_headers_all poh,po_releases_all por
105: where poh.po_header_id=por.po_header_id
106: and por.po_release_id = l_doc_rel_id;
107: elsif (l_doc_type = 'PO' or l_doc_type = 'STANDARD') then --for standard POs.
108: select revision_num,vendor_id,vendor_site_id

Line 110: from po_headers_all

106: and por.po_release_id = l_doc_rel_id;
107: elsif (l_doc_type = 'PO' or l_doc_type = 'STANDARD') then --for standard POs.
108: select revision_num,vendor_id,vendor_site_id
109: into l_revision_num,l_vendor_id ,l_vendor_site_id
110: from po_headers_all
111: where po_header_id= l_doc_id;
112: else
113: x_progress := 'PO_XML_DELIVERY.: call_txn_delivery:02: POs of type ' || l_doc_type || 'is not supported for XML Delivery';
114: wf_core.context('PO_XML_DELIVERY','call_txn_delivery',x_progress);

Line 194: from po_headers_all

190:
191: if (l_po_type = 'STANDARD' or l_po_type = 'PO') then
192: select segment1, org_id, vendor_id, vendor_site_id, comments, type_lookup_code,creation_date
193: into l_po_number, l_org_id, l_party_id, l_party_site_id, l_po_desc, l_po_subtype,l_doc_creation_date
194: from po_headers_all
195: where po_header_id = l_po_header_id;
196: elsif (l_po_type = 'RELEASE') then
197: --In case of RELEASE DOCUMENT_ID will have the RELEASE_ID.
198: --Copy it over here so, it is less confusing.

Line 205: from po_headers_all poh,po_releases_all por

201: select poh.segment1 || ':' || to_char(por.release_num), poh.org_id,
202: poh.vendor_id, poh.vendor_site_id, poh.comments,poh.creation_date
203: into l_po_number, l_org_id, l_party_id, l_party_site_id, l_po_desc,
204: l_doc_creation_date
205: from po_headers_all poh,po_releases_all por
206: where poh.po_header_id=por.po_header_id
207: and por.po_release_id = l_doc_rel_id;
208:
209: l_po_subtype := 'RELEASE';

Line 220: from po_headers_all

216: */
217: select segment1, org_id, vendor_id, vendor_site_id, comments,creation_date
218: into l_po_number, l_org_id, l_party_id, l_party_site_id,l_po_desc,
219: l_doc_creation_date
220: from po_headers_all
221: where po_header_id = l_po_header_id;
222:
223:
224: end if;

Line 364: -- if (if revision_num in po_headers_all for the document id is 0,

360:
361:
362: --get the po_header_id for item passed and assign it to document_id.
363: --get the version number (in case PO Change) and assign it to PARAMETER1.
364: -- if (if revision_num in po_headers_all for the document id is 0,
365: -- it is a new PO) then
366: -- document_type = 'POO';
367: -- else
368: -- document_type = 'POCO'

Line 436: from po_headers_all poh,po_releases_all por

432:
433: select por.revision_num,poh.vendor_id,poh.vendor_site_id,
434: poh.po_header_id, por.cancel_flag
435: into l_revision_num,l_vendor_id ,l_vendor_site_id,l_doc_id, l_cancel_flag --B4407795,reading cancel flag
436: from po_headers_all poh,po_releases_all por
437: where poh.po_header_id=por.po_header_id
438: and por.po_release_id = l_doc_rel_id;
439:
440:

Line 444: from po_headers_all

440:
441: elsif (l_doc_type = 'PO' or l_doc_type = 'STANDARD') then --for standard POs.
442: select revision_num,vendor_id,vendor_site_id,cancel_flag
443: into l_revision_num,l_vendor_id ,l_vendor_site_id, l_cancel_flag --B4407795,reading cancel flag
444: from po_headers_all
445: where po_header_id= l_doc_id;
446: else
447: x_progress := 'PO_XML_DELIVERY.: set_delivery_data:02: POs of type ' || l_doc_type || 'is not supported for XML Delivery';
448: wf_core.context('PO_XML_DELIVERY', 'set_delivery_data',x_progress);

Line 763: from po_headers_all poh,po_releases_all por

759: l_doc_rel_id := l_doc_id;
760:
761:
762: select por.xml_flag,poh.agent_id into l_xml_flag, l_agent_id
763: from po_headers_all poh,po_releases_all por
764: where poh.po_header_id=por.po_header_id
765: and por.po_release_id = l_doc_rel_id;
766:
767: elsif (l_doc_type = 'STANDARD' or l_doc_type = 'PO') then --for standard POs.

Line 770: from po_headers_all poh

766:
767: elsif (l_doc_type = 'STANDARD' or l_doc_type = 'PO') then --for standard POs.
768: x_progress := 'PO_XML_DELIVERY.is_xml_chosen : 04';
769: select poh.xml_flag, poh.agent_id into l_xml_flag, l_agent_id
770: from po_headers_all poh
771: where po_header_id= l_doc_id;
772: end if;
773: x_progress := 'PO_XML_DELIVERY.is_xml_chosen : 05';
774: if l_xml_flag = 'Y' then

Line 799: update po_headers_all

795: PRAGMA AUTONOMOUS_TRANSACTION;
796: begin
797: if(p_document_type ='STANDARD') then
798: if(p_txn_type = 'PRO') then
799: update po_headers_all
800: set xml_send_date = sysdate
801: where
802: po_header_id = p_header_id and
803: org_id = p_org_id;

Line 813: update po_headers_all

809: org_id = p_org_id and
810: revision_num = 0;
811:
812: elsif(p_txn_type = 'POCO') then
813: update po_headers_all
814: set xml_change_send_date = sysdate
815: where
816: po_header_id = p_header_id and
817: org_id = p_org_id;

Line 937: from po_headers_all

933: begin
934: if(p_document_type = 'STANDARD') then
935: select xml_change_send_date, xml_send_date into
936: l_poco_date, l_pro_date
937: from po_headers_all
938: where po_header_id = p_header_id;
939: if(l_poco_date is not null) then
940: out_date := l_poco_date;
941: elsif(l_pro_date is not null) then

Line 981: from po_headers_all

977: begin
978:
979: --To fix bug# 5877293
980: select type_lookup_code into doc_type
981: from po_headers_all
982: where po_header_id= p_header_id;
983:
984: if doc_type = 'BLANKET' then
985:

Line 1053: from po_headers_all

1049: doc_type varchar2(10);
1050: begin
1051: --To fix bug# 5877293
1052: select type_lookup_code into doc_type
1053: from po_headers_all
1054: where po_header_id= p_header_id;
1055:
1056: if doc_type = 'BLANKET' then
1057: select max(revision_num) into l_one

Line 1118: from ap_cards_all aca, ap_card_programs_all acpa, po_headers_all pha

1114: if(p_document_type = 'STANDARD') then
1115: select aca.card_number, aca.cardmember_name,aca.card_expiration_date,
1116: acpa.card_brand_lookup_code
1117: into p_card_num, p_card_name, p_card_exp_date, p_card_brand
1118: from ap_cards_all aca, ap_card_programs_all acpa, po_headers_all pha
1119: where pha.po_header_id = p_header_id
1120: and pha.pcard_id = aca.card_id
1121: and aca.card_program_id = acpa.card_program_id;
1122: else

Line 1136: from ap_card_suppliers_all acsa, po_headers_all pha

1132:
1133: if(p_document_type = 'STANDARD') then
1134: select count(1)
1135: into is_supplier_pcard
1136: from ap_card_suppliers_all acsa, po_headers_all pha
1137: where acsa.card_id = pha.pcard_id
1138: and po_header_id = p_header_id;
1139: else
1140: select count(1)

Line 1150: from po_vendors pva, po_headers_all pha

1146: end if;
1147:
1148: if(is_supplier_pcard > 0) then
1149: select pva.vendor_name into p_card_name
1150: from po_vendors pva, po_headers_all pha
1151: where pha.po_header_id = p_header_id and
1152: pva.vendor_id = pha.vendor_id;
1153: -- p_card_name := 'Supplier P-Card';
1154:

Line 1422: from PO_RELEASES_ARCHIVE_ALL praa, po_headers_all pha

1418:
1419: select PHA.SEGMENT1, PRAA.REVISION_NUM,
1420: PRAA.RELEASE_NUM
1421: into l_ponum, l_revision_num, l_release_num
1422: from PO_RELEASES_ARCHIVE_ALL praa, po_headers_all pha
1423: where PHA.PO_HEADER_ID = PRAA.PO_HEADER_ID and
1424: praa.po_release_id = l_release_id and
1425: praa.revision_num = l_revision_num;
1426:

Line 1806: from po_headers_all

1802:
1803:
1804: select ship_to_location_id, org_id
1805: into l_location_id, x_partner_id
1806: from po_headers_all
1807: where po_header_id = p_po_header_id;
1808:
1809:
1810: