DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_CORE_S

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

1644: -- it is possible that only header was archived and the line was not
1645: -- since all the changes that happened were in Header only
1646: IF l_type_lookup_code = 'STANDARD' then
1647: -- get total amount for working copy of PO
1648: l_spo_amt := po_core_s.get_total(x_object_type=>'H',
1649: x_object_id =>p_doc_id);
1650: --get total amount for last archived version of PO
1651: l_archived_spo_amt:=po_core_s.get_archive_total
1652: (p_object_id =>p_doc_id,

Line 1651: l_archived_spo_amt:=po_core_s.get_archive_total

1647: -- get total amount for working copy of PO
1648: l_spo_amt := po_core_s.get_total(x_object_type=>'H',
1649: x_object_id =>p_doc_id);
1650: --get total amount for last archived version of PO
1651: l_archived_spo_amt:=po_core_s.get_archive_total
1652: (p_object_id =>p_doc_id,
1653: p_doc_type => 'PO',
1654: p_doc_subtype => 'STANDARD');
1655: IF l_spo_amt <> l_archived_spo_amt THEN

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

2243: nvl(poh.rate,1)/nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cu.MINIMUM_ACCOUNTABLE_UNIT,null,cu.precision,0)
2244: ) * nvl(cu.MINIMUM_ACCOUNTABLE_UNIT,1) /
2245: nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1),decode(cuf.MINIMUM_ACCOUNTABLE_UNIT,null,cuf.precision,0)
2246: )* nvl(cuf.MINIMUM_ACCOUNTABLE_UNIT,1) min_release_amount_func
2247: ,PO_CORE_S.get_default_legal_entity_id(poh.org_id) -- Bug 4654758, Bug 4691758
2248: ,poh.segment1
2249: ,poh.revision_num
2250: ,poh.vendor_contact_id
2251: ,poh.agent_id

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

2327: --Bug#3809298.Check if the document type is "Standard"
2328: --If so then calculate the amount in functional and transaction currency.
2329: --If not assign zero those two.
2330: IF(l_poh_type_lookup_code='STANDARD')THEN
2331: l_po_total_amount :=po_core_s.get_total('H',p_doc_id);
2332: l_po_attrib_tbl(12).variable_value_id :=l_po_total_amount;
2333: SELECT ROUND
2334: (
2335: ROUND ( l_po_total_amount * NVL (l_poh_rate, 1) / NVL (l_cu_minimum_accountable_unit, 1),