APPS.PO_CHANGEORDERWF_PVT dependencies on POS_TOTALS_PO_SV

Line 1887: pos_totals_po_sv.get_po_total(po_header_id),

1883: /*Modified as part of bug 7550964 changing date format*/
1884:
1885: select segment1,
1886: revision_num,
1887: pos_totals_po_sv.get_po_total(po_header_id),
1888: currency_code,
1889: vendor_id,
1890: vendor_site_id,
1891: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 1934: pos_totals_po_sv.get_release_total(pr.po_release_id),

1930: select
1931: ph.segment1,
1932: pr.release_num,
1933: pr.revision_num,
1934: pos_totals_po_sv.get_release_total(pr.po_release_id),
1935: ph.currency_code,
1936: ph.vendor_id,
1937: ph.vendor_site_id,
1938: to_char(pr.creation_date,FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 2725: pos_totals_po_sv.get_po_total(po_header_id),

2721: if(l_release_id is null) then
2722:
2723: select segment1,
2724: revision_num,
2725: pos_totals_po_sv.get_po_total(po_header_id),
2726: currency_code,
2727: vendor_id,
2728: vendor_site_id,
2729: to_char(creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 2772: pos_totals_po_sv.get_release_total(pr.po_release_id),

2768: select
2769: ph.segment1,
2770: pr.release_num,
2771: pr.revision_num,
2772: pos_totals_po_sv.get_release_total(pr.po_release_id),
2773: ph.currency_code,
2774: ph.vendor_id,
2775: ph.vendor_site_id,
2776: to_char(pr.creation_date, FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

Line 3644: pos_totals_po_sv.get_po_total(po_header_id),

3640: if(l_release_id is null) then
3641:
3642: select segment1,
3643: revision_num,
3644: pos_totals_po_sv.get_po_total(po_header_id),
3645: currency_code,
3646: vendor_id,
3647: vendor_site_id,
3648: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 3696: pos_totals_po_sv.get_release_total(pr.po_release_id),

3692: select
3693: ph.segment1,
3694: pr.release_num,
3695: pr.revision_num,
3696: pos_totals_po_sv.get_release_total(pr.po_release_id),
3697: ph.currency_code,
3698: ph.vendor_id,
3699: ph.vendor_site_id,
3700: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 4582: pos_totals_po_sv.get_po_total(po_header_id),

4578:
4579: if(l_po_release_id is null) then
4580: select segment1,
4581: revision_num,
4582: pos_totals_po_sv.get_po_total(po_header_id),
4583: currency_code,
4584: vendor_id,
4585: vendor_site_id,
4586: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 4611: pos_totals_po_sv.get_release_total(pr.po_release_id),

4607: else
4608: select ph.segment1,
4609: pr.release_num,
4610: pr.revision_num,
4611: pos_totals_po_sv.get_release_total(pr.po_release_id),
4612: ph.currency_code,
4613: ph.vendor_id,
4614: ph.vendor_site_id,
4615: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 4689: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num,

4685: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
4686: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
4687: elsif(l_type_lookup_code = 'BLANKET') then
4688: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num;
4689: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num,
4690: l_type_lookup_code );
4691: elsif(l_type_lookup_code = 'CONTRACT') then
4692: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num;
4693: elsif(l_type_lookup_code = 'PLANNED') then

Line 5204: pos_totals_po_sv.get_po_total(pha.po_header_id),

5200: pha.segment1,
5201: pha.type_lookup_code,
5202: pha.GLOBAL_AGREEMENT_FLAG,
5203: pha.revision_num,
5204: pos_totals_po_sv.get_po_total(pha.po_header_id),
5205: pha.currency_code,
5206: PDSL.DISPLAY_NAME
5207: into
5208: l_supplier_name,

Line 5271: pos_totals_po_sv.get_release_total(pra.po_release_id),

5267: pha.segment1,
5268: pra.release_num,
5269: pha.type_lookup_code,
5270: pra.revision_num,
5271: pos_totals_po_sv.get_release_total(pra.po_release_id),
5272: pha.currency_code
5273: into
5274: l_supplier_name,
5275: l_blanket_num,