APPS.PN_INDEX_LEASE_CONSTRAINTS_PKG dependencies on PN_INDEX_LEASE_CONSTRAINTS_ALL

Line 75: FROM pn_index_lease_constraints_all

71: ,x_attribute15 IN VARCHAR2
72: ) IS
73: CURSOR c IS
74: SELECT ROWID
75: FROM pn_index_lease_constraints_all
76: WHERE index_constraint_id = x_index_constraint_id;
77:
78: l_return_status VARCHAR2 (30) := NULL;
79: l_rowid VARCHAR2 (18) := NULL;

Line 115: INSERT INTO pn_index_lease_constraints_all

111: IF (l_return_status IS NOT NULL) THEN
112: app_exception.raise_exception;
113: END IF;
114:
115: INSERT INTO pn_index_lease_constraints_all
116: (
117: index_constraint_id
118: ,org_id
119: ,index_lease_id

Line 251: UPDATE pn_index_lease_constraints_all

247: IF (l_return_status IS NOT NULL) THEN
248: app_exception.raise_exception;
249: END IF;
250:
251: UPDATE pn_index_lease_constraints_all
252: SET
253: index_lease_id = x_index_lease_id
254: ,scope = x_scope
255: ,last_update_date = x_last_update_date

Line 327: FROM pn_index_lease_constraints_all

323: )
324: IS
325: CURSOR c1 IS
326: SELECT *
327: FROM pn_index_lease_constraints_all
328: WHERE index_constraint_id = x_index_constraint_id
329: FOR UPDATE OF index_constraint_id NOWAIT;
330:
331: tlinfo c1%ROWTYPE;

Line 395: DELETE FROM pn_index_lease_constraints_all

391: IS
392: BEGIN
393: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_CONSTRAINTS_PKG.delete_row (+)');
394:
395: DELETE FROM pn_index_lease_constraints_all
396: WHERE ROWID = x_rowid;
397:
398: IF (SQL%NOTFOUND) THEN
399: RAISE NO_DATA_FOUND;

Line 420: DELETE FROM pn_index_lease_constraints_all

416: )
417: IS
418: BEGIN
419: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_CONSTRAINTS_PKG.delete_row (+)');
420: DELETE FROM pn_index_lease_constraints_all
421: WHERE index_constraint_id = x_index_constraint_id;
422:
423: IF (SQL%NOTFOUND) THEN
424: RAISE NO_DATA_FOUND;

Line 453: FROM pn_index_lease_constraints_all

449: SELECT 1
450: INTO l_dummy
451: FROM DUAL
452: WHERE NOT EXISTS ( SELECT 1
453: FROM pn_index_lease_constraints_all
454: WHERE (scope = x_scope)
455: AND (index_lease_id = x_index_lease_id)
456: AND ( (x_index_constraint_id IS NULL)
457: OR (index_constraint_id <> x_index_constraint_id)