APPS.PN_INDEX_HISTORY_HEADERS_PKG dependencies on PN_INDEX_HISTORY_HEADERS_PKG

Line 1: PACKAGE BODY pn_index_history_headers_pkg AS

1: PACKAGE BODY pn_index_history_headers_pkg AS
2: -- $Header: PNTINHHB.pls 115.6 2002/11/12 23:05:51 stripath ship $
3:
4: /*============================================================================+
5: | Copyright (c) 2001 Oracle Corporation

Line 65: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.insert_row (+)');

61: l_return_status VARCHAR2 (30) := NULL;
62: l_rowid VARCHAR2 (18) := NULL;
63: BEGIN
64:
65: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.insert_row (+)');
66: -- If no INDEX_ID is provided, get one from sequence
67: IF (x_index_id IS NULL) THEN
68: SELECT pn_index_history_headers_s.NEXTVAL
69: INTO x_index_id

Line 147: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.insert_row (-)');

143: END IF;
144:
145: CLOSE c;
146:
147: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.insert_row (-)');
148: END insert_row;
149:
150:
151: ------------------------------------------------------------------------

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

179: ) IS
180: l_return_status VARCHAR2 (30) := NULL;
181: BEGIN
182:
183: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.update_row (+)');
184:
185:
186: check_unq_index_type (l_return_status, x_index_id, x_name);
187:

Line 221: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.update_row (-)');

217: IF (SQL%NOTFOUND) THEN
218: RAISE NO_DATA_FOUND;
219: END IF;
220:
221: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.update_row (-)');
222: END update_row;
223:
224:
225: ------------------------------------------------------------------------

Line 260: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.lock_row (+)');

256:
257: tlinfo c1%ROWTYPE;
258: BEGIN
259:
260: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.lock_row (+)');
261: OPEN c1;
262: FETCH c1 INTO tlinfo;
263:
264: IF (c1%NOTFOUND) THEN

Line 290: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.lock_row (-)');

286: fnd_message.set_name ('FND', 'FORM_RECORD_CHANGED');
287: app_exception.raise_exception;
288: END IF;
289:
290: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.lock_row (-)');
291: END lock_row;
292:
293:
294: ------------------------------------------------------------------------

Line 302: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.delete_row (+)');

298: x_rowid IN VARCHAR2
299: ) IS
300: BEGIN
301:
302: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.delete_row (+)');
303: DELETE FROM pn_index_history_headers
304: WHERE ROWID = x_rowid;
305:
306: IF (SQL%NOTFOUND) THEN

Line 310: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.delete_row (-)');

306: IF (SQL%NOTFOUND) THEN
307: RAISE NO_DATA_FOUND;
308: END IF;
309:
310: --PNP_DEBUG_PKG.debug (' PN_INDEX_HISTORY_HEADERS_PKG.delete_row (-)');
311: END delete_row;
312:
313: PROCEDURE check_unq_index_type (
314: x_return_status IN OUT NOCOPY VARCHAR2

Line 336: END pn_index_history_headers_pkg;

332:
333: -- fnd_message.set_token ('NAME', x_name);
334: x_return_status := 'E';
335: END check_unq_index_type;
336: END pn_index_history_headers_pkg;