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_LINES

Line 205: 'ozf_offer_discount_lines',

201: IF p_validation_mode = JTF_PLSQL_API.g_create
202: AND p_ozf_offer_line_rec.offer_discount_line_id IS NOT NULL
203: THEN
204: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
205: 'ozf_offer_discount_lines',
206: 'offer_discount_line_id = ''' || p_ozf_offer_line_rec.offer_discount_line_id ||''''
207: );
208: END IF;
209:

Line 549: FROM ozf_offer_discount_lines

545: l_return_status VARCHAR2(1);
546:
547: CURSOR c_complete IS
548: SELECT *
549: FROM ozf_offer_discount_lines
550: WHERE offer_discount_line_id = p_ozf_offer_line_rec.offer_discount_line_id;
551: l_ozf_offer_line_rec c_complete%ROWTYPE;
552: BEGIN
553: x_complete_rec := p_ozf_offer_line_rec;

Line 963: SELECT ozf_offer_discount_lines_s.NEXTVAL

959: l_offer_discount_line_id NUMBER;
960: l_dummy NUMBER;
961: l_ozf_offer_line_rec ozf_offer_line_rec_type;
962: CURSOR c_id IS
963: SELECT ozf_offer_discount_lines_s.NEXTVAL
964: FROM dual;
965:
966: CURSOR c_id_exists (l_id IN NUMBER) IS
967: SELECT 1

Line 968: FROM OZF_OFFER_DISCOUNT_LINES

964: FROM dual;
965:
966: CURSOR c_id_exists (l_id IN NUMBER) IS
967: SELECT 1
968: FROM OZF_OFFER_DISCOUNT_LINES
969: WHERE offer_discount_line_id = l_id;
970: BEGIN
971: -- Standard Start of API savepoint
972: SAVEPOINT create_ozf_disc_line_pvt;

Line 1220: FROM OZF_OFFER_DISCOUNT_LINES

1216:
1217:
1218: CURSOR c_get_ozf_disc_line(offer_discount_line_id NUMBER) IS
1219: SELECT *
1220: FROM OZF_OFFER_DISCOUNT_LINES
1221: WHERE offer_discount_line_id = p_ozf_offer_line_rec.offer_discount_line_id;
1222: -- Hint: Developer need to provide Where clause
1223:
1224:

Line 1876: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_ozf_prod_rec.offer_discount_line_id)) = FND_API.g_false THEN

1872: END IF;
1873:
1874: IF p_ozf_prod_rec.offer_discount_line_id <> -1 THEN
1875: IF p_ozf_prod_rec.offer_discount_line_id is not null AND p_ozf_prod_rec.offer_discount_line_id <> fnd_api.g_miss_num THEN
1876: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_ozf_prod_rec.offer_discount_line_id)) = FND_API.g_false THEN
1877: OZF_Utility_PVT.Error_Message('OZF_DISC_LINE_FK_DUP' ); -- correct message
1878: x_return_status := FND_API.g_ret_sts_error;
1879: END IF;
1880: END IF;

Line 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

3220: x_return_status := FND_API.g_ret_sts_success;
3221:
3222: -- Enter custom code here
3223: IF p_prod_reln_rec.offer_discount_line_id <> -1 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

Line 4192: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES

4188: IS
4189: CURSOR C_SQL (p_offer_id NUMBER, p_offer_discount_line_id NUMBER) IS
4190: SELECT 1 FROM dual WHERE EXISTS
4191: (
4192: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
4193: WHERE offer_id = p_offer_id
4194: AND offer_discount_line_id = p_offer_discount_line_id
4195: );
4196: l_count NUMBER:= 0;

Line 4588: l_tier_level ozf_offer_discount_lines.tier_level%type := 'HEADER';

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:
4590: BEGIN
4591: p_discount_rec.volume_operator := 'BETWEEN';
4592: p_discount_rec.volume_break_type := 'POINT';

Line 4659: l_tier_level ozf_offer_discount_lines.tier_level%type := 'HEADER';

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);
4662: FETCH c_tier_level INTO l_tier_level;
4663: CLOSE c_tier_level;

Line 5033: FROM OZF_OFFER_DISCOUNT_LINES

5029:
5030:
5031: /*CURSOR c_get_ozf_disc_line(offer_discount_line_id NUMBER) IS
5032: SELECT *
5033: FROM OZF_OFFER_DISCOUNT_LINES
5034: WHERE offer_discount_line_id = p_ozf_offer_line_rec.offer_discount_line_id;
5035: l_rec c_get_ozf_disc_line%rowtype;
5036: */
5037: BEGIN

Line 5257: FROM ozf_offer_discount_lines

5253: l_ozf_offer_line_rec ozf_offer_line_rec_type ;
5254:
5255: CURSOR C_DL_INFO (p_offer_discount_line_id NUMBER)is
5256: SELECT offer_discount_line_id,offer_id,object_version_number
5257: FROM ozf_offer_discount_lines
5258: WHERE offer_discount_line_id = p_offer_discount_line_id;
5259: l_dl_rec C_DL_INFO%rowtype;
5260:
5261:

Line 5740: SELECT * FROM ozf_offer_discount_lines

5736: l_msg_count NUMBER;
5737: l_msg_data VARCHAR2(2000);
5738: */
5739: CURSOR C_PARENT_DISC_LINE(p_offer_discount_line_id NUMBER )IS
5740: SELECT * FROM ozf_offer_discount_lines
5741: WHERE offer_discount_line_id = p_offer_discount_line_id;
5742:
5743: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
5744:

Line 5746: select offer_id FROM ozf_offer_discount_lines where offer_discount_line_id = p_offer_discount_line_id;

5742:
5743: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
5744:
5745: cursor c_offer_id(p_offer_discount_line_id NUMBER) IS
5746: select offer_id FROM ozf_offer_discount_lines where offer_discount_line_id = p_offer_discount_line_id;
5747:
5748: l_offer_id NUMBER;
5749:
5750: BEGIN

Line 6272: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES

6268:
6269: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6270: SELECT 1 FROM dual WHERE EXISTS
6271: (
6272: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
6273: WHERE offer_discount_line_id = p_offer_discount_line_id
6274: AND tier_type = 'PBH'
6275: );
6276: l_count NUMBER:= 0;

Line 6520: SELECT * FROM ozf_offer_discount_lines

6516: -- l_return_status VARCHAR2(30);
6517:
6518: /* l_offer_line_rec ozf_offer_line_rec_type;
6519: CURSOR C_ozf_disc_rec(p_offer_discount_line_id NUMBER)IS
6520: SELECT * FROM ozf_offer_discount_lines
6521: WHERE offer_discount_line_id = p_offer_discount_line_id;
6522:
6523: l_ozf_disc_rec C_ozf_disc_rec%rowtype;
6524: */

Line 6661: SELECT * FROM ozf_offer_discount_lines

6657: -- l_return_status VARCHAR2(30);
6658:
6659: /* l_offer_line_rec ozf_offer_line_rec_type;
6660: CURSOR C_ozf_disc_rec(p_offer_discount_line_id NUMBER)IS
6661: SELECT * FROM ozf_offer_discount_lines
6662: WHERE offer_discount_line_id = p_offer_discount_line_id;
6663:
6664: l_ozf_disc_rec C_ozf_disc_rec%rowtype;
6665: */

Line 6795: SELECT * FROM ozf_offer_discount_lines

6791:
6792: -- l_return_status VARCHAR2(30);
6793:
6794: CURSOR C_PARENT_DISC_LINE(p_offer_discount_line_id NUMBER )IS
6795: SELECT * FROM ozf_offer_discount_lines
6796: WHERE offer_discount_line_id = p_offer_discount_line_id;
6797:
6798: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
6799:

Line 6932: (SELECT offer_id FROM ozf_offer_discount_lines

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;
6936: