APPS.PN_LEASE_CHANGES_PKG dependencies on PN_LEASE_CHANGES_ALL

Line 56: FROM pn_lease_changes_all

52: IS
53:
54: CURSOR C IS
55: SELECT ROWID
56: FROM pn_lease_changes_all
57: WHERE lease_change_id = x_lease_change_id;
58:
59: l_leaseTransactionId NUMBER := NULL;
60: l_return_status VARCHAR2(30) := NULL;

Line 83: FROM pn_lease_changes_all pnc

79: IF (x_lease_change_number IS NULL)
80: THEN
81: SELECT NVL(MAX(pnc.lease_change_number), 0)
82: INTO x_lease_change_number
83: FROM pn_lease_changes_all pnc
84: WHERE pnc.lease_id = x_lease_id
85: AND pnc.change_type_lookup_code = x_change_type_lookup_code;
86:
87: x_lease_change_number := x_lease_change_number + 1;

Line 165: INSERT INTO pn_lease_changes_all

161: INTO x_lease_change_id
162: FROM DUAL;
163: END IF;
164:
165: INSERT INTO pn_lease_changes_all
166: (
167: LEASE_CHANGE_ID
168: ,LEASE_ID
169: ,LEASE_TRANSACTION_ID

Line 292: FROM pn_lease_changes_all

288: )
289: IS
290: CURSOR c1 IS
291: SELECT *
292: FROM pn_lease_changes_all
293: WHERE lease_change_id = x_lease_change_id
294: FOR UPDATE OF lease_change_id NOWAIT;
295:
296: tlinfo c1%ROWTYPE;

Line 488: UPDATE pn_lease_changes_all

484: IS
485: BEGIN
486: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Update_Row (+)');
487:
488: UPDATE pn_lease_changes_all
489: SET RESPONSIBLE_USER = X_RESPONSIBLE_USER,
490: CHANGE_COMMENCEMENT_DATE = X_CHANGE_COMMENCEMENT_DATE,
491: CHANGE_TERMINATION_DATE = X_CHANGE_TERMINATION_DATE,
492: CHANGE_TYPE_LOOKUP_CODE = X_CHANGE_TYPE_LOOKUP_CODE,

Line 542: DELETE FROM pn_lease_changes_all

538: )
539: IS
540: BEGIN
541: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row (+)');
542: DELETE FROM pn_lease_changes_all
543: WHERE lease_change_id = x_lease_change_id;
544:
545: IF (SQL%NOTFOUND) THEN
546: RAISE NO_DATA_FOUND;

Line 604: FROM pn_lease_changes_all plc

600: SELECT 1
601: INTO l_dummy
602: FROM DUAL
603: WHERE NOT EXISTS (SELECT 1
604: FROM pn_lease_changes_all plc
605: WHERE plc.change_type_lookup_code = x_change_type_lookup_code
606: AND plc.lease_id = X_LEASE_ID
607: );
608:

Line 622: FROM pn_lease_changes_all plc

618: SELECT 1
619: INTO l_dummy
620: FROM DUAL
621: WHERE NOT EXISTS (SELECT 1
622: FROM pn_lease_changes_all plc
623: WHERE plc.change_type_lookup_code = X_CHANGE_TYPE_LOOKUP_CODE
624: AND plc.lease_change_number = X_LEASE_CHANGE_NUMBER
625: AND plc.lease_id = X_LEASE_ID
626: );