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_COMMUNICATION_PVT dependencies on PO_RELEASES

Line 65: g_release_id PO_RELEASES_ALL.PO_RELEASE_ID%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;
68: g_vendor_address_line_3 PO_VENDOR_SITES.ADDRESS_LINE3%type := null;
69: g_vendor_country FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%type :=null;

Line 629: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186;

625:
626: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
627: l_docNumber PO_HEADERS_ALL.SEGMENT1%TYPE;
628: l_doc_num_rel varchar2(30);
629: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186;
630: l_ga_flag varchar2(1) := null; -- Bug # 3290385
631: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
632: l_attachments_exist VARCHAR2(1); --
633:

Line 732: from po_releases_all

728:
729: -- Bug # 3290385 Start
730: if p_document_type = 'RELEASE' then
731: select po_header_id,release_num into l_document_id,l_release_num
732: from po_releases_all
733: where
734: po_release_id=p_document_id;
735: else
736: l_document_id:=p_document_id;

Line 793: from po_headers poh, po_vendor_sites pvs, po_releases por

789:
790: if p_document_type = 'RELEASE' then
791: select poh.vendor_site_id, pvs.vendor_site_code, pvs.language
792: into l_vendor_site_id, l_vendor_site_code, l_vendor_site_lang
793: from po_headers poh, po_vendor_sites pvs, po_releases por
794: where pvs.vendor_site_id = poh.vendor_site_id
795: and poh.po_header_id = por.po_header_id
796: and por.po_release_id = p_document_id;
797: else

Line 1198: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all

1194: fnd_attached_documents ad,
1195: fnd_doc_category_usages dcu,
1196: fnd_attachment_functions af,
1197: fnd_lobs fl
1198: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1199: where po_release_id=l_po_release_id
1200: )) and ad.entity_name='PO_HEADERS')
1201: OR
1202: (ad.pk1_value=to_char(l_po_release_id) and ad.entity_name='PO_RELEASES')

Line 1202: (ad.pk1_value=to_char(l_po_release_id) and ad.entity_name='PO_RELEASES')

