DBA Data[Home] [Help]

APPS.ICX_CAT_CATEGORIES_PVT dependencies on FND_LOAD_UTIL

Line 215: F_LUBY := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

211: DB_LUDATE DATE; -- entity update in db
212:
213: BEGIN
214: -- Translate owner to file_last_updated_by
215: F_LUBY := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
216: F_LUDATE := NVL(TO_DATE(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), SYSDATE);
217:
218: SELECT LAST_UPDATED_BY,
219: LAST_UPDATE_DATE

Line 230: IF (FND_LOAD_UTIL.UPLOAD_TEST(P_FILE_ID => F_LUBY,

226: -- a. CUSTOM_MODE = FORCE, or
227: -- b. file owner is CUSTOM, db owner is SEED
228: -- c. owners are the same, and file_date > db_date
229:
230: IF (FND_LOAD_UTIL.UPLOAD_TEST(P_FILE_ID => F_LUBY,
231: P_FILE_LUD => F_LUDATE,
232: P_DB_ID => DB_LUBY,
233: P_DB_LUD => DB_LUDATE,
234: P_CUSTOM_MODE => X_CUSTOM_MODE)) THEN

Line 273: F_LUBY := FND_LOAD_UTIL.OWNER_ID(X_OWNER);

269: DB_LUBY NUMBER; -- entity owner in db
270: DB_LUDATE DATE; -- entity update in db
271: BEGIN
272: -- Translate owner to file_last_updated_by
273: F_LUBY := FND_LOAD_UTIL.OWNER_ID(X_OWNER);
274:
275: F_LUDATE := NVL(TO_DATE(X_LAST_UPDATE_DATE,
276: 'YYYY/MM/DD'),
277: SYSDATE);

Line 291: IF (FND_LOAD_UTIL.UPLOAD_TEST(P_FILE_ID => F_LUBY,

287: -- a. CUSTOM_MODE = FORCE, or
288: -- b. file owner is CUSTOM, db owner is SEED
289: -- c. owners are the same, and file_date > db_date
290:
291: IF (FND_LOAD_UTIL.UPLOAD_TEST(P_FILE_ID => F_LUBY,
292: P_FILE_LUD => F_LUDATE,
293: P_DB_ID => DB_LUBY,
294: P_DB_LUD => DB_LUDATE,
295: P_CUSTOM_MODE => X_CUSTOM_MODE)) THEN