APPS.PN_LANDLORD_SERVICES_PKG dependencies on PN_LANDLORD_SERVICES_ALL

Line 57: FROM pn_landlord_services_all

53: IS
54:
55: CURSOR c IS
56: SELECT ROWID
57: FROM pn_landlord_services_all
58: WHERE landlord_service_id = x_landlord_service_id;
59:
60: CURSOR org_cur IS
61: SELECT org_id

Line 86: FROM pn_landlord_services_all pls

82: -- We need to generate the obligation number
83: -------------------------------------------------------*/
84: SELECT NVL(MAX(TO_NUMBER(pls.obligation_num)), 0)+1
85: INTO x_obligation_num
86: FROM pn_landlord_services_all pls
87: WHERE pls.lease_id = x_lease_id;
88:
89: /*-------------------------------------------------------
90: -- SELECT the nextval for landlord service id

Line 98: INSERT INTO pn_landlord_services_all

94: INTO x_landlord_service_id
95: FROM DUAL;
96: END IF;
97:
98: INSERT INTO pn_landlord_services_all
99: (
100: LANDLORD_SERVICE_ID,
101: LAST_UPDATE_DATE,
102: LAST_UPDATED_BY,

Line 239: FROM pn_landlord_services_all

235: )
236: IS
237: CURSOR c1 IS
238: SELECT *
239: FROM pn_landlord_services_all
240: WHERE landlord_service_id = x_landlord_service_id
241: FOR UPDATE OF landlord_service_id NOWAIT;
242:
243: tlinfo c1%ROWTYPE;

Line 467: FROM pn_landlord_services_all

463: )
464: IS
465: CURSOR c2 IS
466: SELECT *
467: FROM pn_landlord_services_all
468: WHERE landlord_service_id = x_landlord_service_id;
469:
470: recInfoForHist c2%ROWTYPE;
471:

Line 590: UPDATE PN_LANDLORD_SERVICES_ALL

586:
587: END IF;
588: END IF;
589:
590: UPDATE PN_LANDLORD_SERVICES_ALL
591: SET LEASE_ID = X_LEASE_ID,
592: LEASE_CHANGE_ID = X_LEASE_CHANGE_ID,
593: SERVICE_TYPE_LOOKUP_CODE = X_SERVICE_TYPE_LOOKUP_CODE,
594: START_DATE = X_START_DATE,

Line 653: DELETE FROM pn_landlord_services_all

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:
656: IF (SQL%NOTFOUND) THEN
657: RAISE NO_DATA_FOUND;