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.

[Home] [Help]

APPS.OZF_DISC_LINE_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 204: 'ozf_offer_discount_lines',

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

Line 548: FROM ozf_offer_discount_lines

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

Line 962: SELECT ozf_offer_discount_lines_s.NEXTVAL

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

Line 967: FROM OZF_OFFER_DISCOUNT_LINES

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

Line 1219: FROM OZF_OFFER_DISCOUNT_LINES

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

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

1871: END IF;
1872:
1873: IF p_ozf_prod_rec.offer_discount_line_id <> -1 THEN
1874: 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
1875: 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
1876: OZF_Utility_PVT.Error_Message('OZF_DISC_LINE_FK_DUP' ); -- correct message
1877: x_return_status := FND_API.g_ret_sts_error;
1878: END IF;
1879: END IF;

Line 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

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

Line 4191: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES

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

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

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

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

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

Line 5014: FROM OZF_OFFER_DISCOUNT_LINES

5010:
5011:
5012: /*CURSOR c_get_ozf_disc_line(offer_discount_line_id NUMBER) IS
5013: SELECT *
5014: FROM OZF_OFFER_DISCOUNT_LINES
5015: WHERE offer_discount_line_id = p_ozf_offer_line_rec.offer_discount_line_id;
5016: l_rec c_get_ozf_disc_line%rowtype;
5017: */
5018: BEGIN

Line 5238: FROM ozf_offer_discount_lines

5234: l_ozf_offer_line_rec ozf_offer_line_rec_type ;
5235:
5236: CURSOR C_DL_INFO (p_offer_discount_line_id NUMBER)is
5237: SELECT offer_discount_line_id,offer_id,object_version_number
5238: FROM ozf_offer_discount_lines
5239: WHERE offer_discount_line_id = p_offer_discount_line_id;
5240: l_dl_rec C_DL_INFO%rowtype;
5241:
5242:

Line 5721: SELECT * FROM ozf_offer_discount_lines

5717: l_msg_count NUMBER;
5718: l_msg_data VARCHAR2(2000);
5719: */
5720: CURSOR C_PARENT_DISC_LINE(p_offer_discount_line_id NUMBER )IS
5721: SELECT * FROM ozf_offer_discount_lines
5722: WHERE offer_discount_line_id = p_offer_discount_line_id;
5723:
5724: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
5725:

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

5723:
5724: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
5725:
5726: cursor c_offer_id(p_offer_discount_line_id NUMBER) IS
5727: select offer_id FROM ozf_offer_discount_lines where offer_discount_line_id = p_offer_discount_line_id;
5728:
5729: l_offer_id NUMBER;
5730:
5731: BEGIN

Line 6253: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES

6249:
6250: CURSOR C_SQL ( p_offer_discount_line_id NUMBER) IS
6251: SELECT 1 FROM dual WHERE EXISTS
6252: (
6253: SELECT 1 FROM OZF_OFFER_DISCOUNT_LINES
6254: WHERE offer_discount_line_id = p_offer_discount_line_id
6255: AND tier_type = 'PBH'
6256: );
6257: l_count NUMBER:= 0;

Line 6483: SELECT * FROM ozf_offer_discount_lines

6479: -- l_return_status VARCHAR2(30);
6480:
6481: /* l_offer_line_rec ozf_offer_line_rec_type;
6482: CURSOR C_ozf_disc_rec(p_offer_discount_line_id NUMBER)IS
6483: SELECT * FROM ozf_offer_discount_lines
6484: WHERE offer_discount_line_id = p_offer_discount_line_id;
6485:
6486: l_ozf_disc_rec C_ozf_disc_rec%rowtype;
6487: */

Line 6624: SELECT * FROM ozf_offer_discount_lines

6620: -- l_return_status VARCHAR2(30);
6621:
6622: /* l_offer_line_rec ozf_offer_line_rec_type;
6623: CURSOR C_ozf_disc_rec(p_offer_discount_line_id NUMBER)IS
6624: SELECT * FROM ozf_offer_discount_lines
6625: WHERE offer_discount_line_id = p_offer_discount_line_id;
6626:
6627: l_ozf_disc_rec C_ozf_disc_rec%rowtype;
6628: */

Line 6758: SELECT * FROM ozf_offer_discount_lines

6754:
6755: -- l_return_status VARCHAR2(30);
6756:
6757: CURSOR C_PARENT_DISC_LINE(p_offer_discount_line_id NUMBER )IS
6758: SELECT * FROM ozf_offer_discount_lines
6759: WHERE offer_discount_line_id = p_offer_discount_line_id;
6760:
6761: l_parent_disc_line C_PARENT_DISC_LINE%rowtype;
6762:

Line 6895: (SELECT offer_id FROM ozf_offer_discount_lines

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