295: db_last_update_date DATE;
296:
297: BEGIN
298: --get last updated by user id
299: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
300:
301: --translate data type VARCHAR2 to DATE for last_update_date
302: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
303:
305: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
306: FROM IBC_FILE_EXTN_MAPPINGS_B
307: WHERE MAPPING_ID = p_mapping_id;
308:
309: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
310: db_user_id, db_last_update_date, p_upload_mode )) THEN
311:
312: IBC_FILE_EXTN_MAPPINGS_PKG.Update_row (
313: x_mapping_id =>TO_NUMBER(p_mapping_id)
352: db_last_update_date DATE;
353:
354: BEGIN
355: --get last updated by user id
356: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
357:
358: --translate data type VARCHAR2 to DATE for last_update_date
359: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
360:
363: FROM IBC_FILE_EXTN_MAPPINGS_TL
364: WHERE MAPPING_ID = p_mapping_id
365: AND USERENV('LANG') IN (LANGUAGE, source_lang);
366:
367: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
368: db_user_id, db_last_update_date, p_upload_mode )) THEN
369: -- Only update rows which have not been altered by user
370: UPDATE IBC_FILE_EXTN_MAPPINGS_TL
371: SET description = p_description,