APPS.IBC_DIRECTORY_NODES_PKG dependencies on FND_LOAD_UTIL

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

582: l_row_id VARCHAR2(64);
583:
584: BEGIN
585: --get last updated by user id
586: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
587:
588: --translate data type VARCHAR2 to DATE for last_update_date
589: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
590:

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

592: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
593: FROM IBC_DIRECTORY_NODES_B
594: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
595:
596: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
597: db_user_id, db_last_update_date, p_upload_mode )) THEN
598:
599: Ibc_Directory_Nodes_Pkg.UPDATE_ROW (
600: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,

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

661: db_last_update_date DATE;
662:
663: BEGIN
664: --get last updated by user id
665: l_user_id := FND_LOAD_UTIL.OWNER_ID(p_OWNER);
666:
667: --translate data type VARCHAR2 to DATE for last_update_date
668: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
669:

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

672: FROM ibc_directory_nodes_tl
673: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID
674: AND USERENV('LANG') IN (LANGUAGE, source_lang);
675:
676: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
677: db_user_id, db_last_update_date, p_upload_mode )) THEN
678:
679: -- Only update rows which have not been altered by user
680: UPDATE ibc_directory_nodes_tl t SET