APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OZF_ADJ_TEMP_ELIGIBILITY

Line 2044: ozf_adj_temp_eligibility temp,

2040: line.shipping_quantity_uom2, -- Catch Weight ER
2041: line.shipping_quantity2, -- Catch Weight ER
2042: line.fulfillment_base -- Catch Weight ER
2043: FROM oe_order_lines_all line,
2044: ozf_adj_temp_eligibility temp,
2045: ozf_offer_adjustments_b adj,
2046: ozf_offer_adjustment_lines adj_line,
2047: ozf_offers off,
2048: qp_list_lines lines,

Line 2143: ozf_adj_temp_eligibility temp,

2139: line.shipping_quantity_uom2, -- Catch Weight ER
2140: line.shipping_quantity2, -- Catch Weight ER
2141: line.fulfillment_base -- Catch Weight ER
2142: FROM oe_order_lines_all line,
2143: ozf_adj_temp_eligibility temp,
2144: ozf_offer_adjustments_b adj,
2145: ozf_offer_adjustment_lines adj_line,
2146: ozf_offers off,
2147: qp_list_lines lines,

Line 2249: ozf_adj_temp_eligibility temp,

2245: line.shipping_quantity_uom2, -- Catch Weight ER
2246: line.shipping_quantity2, -- Catch Weight ER
2247: line.fulfillment_base -- Catch Weight ER
2248: FROM oe_order_lines_all line,
2249: ozf_adj_temp_eligibility temp,
2250: ozf_offer_adjustments_b adj,
2251: ozf_offer_adjustment_lines adj_line,
2252: ozf_offers off,
2253: qp_list_lines lines,

Line 2347: ozf_adj_temp_eligibility temp,

2343: line.shipping_quantity_uom2, -- Catch Weight ER
2344: line.shipping_quantity2, -- Catch Weight ER
2345: line.fulfillment_base -- Catch Weight ER
2346: FROM oe_order_lines_all line,
2347: ozf_adj_temp_eligibility temp,
2348: ozf_offer_adjustments_b adj,
2349: ozf_offer_adjustment_tiers adj_line,
2350: ozf_offer_discount_lines orig_disc,
2351: ozf_offers off,

Line 2433: ozf_adj_temp_eligibility temp,

2429: line.shipping_quantity_uom2, -- Catch Weight ER
2430: line.shipping_quantity2, -- Catch Weight ER
2431: line.fulfillment_base -- Catch Weight ER
2432: FROM oe_order_lines_all line,
2433: ozf_adj_temp_eligibility temp,
2434: ozf_offer_adjustments_b adj,
2435: ozf_offer_adjustment_lines adj_line,
2436: ozf_offers off,
2437: qp_list_lines lines,

Line 2531: ozf_adj_temp_eligibility temp,

2527: line.shipping_quantity_uom2, -- Catch Weight ER
2528: line.shipping_quantity2, -- Catch Weight ER
2529: line.fulfillment_base -- Catch Weight ER
2530: FROM oe_order_lines_all line,
2531: ozf_adj_temp_eligibility temp,
2532: ozf_offer_adjustments_b adj,
2533: ozf_offer_adjustment_tiers adj_line,
2534: ozf_offer_discount_lines orig_disc,
2535: ozf_offers off,

Line 2598: FROM ozf_adj_temp_eligibility;

2594:
2595:
2596: CURSOR c_count_temp IS
2597: SELECT COUNT(eligibility_id)
2598: FROM ozf_adj_temp_eligibility;
2599:
2600: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
2601: SELECT off.offer_id, qp.description, qp.NAME,
2602: nvl(off.transaction_currency_code,fund_request_curr_code) transaction_currency_code,

Line 2878: EXECUTE IMMEDIATE 'DELETE FROM ozf_adj_temp_eligibility';

2874: l_adjIdByListLineId.delete;
2875: l_request_id := fnd_global.conc_request_id;
2876:
2877: --SSD adjustment ER, this is moved here since we want all offers to be merged.
2878: EXECUTE IMMEDIATE 'DELETE FROM ozf_adj_temp_eligibility';
2879:
2880: -- perform adjustment, this will work with old table because
2881: -- commit happens after all processing
2882: --only check what happens if out of multiple errors candidate for

Line 2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');

2991: write_conc_log ( l_full_name || ' : ' || ' Begin Inserting data into temp table for AdjustmentLineId ' || l_adjusted_line_cur.offer_adjustment_line_id );
2992:
2993:
2994: FND_DSQL.init;
2995: FND_DSQL.add_text('INSERT INTO ozf_adj_temp_eligibility(object_type, eligibility_id, offer_adjustment_line_id) ');
2996: FND_DSQL.add_text('(SELECT ''OFFR'', product_id, ' );
2997: FND_DSQL.add_text(l_adjusted_line_cur.offer_adjustment_line_id );
2998: FND_DSQL.add_text(' FROM ( ');
2999: