APPS.PN_LEASES_PKG dependencies on PN_LEASE_DETAILS_PKG

Line 190: pn_lease_details_pkg.Insert_Row

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

Line 373: pn_lease_details_pkg.Lock_Row

369: ------------------------------------------------------
370: -- We need to lock records in pn_lease_details
371: ------------------------------------------------------
372:
373: pn_lease_details_pkg.Lock_Row
374: (
375: X_LEASE_DETAIL_ID =>X_LEASE_DETAIL_ID
376: ,X_LEASE_CHANGE_ID =>X_LEASE_CHANGE_ID
377: ,X_LEASE_ID =>X_LEASE_ID

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

416: -- HISTORY :
417: -- 19-MAR-02 lkatputu o Added Send_Entries into the table handler
418: -- as per the 'DO NOT SEND' enhancement requirement.
419: -- 25-OCT-02 STRIPATH o Modified Update_Row for Lease Number/Name and MTM.
420: -- Now first call pn_lease_details_pkg.Update_row and then
421: -- Update pn_leases_all, for history creation of 3 columns
422: -- of pn_leases_all (name, lease_num, lease_status) in
423: -- table pn_lease_details_history.
424: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in

Line 425: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.

421: -- Update pn_leases_all, for history creation of 3 columns
422: -- of pn_leases_all (name, lease_num, lease_status) in
423: -- table pn_lease_details_history.
424: -- 02-FEB-05 VIVESHAR o Added lease extension end date as input parameter in
425: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.
426: -- Update_Row. Fix for bug# 4142423
427: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_leases with
428: -- _ALL table.
429: -- 01-DEC-05 kiran o passed org_id in pn_leases_pkg.check_unique_lease_number

Line 513: pn_lease_details_pkg.Update_Row

509:
510: ------------------------------------------------------
511: -- We need to update records in pn_lease_details
512: ------------------------------------------------------
513: pn_lease_details_pkg.Update_Row
514: (
515: X_LEASE_DETAIL_ID => X_LEASE_DETAIL_ID
516: ,X_LEASE_CHANGE_ID => X_LEASE_CHANGE_ID
517: ,X_LEASE_ID => X_LEASE_ID

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

604: AND pt.lease_transaction_id = pc.lease_transaction_id
605: FOR UPDATE OF lease_detail_id NOWAIT;
606:
607: -- first we need to DELETE the lease detail rows.
608: pn_lease_details_pkg.Delete_Row (X_LEASE_DETAIL_ID =>l_leaseDetailId);
609:
610:
611: -- we need to DELETE the transactions rows.
612: pn_lease_changes_pkg.Delete_Row_transactions (X_LEASE_TRANSACTION_ID =>l_leaseTransactionId);