APPS.PN_VAR_RENT_DATES_PKG dependencies on PN_VAR_RENT_DATES_ALL

Line 63: FROM PN_VAR_RENT_DATES_ALL

59: IS
60:
61: CURSOR var_rent_dates IS
62: SELECT ROWID
63: FROM PN_VAR_RENT_DATES_ALL
64: WHERE VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID;
65:
66: CURSOR org_cur IS
67: SELECT org_id FROM PN_VAR_RENTS_ALL WHERE VAR_RENT_ID = X_VAR_RENT_ID;

Line 91: INSERT INTO PN_VAR_RENT_DATES_ALL

87: ELSE
88: l_org_id := x_org_id;
89: END IF;
90:
91: INSERT INTO PN_VAR_RENT_DATES_ALL
92: (
93: VAR_RENT_DATE_ID,
94: VAR_RENT_ID,
95: GL_PERIOD_SET_NAME,

Line 253: FROM PN_VAR_RENT_DATES_ALL

249: )
250: IS
251: CURSOR c1 IS
252: SELECT *
253: FROM PN_VAR_RENT_DATES_ALL
254: WHERE VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID
255: FOR UPDATE OF VAR_RENT_DATE_ID NOWAIT;
256:
257: tlinfo c1%rowtype;

Line 564: UPDATE PN_VAR_RENT_DATES_ALL

560: BEGIN
561:
562: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_DATES_PKG.UPDATE_ROW (+)');
563:
564: UPDATE PN_VAR_RENT_DATES_ALL
565: SET
566: VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID,
567: VAR_RENT_ID = X_VAR_RENT_ID,
568: GL_PERIOD_SET_NAME = X_GL_PERIOD_SET_NAME,

Line 636: DELETE FROM PN_VAR_RENT_DATES_ALL

632: BEGIN
633:
634: PNP_DEBUG_PKG.debug ('PN_VAR_RENT_DATES_PKG.DELETE_ROW (+)');
635:
636: DELETE FROM PN_VAR_RENT_DATES_ALL
637: WHERE VAR_RENT_DATE_ID = X_VAR_RENT_DATE_ID;
638:
639: IF (sql%notfound) THEN
640: RAISE NO_DATA_FOUND;