APPS.PN_VAR_ABAT_DEFAULTS_PKG dependencies on PN_VAR_ABAT_DEFAULTS_PKG

Line 1: package body PN_VAR_ABAT_DEFAULTS_PKG as

1: package body PN_VAR_ABAT_DEFAULTS_PKG as
2: /* $Header: PNVRABDB.pls 120.0 2007/10/03 14:27:20 rthumma noship $ */
3: -------------------------------------------------------------------------------
4: -- PROCDURE : INSERT_ROW
5: -- INVOKED FROM : insert_row procedure

Line 50: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.INSERT_ROW (+)');

46: WHERE ABATEMENT_ID = X_ABATEMENT_ID;
47:
48: BEGIN
49:
50: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.INSERT_ROW (+)');
51:
52: -------------------------------------------------------
53: -- Select the nextval for abatement/allowance id
54: -------------------------------------------------------

Line 137: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.INSERT_ROW (-)');

133: RAISE NO_DATA_FOUND;
134: END IF;
135: CLOSE c;
136:
137: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.INSERT_ROW (-)');
138:
139: END INSERT_ROW;
140:
141: -------------------------------------------------------------------------------

Line 191: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.LOCK_ROW (+)');

187: tlinfo c1%rowtype;
188:
189: BEGIN
190:
191: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.LOCK_ROW (+)');
192:
193: OPEN c1;
194: FETCH c1 INTO tlinfo;
195: IF (c1%notfound) THEN

Line 359: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.LOCK_ROW (-)');

355: else
356: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ORG_ID', to_char(tlinfo.ORG_ID));
357: end if;
358:
359: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.LOCK_ROW (-)');
360:
361: END LOCK_ROW;
362:
363: -------------------------------------------------------------------------------

Line 404: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.UPDATE_ROW (+)');

400: ,X_ORG_ID in NUMBER)
401: IS
402: BEGIN
403:
404: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.UPDATE_ROW (+)');
405:
406: UPDATE PN_VAR_ABAT_DEFAULTS_ALL SET
407: ABATEMENT_ID = X_ABATEMENT_ID
408: ,VAR_RENT_ID = X_VAR_RENT_ID

Line 443: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.UPDATE_ROW (-)');

439: IF (SQL%NOTFOUND) THEN
440: RAISE NO_DATA_FOUND;
441: END IF;
442:
443: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.UPDATE_ROW (-)');
444:
445: END UPDATE_ROW;
446:
447: -------------------------------------------------------------------------------

Line 458: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.DELETE_ROW (+)');

454: procedure DELETE_ROW ( X_ABATEMENT_ID in NUMBER)
455: IS
456: BEGIN
457:
458: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.DELETE_ROW (+)');
459:
460: DELETE FROM PN_VAR_ABAT_DEFAULTS_ALL
461: WHERE ABATEMENT_ID = X_ABATEMENT_ID;
462:

Line 467: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.DELETE_ROW (-)');

463: IF (SQL%NOTFOUND) THEN
464: RAISE NO_DATA_FOUND;
465: END IF;
466:
467: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.DELETE_ROW (-)');
468:
469: END DELETE_ROW;
470:
471: END PN_VAR_ABAT_DEFAULTS_PKG;

Line 471: END PN_VAR_ABAT_DEFAULTS_PKG;

467: PNP_DEBUG_PKG.debug ('PN_VAR_ABAT_DEFAULTS_PKG.DELETE_ROW (-)');
468:
469: END DELETE_ROW;
470:
471: END PN_VAR_ABAT_DEFAULTS_PKG;