APPS.PN_LEASE_CHANGES_PKG dependencies on PNP_DEBUG_PKG

Line 72: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Insert_Row (+)');

68:
69:
70: BEGIN
71:
72: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Insert_Row (+)');
73: --------------------------------------------------------
74: -- IF the LEASE_CHANGE_NUMBER IS NULL THEN we need to
75: -- generate it
76: --------------------------------------------------------

Line 248: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Insert_Row (-)');

244: RAISE NO_DATA_FOUND;
245: END IF;
246: CLOSE c;
247:
248: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Insert_Row (-)');
249:
250: END Insert_Row;
251:
252: -------------------------------------------------------------------------------

Line 299: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Lock_Row (+)');

295:
296: tlinfo c1%ROWTYPE;
297:
298: BEGIN
299: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Lock_Row (+)');
300: OPEN c1;
301: FETCH c1 INTO tlinfo;
302: IF (c1%NOTFOUND) THEN
303: CLOSE c1;

Line 440: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Lock_Row (-)');

436: OR ((tlinfo.ABSTRACTED_BY_USER IS NULL) AND (X_ABSTRACTED_BY_USER IS NULL))) THEN
437: pn_var_rent_pkg.lock_row_exception('ABSTRACTED_BY_USER',tlinfo.ABSTRACTED_BY_USER);
438: END IF;
439:
440: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Lock_Row (-)');
441:
442: END Lock_Row;
443:
444: -------------------------------------------------------------------------------

Line 486: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Update_Row (+)');

482: X_LAST_UPDATE_LOGIN IN NUMBER
483: )
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,

Line 525: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Update_Row (-)');

521: IF (SQL%NOTFOUND) THEN
522: RAISE NO_DATA_FOUND;
523: END IF;
524:
525: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Update_Row (-)');
526: END Update_Row;
527:
528: -------------------------------------------------------------------------------
529: -- PROCDURE : Delete_Row

Line 541: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row (+)');

537: X_LEASE_CHANGE_ID IN NUMBER
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

Line 549: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row (-)');

545: IF (SQL%NOTFOUND) THEN
546: RAISE NO_DATA_FOUND;
547: END IF;
548:
549: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row (-)');
550: END Delete_Row;
551:
552: -------------------------------------------------------------------------------
553: -- PROCDURE : Delete_Row_Transactions

Line 566: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row_Transactions (+)');

562: X_LEASE_TRANSACTION_ID IN NUMBER
563: )
564: IS
565: BEGIN
566: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row_Transactions (+)');
567: DELETE FROM pn_lease_transactions_all
568: WHERE lease_transaction_id = x_lease_transaction_id;
569:
570: IF (SQL%NOTFOUND) THEN

Line 574: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row_Transactions (-)');

570: IF (SQL%NOTFOUND) THEN
571: RAISE NO_DATA_FOUND;
572: END IF;
573:
574: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.Delete_Row_Transactions (-)');
575: END Delete_Row_Transactions;
576:
577: -------------------------------------------------------------------------------
578: -- PROCDURE : CHECK_UNIQUE_CHANGE_NUMBER

Line 596: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.CHECK_UNIQUE_CHANGE_NUMBER (+)');

592: IS
593: l_leaseName VARCHAR2 (50) := NULL;
594: l_dummy NUMBER := NULL;
595: BEGIN
596: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.CHECK_UNIQUE_CHANGE_NUMBER (+)');
597:
598: IF (X_CHANGE_TYPE_LOOKUP_CODE = 'ABSTRACT') THEN
599: BEGIN
600: SELECT 1

Line 645: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.CHECK_UNIQUE_CHANGE_NUMBER (-)');

641: ELSE
642: RAISE NO_DATA_FOUND;
643: END IF;
644:
645: pnp_debug_pkg.debug ('PN_LEASE_CHANGES_PKG.CHECK_UNIQUE_CHANGE_NUMBER (-)');
646: END CHECK_UNIQUE_CHANGE_NUMBER;
647:
648: END PN_LEASE_CHANGES_PKG;