eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_DISC_LINE_PVT dependencies on OZF_OFFER_DISCOUNT_PRODUCTS

Line 1721: SELECT 1 from ozf_offer_discount_products

1717: ,p_excluder_flag IN VARCHAR2)
1718: RETURN VARCHAR2
1719: IS
1720: CURSOR c_item_exists(p_item_level VARCHAR2,p_item_number NUMBER,p_excluder_flag VARCHAR2 , p_offer_id NUMBER) IS
1721: SELECT 1 from ozf_offer_discount_products
1722: WHERE product_level = p_item_level
1723: AND product_id = p_item_number
1724: AND excluder_flag = p_excluder_flag
1725: AND offer_id = p_offer_id ;

Line 1750: 'ozf_offer_discount_products',

1746: IF p_validation_mode = JTF_PLSQL_API.g_create
1747: AND p_ozf_prod_rec.off_discount_product_id IS NOT NULL
1748: THEN
1749: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
1750: 'ozf_offer_discount_products',
1751: 'off_discount_product_id = ''' || p_ozf_prod_rec.off_discount_product_id ||''''
1752: );
1753: END IF;
1754: IF l_valid_flag = FND_API.g_false THEN

Line 1987: FROM ozf_offer_discount_products

1983: l_return_status VARCHAR2(1);
1984:
1985: CURSOR c_complete IS
1986: SELECT *
1987: FROM ozf_offer_discount_products
1988: WHERE off_discount_product_id = p_ozf_prod_rec.off_discount_product_id;
1989: l_ozf_prod_rec c_complete%ROWTYPE;
1990: BEGIN
1991: x_complete_rec := p_ozf_prod_rec;

Line 2324: SELECT ozf_offer_discount_products_s.NEXTVAL

2320: l_dummy NUMBER;
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

Line 2329: FROM OZF_OFFER_DISCOUNT_PRODUCTS

2325: FROM dual;
2326:
2327: CURSOR c_id_exists (l_id IN NUMBER) IS
2328: SELECT 1
2329: FROM OZF_OFFER_DISCOUNT_PRODUCTS
2330: WHERE off_discount_product_id = l_id;
2331: BEGIN
2332: -- Standard Start of API savepoint
2333: SAVEPOINT Create_Ozf_Prod_Line_pvt;

Line 2559: FROM OZF_OFFER_DISCOUNT_PRODUCTS

2555:
2556:
2557: CURSOR c_get_create_ozf_prod_line(off_discount_product_id NUMBER) IS
2558: SELECT *
2559: FROM OZF_OFFER_DISCOUNT_PRODUCTS
2560: WHERE off_discount_product_id = p_ozf_prod_rec.off_discount_product_id;
2561: -- Hint: Developer need to provide Where clause
2562:
2563:

Line 2757: select * FROM ozf_offer_discount_products where parent_off_disc_prod_id = p_parent_off_disc_prod_id;

2753: p_parent_off_disc_prod_id IN NUMBER
2754: )
2755: IS
2756: CURSOR c_excl_id IS
2757: select * FROM ozf_offer_discount_products where parent_off_disc_prod_id = p_parent_off_disc_prod_id;
2758: L_API_NAME CONSTANT VARCHAR2(30) := 'DELETE_EXCLUSIONS';
2759: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2760:
2761: BEGIN

Line 2863: select offer_id FROM ozf_offer_discount_products where off_discount_product_id = p_off_discount_product_id;

2859: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
2860: l_object_version_number NUMBER;
2861:
2862: CURSOR c_offer_id (p_off_discount_product_id NUMBER) IS
2863: select offer_id FROM ozf_offer_discount_products where off_discount_product_id = p_off_discount_product_id;
2864: l_offer_id ozf_offers.offer_id%type;
2865:
2866: BEGIN
2867: -- Standard Start of API savepoint

Line 3227: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_PRODUCTS','OFF_DISCOUNT_PRODUCT_ID',to_char(p_prod_reln_rec.off_discount_product_id)) = FND_API.g_false THEN

3223: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_prod_reln_rec.offer_discount_line_id)) = FND_API.g_false THEN
3224: OZF_Utility_PVT.Error_Message('OZF_PROD_RELN_FK_DUP' ); -- correct message
3225: x_return_status := FND_API.g_ret_sts_error;
3226: END IF;
3227: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_PRODUCTS','OFF_DISCOUNT_PRODUCT_ID',to_char(p_prod_reln_rec.off_discount_product_id)) = FND_API.g_false THEN
3228: OZF_Utility_PVT.Error_Message('Prod_ReL_FK_Dupliucate2' );--correct message
3229: x_return_status := FND_API.g_ret_sts_error;
3230: END IF;
3231: END IF;

Line 5244: SELECT offer_discount_line_id FROM ozf_offer_discount_products

5240: l_dl_rec C_DL_INFO%rowtype;
5241:
5242:
5243: CURSOR c_discount_line_id(p_off_discount_product_id NUMBER) IS
5244: SELECT offer_discount_line_id FROM ozf_offer_discount_products
5245: WHERE off_discount_product_id = p_off_discount_product_id;
5246: l_discount_line_id NUMBER;
5247: BEGIN
5248: SAVEPOINT Update_product_Pvt;

Line 5881: SELECT 1 FROM OZF_OFFER_DISCOUNT_PRODUCTS

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
5884: -- AND offer_discount_line_id = p_offer_discount_line_id
5885: AND excluder_flag = 'N'

Line 5966: FROM ozf_offer_discount_products

5962: l_ozf_prod_rec ozf_prod_rec_type ;
5963:
5964: CURSOR c_prod_info(p_off_discount_product_id NUMBER) IS
5965: SELECT *
5966: FROM ozf_offer_discount_products
5967: WHERE off_discount_product_id = p_off_discount_product_id;
5968:
5969: l_prod_rec c_prod_info%rowtype;
5970: BEGIN

Line 6023: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_PRODUCTS','OFF_DISCOUNT_PRODUCT_ID',to_char(l_ozf_prod_rec.parent_off_disc_prod_id)) = FND_API.g_false THEN

6019: RAISE FND_API.G_EXC_ERROR;
6020: END IF;
6021: END IF;
6022:
6023: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_PRODUCTS','OFF_DISCOUNT_PRODUCT_ID',to_char(l_ozf_prod_rec.parent_off_disc_prod_id)) = FND_API.g_false THEN
6024: OZF_Utility_PVT.Error_Message('FK_Non_exist' ); -- correct message
6025: x_return_status := FND_API.g_ret_sts_error;
6026: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6027: RAISE FND_API.G_EXC_ERROR;

Line 6122: SELECT * FROM ozf_offer_discount_products

6118: l_prod_reln_rec prod_reln_rec_type ;
6119: l_ozf_prod_rec ozf_prod_rec_type ;
6120:
6121: CURSOR C_ozf_prod_rec(p_off_discount_product_id NUMBER)IS
6122: SELECT * FROM ozf_offer_discount_products
6123: WHERE off_discount_product_id = p_off_discount_product_id;
6124:
6125: l_ref_ozf_prod_rec C_ozf_prod_rec%rowtype;
6126: