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 1267: SELECT ozf_offer_discount_products_s.NEXTVAL

1263: ,p_new_line_id IN NUMBER
1264: ,x_new_prod_id OUT NOCOPY NUMBER)
1265: IS
1266: CURSOR c_new_prod_id IS
1267: SELECT ozf_offer_discount_products_s.NEXTVAL
1268: FROM DUAL;
1269:
1270: CURSOR c_prod_id_exists(l_id NUMBER) IS
1271: SELECT 1

Line 1274: FROM ozf_offer_discount_products

1270: CURSOR c_prod_id_exists(l_id NUMBER) IS
1271: SELECT 1
1272: FROM DUAL
1273: WHERE EXISTS (SELECT 1
1274: FROM ozf_offer_discount_products
1275: WHERE off_discount_product_id = l_id);
1276:
1277: CURSOR c_product_detail IS
1278: SELECT *

Line 1279: FROM ozf_offer_discount_products

1275: WHERE off_discount_product_id = l_id);
1276:
1277: CURSOR c_product_detail IS
1278: SELECT *
1279: FROM ozf_offer_discount_products
1280: WHERE off_discount_product_id = p_org_prod_id;
1281:
1282: l_product_detail c_product_detail%ROWTYPE;
1283: l_count NUMBER;

Line 1303: INSERT INTO ozf_offer_discount_products(off_discount_product_id

1299: OPEN c_product_detail;
1300: FETCH c_product_detail INTO l_product_detail;
1301: CLOSE c_product_detail;
1302:
1303: INSERT INTO ozf_offer_discount_products(off_discount_product_id
1304: ,product_level
1305: ,product_id
1306: ,excluder_flag
1307: ,uom_code

Line 1359: FROM ozf_offer_discount_products

1355: AND parent_discount_line_id = p_parent_line_id;
1356:
1357: CURSOR c_product_id(p_line_id NUMBER) IS
1358: SELECT off_discount_product_id
1359: FROM ozf_offer_discount_products
1360: WHERE offer_discount_line_id = p_line_id;
1361:
1362: l_new_line_id NUMBER;
1363: l_product_id NUMBER;

Line 1405: FROM ozf_offer_discount_products

1401: WHERE qp_list_header_id = p_source_object_id);
1402:
1403: CURSOR c_parent_products IS
1404: SELECT off_discount_product_id
1405: FROM ozf_offer_discount_products
1406: WHERE offer_id = (SELECT offer_id
1407: FROM ozf_offers
1408: WHERE qp_list_header_id = p_source_object_id)
1409: AND parent_off_disc_prod_id IS NULL;

Line 1413: FROM ozf_offer_discount_products

1409: AND parent_off_disc_prod_id IS NULL;
1410:
1411: CURSOR c_excl_products(p_parent_prod_id NUMBER) IS
1412: SELECT off_discount_product_id
1413: FROM ozf_offer_discount_products
1414: WHERE offer_id = (SELECT offer_id
1415: FROM ozf_offers
1416: WHERE qp_list_header_id = p_source_object_id)
1417: AND parent_off_disc_prod_id = p_parent_prod_id;