APPS.PN_INDEX_LEASE_TERMS_PKG dependencies on PN_INDEX_LEASE_TERMS_PKG

Line 1: PACKAGE BODY PN_INDEX_LEASE_TERMS_PKG AS

1: PACKAGE BODY PN_INDEX_LEASE_TERMS_PKG AS
2: -- $Header: PNILTRHB.pls 120.3 2005/11/30 21:36:01 appldev noship $
3:
4: -- +==========================================================================+
5: -- | Copyright (c) 2001 Oracle Corporation

Line 10: -- | PN_INDEX_LEASE_TERMS_PKG

6: -- | Redwood Shores, California, USA
7: -- | All rights reserved.
8: -- +==========================================================================+
9: -- | Name
10: -- | PN_INDEX_LEASE_TERMS_PKG
11: -- |
12: -- | Description
13: -- | This package contains row handler procedures to populate
14: -- | PN_INDEX_LEASE_TERMS_ALL.

Line 66: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (+)');

62:
63:
64: BEGIN
65:
66: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (+)');
67:
68: FOR rec IN org_cur LOOP
69: l_org_id := rec.org_id;
70: END LOOP;

Line 135: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (-)');

131: ,l_org_id
132: );
133:
134: END IF;
135: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.insert_row (-)');
136: END INSERT_ROW;
137:
138:
139:

Line 164: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (+)');

160: ) IS
161:
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

Line 183: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (-)');

179: WHERE INDEX_LEASE_TERM_ID = X_INDEX_LEASE_TERM_ID;
180:
181: if (sql%notfound) then raise no_data_found ; end if;
182:
183: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.update_row (-)');
184: end update_row;
185:
186:
187:

Line 216: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.lock_row (+)');

212: FOR UPDATE OF INDEX_LEASE_TERM_ID NOWAIT;
213: tlinfo c1%ROWTYPE;
214:
215: BEGIN
216: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.lock_row (+)');
217: open c1; fetch c1 into tlinfo; if (c1%notfound) then close c1; return; end if; close c1;
218: if (
219: tlinfo.INDEX_LEASE_TERM_ID = X_INDEX_LEASE_TERM_ID
220: AND tlinfo.INDEX_LEASE_ID = X_INDEX_LEASE_ID

Line 231: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.lock_row (-)');

227: )
228: then null; ELSE
229: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED'); app_exception.raise_exception;
230: end if;
231: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.lock_row (-)');
232: end LOCK_ROW;
233:
234:
235:

Line 257: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (+)');

253:
254: l_rowExists VARCHAR2(10) := NULL;
255:
256: BEGIN
257: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (+)');
258:
259: BEGIN
260: SELECT '1'
261: INTO l_rowExists

Line 290: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (-)');

286: raise no_data_found;
287: end if;
288:
289: END IF;
290: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (-)');
291: END delete_row;
292:
293:
294: END PN_INDEX_LEASE_TERMS_PKG;

Line 294: END PN_INDEX_LEASE_TERMS_PKG;

290: PNP_DEBUG_PKG.debug (' PN_INDEX_LEASE_TERMS_PKG.delete_row (-)');
291: END delete_row;
292:
293:
294: END PN_INDEX_LEASE_TERMS_PKG;