APPS.CN_IMPORT_TYPES_PKG dependencies on CN_IMPORT_TYPES

Line 1: PACKAGE BODY CN_IMPORT_TYPES_PKG AS

1: PACKAGE BODY CN_IMPORT_TYPES_PKG AS
2: /* $Header: cntimtpb.pls 115.2 2002/02/05 00:25:58 pkm ship $*/
3:
4:
5: -- * -------------------------------------------------------------------------*

Line 20: INSERT into CN_IMPORT_TYPES

16: ( p_import_types_rec IN IMPORT_TYPES_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_IMPORT_TYPES
21: ( IMPORT_TYPE_ID,
22: IMPORT_TYPE_CODE,
23: VIEW_NAME,
24: CONC_PROGRAM,

Line 118: UPDATE CN_IMPORT_TYPES oldrec

114: ( p_import_types_rec IN IMPORT_TYPES_REC_TYPE) IS
115:
116: BEGIN
117:
118: UPDATE CN_IMPORT_TYPES oldrec
119: SET
120: IMPORT_TYPE_CODE = DECODE(p_import_types_rec.IMPORT_TYPE_CODE,
121: FND_API.G_MISS_CHAR,
122: oldrec.IMPORT_TYPE_CODE,

Line 229: FROM CN_IMPORT_TYPES

225: ( p_import_types_rec IN IMPORT_TYPES_REC_TYPE) IS
226:
227: CURSOR c IS
228: SELECT object_version_number
229: FROM CN_IMPORT_TYPES
230: WHERE import_type_id = p_import_types_rec.import_type_id;
231:
232: tlinfo c%ROWTYPE ;
233: BEGIN

Line 250: UPDATE CN_IMPORT_TYPES oldrec

246: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
247: fnd_msg_pub.add;
248: raise fnd_api.g_exc_unexpected_error;
249: end if;
250: UPDATE CN_IMPORT_TYPES oldrec
251: SET
252: IMPORT_TYPE_CODE = DECODE(p_import_types_rec.IMPORT_TYPE_CODE,
253: FND_API.G_MISS_CHAR,
254: oldrec.IMPORT_TYPE_CODE,

Line 361: DELETE FROM CN_IMPORT_TYPES

357: ) IS
358:
359: BEGIN
360:
361: DELETE FROM CN_IMPORT_TYPES
362: WHERE import_type_id = p_import_type_id;
363:
364: IF (SQL%ROWCOUNT=0) THEN
365: RAISE NO_DATA_FOUND;

Line 371: END CN_IMPORT_TYPES_PKG;

367:
368: END Delete_row;
369:
370:
371: END CN_IMPORT_TYPES_PKG;