APPS.FND_IREP_DEFERRED_LOADER dependencies on FND_LOADER_OPEN_INTERFACE_PKG

Line 22: LDT_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_LDT_TAB;

18:
19: procedure cleanup_batches is
20:
21: LDT_RowID_Array FND_ROW_TAB;
22: LDT_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_LDT_TAB;
23: ReqID_Array FND_NUMBER_TAB;
24: BatchID_Array FND_NUMBER_TAB;
25:
26: prevReqID Number;

Line 120: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));

116: where rowid = LDT_RowID_Array(i);
117:
118: -- Purge interface table after copying back entire batch
119: if (i = LDT_Array.COUNT) then -- absolute last row
120: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));
121: elsif (BatchID_Array(i) <> BatchID_Array(i+1)) then -- last in batch
122: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));
123: end if;
124: end if;

Line 122: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));

118: -- Purge interface table after copying back entire batch
119: if (i = LDT_Array.COUNT) then -- absolute last row
120: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));
121: elsif (BatchID_Array(i) <> BatchID_Array(i+1)) then -- last in batch
122: FND_LOADER_OPEN_INTERFACE_PKG.DELETE_BATCH(BatchID_Array(i));
123: end if;
124: end if;
125: end loop;
126:

Line 144: BatchID_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_BATCH_ID_TAB;

140:
141: procedure UploadBatch(pStatus varchar2)
142: is
143: workerNum number;
144: BatchID_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_BATCH_ID_TAB;
145: BatchStatus_Array FND_ONECHAR_TAB;
146: LDT_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_LDT_TAB;
147: LDT_RowID_Array FND_ROW_TAB;
148: BatchReqID_Array FND_NUMBER_TAB;

Line 146: LDT_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_LDT_TAB;

142: is
143: workerNum number;
144: BatchID_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_BATCH_ID_TAB;
145: BatchStatus_Array FND_ONECHAR_TAB;
146: LDT_Array FND_LOADER_OPEN_INTERFACE_PKG.FND_LDT_TAB;
147: LDT_RowID_Array FND_ROW_TAB;
148: BatchReqID_Array FND_NUMBER_TAB;
149: LDT2Batch_Map FND_NUMBER_TAB;
150: BatchError_Array FND_ERROR_TEXT_TAB;

Line 190: BatchID_Array(i-1) := FND_LOADER_OPEN_INTERFACE_PKG.INSERT_BATCH;

186: if (LDT_Array.COUNT > 0) then
187: -- Get n batch_id's from FNDBLOAD
188: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Opening ' || workerNum || ' batches.');
189: for i in 1..workerNum loop
190: BatchID_Array(i-1) := FND_LOADER_OPEN_INTERFACE_PKG.INSERT_BATCH;
191: end loop;
192:
193: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Assigning files to batches.');
194:

Line 197: FND_LOADER_OPEN_INTERFACE_PKG.ADD_ROW_TO_BATCH(

193: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Assigning files to batches.');
194:
195: for i in 1..LDT_Array.COUNT loop
196: -- Add row to batch with batch id = id_kount
197: FND_LOADER_OPEN_INTERFACE_PKG.ADD_ROW_TO_BATCH(
198: X_BATCH_ID => BatchID_Array(mod(i, workerNum)),
199: X_LCT => '@FND:patch/115/import/wfirep.lct',
200: X_LDT => LDT_Array(i),
201: X_LOADER_MODE => 'UPLOAD',