APPS.OZF_OFFER_ADJ_TIER_PVT dependencies on OZF_OFFER_ADJUSTMENT_TIERS

Line 93: SELECT ozf_offer_adjustment_tiers_s.NEXTVAL

89: l_org_id NUMBER := FND_API.G_MISS_NUM;
90: l_offer_adjst_tier_id NUMBER;
91: l_dummy NUMBER;
92: CURSOR c_id IS
93: SELECT ozf_offer_adjustment_tiers_s.NEXTVAL
94: FROM dual;
95:
96: CURSOR c_id_exists (l_id IN NUMBER) IS
97: SELECT 1

Line 98: FROM ozf_OFFER_ADJUSTMENT_TIERS

94: FROM dual;
95:
96: CURSOR c_id_exists (l_id IN NUMBER) IS
97: SELECT 1
98: FROM ozf_OFFER_ADJUSTMENT_TIERS
99: WHERE offer_adjst_tier_id = l_id;
100: BEGIN
101: -- Standard Start of API savepoint
102: SAVEPOINT create_offer_adj_tier_pvt;

Line 320: FROM ozf_OFFER_ADJUSTMENT_TIERS

316:
317:
318: CURSOR c_get_offer_adj_tier(offer_adjst_tier_id NUMBER) IS
319: SELECT *
320: FROM ozf_OFFER_ADJUSTMENT_TIERS
321: WHERE offer_adjst_tier_id = p_offadj_tier_rec.offer_adjst_tier_id;
322: -- Hint: Developer need to provide Where clause
323:
324:

Line 805: 'ozf_offer_adjustment_tiers',

801: IF p_validation_mode = JTF_PLSQL_API.g_create
802: AND p_offadj_tier_rec.offer_adjst_tier_id IS NOT NULL
803: THEN
804: l_valid_flag := OZF_Utility_PVT.check_uniqueness(
805: 'ozf_offer_adjustment_tiers',
806: 'offer_adjst_tier_id = ''' || p_offadj_tier_rec.offer_adjst_tier_id ||''''
807: );
808: END IF;
809:

Line 1047: FROM ozf_offer_adjustment_tiers

1043: l_return_status VARCHAR2(1);
1044:
1045: CURSOR c_complete IS
1046: SELECT *
1047: FROM ozf_offer_adjustment_tiers
1048: WHERE offer_adjst_tier_id = p_offadj_tier_rec.offer_adjst_tier_id;
1049: l_offadj_tier_rec c_complete%ROWTYPE;
1050: BEGIN
1051: x_complete_rec := p_offadj_tier_rec;