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 1163: SELECT ozf_offer_discount_lines_s.NEXTVAL

1159: ,p_offer_id IN NUMBER
1160: ,x_new_line_id OUT NOCOPY NUMBER)
1161: IS
1162: CURSOR c_new_line_id IS
1163: SELECT ozf_offer_discount_lines_s.NEXTVAL
1164: FROM DUAL;
1165:
1166: CURSOR c_line_id_exists(l_id NUMBER) IS
1167: SELECT 1

Line 1170: FROM ozf_offer_discount_lines

1166: CURSOR c_line_id_exists(l_id NUMBER) IS
1167: SELECT 1
1168: FROM DUAL
1169: WHERE EXISTS (SELECT 1
1170: FROM ozf_offer_discount_lines
1171: WHERE offer_discount_line_id = l_id);
1172:
1173: CURSOR c_line_detail IS
1174: SELECT *

Line 1175: FROM ozf_offer_discount_lines

1171: WHERE offer_discount_line_id = l_id);
1172:
1173: CURSOR c_line_detail IS
1174: SELECT *
1175: FROM ozf_offer_discount_lines
1176: WHERE offer_discount_line_id = p_org_line_id;
1177:
1178: l_line_detail c_line_detail%ROWTYPE;
1179: l_count NUMBER;

Line 1199: INSERT INTO ozf_offer_discount_lines(offer_discount_line_id

1195: OPEN c_line_detail;
1196: FETCH c_line_detail INTO l_line_detail;
1197: CLOSE c_line_detail;
1198:
1199: INSERT INTO ozf_offer_discount_lines(offer_discount_line_id
1200: ,parent_discount_line_id
1201: ,volume_from
1202: ,volume_to
1203: ,volume_operator

Line 1343: FROM ozf_offer_discount_lines

1339: ,p_new_offer_id IN NUMBER)
1340: IS
1341: CURSOR c_parent_lines IS
1342: SELECT offer_discount_line_id
1343: FROM ozf_offer_discount_lines
1344: WHERE offer_id = (SELECT offer_id
1345: FROM ozf_offers
1346: WHERE qp_list_header_id = p_source_object_id)
1347: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl

Line 1351: FROM ozf_offer_discount_lines

1347: AND parent_discount_line_id IS NULL; -- start from main line, then process multi-tier and excl
1348:
1349: CURSOR c_tier_excl_lines(p_parent_line_id NUMBER) IS
1350: SELECT offer_discount_line_id
1351: FROM ozf_offer_discount_lines
1352: WHERE offer_id = (SELECT offer_id
1353: FROM ozf_offers
1354: WHERE qp_list_header_id = p_source_object_id)
1355: AND parent_discount_line_id = p_parent_line_id;

Line 1398: FROM ozf_offer_discount_lines

1394: ,p_new_offer_id IN NUMBER)
1395: IS
1396: CURSOR c_line_tiers IS
1397: SELECT offer_discount_line_id
1398: FROM ozf_offer_discount_lines
1399: WHERE offer_id = (SELECT offer_id
1400: FROM ozf_offers
1401: WHERE qp_list_header_id = p_source_object_id);
1402: