[Home] [Help]
960: l_dummy NUMBER;
961: l_ozf_offer_line_rec ozf_offer_line_rec_type;
962: CURSOR c_id IS
963: SELECT ozf_offer_discount_lines_s.NEXTVAL
964: FROM dual;
965:
966: CURSOR c_id_exists (l_id IN NUMBER) IS
967: SELECT 1
968: FROM OZF_OFFER_DISCOUNT_LINES
2322: l_ozf_prod_rec ozf_prod_rec_type := g_miss_ozf_prod_rec;
2323:
2324: CURSOR c_id IS
2325: SELECT ozf_offer_discount_products_s.NEXTVAL
2326: FROM dual;
2327:
2328: CURSOR c_id_exists (l_id IN NUMBER) IS
2329: SELECT 1
2330: FROM OZF_OFFER_DISCOUNT_PRODUCTS
3625: l_prod_reln_rec prod_reln_rec_type := g_miss_prod_reln_rec;
3626:
3627: CURSOR c_id IS
3628: SELECT ozf_discount_product_reln_s.NEXTVAL
3629: FROM dual;
3630:
3631: CURSOR c_id_exists (l_id IN NUMBER) IS
3632: SELECT 1
3633: FROM OZF_DISCOUNT_PRODUCT_RELN
4186: , p_ozf_prod_rec IN ozf_prod_rec_type := g_miss_ozf_prod_rec
4187: )
4188: IS
4189: CURSOR C_SQL (p_offer_id NUMBER, p_offer_discount_line_id NUMBER) IS
4190: SELECT 1 FROM dual WHERE EXISTS
4191: (
4192: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
4193: WHERE offer_id = p_offer_id
4194: AND offer_discount_line_id = p_offer_discount_line_id
5894: , p_ozf_prod_rec IN ozf_prod_rec_type := g_miss_ozf_prod_rec
5895: )
5896: IS
5897: CURSOR C_SQL (p_offer_id NUMBER, p_off_discount_product_id NUMBER,p_offer_discount_line_id NUMBER) IS
5898: SELECT 1 FROM dual WHERE EXISTS
5899: (
5900: SELECT 1 FROM OZF_OFFER_DISCOUNT_PRODUCTS
5901: WHERE offer_id = p_offer_id
5902: AND off_discount_product_id = p_off_discount_product_id
6266: WHERE offer_id = p_offer_id;
6267: l_tier_level ozf_offers.tier_level%type;
6268:
6269: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6270: SELECT 1 FROM dual WHERE EXISTS
6271: (
6272: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
6273: WHERE offer_discount_line_id = p_offer_discount_line_id
6274: AND tier_type = 'PBH'