APPS.OZF_VOLUME_OFFER_DISC_PVT dependencies on OZF_OFFR_DISC_STRUCT_NAME_B

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 122: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_disc_struct_name_b','OFFR_DISC_STRUCT_NAME_ID = ''' || p_vo_disc_rec.offr_disc_struct_name_id ||'''') = FND_API.g_false THEN

118:
119: IF p_validation_mode = JTF_PLSQL_API.g_create
120: AND p_vo_disc_rec.offr_disc_struct_name_id IS NOT NULL
121: THEN
122: IF OZF_Utility_PVT.check_uniqueness('ozf_offr_disc_struct_name_b','OFFR_DISC_STRUCT_NAME_ID = ''' || p_vo_disc_rec.offr_disc_struct_name_id ||'''') = FND_API.g_false THEN
123: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_DISC_NAME_ID_DUP');
124: x_return_status := FND_API.g_ret_sts_error;
125: END IF;
126: END IF;

Line 1617: FROM ozf_offr_disc_struct_name_b

1613: OZF_Offer_Adj_Line_PVT.debug_message('Done calling Delete product');
1614:
1615: BEGIN
1616: SELECT object_version_number, offr_disc_struct_name_id INTO l_object_version_number, l_offr_disc_struct_name_id
1617: FROM ozf_offr_disc_struct_name_b
1618: WHERE offer_discount_line_id = p_offer_discount_line_id;
1619:
1620: OZF_VO_DISC_STRUCT_NAME_PKG.Delete_Row(
1621: p_offr_disc_struct_name_id => l_offr_disc_struct_name_id,

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 2017: FROM ozf_offr_disc_struct_name_b

2013: FROM dual;
2014:
2015: CURSOR c_struct_id_exists (l_id IN NUMBER) IS
2016: SELECT 1
2017: FROM ozf_offr_disc_struct_name_b
2018: WHERE OFFR_DISC_STRUCT_NAME_ID = l_id;
2019: l_struct_object_version NUMBER;
2020: l_offr_disc_struct_name_id NUMBER;
2021: l_struct_dummy NUMBER;

Line 2432: FROM ozf_offr_disc_struct_name_b

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
2432: FROM ozf_offr_disc_struct_name_b
2433: WHERE offer_discount_line_id = p_vo_disc_rec.offer_discount_line_id;
2434:
2435: OZF_VO_DISC_STRUCT_NAME_PKG.Update_Row(
2436: p_offr_disc_struct_name_id => l_offr_disc_struct_name_id