APPS.OZF_COPY_OFFER_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 144: FROM ozf_offer_discount_products

140: , product_attr_value
141: , apply_discount_flag
142: , include_volume_flag
143: , excluder_flag
144: FROM ozf_offer_discount_products
145: WHERE offer_discount_line_id = cp_sourceTierHeaderId;
146: l_vo_prod_rec OZF_Volume_Offer_disc_PVT.vo_prod_rec_type;
147: BEGIN
148: -- initialize

Line 1240: SELECT ozf_offer_discount_products_s.NEXTVAL

1236: ,p_new_line_id IN NUMBER
1237: ,x_new_prod_id OUT NOCOPY NUMBER)
1238: IS
1239: CURSOR c_new_prod_id IS
1240: SELECT ozf_offer_discount_products_s.NEXTVAL
1241: FROM DUAL;
1242:
1243: CURSOR c_prod_id_exists(l_id NUMBER) IS
1244: SELECT 1

Line 1247: FROM ozf_offer_discount_products

1243: CURSOR c_prod_id_exists(l_id NUMBER) IS
1244: SELECT 1
1245: FROM DUAL
1246: WHERE EXISTS (SELECT 1
1247: FROM ozf_offer_discount_products
1248: WHERE off_discount_product_id = l_id);
1249:
1250: CURSOR c_product_detail IS
1251: SELECT *

Line 1252: FROM ozf_offer_discount_products

1248: WHERE off_discount_product_id = l_id);
1249:
1250: CURSOR c_product_detail IS
1251: SELECT *
1252: FROM ozf_offer_discount_products
1253: WHERE off_discount_product_id = p_org_prod_id;
1254:
1255: l_product_detail c_product_detail%ROWTYPE;
1256: l_count NUMBER;

Line 1276: INSERT INTO ozf_offer_discount_products(off_discount_product_id

1272: OPEN c_product_detail;
1273: FETCH c_product_detail INTO l_product_detail;
1274: CLOSE c_product_detail;
1275:
1276: INSERT INTO ozf_offer_discount_products(off_discount_product_id
1277: ,product_level
1278: ,product_id
1279: ,excluder_flag
1280: ,uom_code

Line 1332: FROM ozf_offer_discount_products

1328: AND parent_discount_line_id = p_parent_line_id;
1329:
1330: CURSOR c_product_id(p_line_id NUMBER) IS
1331: SELECT off_discount_product_id
1332: FROM ozf_offer_discount_products
1333: WHERE offer_discount_line_id = p_line_id;
1334:
1335: l_new_line_id NUMBER;
1336: l_product_id NUMBER;

Line 1378: FROM ozf_offer_discount_products

1374: WHERE qp_list_header_id = p_source_object_id);
1375:
1376: CURSOR c_parent_products IS
1377: SELECT off_discount_product_id
1378: FROM ozf_offer_discount_products
1379: WHERE offer_id = (SELECT offer_id
1380: FROM ozf_offers
1381: WHERE qp_list_header_id = p_source_object_id)
1382: AND parent_off_disc_prod_id IS NULL;

Line 1386: FROM ozf_offer_discount_products

1382: AND parent_off_disc_prod_id IS NULL;
1383:
1384: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS
1385: SELECT off_discount_product_id
1386: FROM ozf_offer_discount_products
1387: WHERE offer_id = (SELECT offer_id
1388: FROM ozf_offers
1389: WHERE qp_list_header_id = p_source_object_id)
1390: AND parent_off_disc_prod_id = p_parent_prod_id;