APPS.PN_VAR_ABATEMENTS_PKG dependencies on PN_VAR_ABATEMENTS_PKG

Line 1: PACKAGE BODY PN_VAR_ABATEMENTS_PKG AS

1: PACKAGE BODY PN_VAR_ABATEMENTS_PKG AS
2: /* $Header: PNVRABTB.pls 120.7 2007/07/02 15:21:29 lbala noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 44: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (+)');

40:
41:
42: BEGIN
43:
44: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (+)');
45:
46: -------------------------------------------------------
47: -- SELECT the nextval fOR var abatement id
48: -------------------------------------------------------

Line 103: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (-)');

99: RAISE no_data_found;
100: END IF;
101: CLOSE var_abatements;
102:
103: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.INSERT_ROW (-)');
104:
105: END INSERT_ROW;
106:
107: -------------------------------------------------------------------------------

Line 132: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (+)');

128: tlINfo c1%ROWTYPE;
129:
130: BEGIN
131:
132: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (+)');
133:
134: OPEN c1;
135: FETCH c1 INTO tlINfo;
136: IF (c1%NOTFOUND) THEN

Line 160: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (-)');

156: ELSE
157: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('PAYMENT_TERM_ID',tlINfo.PAYMENT_TERM_ID);
158: END IF;
159:
160: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.LOCK_ROW (-)');
161:
162: END LOCK_ROW;
163:
164: -----------------------------------------------------------------------

Line 182: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (+)');

178: ) IS
179:
180: BEGIN
181:
182: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (+)');
183:
184: UPDATE PN_VAR_ABATEMENTS_ALL SET
185: VAR_RENT_ID = X_VAR_RENT_ID,
186: VAR_RENT_INV_ID = X_VAR_RENT_INV_ID,

Line 202: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (-)');

198: IF (SQL%NOTFOUND) THEN
199: RAISE NO_DATA_FOUND;
200: END IF;
201:
202: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (-)');
203:
204: END UPDATE_ROW;
205:
206: -------------------------------------------------------------------------------

Line 222: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (+)');

218: ) IS
219:
220: BEGIN
221:
222: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (+)');
223:
224: DELETE FROM PN_VAR_ABATEMENTS_ALL
225: WHERE VAR_RENT_ID = X_VAR_RENT_ID
226: AND VAR_RENT_INV_ID = X_VAR_RENT_INV_ID

Line 234: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (-)');

230: RAISE NO_DATA_FOUND;
231: END IF;
232:
233:
234: PNP_DEBUG_PKG.debug ('PN_VAR_ABATEMENTS_PKG.DELETE_ROW (-)');
235:
236: END DELETE_ROW;
237:
238: --------------------------------------------------------------------

Line 361: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (

357: AND update_flag = 'Y';
358: BEGIN
359: --
360: FOR get_update_rec IN get_update_cur(p_var_rentId,p_var_rent_inv_id) LOOP
361: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW (
362: X_VAR_RENT_ID => p_var_rentId ,
363: X_VAR_RENT_INV_ID => p_var_rent_inv_id,
364: X_PAYMENT_TERM_ID => get_update_rec.PAYMENT_TERM_ID,
365: X_INCLUDE_TERM => get_update_rec.INCLUDE_TERM ,

Line 524: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

520: IF l_abtmt_exists IS NULL THEN
521: l_row_id := NULL;
522: l_var_abmt_id :=NULL;
523:
524: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
525: X_ROWID => l_row_id,
526: X_VAR_ABATEMENT_ID => l_var_abmt_id,
527: X_VAR_RENT_ID => p_var_rentId,
528: X_VAR_RENT_INV_ID => l_inv_id,

Line 541: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(

537: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
538: X_ORG_ID => l_org_id );
539:
540: ELSE
541: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(
542: X_VAR_RENT_ID => p_var_rentId,
543: X_VAR_RENT_INV_ID => l_inv_id,
544: X_PAYMENT_TERM_ID => upd_rec.payment_term_id,
545: X_INCLUDE_TERM => upd_rec.include_term,

Line 572: PN_VAR_ABATEMENTS_PKG.DELETE_ROW(

568: END LOOP;
569:
570: IF l_abtmt_exists IS NOT NULL THEN
571:
572: PN_VAR_ABATEMENTS_PKG.DELETE_ROW(
573: X_VAR_RENT_ID => p_var_rentId,
574: X_VAR_RENT_INV_ID => l_inv_id,
575: X_PAYMENT_TERM_ID => p_pmt_term_id);
576:

Line 811: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(

807: IF l_abtmt_exists IS NULL THEN
808: l_row_id := NULL;
809: l_var_abmt_id :=NULL;
810:
811: PN_VAR_ABATEMENTS_PKG.INSERT_ROW(
812: X_ROWID => l_row_id,
813: X_VAR_ABATEMENT_ID => l_var_abmt_id,
814: X_VAR_RENT_ID => p_var_rentId,
815: X_VAR_RENT_INV_ID => l_inv_id,

Line 828: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(

824: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
825: X_ORG_ID => l_org_id );
826:
827: ELSE
828: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(
829: X_VAR_RENT_ID => p_var_rentId,
830: X_VAR_RENT_INV_ID => l_inv_id,
831: X_PAYMENT_TERM_ID => upd_rec.payment_term_id,
832: X_INCLUDE_TERM => upd_rec.include_term,

Line 859: PN_VAR_ABATEMENTS_PKG.DELETE_ROW(

855: END LOOP;
856:
857: IF l_abtmt_exists IS NOT NULL THEN
858:
859: PN_VAR_ABATEMENTS_PKG.DELETE_ROW(
860: X_VAR_RENT_ID => p_var_rentId,
861: X_VAR_RENT_INV_ID => l_inv_id,
862: X_PAYMENT_TERM_ID => p_pmt_term_id);
863:

Line 914: END PN_VAR_ABATEMENTS_PKG;

910: WHEN others THEN
911: NULL;
912: END CHECK_TRUE_UP_INVOICE;
913:
914: END PN_VAR_ABATEMENTS_PKG;