DBA Data[Home] [Help]

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 2484: from po_headers_archive_all

2480: Begin
2481: IF p_document_type in ('STANDARD','BLANKET','CONTRACT') THEN
2482: select max(revision_num)
2483: into l_revision_num
2484: from po_headers_archive_all
2485: where po_header_id = p_document_id
2486: and authorization_status = 'APPROVED';
2487: ELSE
2488: select max(revision_num)

Line 4250: FROM po_vendors vn, po_headers_archive_all ph

4246: /*Bug5983107 Modifying the below sql by removing reference to hr_all_organization_units*/
4247:
4248: SELECT vn.vendor_name, ph.segment1, ph.change_summary, ph.vendor_id, ph.currency_code
4249: INTO l_supp_org, l_po_number, l_change_summary, l_vendor_id, g_current_currency_code
4250: FROM po_vendors vn, po_headers_archive_all ph
4251: WHERE vn.vendor_id = ph.vendor_id
4252: AND ph.po_header_id = p_document_id AND ph.revision_num = p_revision_num;
4253:
4254: SELECT count(distinct(plla.SHIP_TO_LOCATION_ID)) INTO PO_COMMUNICATION_PVT.g_dist_shipto_count

Line 5266: from po_headers_archive_all pb, po_releases_archive_all pr

5262: and ''Y'' = decode(nvl(pllaa.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllaa.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) )
5263: and plx.po_header_id = phx.po_header_id
5264: AND plx.REVISION_NUM = (select max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
5265: and pla.revision_num <= (select max(pb.revision_num)
5266: from po_headers_archive_all pb, po_releases_archive_all pr
5267: where pb.po_header_id = pr.po_header_id
5268: and pr.po_release_id = pcgt.po_release_id
5269: and pr.revision_num= pcgt.revision_number
5270: and pb.approved_date <= pr.approved_date

Line 6186: PO_HEADERS_ARCHIVE_ALL PHA

6182: PO_COMMUNICATION_PVT.g_arcBuyer_title, PO_COMMUNICATION_PVT.g_arcAgent_id
6183:
6184: FROM
6185: PER_ALL_PEOPLE_F HRE,
6186: PO_HEADERS_ARCHIVE_ALL PHA
6187: WHERE
6188: HRE.PERSON_ID = PHA.AGENT_ID AND
6189: --HRE.EMPLOYEE_NUMBER IS NOT NULL AND --
6190: TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND

Line 6997: FROM po_headers_archive_all poha

6993: d_progress := 20;
6994:
6995: SELECT poha.style_id
6996: INTO l_style_id
6997: FROM po_headers_archive_all poha
6998: WHERE poha.po_header_id = p_document_id
6999: AND poha.revision_num = p_revision_num;
7000:
7001: d_progress := 25;