APPS.PN_LEASES_PKG dependencies on PN_LEASE_DETAILS_PKG

Line 187: pn_lease_details_pkg.Insert_Row

183: ------------------------------------------------------
184: -- We need to insert a record in PN_LEASE_DETAILS
185: ------------------------------------------------------
186: l_rowId := NULL;
187: pn_lease_details_pkg.Insert_Row
188: (
189: X_ROWID => l_rowId
190: ,X_LEASE_DETAIL_ID => X_LEASE_DETAIL_ID
191: ,X_LEASE_CHANGE_ID => X_LEASE_CHANGE_ID

Line 364: pn_lease_details_pkg.Lock_Row

360: ------------------------------------------------------
361: -- We need to lock records in pn_lease_details
362: ------------------------------------------------------
363:
364: pn_lease_details_pkg.Lock_Row
365: (
366: X_LEASE_DETAIL_ID =>X_LEASE_DETAIL_ID
367: ,X_LEASE_CHANGE_ID =>X_LEASE_CHANGE_ID
368: ,X_LEASE_ID =>X_LEASE_ID

Line 411: -- Now first call pn_lease_details_pkg.Update_row and then

407: -- HISTORY :
408: -- 19-MAR-02 lkatputu o Added Send_Entries into the table handler
409: -- as per the 'DO NOT SEND' enhancement requirement.
410: -- 25-OCT-02 STRIPATH o Modified Update_Row for Lease Number/Name and MTM.
411: -- Now first call pn_lease_details_pkg.Update_row and then
412: -- Update pn_leases_all, for history creation of 3 columns
413: -- of pn_leases_all (name, lease_num, lease_status) in
414: -- table pn_lease_details_history.
415: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in

Line 416: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.

412: -- Update pn_leases_all, for history creation of 3 columns
413: -- of pn_leases_all (name, lease_num, lease_status) in
414: -- table pn_lease_details_history.
415: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in
416: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.
417: -- Update_Row. Fix for bug# 4142423
418: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_leases with
419: -- _ALL table.
420: -- 01-DEC-05 kiran o passed org_id in pn_leases_pkg.check_unique_lease_number

Line 503: pn_lease_details_pkg.Update_Row

499:
500: ------------------------------------------------------
501: -- We need to update records in pn_lease_details
502: ------------------------------------------------------
503: pn_lease_details_pkg.Update_Row
504: (
505: X_LEASE_DETAIL_ID => X_LEASE_DETAIL_ID
506: ,X_LEASE_CHANGE_ID => X_LEASE_CHANGE_ID
507: ,X_LEASE_ID => X_LEASE_ID

Line 597: pn_lease_details_pkg.Delete_Row (X_LEASE_DETAIL_ID =>l_leaseDetailId);

593: AND pt.lease_transaction_id = pc.lease_transaction_id
594: FOR UPDATE OF lease_detail_id NOWAIT;
595:
596: -- first we need to DELETE the lease detail rows.
597: pn_lease_details_pkg.Delete_Row (X_LEASE_DETAIL_ID =>l_leaseDetailId);
598:
599:
600: -- we need to DELETE the transactions rows.
601: pn_lease_changes_pkg.Delete_Row_transactions (X_LEASE_TRANSACTION_ID =>l_leaseTransactionId);