DBA Data[Home] [Help]

APPS.PN_LEASE_CHANGES_PKG dependencies on PN_LEASE_TRANSACTIONS_ALL

Line 127: INSERT INTO pn_lease_transactions_all

123: ELSE
124: l_org_id := x_org_id;
125: END IF;
126:
127: INSERT INTO pn_lease_transactions_all
128: (
129: LEASE_TRANSACTION_ID
130: ,LEASE_ID
131: ,LOCATION_ID

Line 567: DELETE FROM pn_lease_transactions_all

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
571: RAISE NO_DATA_FOUND;