APPS.OZF_VOL_OFFR_PVT dependencies on OZF_VOLUME_OFFER_TIERS

Line 108: SELECT OZF_volume_offer_tiers_s.NEXTVAL

104: l_org_id NUMBER := FND_API.G_MISS_NUM;
105: l_volume_offer_tiers_id NUMBER;
106: l_dummy NUMBER;
107: CURSOR c_id IS
108: SELECT OZF_volume_offer_tiers_s.NEXTVAL
109: FROM dual;
110:
111: CURSOR c_id_exists (l_id IN NUMBER) IS
112: SELECT 1

Line 113: FROM OZF_VOLUME_OFFER_TIERS

109: FROM dual;
110:
111: CURSOR c_id_exists (l_id IN NUMBER) IS
112: SELECT 1
113: FROM OZF_VOLUME_OFFER_TIERS
114: WHERE volume_offer_tiers_id = l_id;
115: BEGIN
116: -- Standard Start of API savepoint
117: SAVEPOINT create_vol_offr_pvt;

Line 332: FROM OZF_VOLUME_OFFER_TIERS

328:
329:
330: CURSOR c_get_vol_offr(volume_offer_tiers_id NUMBER) IS
331: SELECT *
332: FROM OZF_VOLUME_OFFER_TIERS
333: WHERE volume_offer_tiers_id = p_vol_offr_tier_rec.volume_offer_tiers_id;
334: -- Hint: Developer need to provide Where clause
335:
336:

Line 811: 'ozf_volume_offer_tiers',

807: BEGIN
808: x_return_status := FND_API.g_ret_sts_success;
809: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
810: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
811: 'ozf_volume_offer_tiers',
812: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||''''
813: );
814: ELSE
815: l_valid_flag := OZF_Utility_PVT.check_uniqueness(

Line 816: 'ozf_volume_offer_tiers',

812: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||''''
813: );
814: ELSE
815: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
816: 'ozf_volume_offer_tiers',
817: 'volume_offer_tiers_id = ''' || p_vol_offr_tier_rec.volume_offer_tiers_id ||
818: ''' AND volume_offer_tiers_id <> ' || p_vol_offr_tier_rec.volume_offer_tiers_id
819: );
820: END IF;

Line 823: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VOLUME_OFFER_TIERS_ID_DUP');

819: );
820: END IF;
821:
822: IF l_valid_flag = FND_API.g_false THEN
823: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_VOLUME_OFFER_TIERS_ID_DUP');
824: x_return_status := FND_API.g_ret_sts_error;
825: END IF;
826:
827: END check_Vol_Offr_Tier_Uk_Items;

Line 1069: FROM OZF_volume_offer_tiers

1065: l_return_status VARCHAR2(1);
1066:
1067: CURSOR c_complete IS
1068: SELECT *
1069: FROM OZF_volume_offer_tiers
1070: WHERE volume_offer_tiers_id = p_vol_offr_tier_rec.volume_offer_tiers_id;
1071: l_vol_offr_tier_rec c_complete%ROWTYPE;
1072: BEGIN
1073: x_complete_rec := p_vol_offr_tier_rec;

Line 1308: FROM OZF_volume_offer_tiers

1304: )
1305: IS
1306: CURSOR c_range IS
1307: SELECT TIER_VALUE_FROM, TIER_VALUE_TO
1308: FROM OZF_volume_offer_tiers
1309: WHERE QP_LIST_HEADER_ID = p_vol_offr_tier_rec.qp_list_header_id;
1310:
1311: BEGIN
1312: -- Initialize message list if p_init_msg_list is set to TRUE.