DBA Data[Home] [Help]

APPS.IBC_ASSOCIATION_TYPES_PKG dependencies on FND_LOAD_UTIL

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

334: db_last_update_date DATE;
335:
336: BEGIN
337: --get last updated by user id
338: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
339:
340: --translate data type VARCHAR2 to DATE for last_update_date
341: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
342:

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

344: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
345: FROM ibc_association_types_b
346: WHERE association_type_code = p_association_type_code;
347:
348: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
349: db_user_id, db_last_update_date, p_upload_mode )) THEN
350:
351: Ibc_Association_Types_Pkg.UPDATE_ROW (
352: p_association_type_code => NVL(p_association_type_code,FND_API.G_MISS_CHAR)

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

400:
401:
402: BEGIN
403: --get last updated by user id
404: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
405:
406: --translate data type VARCHAR2 to DATE for last_update_date
407: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
408:

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

411: FROM ibc_association_types_tl
412: WHERE association_type_code = p_association_type_code
413: AND USERENV('LANG') IN (LANGUAGE, source_lang);
414:
415: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
416: db_user_id, db_last_update_date, p_upload_mode )) THEN
417:
418: -- Only update rows which have not been altered by user
419: UPDATE ibc_association_types_tl t SET