APPS.CN_IMP_HEADERS_PKG dependencies on CN_IMP_HEADERS

Line 1: PACKAGE BODY CN_IMP_HEADERS_PKG AS

1: PACKAGE BODY CN_IMP_HEADERS_PKG AS
2: /* $Header: cntimhrb.pls 115.4 2002/02/12 18:58:45 pkm ship $*/
3:
4:
5: -- * -------------------------------------------------------------------------*

Line 16: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS

12: -- this procedure. No refernece to sequence in this procedure.
13: -- 2. All paramaters are IN parameter.
14: -- * -------------------------------------------------------------------------*
15: PROCEDURE insert_row
16: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_IMP_HEADERS

Line 20: INSERT into CN_IMP_HEADERS

16: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_IMP_HEADERS
21: ( IMP_HEADER_ID,
22: NAME,
23: DESCRIPTION,
24: IMPORT_TYPE_CODE,

Line 150: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS

146: -- 3. All paramaters are IN parameter.
147: -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
148: -- * -------------------------------------------------------------------------*
149: PROCEDURE update_row
150: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
151:
152: BEGIN
153:
154: UPDATE CN_IMP_HEADERS oldrec

Line 154: UPDATE CN_IMP_HEADERS oldrec

150: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
151:
152: BEGIN
153:
154: UPDATE CN_IMP_HEADERS oldrec
155: SET
156: NAME = DECODE(p_imp_headers_rec.NAME,
157: FND_API.G_MISS_CHAR,
158: oldrec.NAME,

Line 309: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS

305: -- 3. All paramaters are IN parameter.
306: -- 4. Raise NO_DATA_FOUND exception if no reocrd updated (??)
307: -- * -------------------------------------------------------------------------*
308: PROCEDURE lock_update_row
309: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
310:
311: CURSOR c IS
312: SELECT object_version_number
313: FROM CN_IMP_HEADERS

Line 313: FROM CN_IMP_HEADERS

309: ( p_imp_headers_rec IN CN_IMP_HEADERS_PVT.IMP_HEADERS_REC_TYPE) IS
310:
311: CURSOR c IS
312: SELECT object_version_number
313: FROM CN_IMP_HEADERS
314: WHERE imp_header_id = p_imp_headers_rec.imp_header_id;
315:
316: tlinfo c%ROWTYPE ;
317: BEGIN

Line 334: UPDATE CN_IMP_HEADERS oldrec

330: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
331: fnd_msg_pub.add;
332: raise fnd_api.g_exc_unexpected_error;
333: end if;
334: UPDATE CN_IMP_HEADERS oldrec
335: SET
336: NAME = DECODE(p_imp_headers_rec.NAME,
337: FND_API.G_MISS_CHAR,
338: oldrec.NAME,

Line 493: DELETE FROM CN_IMP_HEADERS

489: ) IS
490:
491: BEGIN
492:
493: DELETE FROM CN_IMP_HEADERS
494: WHERE imp_header_id = p_imp_header_id;
495:
496: IF (SQL%ROWCOUNT=0) THEN
497: RAISE NO_DATA_FOUND;

Line 503: END CN_IMP_HEADERS_PKG;

499:
500: END Delete_row;
501:
502:
503: END CN_IMP_HEADERS_PKG;