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 1722: SELECT 1 from ozf_offer_discount_products

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

Line 1751: 'ozf_offer_discount_products',

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

Line 1988: FROM ozf_offer_discount_products

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

Line 2325: SELECT ozf_offer_discount_products_s.NEXTVAL

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

Line 2330: FROM OZF_OFFER_DISCOUNT_PRODUCTS

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

Line 2560: FROM OZF_OFFER_DISCOUNT_PRODUCTS

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

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

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

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

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

Line 3228: 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

3224: 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
3225: OZF_Utility_PVT.Error_Message('OZF_PROD_RELN_FK_DUP' ); -- correct message
3226: x_return_status := FND_API.g_ret_sts_error;
3227: END IF;
3228: 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
3229: OZF_Utility_PVT.Error_Message('Prod_ReL_FK_Dupliucate2' );--correct message
3230: x_return_status := FND_API.g_ret_sts_error;
3231: END IF;
3232: END IF;

Line 5263: SELECT offer_discount_line_id FROM ozf_offer_discount_products

5259: l_dl_rec C_DL_INFO%rowtype;
5260:
5261:
5262: CURSOR c_discount_line_id(p_off_discount_product_id NUMBER) IS
5263: SELECT offer_discount_line_id FROM ozf_offer_discount_products
5264: WHERE off_discount_product_id = p_off_discount_product_id;
5265: l_discount_line_id NUMBER;
5266: BEGIN
5267: SAVEPOINT Update_product_Pvt;

Line 5900: SELECT 1 FROM OZF_OFFER_DISCOUNT_PRODUCTS

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

Line 5985: FROM ozf_offer_discount_products

5981: l_ozf_prod_rec ozf_prod_rec_type ;
5982:
5983: CURSOR c_prod_info(p_off_discount_product_id NUMBER) IS
5984: SELECT *
5985: FROM ozf_offer_discount_products
5986: WHERE off_discount_product_id = p_off_discount_product_id;
5987:
5988: l_prod_rec c_prod_info%rowtype;
5989: BEGIN

Line 6042: 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

6038: RAISE FND_API.G_EXC_ERROR;
6039: END IF;
6040: END IF;
6041:
6042: 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
6043: OZF_Utility_PVT.Error_Message('FK_Non_exist' ); -- correct message
6044: x_return_status := FND_API.g_ret_sts_error;
6045: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
6046: RAISE FND_API.G_EXC_ERROR;

Line 6141: SELECT * FROM ozf_offer_discount_products

6137: l_prod_reln_rec prod_reln_rec_type ;
6138: l_ozf_prod_rec ozf_prod_rec_type ;
6139:
6140: CURSOR C_ozf_prod_rec(p_off_discount_product_id NUMBER)IS
6141: SELECT * FROM ozf_offer_discount_products
6142: WHERE off_discount_product_id = p_off_discount_product_id;
6143:
6144: l_ref_ozf_prod_rec C_ozf_prod_rec%rowtype;
6145: