APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 174: SELECT ozf_offer_adjustments_b_s.NEXTVAL

170: l_org_id NUMBER := FND_API.G_MISS_NUM;
171: l_offer_adjustment_id NUMBER;
172: l_dummy NUMBER;
173: CURSOR c_id IS
174: SELECT ozf_offer_adjustments_b_s.NEXTVAL
175: FROM dual;
176:
177: CURSOR c_id_exists (l_id IN NUMBER) IS
178: SELECT 1

Line 179: FROM OZF_OFFER_ADJUSTMENTS_B

175: FROM dual;
176:
177: CURSOR c_id_exists (l_id IN NUMBER) IS
178: SELECT 1
179: FROM OZF_OFFER_ADJUSTMENTS_B
180: WHERE offer_adjustment_id = l_id;
181: BEGIN
182: -- Standard Start of API savepoint
183: SAVEPOINT create_offer_adjustment_pvt;

Line 423: FROM OZF_OFFER_ADJUSTMENTS_B

419:
420:
421: CURSOR c_get_offer_adjustment(offer_adjustment_id NUMBER) IS
422: SELECT *
423: FROM OZF_OFFER_ADJUSTMENTS_B
424: WHERE offer_adjustment_id = p_offer_adj_rec.offer_adjustment_id;
425: -- Hint: Developer need to provide Where clause
426:
427:

Line 449: FROM ozf_offer_adjustments_b

445:
446: -- code added by mthumu
447: CURSOR c_get_offer_status(p_offer_adjustment_id NUMBER) IS
448: SELECT status_code
449: FROM ozf_offer_adjustments_b
450: WHERE offer_adjustment_id = p_offer_adjustment_id ;
451: -- end mthumu
452:
453: CURSOR c_custom_setup_id(p_list_header_id NUMBER) IS

Line 1082: FROM OZF_OFFER_ADJUSTMENTS_B

1078: IS
1079: -- Cursor to check, if 2 adjustments exist with same effective date
1080: CURSOR c_adj_exists_oncreate (l_objid IN NUMBER, l_effdt IN DATE) IS
1081: SELECT 1
1082: FROM OZF_OFFER_ADJUSTMENTS_B
1083: WHERE list_header_id = l_objid
1084: AND effective_date = l_effdt
1085: AND status_code NOT IN ('CANCELLED' ,'CLOSED');
1086:

Line 1089: FROM OZF_OFFER_ADJUSTMENTS_B

1085: AND status_code NOT IN ('CANCELLED' ,'CLOSED');
1086:
1087: CURSOR c_adj_exists_onupdate (l_objid IN NUMBER, l_adjid IN NUMBER, l_effdt IN DATE) IS
1088: SELECT 1
1089: FROM OZF_OFFER_ADJUSTMENTS_B
1090: WHERE list_header_id = l_objid
1091: AND offer_adjustment_id <> l_adjid
1092: AND effective_date = l_effdt
1093: AND status_code NOT IN ('CANCELLED' ,'CLOSED');

Line 1131: -- 'ozf_offer_adjustments_b',

1127: CLOSE c_check_uniqeness_create;
1128: -- Check for, 2 adjustments with same effective date -sangara
1129:
1130: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1131: -- 'ozf_offer_adjustments_b',
1132: -- ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||''||
1133: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1134: -- ' OR status_code <> '||' '|| l_strClosed ||''||
1135: -- ' AND effective_date = '||' '|| p_offer_adj_rec.effective_date

Line 1157: -- 'ozf_offer_adjustments_b',

1153: CLOSE c_check_uniqeness_update;
1154:
1155: -- Check for, 2 adjustments with same effective date -sangara
1156: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1157: -- 'ozf_offer_adjustments_b',
1158: -- 'list_header_id =' || p_offer_adj_rec.list_header_id ||
1159: -- ' AND offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1160: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1161: -- ' OR status_code <> '||' '|| l_strClosed ||''||

Line 1341: FROM ozf_offer_adjustments_b

1337: l_return_status VARCHAR2(1);
1338:
1339: CURSOR c_complete IS
1340: SELECT *
1341: FROM ozf_offer_adjustments_b
1342: WHERE offer_adjustment_id = p_offer_adj_rec.offer_adjustment_id;
1343: l_offer_adj_rec c_complete%ROWTYPE;
1344: BEGIN
1345: x_complete_rec := p_offer_adj_rec;