98: p_imp_map_fields_rec.ATTRIBUTE14),
99: DECODE(p_imp_map_fields_rec.ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,
100: p_imp_map_fields_rec.ATTRIBUTE15),
101: Sysdate,
102: fnd_global.user_id,
103: Sysdate,
104: fnd_global.user_id,
105: fnd_global.login_id
106: from dual;
100: p_imp_map_fields_rec.ATTRIBUTE15),
101: Sysdate,
102: fnd_global.user_id,
103: Sysdate,
104: fnd_global.user_id,
105: fnd_global.login_id
106: from dual;
107:
108: END insert_row;
101: Sysdate,
102: fnd_global.user_id,
103: Sysdate,
104: fnd_global.user_id,
105: fnd_global.login_id
106: from dual;
107:
108: END insert_row;
109:
219: FND_API.G_MISS_CHAR,
220: oldrec.ATTRIBUTE15,
221: p_imp_map_fields_rec.ATTRIBUTE15),
222: LAST_UPDATE_DATE = Sysdate,
223: LAST_UPDATED_BY = fnd_global.user_id,
224: LAST_UPDATE_LOGIN = fnd_global.login_id
225: WHERE imp_map_field_id = p_imp_map_fields_rec.imp_map_field_id;
226:
227: IF (SQL%ROWCOUNT=0) THEN
220: oldrec.ATTRIBUTE15,
221: p_imp_map_fields_rec.ATTRIBUTE15),
222: LAST_UPDATE_DATE = Sysdate,
223: LAST_UPDATED_BY = fnd_global.user_id,
224: LAST_UPDATE_LOGIN = fnd_global.login_id
225: WHERE imp_map_field_id = p_imp_map_fields_rec.imp_map_field_id;
226:
227: IF (SQL%ROWCOUNT=0) THEN
228: RAISE NO_DATA_FOUND;
363: FND_API.G_MISS_CHAR,
364: oldrec.ATTRIBUTE15,
365: p_imp_map_fields_rec.ATTRIBUTE15),
366: LAST_UPDATE_DATE = Sysdate,
367: LAST_UPDATED_BY = fnd_global.user_id,
368: LAST_UPDATE_LOGIN = fnd_global.login_id
369: WHERE imp_map_field_id = p_imp_map_fields_rec.imp_map_field_id;
370:
371: IF (SQL%ROWCOUNT=0) THEN
364: oldrec.ATTRIBUTE15,
365: p_imp_map_fields_rec.ATTRIBUTE15),
366: LAST_UPDATE_DATE = Sysdate,
367: LAST_UPDATED_BY = fnd_global.user_id,
368: LAST_UPDATE_LOGIN = fnd_global.login_id
369: WHERE imp_map_field_id = p_imp_map_fields_rec.imp_map_field_id;
370:
371: IF (SQL%ROWCOUNT=0) THEN
372: RAISE NO_DATA_FOUND;