APPS.PN_VAR_ABAT_DEFAULTS_PKG dependencies on PN_VAR_ABAT_DEFAULTS_ALL

Line 45: FROM PN_VAR_ABAT_DEFAULTS_ALL

41: ,X_ORG_ID in NUMBER )
42: IS
43: CURSOR C IS
44: SELECT ROWID
45: FROM PN_VAR_ABAT_DEFAULTS_ALL
46: WHERE ABATEMENT_ID = X_ABATEMENT_ID;
47:
48: BEGIN
49:

Line 62: INSERT INTO PN_VAR_ABAT_DEFAULTS_ALL

58: INTO X_ABATEMENT_ID
59: FROM dual;
60: END IF;
61:
62: INSERT INTO PN_VAR_ABAT_DEFAULTS_ALL
63: (
64: ABATEMENT_ID
65: ,VAR_RENT_ID
66: ,START_DATE

Line 183: FROM PN_VAR_ABAT_DEFAULTS_ALL

179: IS
180:
181: CURSOR c1 IS
182: SELECT *
183: FROM PN_VAR_ABAT_DEFAULTS_ALL
184: WHERE ABATEMENT_ID = X_ABATEMENT_ID
185: FOR UPDATE OF ABATEMENT_ID NOWAIT;
186:
187: tlinfo c1%rowtype;

Line 406: UPDATE PN_VAR_ABAT_DEFAULTS_ALL SET

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
409: ,START_DATE = X_START_DATE
410: ,END_DATE = X_END_DATE

Line 460: DELETE FROM PN_VAR_ABAT_DEFAULTS_ALL

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:
463: IF (SQL%NOTFOUND) THEN
464: RAISE NO_DATA_FOUND;