[Home] [Help]
959: l_dummy NUMBER;
960: l_ozf_offer_line_rec ozf_offer_line_rec_type;
961: CURSOR c_id IS
962: SELECT ozf_offer_discount_lines_s.NEXTVAL
963: FROM dual;
964:
965: CURSOR c_id_exists (l_id IN NUMBER) IS
966: SELECT 1
967: FROM OZF_OFFER_DISCOUNT_LINES
2321: l_ozf_prod_rec ozf_prod_rec_type := g_miss_ozf_prod_rec;
2322:
2323: CURSOR c_id IS
2324: SELECT ozf_offer_discount_products_s.NEXTVAL
2325: FROM dual;
2326:
2327: CURSOR c_id_exists (l_id IN NUMBER) IS
2328: SELECT 1
2329: FROM OZF_OFFER_DISCOUNT_PRODUCTS
3624: l_prod_reln_rec prod_reln_rec_type := g_miss_prod_reln_rec;
3625:
3626: CURSOR c_id IS
3627: SELECT ozf_discount_product_reln_s.NEXTVAL
3628: FROM dual;
3629:
3630: CURSOR c_id_exists (l_id IN NUMBER) IS
3631: SELECT 1
3632: FROM OZF_DISCOUNT_PRODUCT_RELN
4185: , p_ozf_prod_rec IN ozf_prod_rec_type := g_miss_ozf_prod_rec
4186: )
4187: IS
4188: CURSOR C_SQL (p_offer_id NUMBER, p_offer_discount_line_id NUMBER) IS
4189: SELECT 1 FROM dual WHERE EXISTS
4190: (
4191: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
4192: WHERE offer_id = p_offer_id
4193: AND offer_discount_line_id = p_offer_discount_line_id
5875: , p_ozf_prod_rec IN ozf_prod_rec_type := g_miss_ozf_prod_rec
5876: )
5877: IS
5878: CURSOR C_SQL (p_offer_id NUMBER, p_off_discount_product_id NUMBER,p_offer_discount_line_id NUMBER) IS
5879: SELECT 1 FROM dual WHERE EXISTS
5880: (
5881: SELECT 1 FROM OZF_OFFER_DISCOUNT_PRODUCTS
5882: WHERE offer_id = p_offer_id
5883: AND off_discount_product_id = p_off_discount_product_id
6247: WHERE offer_id = p_offer_id;
6248: l_tier_level ozf_offers.tier_level%type;
6249:
6250: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6251: SELECT 1 FROM dual WHERE EXISTS
6252: (
6253: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
6254: WHERE offer_discount_line_id = p_offer_discount_line_id
6255: AND tier_type = 'PBH'