APPS.FND_IREP_DEFERRED_LOADER dependencies on FND_IREP_DEFERRED_LOAD_FILES

Line 45: FROM FND_IREP_DEFERRED_LOAD_FILES

41:
42: CURSOR PendingFiles is
43: SELECT rowid, '@' || file_product || ':' || file_path || '/' || file_name,
44: REQUEST_ID, BATCH_ID
45: FROM FND_IREP_DEFERRED_LOAD_FILES
46: WHERE load_status = 'R' and REQUEST_ID is not Null
47: ORDER BY 4,3,2;
48:
49: begin

Line 108: update FND_IREP_DEFERRED_LOAD_FILES

104: || ' not found.';
105: LDT_Logfile := Null;
106: end;
107:
108: update FND_IREP_DEFERRED_LOAD_FILES
109: set LOAD_STATUS = DECODE(LDT_Status, 'S', 'C', 'E'),
110: LOAD_ERRORS = LDT_Errors,
111: LOAD_START = LDT_Start,
112: LOAD_FINISH = LDT_Finish,

Line 155: FROM FND_IREP_DEFERRED_LOAD_FILES

151: requestID number;
152:
153: CURSOR curLoadFile IS
154: SELECT rowid, '@' || file_product || ':' || file_path || '/' || file_name
155: FROM FND_IREP_DEFERRED_LOAD_FILES
156: WHERE load_status = pStatus
157: ORDER BY file_path, file_product, file_name;
158:
159: begin

Line 239: update FND_IREP_DEFERRED_LOAD_FILES

235: end loop;
236:
237: for i in 1..LDT_Array.COUNT loop
238: -- Update original row with state / request info
239: update FND_IREP_DEFERRED_LOAD_FILES
240: set load_status = BatchStatus_Array(LDT2Batch_Map(i)),
241: request_id = BatchReqID_Array(LDT2Batch_Map(i)),
242: batch_id = BatchID_Array(LDT2Batch_Map(i)),
243: LAST_UPDATE_DATE = sysdate,

Line 299: -- Populate fnd_irep_deferred_load_files table

295: P_end_date => '01-01-2049',
296: P_file_extension_list => '(''ildt'')'
297: );
298:
299: -- Populate fnd_irep_deferred_load_files table
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating FND_IREP_DEFERRED_LOAD_FILES.');
301: insert into FND_IREP_DEFERRED_LOAD_FILES
302: (
303: FILE_PRODUCT, FILE_PATH, FILE_NAME,

Line 300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating FND_IREP_DEFERRED_LOAD_FILES.');

296: P_file_extension_list => '(''ildt'')'
297: );
298:
299: -- Populate fnd_irep_deferred_load_files table
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating FND_IREP_DEFERRED_LOAD_FILES.');
301: insert into FND_IREP_DEFERRED_LOAD_FILES
302: (
303: FILE_PRODUCT, FILE_PATH, FILE_NAME,
304: FILE_VERSION, LOAD_STATUS, CREATED_BY, CREATION_DATE,

Line 301: insert into FND_IREP_DEFERRED_LOAD_FILES

297: );
298:
299: -- Populate fnd_irep_deferred_load_files table
300: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Populating FND_IREP_DEFERRED_LOAD_FILES.');
301: insert into FND_IREP_DEFERRED_LOAD_FILES
302: (
303: FILE_PRODUCT, FILE_PATH, FILE_NAME,
304: FILE_VERSION, LOAD_STATUS, CREATED_BY, CREATION_DATE,
305: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN

Line 315: from FND_IREP_DEFERRED_LOAD_FILES LF

311: from AD_PROCESSED_FILES_TEMP PF
312: where not exists
313: (
314: select 1
315: from FND_IREP_DEFERRED_LOAD_FILES LF
316: where FND_IREP_LOADER_PRIVATE.COMPARE_VERSIONS(
317: PF.VERSION, LF.FILE_VERSION) in ('=', '<')
318: and LF.FILE_NAME = PF.FILE_BASE || '.' || PF.FILE_EXTENSION
319: and LF.FILE_PATH = PF.SUBDIR

Line 324: update FND_IREP_DEFERRED_LOAD_FILES F1

320: and LF.FILE_PRODUCT = PF.PRODUCT_SHORT_NAME
321: );
322:
323: -- clean out old versions of files that have updated revisions.
324: update FND_IREP_DEFERRED_LOAD_FILES F1
325: set LOAD_STATUS = 'X'
326: where F1.LOAD_STATUS <> 'X'
327: and F1.LOAD_STATUS <> 'C'
328: and exists (select Null

Line 329: from FND_IREP_DEFERRED_LOAD_FILES F2

325: set LOAD_STATUS = 'X'
326: where F1.LOAD_STATUS <> 'X'
327: and F1.LOAD_STATUS <> 'C'
328: and exists (select Null
329: from FND_IREP_DEFERRED_LOAD_FILES F2
330: where F1.FILE_NAME = F2.FILE_NAME
331: and F1.FILE_PATH = F2.FILE_PATH
332: and F1.FILE_PRODUCT = F2.FILE_PRODUCT
333: and FND_IREP_LOADER_PRIVATE.COMPARE_VERSIONS(

Line 350: Update FND_IREP_DEFERRED_LOAD_FILES

346: -- On very rare occasions a file will get stuck as listed in running mode
347: -- If we see something that is in R and hasn't been updated in a day,
348: -- we will consider it an error.
349:
350: Update FND_IREP_DEFERRED_LOAD_FILES
351: Set LOAD_STATUS = 'E',
352: LOAD_ERRORS = 'Hung in Status R for 24 hours.'
353: where LOAD_STATUS = 'R'
354: and LAST_UPDATE_DATE < SYSDATE - 1;

Line 395: from FND_IREP_DEFERRED_LOAD_FILES

391:
392: -- Lets see if there are still some running rows, if so resubmit.
393: select count(*)
394: into kount
395: from FND_IREP_DEFERRED_LOAD_FILES
396: where LOAD_STATUS = 'R';
397:
398: if (kount > 0) then
399: dbms_lock.sleep(120);