APPS.OZF_COPY_OFFER_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 360: FROM ozf_offer_discount_lines

356: , tier_type
357: , volume_operator
358: , volume_break_type
359: , tier_level
360: FROM ozf_offer_discount_lines
361: WHERE parent_discount_line_id = cp_parentDiscountId;
362:
363: l_discountLineId NUMBER;
364: l_vo_disc_rec OZF_Volume_Offer_disc_PVT.vo_disc_rec_type;

Line 440: FROM ozf_offer_discount_lines a, ozf_offr_disc_struct_name_b b , ozf_offr_disc_struct_name_tl c

436: , c.discount_table_name
437: , c.description
438: , a.tier_level
439: , a.offer_discount_line_id
440: FROM ozf_offer_discount_lines a, ozf_offr_disc_struct_name_b b , ozf_offr_disc_struct_name_tl c
441: WHERE a.offer_discount_line_id = b.offer_discount_Line_id
442: AND b.offr_disc_struct_name_id = c.offr_disc_struct_name_id
443: AND c.language = USERENV('LANG')
444: AND a.offer_id = cp_offerId;

Line 1136: SELECT ozf_offer_discount_lines_s.NEXTVAL

1132: ,p_offer_id IN NUMBER
1133: ,x_new_line_id OUT NOCOPY NUMBER)
1134: IS
1135: CURSOR c_new_line_id IS
1136: SELECT ozf_offer_discount_lines_s.NEXTVAL
1137: FROM DUAL;
1138:
1139: CURSOR c_line_id_exists(l_id NUMBER) IS
1140: SELECT 1

Line 1143: FROM ozf_offer_discount_lines

1139: CURSOR c_line_id_exists(l_id NUMBER) IS
1140: SELECT 1
1141: FROM DUAL
1142: WHERE EXISTS (SELECT 1
1143: FROM ozf_offer_discount_lines
1144: WHERE offer_discount_line_id = l_id);
1145:
1146: CURSOR c_line_detail IS
1147: SELECT *

Line 1148: FROM ozf_offer_discount_lines

1144: WHERE offer_discount_line_id = l_id);
1145:
1146: CURSOR c_line_detail IS
1147: SELECT *
1148: FROM ozf_offer_discount_lines
1149: WHERE offer_discount_line_id = p_org_line_id;
1150:
1151: l_line_detail c_line_detail%ROWTYPE;
1152: l_count NUMBER;

Line 1172: INSERT INTO ozf_offer_discount_lines(offer_discount_line_id

1168: OPEN c_line_detail;
1169: FETCH c_line_detail INTO l_line_detail;
1170: CLOSE c_line_detail;
1171:
1172: INSERT INTO ozf_offer_discount_lines(offer_discount_line_id
1173: ,parent_discount_line_id
1174: ,volume_from
1175: ,volume_to
1176: ,volume_operator

Line 1316: FROM ozf_offer_discount_lines

1312: ,p_new_offer_id IN NUMBER)
1313: IS
1314: CURSOR c_parent_lines IS
1315: SELECT offer_discount_line_id
1316: FROM ozf_offer_discount_lines
1317: WHERE offer_id = (SELECT offer_id
1318: FROM ozf_offers
1319: WHERE qp_list_header_id = p_source_object_id)
1320: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl

Line 1324: FROM ozf_offer_discount_lines

1320: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl
1321:
1322: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS
1323: SELECT offer_discount_line_id
1324: FROM ozf_offer_discount_lines
1325: WHERE offer_id = (SELECT offer_id
1326: FROM ozf_offers
1327: WHERE qp_list_header_id = p_source_object_id)
1328: AND parent_discount_line_id = p_parent_line_id;

Line 1371: FROM ozf_offer_discount_lines

1367: ,p_new_offer_id IN NUMBER)
1368: IS
1369: CURSOR c_line_tiers IS
1370: SELECT offer_discount_line_id
1371: FROM ozf_offer_discount_lines
1372: WHERE offer_id = (SELECT offer_id
1373: FROM ozf_offers
1374: WHERE qp_list_header_id = p_source_object_id);
1375: