DBA Data[Home] [Help]

APPS.IBC_FILE_EXTN_MAPPINGS_PKG dependencies on FND_LOAD_UTIL

Line 299: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);

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:

Line 309: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

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)

Line 356: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);

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:

Line 367: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

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,