APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_OFFER_ADJUSTMENTS_B

Line 173: SELECT ozf_offer_adjustments_b_s.NEXTVAL

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

Line 178: FROM OZF_OFFER_ADJUSTMENTS_B

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

Line 422: FROM OZF_OFFER_ADJUSTMENTS_B

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

Line 448: FROM ozf_offer_adjustments_b

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

Line 1081: FROM OZF_OFFER_ADJUSTMENTS_B

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

Line 1088: FROM OZF_OFFER_ADJUSTMENTS_B

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

Line 1111: -- 'ozf_offer_adjustments_b',

1107: );
1108: -- Check for, 2 adjustments with same effective date -sangara
1109:
1110: -- l_dup_effective_dt := OZF_Utility_PVT.check_uniqueness(
1111: -- 'ozf_offer_adjustments_b',
1112: -- ' list_header_id = '||' '|| p_offer_adj_rec.list_header_id ||''||
1113: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1114: -- ' OR status_code <> '||' '|| l_strClosed ||''||
1115: -- ' AND effective_date = '||' '|| p_offer_adj_rec.effective_date

Line 1131: -- 'ozf_offer_adjustments_b',

1127: ' AND offer_adjustment_name ='||' '|| p_offer_adj_rec.offer_adjustment_name||''
1128: );
1129: -- Check for, 2 adjustments with same effective date -sangara
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 offer_adjustment_id <> '||' '|| p_offer_adj_rec.offer_adjustment_id||' '||
1134: -- ' AND status_code <> '||' '|| l_strTerminated ||''||
1135: -- ' OR status_code <> '||' '|| l_strClosed ||''||

Line 1315: FROM ozf_offer_adjustments_b

1311: l_return_status VARCHAR2(1);
1312:
1313: CURSOR c_complete IS
1314: SELECT *
1315: FROM ozf_offer_adjustments_b
1316: WHERE offer_adjustment_id = p_offer_adj_rec.offer_adjustment_id;
1317: l_offer_adj_rec c_complete%ROWTYPE;
1318: BEGIN
1319: x_complete_rec := p_offer_adj_rec;