APPS.CN_IMP_MAP_FIELDS_PKG dependencies on CN_IMP_MAP_FIELDS

Line 1: PACKAGE BODY CN_IMP_MAP_FIELDS_PKG AS

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

Line 20: INSERT into CN_IMP_MAP_FIELDS

16: ( p_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE) IS
17:
18: BEGIN
19:
20: INSERT into CN_IMP_MAP_FIELDS
21: ( IMP_MAP_FIELD_ID,
22: IMP_MAP_ID,
23: SOURCE_COLUMN,
24: SOURCE_USER_COLUMN,

Line 127: UPDATE CN_IMP_MAP_FIELDS oldrec

123: ( p_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE) IS
124:
125: BEGIN
126:
127: UPDATE CN_IMP_MAP_FIELDS oldrec
128: SET
129: IMP_MAP_ID = DECODE(p_imp_map_fields_rec.IMP_MAP_ID,
130: FND_API.G_MISS_NUM,
131: oldrec.IMP_MAP_ID,

Line 250: FROM CN_IMP_MAP_FIELDS

246: ( p_imp_map_fields_rec IN IMP_MAP_FIELDS_REC_TYPE) IS
247:
248: CURSOR c IS
249: SELECT object_version_number
250: FROM CN_IMP_MAP_FIELDS
251: WHERE imp_map_field_id = p_imp_map_fields_rec.imp_map_field_id;
252:
253: tlinfo c%ROWTYPE ;
254: BEGIN

Line 271: UPDATE CN_IMP_MAP_FIELDS oldrec

267: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
268: fnd_msg_pub.add;
269: raise fnd_api.g_exc_unexpected_error;
270: end if;
271: UPDATE CN_IMP_MAP_FIELDS oldrec
272: SET
273: IMP_MAP_ID = DECODE(p_imp_map_fields_rec.IMP_MAP_ID,
274: FND_API.G_MISS_NUM,
275: oldrec.IMP_MAP_ID,

Line 394: DELETE FROM CN_IMP_MAP_FIELDS

390: ) IS
391:
392: BEGIN
393:
394: DELETE FROM CN_IMP_MAP_FIELDS
395: WHERE imp_map_field_id = p_imp_map_field_id;
396:
397: IF (SQL%ROWCOUNT=0) THEN
398: RAISE NO_DATA_FOUND;

Line 404: END CN_IMP_MAP_FIELDS_PKG;

400:
401: END Delete_row;
402:
403:
404: END CN_IMP_MAP_FIELDS_PKG;