APPS.PN_LANDLORD_SERVICES_PKG dependencies on PNP_DEBUG_PKG

Line 70: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Insert_Row (+)');

66:
67:
68: BEGIN
69:
70: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Insert_Row (+)');
71:
72: IF x_org_id IS NULL THEN
73: FOR rec IN org_cur LOOP
74: l_org_id := rec.org_id;

Line 189: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Insert_Row (-)');

185: RAISE NO_DATA_FOUND;
186: END IF;
187: CLOSE c;
188:
189: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Insert_Row (-)');
190:
191: END Insert_Row;
192:
193: -------------------------------------------------------------------------------

Line 247: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Lock_Row (+)');

243: tlinfo c1%ROWTYPE;
244:
245: BEGIN
246:
247: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Lock_Row (+)');
248:
249: OPEN c1;
250: FETCH c1 INTO tlinfo;
251: IF (c1%NOTFOUND) THEN

Line 414: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Lock_Row (-)');

410: END IF;
411:
412: RETURN;
413:
414: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Lock_Row (-)');
415:
416: END Lock_Row;
417:
418: -------------------------------------------------------------------------------

Line 477: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Update_Row (+)');

473: l_leaseStatus VARCHAR2(30) := NULL;
474:
475: BEGIN
476:
477: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Update_Row (+)');
478: /*---------------------------------------------------------------
479: -- get the lease status
480: ---------------------------------------------------------------*/
481: l_leaseStatus := PNP_UTIL_FUNC.GET_LEASE_STATUS (X_LEASE_ID);

Line 632: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Update_Row (-)');

628: IF (SQL%NOTFOUND) THEN
629: RAISE NO_DATA_FOUND;
630: END IF;
631:
632: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Update_Row (-)');
633:
634: END Update_Row;
635:
636: -------------------------------------------------------------------------------

Line 651: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Delete_Row (+)');

647: )
648: IS
649: BEGIN
650:
651: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Delete_Row (+)');
652:
653: DELETE FROM pn_landlord_services_all
654: WHERE landlord_service_id = x_landlord_service_id;
655:

Line 660: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Delete_Row (-)');

656: IF (SQL%NOTFOUND) THEN
657: RAISE NO_DATA_FOUND;
658: END IF;
659:
660: pnp_debug_pkg.debug ('PN_LANDLORD_SERVICES_PKG.Delete_Row (-)');
661:
662: END Delete_Row;
663:
664: END pn_landlord_services_pkg;