eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_ADJ_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 75: FROM ozf_offer_adjustment_lines a

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

Line 365: ozf_offer_adjustment_lines a, qp_rltd_modifiers b, qp_list_lines c

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

Line 911: FROM ozf_offer_adjustment_lines a, qp_rltd_modifiers b

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

Line 1065: FROM ozf_offer_adjustment_lines l

1061: l_endDate DATE;
1062:
1063: CURSOR c_endDate IS
1064: SELECT l.discount_end_date
1065: FROM ozf_offer_adjustment_lines l
1066: WHERE l.offer_adjustment_line_id = p_offerAdjustmentLineId;
1067:
1068: BEGIN
1069: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1139: FROM ozf_offer_adjustment_lines adjl, qp_list_lines qpl

1135: CURSOR c_listLineId IS
1136: SELECT adjl.list_line_id
1137: ,qpl.list_line_no
1138: ,adjl.modified_discount
1139: FROM ozf_offer_adjustment_lines adjl, qp_list_lines qpl
1140: WHERE offer_adjustment_line_id = p_offerAdjustmentLineId
1141: AND qpl.list_header_id = adjl.list_header_id
1142: AND adjl.list_line_id = qpl.list_line_id ;
1143:

Line 1517: FROM ozf_offer_adjustment_lines

1513: )
1514: IS
1515: CURSOR c_listLineId(cp_offerAdjustmentLineId NUMBER) IS
1516: SELECT list_line_id
1517: FROM ozf_offer_adjustment_lines
1518: WHERE offer_adjustment_line_id = cp_offerAdjustmentLineId;
1519: l_listLineId NUMBER;
1520: BEGIN
1521: -- initialize

Line 1623: FROM ozf_offer_adjustment_lines a, qp_list_lines b

1619: IS
1620: CURSOR c_adjustmentLines(cp_offerAdjustmentId NUMBER)
1621: IS
1622: SELECT a.list_line_id, b.list_line_type_code , a.offer_adjustment_line_id
1623: FROM ozf_offer_adjustment_lines a, qp_list_lines b
1624: WHERE
1625: a.list_line_id = b.list_line_id
1626: AND b.qualification_ind in (0,2,4,6,8,10,12,14,16,18,20,22,24,26, 28, 30, 32)
1627: AND offer_adjustment_id = cp_offerAdjustmentId;

Line 1992: FROM ozf_offer_adjustment_lines

1988: )
1989: IS
1990: CURSOR c_listLine(cp_offerAdjustmentId NUMBER)IS
1991: SELECT list_line_id, offer_adjustment_line_id
1992: FROM ozf_offer_adjustment_lines
1993: WHERE offer_adjustment_id = cp_offerAdjustmentId;
1994: BEGIN
1995: x_return_status := FND_API.G_RET_STS_SUCCESS;
1996: FOR l_listLine in c_listLine(cp_offerAdjustmentId => p_offerAdjustmentId ) LOOP

Line 2111: FROM ozf_offer_adjustment_lines a

2107: , nvl(a.modified_discount,a.original_discount) discount
2108: , nvl(a.modified_discount_td, a.original_discount_td) discount_td
2109: , a.discount_end_date
2110: , h.start_date_active
2111: FROM ozf_offer_adjustment_lines a
2112: , ozf_offer_adjustments_b b
2113: , qp_list_headers_b h
2114: WHERE a.offer_adjustment_id = b.offer_adjustment_id
2115: AND a.list_header_id = h.list_header_id

Line 2870: FROM ozf_offer_adjustment_lines

2866: IS
2867: CURSOR c_adjLines(cp_offerAdjustmentId NUMBER) IS
2868: SELECT
2869: list_line_id
2870: FROM ozf_offer_adjustment_lines
2871: WHERE offer_adjustment_id = cp_offerAdjustmentId;
2872:
2873: BEGIN
2874: -- initialize

Line 3138: -- create line in ozf_offer_adjustment_lines

3134: l_modifiers_tbl QP_MODIFIERS_PUB.modifiers_tbl_type;
3135: BEGIN
3136: -- initialize
3137: -- create new line
3138: -- create line in ozf_offer_adjustment_lines
3139: x_return_status := FND_API.G_RET_STS_SUCCESS;
3140: createNewBuyProduct
3141: (
3142: x_return_status => x_return_status

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

3779: BEGIN
3780: -- initialize
3781: -- populate discounts
3782: -- create qp_list_lines
3783: -- create ozf_offer_adjustment_lines with created from adjustments = y -- required only for processing with bugets
3784: -- 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.
3785: x_return_status := FND_API.G_RET_STS_SUCCESS;
3786: l_modifier_line_tbl.delete;
3787: l_SDR_lines_tbl.delete;

Line 4449: -- back create ozf_offer_adjustment_lines

4445: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
4446: BEGIN
4447: -- initialize
4448: -- create a product qp data
4449: -- back create ozf_offer_adjustment_lines
4450: x_return_status := FND_API.G_RET_STS_SUCCESS;
4451: l_modifier_line_tbl.delete;
4452:
4453: createNewMtProduct