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_LINE_PVT dependencies on OZF_OFFERS

Line 69: l_order_value_discount_type ozf_offers.order_value_discount_type%type;

65:
66: PROCEDURE populate_order_value_rec(p_list_line_rec IN offadj_new_line_rec_type,
67: p_offadj_line_rec IN OUT NOCOPY offadj_line_rec_type )
68: IS
69: l_order_value_discount_type ozf_offers.order_value_discount_type%type;
70: CURSOR cur_get_ov_discount_type(p_list_header_id NUMBER) IS
71: SELECT order_value_discount_type
72: FROM ozf_offers
73: WHERE qp_list_header_id = p_list_header_id;

Line 72: FROM ozf_offers

68: IS
69: l_order_value_discount_type ozf_offers.order_value_discount_type%type;
70: CURSOR cur_get_ov_discount_type(p_list_header_id NUMBER) IS
71: SELECT order_value_discount_type
72: FROM ozf_offers
73: WHERE qp_list_header_id = p_list_header_id;
74: BEGIN
75: open cur_get_ov_discount_type(p_list_line_rec.list_header_id);
76: fetch cur_get_ov_discount_type into l_order_value_discount_type;

Line 131: FROM ozf_offers

127: p_modifier_line_rec IN OUT NOCOPY ozf_offer_pvt.Modifier_Line_Rec_Type )
128: IS
129: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
130: SELECT offer_type
131: FROM ozf_offers
132: WHERE qp_list_header_id = p_list_header_id;
133: l_offer_type OZF_OFFERS.offer_type%type;
134: BEGIN
135: p_modifier_line_rec.LIST_HEADER_ID := p_list_line_rec.list_header_id;

Line 133: l_offer_type OZF_OFFERS.offer_type%type;

129: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
130: SELECT offer_type
131: FROM ozf_offers
132: WHERE qp_list_header_id = p_list_header_id;
133: l_offer_type OZF_OFFERS.offer_type%type;
134: BEGIN
135: p_modifier_line_rec.LIST_HEADER_ID := p_list_line_rec.list_header_id;
136: p_modifier_line_rec.list_line_id := p_list_line_rec.list_line_id;
137: p_modifier_line_rec.LIST_LINE_TYPE_CODE := p_list_line_rec.list_line_type_code;

Line 575: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;

571: l_object_version_number NUMBER := 1;
572: l_org_id NUMBER := FND_API.G_MISS_NUM;
573: l_offer_adjustment_line_id NUMBER;
574: l_dummy NUMBER;
575: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
576: l_error_loc NUMBER;
577: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
578: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
579: l_offadj_line_rec offadj_line_rec_type ;

Line 589: FROM ozf_offers

585: l_accrual_flag VARCHAR2(1):= 'N';
586:
587: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
588: SELECT offer_type
589: FROM ozf_offers
590: WHERE qp_list_header_id = p_list_header_id;
591:
592: CURSOR cur_get_ov_discount_type(p_list_header_id NUMBER) IS
593: SELECT order_value_discount_type

Line 594: FROM ozf_offers

590: WHERE qp_list_header_id = p_list_header_id;
591:
592: CURSOR cur_get_ov_discount_type(p_list_header_id NUMBER) IS
593: SELECT order_value_discount_type
594: FROM ozf_offers
595: WHERE qp_list_header_id = p_list_header_id;
596:
597: BEGIN
598: -- Standard Start of API savepoint

Line 1109: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;

1105: l_object_version_number NUMBER := 1;
1106: l_org_id NUMBER := FND_API.G_MISS_NUM;
1107: l_offer_adjustment_line_id NUMBER;
1108: l_dummy NUMBER;
1109: l_offer_type OZF_OFFERS.OFFER_TYPE%TYPE;
1110: l_error_loc NUMBER;
1111:
1112: l_modifier_line_tbl ozf_offer_pvt.MODIFIER_LINE_TBL_TYPE;
1113: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 1124: FROM ozf_offers

1120: l_accrual_flag VARCHAR2(1):= 'N';
1121:
1122: CURSOR c_offer_type (p_list_header_id IN NUMBER) IS
1123: SELECT offer_type
1124: FROM ozf_offers
1125: WHERE qp_list_header_id = p_list_header_id;
1126:
1127:
1128: BEGIN

Line 1691: SELECT offer_type from ozf_offers where qp_list_header_id = p_list_header_id;

1687: x_return_status OUT NOCOPY VARCHAR2
1688: )
1689: IS
1690: CURSOR c_offer_type(p_list_header_id NUMBER) is
1691: SELECT offer_type from ozf_offers where qp_list_header_id = p_list_header_id;
1692:
1693: CURSOR c_list_line_type_Code(p_list_line_id NUMBER) is
1694: select list_line_type_code from qp_list_lines where list_line_id = p_list_line_id;
1695:

Line 1697: l_offer_type ozf_offers.offer_type%type;

1693: CURSOR c_list_line_type_Code(p_list_line_id NUMBER) is
1694: select list_line_type_code from qp_list_lines where list_line_id = p_list_line_id;
1695:
1696: l_list_line_type_code qp_list_lines.list_line_type_code%type;
1697: l_offer_type ozf_offers.offer_type%type;
1698:
1699: BEGIN
1700:
1701: open c_offer_type(p_offadj_line_rec.list_header_id);