APPS.PN_LEASES_PKG dependencies on PN_LEASES_ALL

Line 69: FROM pn_leases_all

65: IS
66:
67: CURSOR c IS
68: SELECT ROWID
69: FROM pn_leases_all
70: WHERE lease_id = x_lease_id;
71:
72: l_return_status VARCHAR2(30) := NULL;
73: l_rowId VARCHAR2(18) := NULL;

Line 91: INSERT INTO pn_leases_all

87: IF (l_return_status IS NOT NULL) THEN
88: APP_EXCEPTION.Raise_Exception;
89: END IF;
90:
91: INSERT INTO pn_leases_all
92: (
93: LEASE_ID,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY,

Line 290: FROM pn_leases_all --sdm_MOAC

286: )
287: IS
288: CURSOR c1 IS
289: SELECT *
290: FROM pn_leases_all --sdm_MOAC
291: WHERE lease_id = x_lease_id
292: FOR UPDATE OF lease_id NOWAIT;
293:
294: tlinfo c1%ROWTYPE;

Line 421: -- Update pn_leases_all, for history creation of 3 columns

417: -- 19-MAR-02 lkatputu o Added Send_Entries into the table handler
418: -- as per the 'DO NOT SEND' enhancement requirement.
419: -- 25-OCT-02 STRIPATH o Modified Update_Row for Lease Number/Name and MTM.
420: -- Now first call pn_lease_details_pkg.Update_row and then
421: -- Update pn_leases_all, for history creation of 3 columns
422: -- of pn_leases_all (name, lease_num, lease_status) in
423: -- table pn_lease_details_history.
424: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in
425: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.

Line 422: -- of pn_leases_all (name, lease_num, lease_status) in

418: -- as per the 'DO NOT SEND' enhancement requirement.
419: -- 25-OCT-02 STRIPATH o Modified Update_Row for Lease Number/Name and MTM.
420: -- Now first call pn_lease_details_pkg.Update_row and then
421: -- Update pn_leases_all, for history creation of 3 columns
422: -- of pn_leases_all (name, lease_num, lease_status) in
423: -- table pn_lease_details_history.
424: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in
425: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.
426: -- Update_Row. Fix for bug# 4142423

Line 482: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

478: IS
479: l_return_status VARCHAR2(30) := NULL;
480:
481: CURSOR org_cur IS
482: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;
483:
484: l_org_id NUMBER;
485:
486: BEGIN

Line 549: UPDATE pn_leases_all

545: ,X_ATTRIBUTE15 => X_ATTRIBUTE15
546: ,x_lease_extension_end_date => x_lease_extension_end_date
547: );
548:
549: UPDATE pn_leases_all
550: SET NAME = X_NAME,
551: LEASE_NUM = X_LEASE_NUM,
552: PARENT_LEASE_ID = X_PARENT_LEASE_ID,
553: LEASE_TYPE_CODE = X_LEASE_TYPE_CODE,

Line 618: DELETE FROM pn_leases_all

614:
615: -- we need to DELETE the lease changes rows.
616: pn_lease_changes_pkg.Delete_Row (X_LEASE_CHANGE_ID =>l_leaseChangeId);
617:
618: DELETE FROM pn_leases_all
619: WHERE lease_id = x_lease_id;
620:
621: IF (SQL%NOTFOUND) THEN
622: RAISE NO_DATA_FOUND;

Line 690: FROM pn_leases_all pnl

686: SELECT 1
687: INTO l_dummy
688: FROM DUAL
689: WHERE NOT EXISTS (SELECT 1
690: FROM pn_leases_all pnl
691: WHERE pnl.lease_num = x_lease_number
692: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
693: AND org_id = x_org_id
694: );