APPS.PN_LEASE_DETAILS_PKG dependencies on PNP_DEBUG_PKG

Line 66: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Insert_Row (+)');

62: l_org_id NUMBER;
63:
64: BEGIN
65:
66: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Insert_Row (+)');
67:
68: IF x_org_id IS NULL THEN
69: FOR rec IN org_cur LOOP
70: l_org_id := rec.org_id;

Line 160: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Insert_Row (-)');

156: RAISE NO_DATA_FOUND;
157: END IF;
158: CLOSE c;
159:
160: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Insert_Row (-)');
161:
162: END Insert_Row;
163:
164: -------------------------------------------------------------------------------

Line 226: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Lock_Row (+)');

222: tlinfo c1%ROWTYPE;
223:
224: BEGIN
225:
226: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Lock_Row (+)');
227:
228: OPEN c1;
229: FETCH c1 INTO tlinfo;
230: IF(c1%NOTFOUND) THEN

Line 391: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Lock_Row (-)');

387: END IF;
388:
389: RETURN;
390:
391: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Lock_Row (-)');
392:
393: END Lock_Row;
394:
395: -------------------------------------------------------------------------------

Line 461: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Update_Row (+)');

457: l_leaseStatus VARCHAR2(30):= NULL;
458:
459: BEGIN
460:
461: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Update_Row (+)');
462:
463: -- get the lease status
464: l_leaseStatus := PNP_UTIL_FUNC.get_lease_status(x_lease_id);
465:

Line 595: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Update_Row (-)');

591: IF(SQL%NOTFOUND) THEN
592: RAISE NO_DATA_FOUND;
593: END IF;
594:
595: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Update_Row (-)');
596:
597: END Update_Row;
598:
599: -------------------------------------------------------------------------------

Line 614: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Delete_Row (+)');

610: )
611: IS
612: BEGIN
613:
614: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Delete_Row (+)');
615:
616: DELETE FROM pn_lease_details_all
617: WHERE lease_detail_id = x_lease_detail_id;
618:

Line 623: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Delete_Row (-)');

619: IF(SQL%NOTFOUND) THEN
620: RAISE NO_DATA_FOUND;
621: END IF;
622:
623: pnp_debug_pkg.debug('PN_LEASE_DETAILS_PKG.Delete_Row (-)');
624:
625: END Delete_Row;
626:
627: END pn_lease_details_pkg;