DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_CORE_S

Line 1829: l_spo_amt := po_core_s.get_total(x_object_type=>'H',

1825: -- it is possible that only header was archived and the line was not
1826: -- since all the changes that happened were in Header only
1827: IF l_type_lookup_code = 'STANDARD' then
1828: -- get total amount for working copy of PO
1829: l_spo_amt := po_core_s.get_total(x_object_type=>'H',
1830: x_object_id =>p_doc_id);
1831: --get total amount for last archived version of PO
1832: l_archived_spo_amt:=po_core_s.get_archive_total
1833: (p_object_id =>p_doc_id,

Line 1832: l_archived_spo_amt:=po_core_s.get_archive_total

1828: -- get total amount for working copy of PO
1829: l_spo_amt := po_core_s.get_total(x_object_type=>'H',
1830: x_object_id =>p_doc_id);
1831: --get total amount for last archived version of PO
1832: l_archived_spo_amt:=po_core_s.get_archive_total
1833: (p_object_id =>p_doc_id,
1834: p_doc_type => 'PO',
1835: p_doc_subtype => 'STANDARD');
1836: IF l_spo_amt <> l_archived_spo_amt THEN

Line 2446: ,PO_CORE_S.get_default_legal_entity_id(poh.org_id) -- Bug 4654758, Bug 4691758

2442: nvl(poh.rate,1)/nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cu.MINIMUM_ACCOUNTABLE_UNIT,null,cu.precision,0)
2443: ) * nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1) /
2444: nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cuf.MINIMUM_ACCOUNTABLE_UNIT,null,cuf.precision,0)
2445: )* nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1) min_release_amount_func
2446: ,PO_CORE_S.get_default_legal_entity_id(poh.org_id) -- Bug 4654758, Bug 4691758
2447: ,poh.segment1
2448: ,poh.revision_num
2449: ,poh.vendor_contact_id
2450: ,poh.agent_id

Line 2580: ,PO_CORE_S.get_default_legal_entity_id(poh.org_id) -- Bug 4654758, Bug 4691758

2576: nvl(poh.rate,1)/nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cu.MINIMUM_ACCOUNTABLE_UNIT,null,cu.precision,0)
2577: ) * nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1) /
2578: nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cuf.MINIMUM_ACCOUNTABLE_UNIT,null,cuf.precision,0)
2579: )* nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1) min_release_amount_func
2580: ,PO_CORE_S.get_default_legal_entity_id(poh.org_id) -- Bug 4654758, Bug 4691758
2581: ,poh.segment1
2582: ,poh.revision_num
2583: ,poh.vendor_contact_id
2584: ,poh.agent_id

Line 2665: l_po_total_amount :=po_core_s.get_total('H',p_doc_id);

2661: --Bug#3809298.Check if the document type is "Standard"
2662: --If so then calculate the amount in functional and transaction currency.
2663: --If not assign zero those two.
2664: IF(l_poh_type_lookup_code='STANDARD')THEN
2665: l_po_total_amount :=po_core_s.get_total('H',p_doc_id);
2666: l_po_attrib_tbl(12).variable_value_id :=l_po_total_amount;
2667: SELECT ROUND
2668: (
2669: ROUND ( l_po_total_amount * NVL (l_poh_rate, 1) / NVL (l_cu_minimum_accountable_unit, 1),