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 75: SELECT status_code FROM ozf_offers where offer_id = p_offer_id;

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

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

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

Line 234: l_tier_level ozf_offers.tier_level%type;

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

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

421: -- Enter custom code here
422:
423: IF p_ozf_offer_line_rec.offer_id IS NOT NULL AND p_ozf_offer_line_rec.offer_id <> FND_API.G_MISS_NUM
424: THEN
425: 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
426: OZF_Utility_PVT.Error_Message('OZF_OFFER_ID_DUP' ); -- correct message
427: x_return_status := FND_API.g_ret_sts_error;
428: return;
429: END IF;

Line 458: FROM ozf_offers

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

Line 460: l_currency ozf_offers.transaction_currency_code%TYPE;

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

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

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

Line 2865: l_offer_id ozf_offers.offer_id%type;

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

Line 4585: SELECT tier_level FROM ozf_offers

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

Line 4657: SELECT tier_level FROM ozf_offers

4653:
4654: PROCEDURE default_prod_rec(p_product_rec IN OUT NOCOPY ozf_prod_rec_type)
4655: is
4656: CURSOR c_tier_level(p_offer_id NUMBER) is
4657: SELECT tier_level FROM ozf_offers
4658: WHERE offer_id = p_offer_id;
4659: l_tier_level ozf_offer_discount_lines.tier_level%type := 'HEADER';
4660: BEGIN
4661: OPEN c_tier_level(p_product_rec.offer_id);

Line 6265: SELECT tier_level FROM ozf_offers

6261: , p_tier_rec IN ozf_offer_tier_rec_type
6262: )
6263: IS
6264: CURSOR c_tier_level(p_offer_id NUMBER) IS
6265: SELECT tier_level FROM ozf_offers
6266: WHERE offer_id = p_offer_id;
6267: l_tier_level ozf_offers.tier_level%type;
6268:
6269: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS

Line 6267: l_tier_level ozf_offers.tier_level%type;

6263: IS
6264: CURSOR c_tier_level(p_offer_id NUMBER) IS
6265: SELECT tier_level FROM ozf_offers
6266: WHERE offer_id = p_offer_id;
6267: l_tier_level ozf_offers.tier_level%type;
6268:
6269: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6270: SELECT 1 FROM dual WHERE EXISTS
6271: (

Line 6345: SELECT tier_level FROM ozf_offers

6341: )
6342: IS
6343: CURSOR c_tier_level (p_offer_id NUMBER)
6344: is
6345: SELECT tier_level FROM ozf_offers
6346: where offer_id = p_offer_id;
6347: l_tier_level ozf_offers.tier_level%type;
6348: BEGIN
6349: x_return_status := FND_API.g_ret_sts_success;

Line 6347: l_tier_level ozf_offers.tier_level%type;

6343: CURSOR c_tier_level (p_offer_id NUMBER)
6344: is
6345: SELECT tier_level FROM ozf_offers
6346: where offer_id = p_offer_id;
6347: l_tier_level ozf_offers.tier_level%type;
6348: BEGIN
6349: x_return_status := FND_API.g_ret_sts_success;
6350: p_disc_rec.tier_type := 'DIS';
6351: p_disc_rec.offer_id := p_tier_rec.offer_id;

Line 6371: SELECT tier_level FROM ozf_offers

6367: x_return_status OUT NOCOPY VARCHAR2
6368: )
6369: IS
6370: CURSOR c_tier_level(p_offer_id NUMBER) IS
6371: SELECT tier_level FROM ozf_offers
6372: WHERE offer_id = p_offer_id;
6373: l_tier_level VARCHAR2(30);
6374:
6375: BEGIN

Line 6931: SELECT tier_level FROM ozf_offers where offer_id =

6927:
6928:
6929: CURSOR c_tier_level(p_offer_discount_line_id NUMBER)
6930: is
6931: SELECT tier_level FROM ozf_offers where offer_id =
6932: (SELECT offer_id FROM ozf_offer_discount_lines
6933: WHERE offer_discount_line_id = p_offer_discount_line_id );
6934:
6935: l_tier_level ozf_offers.tier_level%type;

Line 6935: l_tier_level ozf_offers.tier_level%type;

6931: SELECT tier_level FROM ozf_offers where offer_id =
6932: (SELECT offer_id FROM ozf_offer_discount_lines
6933: WHERE offer_discount_line_id = p_offer_discount_line_id );
6934:
6935: l_tier_level ozf_offers.tier_level%type;
6936:
6937: BEGIN
6938: SAVEPOINT Delete_tier_line_Pvt;
6939: