APPS.PO_COMMUNICATION_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type := null;

59: g_line_id PO_LINES_ALL.FROM_LINE_ID%type := null;
60: g_arcBuyer_fname PER_ALL_PEOPLE_F.FIRST_NAME%type := null;
61: g_arcBuyer_lname PER_ALL_PEOPLE_F.LAST_NAME%type := null;
62: g_arcBuyer_title PER_ALL_PEOPLE_F.TITLE%type := null;
63: g_arcAgent_id PO_HEADERS_ARCHIVE_ALL.AGENT_ID%type := null;
64: g_header_id1 PO_HEADERS_ALL.PO_HEADER_ID%type := null;
65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%type := null;
66: g_timezone VARCHAR2(255) := NULL;
67: g_vendor_address_line_2 PO_VENDOR_SITES.ADDRESS_LINE2%type := null;

Line 2872: from po_headers_archive_all

2868: Begin
2869: IF p_document_type in ('STANDARD', 'BLANKET', 'CONTRACT') THEN
2870: select max(revision_num)
2871: into l_revision_num
2872: from po_headers_archive_all
2873: where po_header_id = p_document_id
2874: and authorization_status = 'APPROVED';
2875: ELSE
2876: select max(revision_num)

Line 5008: FROM po_vendors vn, po_headers_archive_all ph

5004: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
5005:
5006: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
5007: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
5008: FROM po_vendors vn, po_headers_archive_all ph
5009: WHERE vn.vendor_id = ph.vendor_id
5010: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
5011:
5012: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

Line 5930: l_price_modifier_query3 := 'CURSOR (SELECT pha.segment1 ponum FROM po_headers_archive_all pha '

5926: l_price_modifier_query2 := 'CURSOR (SELECT pax2.* FROM PO_PRICE_ADJS_ARCHIVE_XML pax2 '
5927: || 'WHERE pax2.po_header_id = plx.from_header_id AND pax2.po_line_id = plx.from_line_id '
5928: || 'AND pax2.revision_num= PO_COMMUNICATION_PVT.getRevisionNum() AND '
5929: || 'pax2.parent_adjustment_id is null order by pax2.pricing_group_sequence) AS ADD_PRICE_MODIFIERS';
5930: l_price_modifier_query3 := 'CURSOR (SELECT pha.segment1 ponum FROM po_headers_archive_all pha '
5931: || 'WHERE pha.po_header_id = plx.from_header_id) AS ADD_PRICE_PONUM';
5932: --
5933:
5934: /* Bug#3574748: Added the condition SHIPMENT_TYPE in ('BLANKET','STANDARD') in shipment query. */

Line 6151: from po_headers_archive_all pb, po_releases_archive_all pr

6147: and ''Y'' = decode(nvl(pllaa.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllaa.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) )
6148: and plx.po_header_id = phx.po_header_id
6149: AND plx.REVISION_NUM = (select /*+ push_subq no_unnest */ max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
6150: and pla.revision_num <= (select max(pb.revision_num)
6151: from po_headers_archive_all pb, po_releases_archive_all pr
6152: where pb.po_header_id = pr.po_header_id
6153: and pr.po_release_id = pcgt.po_release_id
6154: and pr.revision_num= pcgt.revision_number
6155: and pb.approved_date <= pr.approved_date

Line 7294: PO_HEADERS_ARCHIVE_ALL PHA,

7290: PO_COMMUNICATION_PVT.g_arcBuyer_title, PO_COMMUNICATION_PVT.g_arcAgent_id
7291:
7292: FROM
7293: PER_ALL_PEOPLE_F HRE,
7294: PO_HEADERS_ARCHIVE_ALL PHA,
7295: HR_LOOKUPS HRL
7296: WHERE HRL.LOOKUP_CODE(+) = HRE.TITLE AND
7297: HRL.LOOKUP_TYPE(+) = 'TITLE' AND
7298: HRE.PERSON_ID = PHA.AGENT_ID AND

Line 8192: FROM po_headers_archive_all poha

8188: d_progress := 20;
8189:
8190: SELECT poha.style_id
8191: INTO l_style_id
8192: FROM po_headers_archive_all poha
8193: WHERE poha.po_header_id = p_document_id
8194: AND poha.revision_num = p_revision_num;
8195:
8196: d_progress := 25;