APPS.PO_CHANGEORDERWF_PVT dependencies on POS_TOTALS_PO_SV

Line 1742: pos_totals_po_sv.get_po_total(po_header_id),

1738: if(l_release_id is null) then
1739:
1740: select segment1,
1741: revision_num,
1742: pos_totals_po_sv.get_po_total(po_header_id),
1743: currency_code,
1744: vendor_id,
1745: vendor_site_id,
1746: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

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

1784: select
1785: ph.segment1,
1786: pr.release_num,
1787: pr.revision_num,
1788: pos_totals_po_sv.get_release_total(pr.po_release_id),
1789: ph.currency_code,
1790: ph.vendor_id,
1791: ph.vendor_site_id,
1792: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 2575: pos_totals_po_sv.get_po_total(po_header_id),

2571: if(l_release_id is null) then
2572:
2573: select segment1,
2574: revision_num,
2575: pos_totals_po_sv.get_po_total(po_header_id),
2576: currency_code,
2577: vendor_id,
2578: vendor_site_id,
2579: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

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

2617: select
2618: ph.segment1,
2619: pr.release_num,
2620: pr.revision_num,
2621: pos_totals_po_sv.get_release_total(pr.po_release_id),
2622: ph.currency_code,
2623: ph.vendor_id,
2624: ph.vendor_site_id,
2625: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 3492: pos_totals_po_sv.get_po_total(po_header_id),

3488: if(l_release_id is null) then
3489:
3490: select segment1,
3491: revision_num,
3492: pos_totals_po_sv.get_po_total(po_header_id),
3493: currency_code,
3494: vendor_id,
3495: vendor_site_id,
3496: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

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

3540: select
3541: ph.segment1,
3542: pr.release_num,
3543: pr.revision_num,
3544: pos_totals_po_sv.get_release_total(pr.po_release_id),
3545: ph.currency_code,
3546: ph.vendor_id,
3547: ph.vendor_site_id,
3548: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

Line 4430: pos_totals_po_sv.get_po_total(po_header_id),

4426:
4427: if(l_po_release_id is null) then
4428: select segment1,
4429: revision_num,
4430: pos_totals_po_sv.get_po_total(po_header_id),
4431: currency_code,
4432: vendor_id,
4433: vendor_site_id,
4434: to_char(creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

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

4455: else
4456: select ph.segment1,
4457: pr.release_num,
4458: pr.revision_num,
4459: pos_totals_po_sv.get_release_total(pr.po_release_id),
4460: ph.currency_code,
4461: ph.vendor_id,
4462: ph.vendor_site_id,
4463: to_char(pr.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS'),

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

4533: elsif (l_global_agreement_flag = 'Y' and l_type_lookup_code = 'BLANKET') then
4534: l_doc_hdr_info := fnd_message.get_string('PO','PO_GA_TYPE') ||' '||l_po_num;
4535: elsif(l_type_lookup_code = 'BLANKET') then
4536: l_doc_hdr_info := fnd_message.get_string('PO','PO_WF_NOTIF_BLANKET')||' '||l_po_num;
4537: l_po_total := pos_totals_po_sv.get_po_archive_total(l_document_header_id,l_revision_num,
4538: l_type_lookup_code );
4539: elsif(l_type_lookup_code = 'CONTRACT') then
4540: l_doc_hdr_info := fnd_message.get_string('PO','PO_POTYPE_CNTR')||' '||l_po_num;
4541: elsif(l_type_lookup_code = 'PLANNED') then

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

5048: pha.segment1,
5049: pha.type_lookup_code,
5050: pha.GLOBAL_AGREEMENT_FLAG,
5051: pha.revision_num,
5052: pos_totals_po_sv.get_po_total(pha.po_header_id),
5053: pha.currency_code,
5054: PDSL.DISPLAY_NAME
5055: into
5056: l_supplier_name,

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

5115: pha.segment1,
5116: pra.release_num,
5117: pha.type_lookup_code,
5118: pra.revision_num,
5119: pos_totals_po_sv.get_release_total(pra.po_release_id),
5120: pha.currency_code
5121: into
5122: l_supplier_name,
5123: l_blanket_num,