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_OFFERS

Line 74: SELECT status_code FROM ozf_offers where offer_id = p_offer_id;

70: FUNCTION is_delete_valid(p_offer_id IN NUMBER)
71: RETURN VARCHAR2
72: IS
73: CURSOR c_offer_status(p_offer_id NUMBER) IS
74: SELECT status_code FROM ozf_offers where offer_id = p_offer_id;
75: l_offer_status VARCHAR2(30);
76: l_return VARCHAR2(1) := 'N';
77: BEGIN
78: OPEN c_offer_status(p_offer_id);

Line 231: select tier_level FROM ozf_offers where offer_id = p_offer_id;

227: x_return_status OUT NOCOPY VARCHAR2
228: )
229: IS
230: CURSOR c_tier_level(p_offer_id NUMBER) IS
231: select tier_level FROM ozf_offers where offer_id = p_offer_id;
232:
233: l_tier_level ozf_offers.tier_level%type;
234:
235: BEGIN

Line 233: l_tier_level ozf_offers.tier_level%type;

229: IS
230: CURSOR c_tier_level(p_offer_id NUMBER) IS
231: select tier_level FROM ozf_offers where offer_id = p_offer_id;
232:
233: l_tier_level ozf_offers.tier_level%type;
234:
235: BEGIN
236: open c_tier_level(p_ozf_offer_line_rec.offer_id);
237: fetch c_tier_level into l_tier_level;

Line 424: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_ozf_offer_line_rec.offer_id)) = FND_API.g_false THEN

420: -- Enter custom code here
421:
422: IF p_ozf_offer_line_rec.offer_id IS NOT NULL AND p_ozf_offer_line_rec.offer_id <> FND_API.G_MISS_NUM
423: THEN
424: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_ozf_offer_line_rec.offer_id)) = FND_API.g_false THEN
425: OZF_Utility_PVT.Error_Message('OZF_OFFER_ID_DUP' ); -- correct message
426: x_return_status := FND_API.g_ret_sts_error;
427: return;
428: END IF;

Line 457: FROM ozf_offers

453: IS
454: CURSOR c_currency(cp_offerId NUMBER)
455: IS
456: SELECT transaction_currency_code
457: FROM ozf_offers
458: WHERE offer_id = cp_offerId;
459: l_currency ozf_offers.transaction_currency_code%TYPE;
460: BEGIN
461: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 459: l_currency ozf_offers.transaction_currency_code%TYPE;

455: IS
456: SELECT transaction_currency_code
457: FROM ozf_offers
458: WHERE offer_id = cp_offerId;
459: l_currency ozf_offers.transaction_currency_code%TYPE;
460: BEGIN
461: x_return_status := FND_API.G_RET_STS_SUCCESS;
462: OPEN c_currency(cp_offerId => p_ozf_offer_line_rec.offer_id);
463: FETCH c_currency INTO l_currency;

Line 1867: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_ozf_prod_rec.offer_id)) = FND_API.g_false THEN

1863: x_return_status := FND_API.g_ret_sts_success;
1864:
1865: -- Enter custom code here
1866: IF p_ozf_prod_rec.offer_id is not null AND p_ozf_prod_rec.offer_id <> FND_API.G_MISS_NUM THEN
1867: IF ozf_utility_pvt.check_fk_exists('OZF_OFFERS','OFFER_ID',to_char(p_ozf_prod_rec.offer_id)) = FND_API.g_false THEN
1868: OZF_Utility_PVT.Error_Message('OZF_PROD_OFFER_ID_FK_DUP' ); -- correct message
1869: x_return_status := FND_API.g_ret_sts_error;
1870: END IF;
1871: END IF;

Line 2864: l_offer_id ozf_offers.offer_id%type;

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
2868: SAVEPOINT Delete_Ozf_Prod_Line_pvt;

Line 4584: SELECT tier_level FROM ozf_offers

