DBA Data[Home] [Help]

APPS.ICX_POR_ITEM_SOURCES_PKG dependencies on FND_LOAD_UTIL

Line 152: f_luby := fnd_load_util.OWNER_ID(X_OWNER);

148: db_luby number; -- entity owner in db
149: db_ludate date; -- entity update in db
150: begin
151: -- Translate owner to file_last_updated_by
152: f_luby := fnd_load_util.OWNER_ID(X_OWNER);
153: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
154:
155: select LAST_UPDATED_BY, LAST_UPDATE_DATE
156: into db_luby, db_ludate

Line 166: if (fnd_load_util.UPLOAD_TEST(

162: -- Record should be updated only if:
163: -- a. CUSTOM_MODE = FORCE, or
164: -- b. file owner is CUSTOM, db owner is SEED
165: -- c. owners are the same, and file_date > db_date
166: if (fnd_load_util.UPLOAD_TEST(
167: p_file_id => f_luby,
168: p_file_lud => f_ludate,
169: p_db_id => db_luby,
170: p_db_lud => db_ludate,

Line 210: f_luby := fnd_load_util.OWNER_ID(X_OWNER);

206: db_ludate date; -- entity update in db
207:
208: begin
209: -- Translate owner to file_last_updated_by
210: f_luby := fnd_load_util.OWNER_ID(X_OWNER);
211: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
212:
213: select LAST_UPDATED_BY, LAST_UPDATE_DATE
214: into db_luby, db_ludate

Line 242: if (fnd_load_util.UPLOAD_TEST(

238: -- Record should be updated only if:
239: -- a. CUSTOM_MODE = FORCE, or
240: -- b. file owner is CUSTOM, db owner is SEED
241: -- c. owners are the same, and file_date > db_date
242: if (fnd_load_util.UPLOAD_TEST(
243: p_file_id => f_luby,
244: p_file_lud => f_ludate,
245: p_db_id => db_luby,
246: p_db_lud => db_ludate,