APPS.PN_LEASES_PKG dependencies on PN_LEASES_ALL

Line 68: FROM pn_leases_all

64: IS
65:
66: CURSOR c IS
67: SELECT ROWID
68: FROM pn_leases_all
69: WHERE lease_id = x_lease_id;
70:
71: l_return_status VARCHAR2(30) := NULL;
72: l_rowId VARCHAR2(18) := NULL;

Line 90: INSERT INTO pn_leases_all

86: IF (l_return_status IS NOT NULL) THEN
87: APP_EXCEPTION.Raise_Exception;
88: END IF;
89:
90: INSERT INTO pn_leases_all
91: (
92: LEASE_ID,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY,

Line 286: FROM pn_leases_all --sdm_MOAC

282: )
283: IS
284: CURSOR c1 IS
285: SELECT *
286: FROM pn_leases_all --sdm_MOAC
287: WHERE lease_id = x_lease_id
288: FOR UPDATE OF lease_id NOWAIT;
289:
290: tlinfo c1%ROWTYPE;

Line 412: -- Update pn_leases_all, for history creation of 3 columns

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
416: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.

Line 413: -- of pn_leases_all (name, lease_num, lease_status) in

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
416: -- pn_leases_pkg.Update_row and pn_lease_details_pkg.
417: -- Update_Row. Fix for bug# 4142423

Line 472: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;

468: IS
469: l_return_status VARCHAR2(30) := NULL;
470:
471: CURSOR org_cur IS
472: SELECT org_id FROM pn_leases_all WHERE lease_id = x_lease_id;
473:
474: l_org_id NUMBER;
475:
476: BEGIN

Line 539: UPDATE pn_leases_all

535: ,X_ATTRIBUTE15 => X_ATTRIBUTE15
536: ,x_lease_extension_end_date => x_lease_extension_end_date
537: );
538:
539: UPDATE pn_leases_all
540: SET NAME = X_NAME,
541: LEASE_NUM = X_LEASE_NUM,
542: PARENT_LEASE_ID = X_PARENT_LEASE_ID,
543: LEASE_TYPE_CODE = X_LEASE_TYPE_CODE,

Line 607: DELETE FROM pn_leases_all

603:
604: -- we need to DELETE the lease changes rows.
605: pn_lease_changes_pkg.Delete_Row (X_LEASE_CHANGE_ID =>l_leaseChangeId);
606:
607: DELETE FROM pn_leases_all
608: WHERE lease_id = x_lease_id;
609:
610: IF (SQL%NOTFOUND) THEN
611: RAISE NO_DATA_FOUND;

Line 679: FROM pn_leases_all pnl

675: SELECT 1
676: INTO l_dummy
677: FROM DUAL
678: WHERE NOT EXISTS (SELECT 1
679: FROM pn_leases_all pnl
680: WHERE pnl.lease_num = x_lease_number
681: AND ((x_lease_id IS NULL) OR (pnl.lease_id <> x_lease_id))
682: AND org_id = x_org_id
683: );