DBA Data[Home] [Help]

APPS.IBC_CONTENT_TYPES_PKG dependencies on FND_LOAD_UTIL

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

366: db_last_update_date DATE;
367:
368: BEGIN
369: --get last updated by user id
370: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
371:
372: --translate data type VARCHAR2 to DATE for last_update_date
373: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
374:

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

376: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
377: FROM IBC_CONTENT_TYPES_B
378: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE;
379:
380: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
381: db_user_id, db_last_update_date, p_upload_mode )) THEN
382:
383: Ibc_Content_Types_Pkg.UPDATE_ROW (
384: p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)

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

435: db_last_update_date DATE;
436:
437: BEGIN
438: --get last updated by user id
439: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
440:
441: --translate data type VARCHAR2 to DATE for last_update_date
442: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
443:

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

446: FROM IBC_CONTENT_TYPES_TL
447: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
448: AND USERENV('LANG') IN (LANGUAGE, source_lang);
449:
450: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
451: db_user_id, db_last_update_date, p_upload_mode )) THEN
452: -- Only update rows which have not been altered by user
453: UPDATE IBC_CONTENT_TYPES_TL
454: SET description = p_DESCRIPTION,