APPS.PN_INDEX_LEASES_PKG dependencies on PN_INDEX_LEASES_ALL

Line 128: FROM pn_index_leases_all

124: ,x_proration_period_start_date IN DATE)
125: IS
126: CURSOR c IS
127: SELECT ROWID
128: FROM pn_index_leases_all
129: WHERE index_lease_id = x_index_lease_id;
130:
131: l_return_status VARCHAR2 (30) := NULL;
132: l_rowid VARCHAR2 (18) := NULL;

Line 177: INSERT INTO pn_index_leases_all

173: ELSE
174: l_org_id := x_org_id;
175: END IF;
176:
177: INSERT INTO pn_index_leases_all
178: (
179: index_lease_id
180: ,org_id
181: ,lease_id

Line 440: UPDATE pn_index_leases_all

436: app_exception.raise_exception;
437: END IF;
438:
439:
440: UPDATE pn_index_leases_all
441: SET lease_id = x_lease_id
442: ,index_id = x_index_id
443: ,commencement_date = x_commencement_date
444: ,termination_date = x_termination_date

Line 605: FROM pn_index_leases_all

601: IS
602:
603: CURSOR c1 IS
604: SELECT *
605: FROM pn_index_leases_all
606: WHERE INDEX_LEASE_ID = x_index_lease_id
607: FOR UPDATE OF index_lease_id NOWAIT;
608:
609: tlinfo c1%ROWTYPE;

Line 889: DELETE FROM pn_index_leases_all

885: x_rowid IN VARCHAR2)
886: IS
887: BEGIN
888: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASES_PKG.delete_row (+)');
889: DELETE FROM pn_index_leases_all
890: WHERE ROWID = x_rowid;
891:
892: IF (SQL%NOTFOUND)
893: THEN

Line 911: DELETE FROM pn_index_leases_all

907: PROCEDURE delete_row (
908: x_index_lease_id IN NUMBER) IS
909: BEGIN
910: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASES_PKG.delete_row (+)');
911: DELETE FROM pn_index_leases_all
912: WHERE index_lease_id = x_index_lease_id;
913:
914: IF (SQL%NOTFOUND)
915: THEN

Line 942: FROM pn_index_leases_all

938: SELECT 1
939: INTO l_dummy
940: FROM DUAL
941: WHERE NOT EXISTS ( SELECT 1
942: FROM pn_index_leases_all
943: WHERE (index_lease_number = x_index_lease_number)
944: AND ( (x_index_lease_id IS NULL)
945: OR (index_lease_id <> x_index_lease_id)));
946: EXCEPTION