APPS.PN_INDEX_EXCLUDE_TERM_PKG dependencies on PN_INDEX_EXCLUDE_TERM_PKG

Line 1: PACKAGE BODY PN_INDEX_EXCLUDE_TERM_PKG AS

1: PACKAGE BODY PN_INDEX_EXCLUDE_TERM_PKG AS
2: -- $Header: PNINXTRB.pls 120.3 2006/12/20 07:40:40 rdonthul ship $
3:
4:
5: -------------------------------------------------------------------------------

Line 38: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (+)');

34: SELECT org_id FROM pn_index_leases_all WHERE index_lease_id = x_index_lease_id;
35: l_org_ID NUMBER;
36: BEGIN
37:
38: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (+)');
39:
40: /* If no INDEX_EXCLUDE_TERM_ID is provided, get one from sequence */
41:
42: BEGIN

Line 103: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (-)');

99: );
100:
101: END IF;
102:
103: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.insert_row (-)');
104:
105: END INSERT_ROW;
106:
107:

Line 134: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (+)');

130: l_return_status VARCHAR2(30) := NULL;
131:
132: BEGIN
133:
134: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (+)');
135:
136: IF (l_return_status IS NOT NULL) THEN
137: APP_EXCEPTION.Raise_Exception;
138: END IF;

Line 153: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (-)');

149:
150: IF (sql%notfound) THEN
151: RAISE NO_DATA_FOUND ;
152: END IF;
153: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.update_row (-)');
154:
155: END update_row;
156:
157: -------------------------------------------------------------------------------

Line 185: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.lock_row (+)');

181: tlinfo c1%ROWTYPE;
182:
183: BEGIN
184:
185: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.lock_row (+)');
186:
187: OPEN c1;
188: FETCH c1 INTO tlinfo;
189: IF (c1%notfound) THEN

Line 211: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.lock_row (-)');

207: IF NOT (tlinfo.INCLUDE_EXCLUDE_FLAG = X_INCLUDE_EXCLUDE_FLAG) THEN
208: pn_var_rent_pkg.lock_row_exception('INCLUDE_EXCLUDE_FLAG',tlinfo.include_exclude_flag);
209: END IF;
210:
211: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.lock_row (-)');
212: END LOCK_ROW;
213:
214:
215:

Line 236: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (+)');

232: l_rowExists VARCHAR2(10) := NULL;
233:
234: BEGIN
235:
236: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (+)');
237:
238: BEGIN
239: SELECT '1'
240: INTO l_rowExists

Line 264: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (-)');

260: END IF;
261:
262: END IF;
263:
264: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.delete_row (-)');
265:
266: END delete_row;
267:
268: -------------------------------------------------------------------------------

Line 281: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (+)');

277: IS
278:
279: BEGIN
280:
281: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (+)');
282:
283: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
284: WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID;
285:

Line 286: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (-)');

282:
283: DELETE FROM PN_INDEX_EXCLUDE_TERM_ALL
284: WHERE INDEX_LEASE_ID = X_INDEX_LEASE_ID;
285:
286: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (-)');
287:
288: END DELETE_ALL_EXCLUDE_TERMS;
289:
290: END PN_INDEX_EXCLUDE_TERM_PKG;

Line 290: END PN_INDEX_EXCLUDE_TERM_PKG;

286: PNP_DEBUG_PKG.debug (' PN_INDEX_EXCLUDE_TERM_PKG.DELETE_ALL_EXCLUDE_TERMS (-)');
287:
288: END DELETE_ALL_EXCLUDE_TERMS;
289:
290: END PN_INDEX_EXCLUDE_TERM_PKG;