1198: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1199: where po_release_id=l_po_release_id
1200: )) and ad.entity_name='PO_HEADERS')
1201: OR
1202: (ad.pk1_value=to_char(l_po_release_id) and ad.entity_name='PO_RELEASES')
1203: OR
1204: (ad.pk1_value=to_char((select pha.vendor_id
1205: from po_headers_all pha,po_releases_all pra
1206: where pra.po_release_id=l_po_release_id

Line 1205: from po_headers_all pha,po_releases_all pra

1201: OR
1202: (ad.pk1_value=to_char(l_po_release_id) and ad.entity_name='PO_RELEASES')
1203: OR
1204: (ad.pk1_value=to_char((select pha.vendor_id
1205: from po_headers_all pha,po_releases_all pra
1206: where pra.po_release_id=l_po_release_id
1207: and pha.po_header_id=pra.po_header_id
1208: )) and ad.entity_name='PO_VENDORS')
1209: OR

Line 1386: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all

1382: fnd_attached_documents ad,
1383: fnd_doc_category_usages dcu,
1384: fnd_attachment_functions af,
1385: fnd_lobs fl
1386: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1387: where po_release_id=l_document_id
1388: )) and ad.entity_name='PO_HEADERS')
1389: OR
1390: (ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_RELEASES')

Line 1390: (ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_RELEASES')

1386: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
1387: where po_release_id=l_document_id
1388: )) and ad.entity_name='PO_HEADERS')
1389: OR
1390: (ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_RELEASES')
1391: OR
1392: (ad.pk1_value=(select pha.vendor_id
1393: from po_headers_all pha,po_releases_all pra
1394: where pra.po_release_id=l_document_id

Line 1393: from po_headers_all pha,po_releases_all pra

1389: OR
1390: (ad.pk1_value=to_char(l_document_id) and ad.entity_name='PO_RELEASES')
1391: OR
1392: (ad.pk1_value=(select pha.vendor_id
1393: from po_headers_all pha,po_releases_all pra
1394: where pra.po_release_id=l_document_id
1395: and pha.po_header_id=pra.po_header_id
1396: ) and ad.entity_name='PO_VENDORS')
1397: OR

Line 1700: SELECT po_header_id into l_header_id FROM po_releases_all

1696:
1697: IF l_document_type in ('PO','PA') and l_document_subtype in ('STANDARD','BLANKET','CONTRACT') THEN
1698: l_header_id := l_document_id;
1699: ELSE
1700: SELECT po_header_id into l_header_id FROM po_releases_all
1701: WHERE po_release_id = l_document_id;
1702: END IF;
1703:
1704: SELECT pv.language into l_supp_lang

Line 1973: l_po_release_id po_releases.po_release_id%type := NULL;

1969: p_request_id out NOCOPY number) is
1970:
1971: l_po_num po_headers.segment1%type := NULL;
1972: l_po_header_id po_headers.po_header_id%type := NULL;
1973: l_po_release_id po_releases.po_release_id%type := NULL;
1974: l_communication varchar2(1);
1975: l_api_name CONSTANT VARCHAR2(25):= 'launch_communicate';
1976:
1977:

Line 2326: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr

2322: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2323: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2324: else
2325: l_entity_name := 'PO_REL';
2326: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr
2327: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2328: ph.vendor_site_id = pvs.vendor_site_id ;
2329: end if;
2330: IF g_debug_stmt THEN

Line 2490: from po_releases_archive_all

2486: and authorization_status = 'APPROVED';
2487: ELSE
2488: select max(revision_num)
2489: into l_revision_num
2490: from po_releases_archive_all
2491: where po_release_id = p_document_id
2492: and authorization_status = 'APPROVED';
2493: END IF;
2494: Exception

Line 2725: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr

2721: if p_document_type in ('STANDARD','BLANKET','CONTRACT') then
2722: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph
2723: where po_header_id = p_document_id and ph.vendor_site_id = pvs.vendor_site_id ;
2724: else
2725: select pvs.language into l_supp_lang from po_vendor_sites pvs , po_headers_all ph,po_releases_all pr
2726: where ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id and
2727: ph.vendor_site_id = pvs.vendor_site_id ;
2728: end if;
2729:

Line 3394: po_releases_all pr, fnd_languages fl

3390: and pvs.language = fl.nls_language;
3391: elsif l_document_type = 'RELEASE' then
3392: select fl.language_code into l_language
3393: from po_vendor_sites_all pvs , po_headers_all ph,
3394: po_releases_all pr, fnd_languages fl
3395: where ph.po_header_id = pr.po_header_id
3396: and pr.po_release_id = l_document_id
3397: and ph.vendor_site_id = pvs.vendor_site_id
3398: and pvs.language = fl.nls_language;

Line 3979: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all

3975: fnd_attached_documents ad,
3976: fnd_doc_category_usages dcu,
3977: fnd_attachment_functions af,
3978: fnd_lobs fl
3979: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
3980: where po_release_id=p_document_id
3981: )) and ad.entity_name='PO_HEADERS')
3982: OR
3983: (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_RELEASES')

Line 3983: (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_RELEASES')

3979: where ((ad.pk1_value=to_char((select po_header_id from po_releases_all
3980: where po_release_id=p_document_id
3981: )) and ad.entity_name='PO_HEADERS')
3982: OR
3983: (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_RELEASES')
3984: OR
3985: (ad.pk1_value=to_char((select pha.vendor_id
3986: from po_headers_all pha,po_releases_all pra
3987: where pra.po_release_id=p_document_id

Line 3986: from po_headers_all pha,po_releases_all pra

3982: OR
3983: (ad.pk1_value=to_char(p_document_id) and ad.entity_name='PO_RELEASES')
3984: OR
3985: (ad.pk1_value=to_char((select pha.vendor_id
3986: from po_headers_all pha,po_releases_all pra
3987: where pra.po_release_id=p_document_id
3988: and pha.po_header_id=pra.po_header_id
3989: )) and ad.entity_name='PO_VENDORS')
3990: OR

Line 4295: SELECT po_header_id INTO PO_COMMUNICATION_PVT.g_release_header_id FROM po_releases_all WHERE po_release_id = p_document_id;

4291: -- Modified as a part of bug #3274076
4292: -- Vendor id is same for revisied and non revised documents. So vendor id is retreived from the releases table.
4293:
4294: -- select the header id into g_release_header_id global variable for a given release id.
4295: SELECT po_header_id INTO PO_COMMUNICATION_PVT.g_release_header_id FROM po_releases_all WHERE po_release_id = p_document_id;
4296:
4297: SELECT ph.vendor_id, ph.currency_code INTO l_vendor_id, g_current_currency_code
4298: FROM po_vendors vn, po_headers_all ph
4299: WHERE vn.vendor_id = ph.vendor_id

Line 4476: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES

4472:
4473: --bug#3768142 added the condtion if p_document_type='RELEASE'
4474: --so that the attachments for Releases are also displayed
4475: --correctly. An order by is used so that first the
4476: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
4477: --attachments and then finally PO_VENDORS. This is necessary
4478: --only for the Releases because you can display the BPA header
4479: --attachments also with a release.
4480:

Line 4492: (entity_name = ''PO_RELEASES'' AND

4488: fnd_attached_docs_form_vl fad,
4489: fnd_documents_short_text fds
4490: WHERE ((entity_name=''PO_HEADERS'' AND
4491: pk1_value=to_char(phx.po_header_id))OR
4492: (entity_name = ''PO_RELEASES'' AND
4493: pk1_value = to_char(phx.po_release_id)) OR
4494: (entity_name = ''PO_VENDORS'' AND
4495: pk1_value = to_char(phx.vendor_id)) OR
4496: (entity_name = ''PO_VENDOR_SITES'' AND

Line 4507: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR

4503: l_head_url_attachment_query := 'CURSOR(
4504: SELECT fad.url web_page --Bug#4958642
4505: FROM fnd_attached_docs_form_vl fad
4506: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4507: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4508: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4509: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4510: )
4511: AND fad.datatype_id=5

Line 4519: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR

4515: l_head_file_attachment_query := 'CURSOR(
4516: SELECT fad.file_name
4517: FROM fnd_attached_docs_form_vl fad
4518: WHERE ((fad.entity_name=''PO_HEADERS'' AND fad.pk1_value=to_char(phx.po_header_id)) OR
4519: (fad.entity_name=''PO_RELEASES'' AND fad.pk1_value=to_char(phx.po_release_id)) OR
4520: (fad.entity_name=''PO_VENDORS'' AND fad.pk1_value=to_char(phx.vendor_id)) OR
4521: (fad.entity_name=''PO_VENDOR_SITES'' AND fad.pk1_value=to_char(phx.vendor_site_id)) --bug6154354
4522: )
4523: AND fad.datatype_id=6

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 5286: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES

5282: /* for header long text */
5283: --bug#3768142 also added the condition to check if the document
5284: --type is a release so that even the release header documents
5285: --are retrieved. An order by is used so that first the
5286: --PO_HEADERS(BPA) attachments are printed followed by PO_RELEASES
5287: --attachments and then finally PO_VENDORS. This is necessary
5288: --only for the Releases because you can display the BPA header
5289: --attachments also with a release.
5290: --bug#3823799: Replaced the hard coded p_document id with PO_COMMUNICATION_PVT.getDocumentId() function

Line 5304: WHERE ( (entity_name=''PO_RELEASES'' AND

5300: l_headerAttachmentsQuery := 'select PO_COMMUNICATION_PVT.get_clob(fdl.rowid) long_text
5301: FROM
5302: fnd_attached_docs_form_vl fad,
5303: fnd_documents_long_text fdl
5304: WHERE ( (entity_name=''PO_RELEASES'' AND
5305: pk1_value= to_char(PO_COMMUNICATION_PVT.getDocumentId()) ) OR
5306: (entity_name = ''PO_HEADERS'' AND
5307: pk1_value = to_char(PO_COMMUNICATION_PVT.getReleaseHeaderId())) OR --Bug6139548
5308: (entity_name = ''PO_VENDORS'' AND

Line 6233: PO_RELEASES_ARCHIVE_ALL PHA

6229: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname, PO_COMMUNICATION_PVT.g_arcAgent_id
6230:
6231: FROM
6232: PER_ALL_PEOPLE_F HRE,
6233: PO_RELEASES_ARCHIVE_ALL PHA
6234: WHERE
6235: HRE.PERSON_ID = PHA.AGENT_ID AND
6236: -- HRE.EMPLOYEE_NUMBER IS NOT NULL AND --
6237: TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND

Line 6451: FROM po_headers_all ph,po_releases_all pr

6447: FROM po_headers_all ph
6448: WHERE po_header_id = p_document_id ;
6449: ELSE
6450: SELECT ph.segment1 into l_po_number
6451: FROM po_headers_all ph,po_releases_all pr
6452: WHERE ph.po_header_id = pr.po_header_id and pr.po_release_id = p_document_id ;
6453: END IF;
6454:
6455: EXCEPTION

Line 7106: FROM po_releases_all

7102:
7103: IF p_document_type = 'RELEASE' THEN
7104: SELECT wf_item_type, wf_item_key
7105: INTO x_item_type, x_item_key
7106: FROM po_releases_all
7107: WHERE po_release_id = p_document_id;
7108:
7109: l_progress := '001';
7110: