APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 73: FROM ozf_offer_adjustment_lines a

69: IS
70: l_modifiedDiscount NUMBER;
71: CURSOR c_modifiedDiscount( cp_offerAdjustmentLineId NUMBER)IS
72: SELECT a.modified_discount
73: FROM ozf_offer_adjustment_lines a
74: WHERE a.offer_adjustment_line_id = cp_offerAdjustmentLineId;
75: BEGIN
76: OPEN c_modifiedDiscount(cp_offerAdjustmentLineId => p_offerAdjustmentLineId) ;
77: FETCH c_modifiedDiscount INTO l_modifiedDiscount;

Line 363: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

359: CURSOR c_discounts(cp_offerAdjustmentId NUMBER, cp_pbhListLineId NUMBER) IS
360: SELECT
361: nvl(a.modified_discount,c.operand) discount
362: FROM
363: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c
364: WHERE
365: a.list_line_id (+) = b.to_rltd_modifier_id
366: AND b.to_rltd_modifier_id = c.list_line_id
367: AND b.from_rltd_modifier_id = cp_pbhListLineId

Line 909: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b

905: l_phbLineId NUMBER;
906: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
907: CURSOR c_pbhLines(cp_offerAdjustmentId NUMBER) IS
908: SELECT distinct b.from_rltd_modifier_id
909: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b
910: WHERE a.list_line_id = b.to_rltd_modifier_id
911: AND a.offer_adjustment_id = cp_offerAdjustmentId;
912: BEGIN
913: -- initialize

Line 1283: FROM ozf_offer_adjustment_lines

1279: )
1280: IS
1281: CURSOR c_listLineId(cp_offerAdjustmentLineId NUMBER) IS
1282: SELECT list_line_id
1283: FROM ozf_offer_adjustment_lines
1284: WHERE offer_adjustment_line_id = cp_offerAdjustmentLineId;
1285: l_listLineId NUMBER;
1286: BEGIN
1287: -- initialize

Line 1372: FROM ozf_offer_adjustment_lines a, qp_list_lines b

1368: IS
1369: CURSOR c_adjustmentLines(cp_offerAdjustmentId NUMBER)
1370: IS
1371: SELECT a.list_line_id, b.list_line_type_code , a.offer_adjustment_line_id
1372: FROM ozf_offer_adjustment_lines a, qp_list_lines b
1373: WHERE
1374: a.list_line_id = b.list_line_id
1375: AND b.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26, 28, 30, 32)
1376: AND offer_adjustment_id = cp_offerAdjustmentId;

Line 1741: FROM ozf_offer_adjustment_lines

1737: )
1738: IS
1739: CURSOR c_listLine(cp_offerAdjustmentId NUMBER)IS
1740: SELECT list_line_id, offer_adjustment_line_id
1741: FROM ozf_offer_adjustment_lines
1742: WHERE offer_adjustment_id = cp_offerAdjustmentId;
1743: BEGIN
1744: x_return_status := FND_API.G_RET_STS_SUCCESS;
1745: FOR l_listLine in c_listLine(cp_offerAdjustmentId => p_offerAdjustmentId ) LOOP

Line 1854: FROM ozf_offer_adjustment_lines a, ozf_offer_adjustments_b b

1850: CURSOR c_tdCrtLineDetails(cp_offerAdjustmentId NUMBER, cp_listLineId NUMBER) IS
1851: SELECT b.effective_date
1852: , nvl(a.modified_discount,a.original_discount) discount
1853: , nvl(a.modified_discount_td, a.original_discount_td) discount_td
1854: FROM ozf_offer_adjustment_lines a, ozf_offer_adjustments_b b
1855: WHERE a.offer_adjustment_id = b.offer_adjustment_id
1856: AND a.offer_adjustment_id = cp_offerAdjustmentId
1857: AND a.list_line_id = cp_listLineId;
1858: BEGIN

Line 2586: FROM ozf_offer_adjustment_lines

2582: IS
2583: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
2584: SELECT
2585: list_line_id
2586: FROM ozf_offer_adjustment_lines
2587: WHERE offer_adjustment_id = cp_offerAdjustmentId;
2588:
2589: BEGIN
2590: -- initialize

Line 2854: -- create line in ozf_offer_adjustment_lines

2850: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
2851: BEGIN
2852: -- initialize
2853: -- create new line
2854: -- create line in ozf_offer_adjustment_lines
2855: x_return_status := FND_API.G_RET_STS_SUCCESS;
2856: createNewBuyProduct
2857: (
2858: x_return_status => x_return_status

Line 3293: -- create ozf_offer_adjustment_lines with created from adjustments = y -- required only for processing with bugets

3289: BEGIN
3290: -- initialize
3291: -- populate discounts
3292: -- create qp_list_lines
3293: -- create ozf_offer_adjustment_lines with created from adjustments = y -- required only for processing with bugets
3294: -- need to look at relating offer_adj_new_line_id with the qp list_line_id created. may be useful later for audit reporting and Sarbines-Auxley compliance.
3295: x_return_status := FND_API.G_RET_STS_SUCCESS;
3296: l_modifier_line_tbl.delete;
3297: populateDisDiscounts

Line 3903: -- back create ozf_offer_adjustment_lines

3899: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
3900: BEGIN
3901: -- initialize
3902: -- create a product qp data
3903: -- back create ozf_offer_adjustment_lines
3904: x_return_status := FND_API.G_RET_STS_SUCCESS;
3905: l_modifier_line_tbl.delete;
3906:
3907: createNewMtProduct