APPS.POA_DBI_PO_DIST_F_C dependencies on POA_DBI_SAVINGS_PKG

Line 2034: * (Nvl(pll.price_override,0) - Nvl(poa_dbi_savings_pkg.get_lowest_possible_price(pod.creation_date,

2030: AND (nvl(ref.global_agreement_flag, 'N') = 'N')
2031: AND match.po_distribution_id IS NOT null
2032: and nvl(pol.negotiated_by_preparer_flag,'N') = 'N')
2033: THEN ((Nvl(pod.quantity_ordered,0) - Nvl(pod.quantity_cancelled,0))
2034: * (Nvl(pll.price_override,0) - Nvl(poa_dbi_savings_pkg.get_lowest_possible_price(pod.creation_date,
2035: poh.org_id,
2036: pll.need_by_date,
2037: pll.quantity, --shipment quantity
2038: nvl(pll.unit_meas_lookup_code,pol.unit_meas_lookup_code),

Line 2082: then poa_dbi_savings_pkg.get_lowest_possible_price(pod.creation_date,

2078: then pod.quantity_cancelled
2079: else null
2080: end) quantity_cancelled,
2081: (case when (pol.item_id is not null and pll.shipment_type = 'STANDARD' and match.po_distribution_id is not null)
2082: then poa_dbi_savings_pkg.get_lowest_possible_price(pod.creation_date,
2083: poh.org_id,
2084: pll.need_by_date,
2085: pll.quantity, --shipment quantity
2086: nvl(pll.unit_meas_lookup_code,pol.unit_meas_lookup_code),

Line 2527: bis_collection_utilities.log('best price calculation hit='|| poa_dbi_savings_pkg.g_hit_count, 2);

2523: s.negotiated_by_preparer_flag
2524: );
2525:
2526: COMMIT;
2527: bis_collection_utilities.log('best price calculation hit='|| poa_dbi_savings_pkg.g_hit_count, 2);
2528: poa_dbi_savings_pkg.g_hit_count := 0;
2529:
2530: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
2531: END LOOP;

Line 2528: poa_dbi_savings_pkg.g_hit_count := 0;

2524: );
2525:
2526: COMMIT;
2527: bis_collection_utilities.log('best price calculation hit='|| poa_dbi_savings_pkg.g_hit_count, 2);
2528: poa_dbi_savings_pkg.g_hit_count := 0;
2529:
2530: DBMS_APPLICATION_INFO.SET_ACTION('batch ' || v_batch_no || ' done');
2531: END LOOP;
2532: END IF;