DBA Data[Home] [Help]

APPS.IBC_CITEM_VERSIONS_PKG dependencies on FND_LOAD_UTIL

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

1020: BEGIN
1021:
1022:
1023: --get last updated by user id
1024: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
1025:
1026: --translate data type VARCHAR2 to DATE for last_update_date
1027: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
1028:

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

1058: SELECT MAX(object_version_number) INTO lx_object_version_number
1059: FROM IBC_CONTENT_ITEMS
1060: WHERE content_item_id = p_content_item_id;
1061:
1062: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
1063: db_user_id, db_last_update_date, p_upload_mode )) THEN
1064:
1065: Ibc_Citem_Versions_Pkg.UPDATE_ROW (
1066: p_citem_version_id => NVL(p_citem_version_id,FND_API.G_MISS_NUM)

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

1149:
1150: BEGIN
1151:
1152: --get last updated by user id
1153: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
1154:
1155: --translate data type VARCHAR2 to DATE for last_update_date
1156: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
1157:

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

1190: END IF;
1191: */
1192: END LOOP;
1193:
1194: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
1195: db_user_id, db_last_update_date, p_upload_mode )) THEN
1196:
1197: -- Only update rows which have not been altered by user
1198: UPDATE IBC_CITEM_VERSIONS_TL