APPS.PN_INDEX_LEASE_TERMS_PKG dependencies on PN_INDEX_LEASE_TERMS_ALL

Line 14: -- | PN_INDEX_LEASE_TERMS_ALL.

10: -- | PN_INDEX_LEASE_TERMS_PKG
11: -- |
12: -- | Description
13: -- | This package contains row handler procedures to populate
14: -- | PN_INDEX_LEASE_TERMS_ALL.
15: -- |
16: -- | History
17: -- | 05-dec-2001 achauhan Created
18: -- | 15-JAN-2002 Mrinal Misra Added dbdrv command.

Line 33: -- pn_index_lease_terms_all.

29: -- 14-jul-05 sdmahesh o Bug 4284035 - Replaced pn_index_lease_terms with
30: -- _ALL table.
31: -- 12-Nov-05 HRodda o Bug 4734542 Modified select statement to select
32: -- org_id from index_leases_all instead of
33: -- pn_index_lease_terms_all.
34: -- 28-NOV-05 pikhar o fetched org_id using cursor
35: -------------------------------------------------------------------------------
36: procedure INSERT_ROW
37: (

Line 81: FROM pn_index_lease_terms_all ilt

77: INTO l_rowExists
78: FROM DUAL
79: WHERE EXISTS (
80: SELECT 1
81: FROM pn_index_lease_terms_all ilt
82: WHERE ilt.index_lease_id = x_index_lease_id
83: AND ilt.index_period_id = x_index_period_id
84: AND ilt.lease_term_id = x_lease_term_id
85: AND ilt.rent_increase_term_id = x_rent_increase_term_id);

Line 99: INSERT INTO PN_INDEX_LEASE_TERMS_ALL

95: IF (X_INDEX_LEASE_TERM_ID IS NULL) THEN
96: SELECT PN_INDEX_LEASE_TERM_S.nextval into X_INDEX_LEASE_TERM_ID from dual;
97: END IF;
98:
99: INSERT INTO PN_INDEX_LEASE_TERMS_ALL
100: (
101: index_lease_term_id
102: ,index_lease_id
103: ,index_period_id

Line 166: UPDATE PN_INDEX_LEASE_TERMS_ALL

162: BEGIN
163:
164: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (+)');
165:
166: UPDATE PN_INDEX_LEASE_TERMS_ALL
167: SET
168: INDEX_LEASE_TERM_ID = X_INDEX_LEASE_TERM_ID
169: ,INDEX_LEASE_ID = X_INDEX_LEASE_ID
170: ,INDEX_PERIOD_ID = X_INDEX_PERIOD_ID

Line 210: FROM PN_INDEX_LEASE_TERMS_ALL

206: ,X_INDEX_TERM_INDICATOR IN VARCHAR2
207: ) IS
208: CURSOR c1 IS
209: SELECT *
210: FROM PN_INDEX_LEASE_TERMS_ALL
211: WHERE INDEX_LEASE_TERM_ID = X_INDEX_LEASE_TERM_ID
212: FOR UPDATE OF INDEX_LEASE_TERM_ID NOWAIT;
213: tlinfo c1%ROWTYPE;
214:

Line 265: FROM pn_index_lease_terms_all ilt

261: INTO l_rowExists
262: FROM DUAL
263: WHERE EXISTS (
264: SELECT 1
265: FROM pn_index_lease_terms_all ilt
266: WHERE ilt.index_lease_id = x_index_lease_id
267: AND ilt.index_period_id = x_index_period_id
268: AND ilt.lease_term_id = x_lease_term_id
269: AND ilt.rent_increase_term_id = x_rent_increase_term_id);

Line 279: DELETE FROM pn_index_lease_terms_all ilt

275: END;
276:
277: IF l_rowExists = '1' THEN
278:
279: DELETE FROM pn_index_lease_terms_all ilt
280: WHERE ilt.index_lease_id = x_index_lease_id
281: AND ilt.index_period_id = x_index_period_id
282: AND ilt.lease_term_id = x_lease_term_id
283: AND ilt.rent_increase_term_id = x_rent_increase_term_id;