4580: --=========================================================================
4581: procedure default_disc_rec(p_discount_rec IN OUT NOCOPY ozf_offer_line_rec_type)
4582: IS
4583: CURSOR c_tier_level(p_offer_id NUMBER) is
4584: SELECT tier_level FROM ozf_offers
4585: WHERE offer_id = p_offer_id;
4586:
4587: l_tier_level ozf_offer_discount_lines.tier_level%type := 'HEADER';
4588:

Line 4638: SELECT tier_level FROM ozf_offers

4634:
4635: PROCEDURE default_prod_rec(p_product_rec IN OUT NOCOPY ozf_prod_rec_type)
4636: is
4637: CURSOR c_tier_level(p_offer_id NUMBER) is
4638: SELECT tier_level FROM ozf_offers
4639: WHERE offer_id = p_offer_id;
4640: l_tier_level ozf_offer_discount_lines.tier_level%type := 'HEADER';
4641: BEGIN
4642: OPEN c_tier_level(p_product_rec.offer_id);

Line 6246: SELECT tier_level FROM ozf_offers

6242: , p_tier_rec IN ozf_offer_tier_rec_type
6243: )
6244: IS
6245: CURSOR c_tier_level(p_offer_id NUMBER) IS
6246: SELECT tier_level FROM ozf_offers
6247: WHERE offer_id = p_offer_id;
6248: l_tier_level ozf_offers.tier_level%type;
6249:
6250: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS

Line 6248: l_tier_level ozf_offers.tier_level%type;

6244: IS
6245: CURSOR c_tier_level(p_offer_id NUMBER) IS
6246: SELECT tier_level FROM ozf_offers
6247: WHERE offer_id = p_offer_id;
6248: l_tier_level ozf_offers.tier_level%type;
6249:
6250: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6251: SELECT 1 FROM dual WHERE EXISTS
6252: (

Line 6308: SELECT tier_level FROM ozf_offers

6304: )
6305: IS
6306: CURSOR c_tier_level (p_offer_id NUMBER)
6307: is
6308: SELECT tier_level FROM ozf_offers
6309: where offer_id = p_offer_id;
6310: l_tier_level ozf_offers.tier_level%type;
6311: BEGIN
6312: x_return_status := FND_API.g_ret_sts_success;

Line 6310: l_tier_level ozf_offers.tier_level%type;

6306: CURSOR c_tier_level (p_offer_id NUMBER)
6307: is
6308: SELECT tier_level FROM ozf_offers
6309: where offer_id = p_offer_id;
6310: l_tier_level ozf_offers.tier_level%type;
6311: BEGIN
6312: x_return_status := FND_API.g_ret_sts_success;
6313: p_disc_rec.tier_type := 'DIS';
6314: p_disc_rec.offer_id := p_tier_rec.offer_id;

Line 6334: SELECT tier_level FROM ozf_offers

6330: x_return_status OUT NOCOPY VARCHAR2
6331: )
6332: IS
6333: CURSOR c_tier_level(p_offer_id NUMBER) IS
6334: SELECT tier_level FROM ozf_offers
6335: WHERE offer_id = p_offer_id;
6336: l_tier_level VARCHAR2(30);
6337:
6338: BEGIN

Line 6894: SELECT tier_level FROM ozf_offers where offer_id =

6890:
6891:
6892: CURSOR c_tier_level(p_offer_discount_line_id NUMBER)
6893: is
6894: SELECT tier_level FROM ozf_offers where offer_id =
6895: (SELECT offer_id FROM ozf_offer_discount_lines
6896: WHERE offer_discount_line_id = p_offer_discount_line_id );
6897:
6898: l_tier_level ozf_offers.tier_level%type;

Line 6898: l_tier_level ozf_offers.tier_level%type;

6894: SELECT tier_level FROM ozf_offers where offer_id =
6895: (SELECT offer_id FROM ozf_offer_discount_lines
6896: WHERE offer_discount_line_id = p_offer_discount_line_id );
6897:
6898: l_tier_level ozf_offers.tier_level%type;
6899:
6900: BEGIN
6901: SAVEPOINT Delete_tier_line_Pvt;
6902: