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_VOLUME_OFFER_DISC_PVT dependencies on OZF_OFFER_DISCOUNT_LINES

Line 75: SELECT 'Y' from dual where exists (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = cp_offerDiscountLineId AND tier_type = 'PBH');

71: ( p_offerDiscountLineId IN NUMBER)
72: RETURN VARCHAR2
73: IS
74: CURSOR c_discountLineExists(cp_offerDiscountLineId NUMBER) is
75: SELECT 'Y' from dual where exists (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = cp_offerDiscountLineId AND tier_type = 'PBH');
76: l_discountLineExists VARCHAR2(1) := 'Y';
77: BEGIN
78: OPEN c_discountLineExists(p_offerDiscountLineId );
79: FETCH c_discountLineExists INTO l_discountLineExists;

Line 98: SELECT 1 FROM OZF_OFFR_DISC_STRUCT_NAME_TL tl, ozf_offr_disc_struct_name_b b, ozf_offer_discount_lines l

94: CURSOR c_name(p_name IN VARCHAR2 , p_offer_id IN NUMBER)
95: IS
96: SELECT 1 FROM DUAL WHERE EXISTS
97: (
98: SELECT 1 FROM OZF_OFFR_DISC_STRUCT_NAME_TL tl, ozf_offr_disc_struct_name_b b, ozf_offer_discount_lines l
99: WHERE b.offr_disc_struct_name_id = tl.offr_disc_struct_name_id
100: AND tl.LANGUAGE = userenv('LANG')
101: AND l.offer_discount_line_id = b.offer_discount_line_id
102: AND tl.discount_table_name = p_name

Line 113: IF OZF_Utility_PVT.check_uniqueness('ozf_offer_discount_lines','offer_discount_line_id = ''' || p_vo_disc_rec.offer_discount_line_id ||'''') = FND_API.g_false THEN

109:
110: IF p_validation_mode = JTF_PLSQL_API.g_create
111: AND p_vo_disc_rec.offer_discount_line_id IS NOT NULL
112: THEN
113: IF OZF_Utility_PVT.check_uniqueness('ozf_offer_discount_lines','offer_discount_line_id = ''' || p_vo_disc_rec.offer_discount_line_id ||'''') = FND_API.g_false THEN
114: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_LINE_ID_DUP');
115: x_return_status := FND_API.g_ret_sts_error;
116: END IF;
117: END IF;

Line 181: SELECT volume_type FROM ozf_offer_discount_lines

177: IS
178: l_api_name CONSTANT VARCHAR2(30) := 'check_PBH_req_items';
179: CURSOR c_volume_type(p_offer_discount_line_id NUMBER)
180: IS
181: SELECT volume_type FROM ozf_offer_discount_lines
182: WHERE offer_discount_line_id = p_offer_discount_line_id;
183: l_volume_type OZF_OFFER_DISCOUNT_LINES.volume_type%type;
184: BEGIN
185: --initialize

Line 183: l_volume_type OZF_OFFER_DISCOUNT_LINES.volume_type%type;

179: CURSOR c_volume_type(p_offer_discount_line_id NUMBER)
180: IS
181: SELECT volume_type FROM ozf_offer_discount_lines
182: WHERE offer_discount_line_id = p_offer_discount_line_id;
183: l_volume_type OZF_OFFER_DISCOUNT_LINES.volume_type%type;
184: BEGIN
185: --initialize
186: OZF_Offer_Adj_Line_PVT.debug_message('Private API: ' || l_api_name || 'start');
187:

Line 413: SELECT tier_type FROM ozf_offer_discount_lines

409: SELECT offer_type FROM ozf_offers
410: WHERE offer_id = p_offer_id;
411:
412: CURSOR c_tier_type(p_offer_discount_line_id number) IS
413: SELECT tier_type FROM ozf_offer_discount_lines
414: WHERE offer_discount_line_id = p_offer_discount_line_id;
415:
416: l_offer_type OZF_OFFERS.offer_type%type;
417: l_tier_type OZF_OFFER_DISCOUNT_LINES.tier_type%type;

Line 417: l_tier_type OZF_OFFER_DISCOUNT_LINES.tier_type%type;

413: SELECT tier_type FROM ozf_offer_discount_lines
414: WHERE offer_discount_line_id = p_offer_discount_line_id;
415:
416: l_offer_type OZF_OFFERS.offer_type%type;
417: l_tier_type OZF_OFFER_DISCOUNT_LINES.tier_type%type;
418:
419: l_api_name CONSTANT VARCHAR2(30) := 'check_vo_req_items';
420:
421: BEGIN

Line 619: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_vo_disc_rec.parent_discount_line_id)) = FND_API.g_false THEN

615:
616: IF p_vo_disc_rec.parent_discount_line_id IS NOT NULL AND p_vo_disc_rec.PARENT_DISCOUNT_LINE_ID <> FND_API.G_MISS_NUM
617: THEN
618: OZF_Offer_Adj_Line_PVT.debug_message('Parent Id is :'||p_vo_disc_rec.parent_discount_line_id);
619: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_vo_disc_rec.parent_discount_line_id)) = FND_API.g_false THEN
620: OZF_Utility_PVT.Error_Message('OZF_INVALID_PARENT_ID' );
621: x_return_status := FND_API.g_ret_sts_error;
622: return;
623: END IF;

Line 848: FROM ozf_offer_discount_lines

844: , cp_parentDiscountLineId NUMBER
845: , cp_offerDiscountLineId NUMBER
846: ) IS
847: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'
848: FROM ozf_offer_discount_lines
849: WHERE tier_type = 'DIS'
850: AND (
851: ( cp_volumeFrom BETWEEN volume_from AND volume_to)
852: OR

Line 884: FROM ozf_offer_discount_lines

880: FUNCTION discontinuous_tiers_exist(p_volumeFrom NUMBER, p_volumeTo NUMBER, p_offerId NUMBER , p_offerDiscountLineId NUMBER)
881: RETURN VARCHAR2 IS
882: CURSOR c_getContinuousTiers(cp_volumeFrom NUMBER,cp_volumeTo NUMBER , cp_offerId NUMBER, cp_offerDiscountLineId NUMBER) IS
883: SELECT 1 FROM dual WHERE EXISTS(SELECT 'X'
884: FROM ozf_offer_discount_lines
885: WHERE tier_type = 'DIS'
886: AND (
887: (volume_to IN (cp_volumeFrom , cp_volumeFrom -1 ))
888: OR

Line 899: FROM ozf_offer_discount_lines

895: CURSOR c_tiersExist( cp_parentDiscountLineId NUMBER )IS
896: SELECT 'Y'
897: FROM dual
898: WHERE EXISTS (SELECT 'X'
899: FROM ozf_offer_discount_lines
900: WHERE parent_discount_line_id = cp_parentDiscountLineId
901: );
902: l_tiersExist VARCHAR2(1) := null;
903: l_getContinuousTiers NUMBER;

Line 937: FROM ozf_offer_discount_lines

933: l_offerId NUMBER;
934: CURSOR c_offerId(cp_offerDiscountLineId NUMBER)
935: IS
936: SELECT offer_id
937: FROM ozf_offer_discount_lines
938: WHERE offer_discount_line_id = cp_offerDiscountLineId;
939: BEGIN
940: OPEN c_offerId(cp_offerDiscountLineId => p_offerDiscountLineId);
941: FETCH c_offerId INTO l_offerId;

Line 1010: l_discount_type OZF_OFFER_DISCOUNT_LINES.DISCOUNT_TYPE%TYPE;

1006: p_vo_disc_rec IN vo_disc_rec_type,
1007: x_return_status OUT NOCOPY VARCHAR2
1008: )
1009: IS
1010: l_discount_type OZF_OFFER_DISCOUNT_LINES.DISCOUNT_TYPE%TYPE;
1011: BEGIN
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013: OZF_Offer_Adj_Line_PVT.debug_message('uom is ' || p_vo_disc_rec.uom_code);
1014: IF p_vo_disc_rec.uom_code IS NOT NULL AND p_vo_disc_rec.uom_code <> fnd_api.g_miss_char AND p_vo_disc_rec.volume_type <> 'PRICING_ATTRIBUTE10' THEN

Line 1021: SELECT discount_type INTO l_discount_type FROM OZF_OFFER_DISCOUNT_LINES

1017: RETURN;
1018: END IF;
1019:
1020: IF p_vo_disc_rec.tier_type = 'DIS' AND (p_vo_disc_rec.parent_discount_line_id IS NOT NULL AND p_vo_disc_rec.parent_discount_line_id <> FND_API.G_MISS_NUM) THEN
1021: SELECT discount_type INTO l_discount_type FROM OZF_OFFER_DISCOUNT_LINES
1022: WHERE OFFER_DISCOUNT_LINE_ID = p_vo_disc_rec.parent_discount_line_id;
1023: OZF_Offer_Adj_Line_PVT.debug_message('Discount is :'||p_vo_disc_rec.discount);
1024: IF p_vo_disc_rec.discount IS NOT NULL AND p_vo_disc_rec.discount <> FND_API.G_MISS_NUM THEN
1025: IF l_discount_type ='%' AND p_vo_disc_rec.discount > 100 THEN

Line 1734: FROM OZF_OFFER_DISCOUNT_LINES a, ozf_offr_disc_struct_name_b b, ozf_offr_disc_struct_name_tl tl

1730: , a.uom_code
1731: , tl.discount_table_name
1732: , tl.description
1733: , a.tier_level
1734: FROM OZF_OFFER_DISCOUNT_LINES a, ozf_offr_disc_struct_name_b b, ozf_offr_disc_struct_name_tl tl
1735: WHERE a.offer_discount_line_id = b.offer_discount_line_id
1736: AND b.offr_disc_struct_name_id = tl.offr_disc_struct_name_id
1737: AND tl.language = userenv('LANG')
1738: AND a.offer_discount_line_id = p_offer_discount_line_id;

Line 1754: FROM ozf_offer_discount_lines

1750: , start_date_active
1751: , end_date_active
1752: , formula_id
1753: , tier_level
1754: FROM ozf_offer_discount_lines
1755: WHERE parent_discount_line_id = p_offer_discount_line_id;
1756:
1757:
1758:

Line 1771: FROM OZF_OFFER_DISCOUNT_LINES

1767: l_vo_discount_line_id NUMBER;
1768:
1769: CURSOR c_get_vo_disc_line(p_offer_discount_line_id NUMBER, p_object_version_number NUMBER) IS
1770: SELECT *
1771: FROM OZF_OFFER_DISCOUNT_LINES
1772: WHERE offer_discount_line_id = p_offer_discount_line_id
1773: AND object_version_number = p_object_version_number;
1774: -- Hint: Developer need to provide Where clause
1775: l_get_vo_disc_line c_get_vo_disc_line%ROWTYPE;

Line 2003: SELECT ozf_offer_discount_lines_s.NEXTVAL

1999: l_vo_discount_line_id NUMBER;
2000: l_object_version_number NUMBER;
2001: l_dummy NUMBER;
2002: CURSOR c_id IS
2003: SELECT ozf_offer_discount_lines_s.NEXTVAL
2004: FROM dual;
2005:
2006: CURSOR c_id_exists (l_id IN NUMBER) IS
2007: SELECT 1

Line 2008: FROM OZF_OFFER_DISCOUNT_LINES

2004: FROM dual;
2005:
2006: CURSOR c_id_exists (l_id IN NUMBER) IS
2007: SELECT 1
2008: FROM OZF_OFFER_DISCOUNT_LINES
2009: WHERE offer_discount_line_id = l_id;
2010:
2011: CURSOR c_struct_id IS
2012: SELECT ozf_offr_disc_struct_name_s.NEXTVAL

Line 2292: FROM OZF_OFFER_DISCOUNT_LINES

2288: )IS
2289:
2290: CURSOR c_get_vo_disc_line(p_offer_discount_line_id NUMBER, p_object_version_number NUMBER) IS
2291: SELECT *
2292: FROM OZF_OFFER_DISCOUNT_LINES
2293: WHERE offer_discount_line_id = p_offer_discount_line_id
2294: AND object_version_number = p_object_version_number;
2295: -- Hint: Developer need to provide Where clause
2296:

Line 2307: l_tier_type OZF_OFFER_DISCOUNT_LINES.TIER_TYPE%TYPE;

2303: l_tar_vo_disc_line_rec vo_disc_rec_type := p_vo_disc_rec ;
2304: l_rowid ROWID;
2305: l_struct_object_version NUMBER;
2306: l_offr_disc_struct_name_id NUMBER;
2307: l_tier_type OZF_OFFER_DISCOUNT_LINES.TIER_TYPE%TYPE;
2308: BEGIN
2309: --initialize
2310: -- Standard Start of API savepoint
2311: SAVEPOINT update_ozf_disc_line_pvt;

Line 2427: SELECT tier_type into l_tier_type FROM ozf_offer_discount_lines

2423: p_offer_id => l_tar_vo_disc_line_rec.offer_id,
2424: p_formula_id => l_tar_vo_disc_line_rec.formula_id
2425: );
2426:
2427: SELECT tier_type into l_tier_type FROM ozf_offer_discount_lines
2428: WHERE offer_discount_line_id = p_vo_disc_rec.offer_discount_line_id;
2429:
2430: IF l_tier_type = 'PBH' THEN
2431: SELECT object_version_number, offr_disc_struct_name_id into l_struct_object_version , l_offr_disc_struct_name_id

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

2737: END IF;
2738: OZF_Offer_Adj_Line_PVT.debug_message('Offer Discount LIne Id is: ' || p_vo_prod_rec.offer_discount_line_id || 'end');
2739: IF p_vo_prod_rec.offer_discount_line_id IS NOT NULL AND p_vo_prod_rec.offer_discount_line_id <> FND_API.G_MISS_NUM
2740: THEN
2741: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','OFFER_DISCOUNT_LINE_ID',to_char(p_vo_prod_rec.offer_discount_line_id)) = FND_API.g_false THEN
2742: OZF_Utility_PVT.Error_Message('OZF_INVALID_DISCOUNT_ID' );
2743: x_return_status := FND_API.g_ret_sts_error;
2744: return;
2745: END IF;

Line 2792: FROM ozf_offer_discount_lines

2788:
2789: CURSOR c_uom_code(p_discount_line_id NUMBER)
2790: IS
2791: SELECT uom_code , volume_type, offer_id
2792: FROM ozf_offer_discount_lines
2793: WHERE offer_discount_line_id = p_discount_line_id;
2794:
2795: l_uom_code c_uom_code%rowtype;
2796:

Line 3013: SELECT volume_type FROM ozf_offer_discount_lines

3009: , x_return_status OUT NOCOPY VARCHAR2
3010: )
3011: IS
3012: CURSOR c_discount_volume_type(p_offer_discount_line_id NUMBER) IS
3013: SELECT volume_type FROM ozf_offer_discount_lines
3014: WHERE offer_discount_line_id = p_offer_discount_line_id;
3015:
3016: l_discount_volume_type c_discount_volume_type%rowtype;
3017: