eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_EXT_CLASS dependencies on ICX_POR_EXTRACTOR

Line 155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

151: gAddCategoryKeys(i), 'Oracle', pType,
152: gAddLanguages(i), gAddSourceLangs(i),
153: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
154: rpad('0', 300, 0),
155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
158: ICX_POR_EXTRACTOR.gProgramApplicationId,
159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

Line 156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

152: gAddLanguages(i), gAddSourceLangs(i),
153: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
154: rpad('0', 300, 0),
155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
158: ICX_POR_EXTRACTOR.gProgramApplicationId,
159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
160:

Line 157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,

153: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
154: rpad('0', 300, 0),
155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
158: ICX_POR_EXTRACTOR.gProgramApplicationId,
159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
160:
161: -- Duplicate template headers accross all installed languages

Line 158: ICX_POR_EXTRACTOR.gProgramApplicationId,

154: rpad('0', 300, 0),
155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
158: ICX_POR_EXTRACTOR.gProgramApplicationId,
159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
160:
161: -- Duplicate template headers accross all installed languages
162: -- For categories, we don't replicate, just take it as is

Line 159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);

155: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
156: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
157: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
158: ICX_POR_EXTRACTOR.gProgramApplicationId,
159: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
160:
161: -- Duplicate template headers accross all installed languages
162: -- For categories, we don't replicate, just take it as is
163: IF (pType = TEMPLATE_HEADER_TYPE) THEN

Line 183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

179: gAddCategoryKeys(i), 'Oracle', TEMPLATE_HEADER_TYPE,
180: language_code, gAddLanguages(i),
181: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
182: rpad('0', 300, 0),
183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
186: ICX_POR_EXTRACTOR.gProgramApplicationId,
187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE

Line 184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

180: language_code, gAddLanguages(i),
181: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
182: rpad('0', 300, 0),
183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
186: ICX_POR_EXTRACTOR.gProgramApplicationId,
187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
188: FROM fnd_languages

Line 185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,

181: upper(gAddCategoryNames(i)), upper(gAddCategoryKeys(i)),
182: rpad('0', 300, 0),
183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
186: ICX_POR_EXTRACTOR.gProgramApplicationId,
187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
188: FROM fnd_languages
189: WHERE installed_flag = 'I';

Line 186: ICX_POR_EXTRACTOR.gProgramApplicationId,

182: rpad('0', 300, 0),
183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
186: ICX_POR_EXTRACTOR.gProgramApplicationId,
187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
188: FROM fnd_languages
189: WHERE installed_flag = 'I';
190:

Line 187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE

183: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
184: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
185: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
186: ICX_POR_EXTRACTOR.gProgramApplicationId,
187: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
188: FROM fnd_languages
189: WHERE installed_flag = 'I';
190:
191: END IF;

Line 215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

211: created_by, creation_date, last_updated_by, last_update_date,
212: last_update_login, request_id, program_application_id,
213: program_id, program_update_date)
214: SELECT rt_category_id, key,'Oracle', key,
215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
218: ICX_POR_EXTRACTOR.gProgramApplicationId,
219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE

Line 216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

212: last_update_login, request_id, program_application_id,
213: program_id, program_update_date)
214: SELECT rt_category_id, key,'Oracle', key,
215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
218: ICX_POR_EXTRACTOR.gProgramApplicationId,
219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
220: FROM icx_cat_categories_tl

Line 217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,

213: program_id, program_update_date)
214: SELECT rt_category_id, key,'Oracle', key,
215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
218: ICX_POR_EXTRACTOR.gProgramApplicationId,
219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
220: FROM icx_cat_categories_tl
221: WHERE

Line 218: ICX_POR_EXTRACTOR.gProgramApplicationId,

214: SELECT rt_category_id, key,'Oracle', key,
215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
218: ICX_POR_EXTRACTOR.gProgramApplicationId,
219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
220: FROM icx_cat_categories_tl
221: WHERE
222: rt_category_id = gAddRtCategoryIds(i) and

Line 219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE

215: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
216: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
217: ICX_POR_EXTRACTOR.gLoginId, ICX_POR_EXTRACTOR.gRequestId,
218: ICX_POR_EXTRACTOR.gProgramApplicationId,
219: ICX_POR_EXTRACTOR.gProgramId, SYSDATE
220: FROM icx_cat_categories_tl
221: WHERE
222: rt_category_id = gAddRtCategoryIds(i) and
223: language = gAddLanguages(i) and

Line 242: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

238: rt_category_id, external_source, external_source_key,
239: created_by, creation_date, last_updated_by,
240: last_update_date, last_update_login)
241: VALUES(gAddNewRtCategoryIds(i), 'Oracle', gAddNewCategoryKeys(i),
242: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
243: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
244: ICX_POR_EXTRACTOR.gLoginId);
245: END IF;
246:

Line 243: ICX_POR_EXTRACTOR.gUserId, SYSDATE,

239: created_by, creation_date, last_updated_by,
240: last_update_date, last_update_login)
241: VALUES(gAddNewRtCategoryIds(i), 'Oracle', gAddNewCategoryKeys(i),
242: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
243: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
244: ICX_POR_EXTRACTOR.gLoginId);
245: END IF;
246:
247: xErrLoc := 600;

Line 244: ICX_POR_EXTRACTOR.gLoginId);

240: last_update_date, last_update_login)
241: VALUES(gAddNewRtCategoryIds(i), 'Oracle', gAddNewCategoryKeys(i),
242: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
243: ICX_POR_EXTRACTOR.gUserId, SYSDATE,
244: ICX_POR_EXTRACTOR.gLoginId);
245: END IF;
246:
247: xErrLoc := 600;
248: ICX_POR_EXT_UTL.extAFCommit;

Line 314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

310: xErrLoc := 240;
311: FORALL j IN 1..xRowIds.COUNT
312: UPDATE icx_cat_items_tlp
313: SET primary_category_name = gUpdateCategoryNames(i),
314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
317: request_id = ICX_POR_EXTRACTOR.gRequestId,
318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

312: UPDATE icx_cat_items_tlp
313: SET primary_category_name = gUpdateCategoryNames(i),
314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
317: request_id = ICX_POR_EXTRACTOR.gRequestId,
318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
319: program_id = ICX_POR_EXTRACTOR.gProgramId,
320: program_update_date = SYSDATE

Line 317: request_id = ICX_POR_EXTRACTOR.gRequestId,

313: SET primary_category_name = gUpdateCategoryNames(i),
314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
317: request_id = ICX_POR_EXTRACTOR.gRequestId,
318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
319: program_id = ICX_POR_EXTRACTOR.gProgramId,
320: program_update_date = SYSDATE
321: WHERE rowid = xRowIds(j);

Line 318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

314: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
317: request_id = ICX_POR_EXTRACTOR.gRequestId,
318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
319: program_id = ICX_POR_EXTRACTOR.gProgramId,
320: program_update_date = SYSDATE
321: WHERE rowid = xRowIds(j);
322:

Line 319: program_id = ICX_POR_EXTRACTOR.gProgramId,

315: last_update_date = SYSDATE,
316: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
317: request_id = ICX_POR_EXTRACTOR.gRequestId,
318: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
319: program_id = ICX_POR_EXTRACTOR.gProgramId,
320: program_update_date = SYSDATE
321: WHERE rowid = xRowIds(j);
322:
323: ICX_POR_EXT_UTL.extAFCommit;

Line 343: last_updated_by = ICX_POR_EXTRACTOR.gUserId,

339: UPDATE icx_cat_categories_tl
340: SET category_name = gUpdateCategoryNames(i),
341: upper_category_name = upper(gUpdateCategoryNames(i)),
342: source_lang = gUpdateSourceLangs(i),
343: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
344: last_update_date = SYSDATE,
345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
346: request_id = ICX_POR_EXTRACTOR.gRequestId,
347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

Line 345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

341: upper_category_name = upper(gUpdateCategoryNames(i)),
342: source_lang = gUpdateSourceLangs(i),
343: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
344: last_update_date = SYSDATE,
345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
346: request_id = ICX_POR_EXTRACTOR.gRequestId,
347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
348: program_id = ICX_POR_EXTRACTOR.gProgramId,
349: program_update_date = SYSDATE

Line 346: request_id = ICX_POR_EXTRACTOR.gRequestId,

342: source_lang = gUpdateSourceLangs(i),
343: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
344: last_update_date = SYSDATE,
345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
346: request_id = ICX_POR_EXTRACTOR.gRequestId,
347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
348: program_id = ICX_POR_EXTRACTOR.gProgramId,
349: program_update_date = SYSDATE
350: WHERE rt_category_id = gUpdateRtCategoryIds(i)

Line 347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,

343: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
344: last_update_date = SYSDATE,
345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
346: request_id = ICX_POR_EXTRACTOR.gRequestId,
347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
348: program_id = ICX_POR_EXTRACTOR.gProgramId,
349: program_update_date = SYSDATE
350: WHERE rt_category_id = gUpdateRtCategoryIds(i)
351: AND language = gUpdateLanguages(i);

Line 348: program_id = ICX_POR_EXTRACTOR.gProgramId,

344: last_update_date = SYSDATE,
345: last_update_login = ICX_POR_EXTRACTOR.gLoginId,
346: request_id = ICX_POR_EXTRACTOR.gRequestId,
347: program_application_id = ICX_POR_EXTRACTOR.gProgramApplicationId,
348: program_id = ICX_POR_EXTRACTOR.gProgramId,
349: program_update_date = SYSDATE
350: WHERE rt_category_id = gUpdateRtCategoryIds(i)
351: AND language = gUpdateLanguages(i);
352:

Line 390: ICX_POR_EXTRACTOR.gInstalledLanguageCount+2 OR

386: (ICX_POR_EXT_UTL.gCommitSize < 3 OR
387: gAddRtCategoryIds.COUNT >= ICX_POR_EXT_UTL.gCommitSize/3)) OR
388: (pType = TEMPLATE_HEADER_TYPE AND
389: (ICX_POR_EXT_UTL.gCommitSize <
390: ICX_POR_EXTRACTOR.gInstalledLanguageCount+2 OR
391: gAddRtCategoryIds.COUNT >=
392: ICX_POR_EXT_UTL.gCommitSize/
393: (ICX_POR_EXTRACTOR.gInstalledLanguageCount+2))))
394: THEN

Line 393: (ICX_POR_EXTRACTOR.gInstalledLanguageCount+2))))

389: (ICX_POR_EXT_UTL.gCommitSize <
390: ICX_POR_EXTRACTOR.gInstalledLanguageCount+2 OR
391: gAddRtCategoryIds.COUNT >=
392: ICX_POR_EXT_UTL.gCommitSize/
393: (ICX_POR_EXTRACTOR.gInstalledLanguageCount+2))))
394: THEN
395: xErrLoc := 200;
396: IF (pType = CATEGORY_TYPE) THEN
397: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,

Line 482: xLastRunDate := ICX_POR_EXTRACTOR.gLoaderValue.categories_last_run_date;

478: ', validate_flag: ' || xValidateFlag ||
479: ', structure_id: ' || xStructureId || ']');
480:
481: xErrLoc := 210;
482: xLastRunDate := ICX_POR_EXTRACTOR.gLoaderValue.categories_last_run_date;
483:
484: xErrLoc := 220;
485: xString :=
486: 'select distinct mck.category_id category_id, ' ||

Line 564: if (ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item = 'Y' and

560: OPEN pCursor FOR xString USING xStructureId, xLastRunDate;
561: END IF;
562: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
563: xErrLoc := 400;
564: if (ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item = 'Y' and
565: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date >
566: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date) then
567: xLastRunDate :=
568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;

Line 565: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date >

561: END IF;
562: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
563: xErrLoc := 400;
564: if (ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item = 'Y' and
565: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date >
566: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date) then
567: xLastRunDate :=
568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;
569: else

Line 566: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date) then

562: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
563: xErrLoc := 400;
564: if (ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item = 'Y' and
565: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date >
566: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date) then
567: xLastRunDate :=
568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;
569: else
570: xLastRunDate :=

Line 568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;

564: if (ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item = 'Y' and
565: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date >
566: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date) then
567: xLastRunDate :=
568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;
569: else
570: xLastRunDate :=
571: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date;
572: end if;

Line 571: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date;

567: xLastRunDate :=
568: ICX_POR_EXTRACTOR.gLoaderValue.internal_item_last_run_date;
569: else
570: xLastRunDate :=
571: ICX_POR_EXTRACTOR.gLoaderValue.template_headers_last_run_date;
572: end if;
573:
574: xErrLoc := 420;
575: xString :=

Line 630: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item,

626: END IF;
627:
628: xErrLoc := 500;
629: OPEN pCursor FOR xString USING xLastRunDate,
630: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item,
631: ICX_POR_EXTRACTOR.gBaseLang;
632: END IF;
633:
634: xErrLoc := 600;

Line 631: ICX_POR_EXTRACTOR.gBaseLang;

627:
628: xErrLoc := 500;
629: OPEN pCursor FOR xString USING xLastRunDate,
630: ICX_POR_EXTRACTOR.gLoaderValue.load_internal_item,
631: ICX_POR_EXTRACTOR.gBaseLang;
632: END IF;
633:
634: xErrLoc := 600;
635: EXCEPTION

Line 774: gAddLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;

770: IF (pType = CATEGORY_TYPE) THEN
771: gAddLanguages(xPendingCount) := xLanguages(i);
772: gAddSourceLangs(xPendingCount) := xSourceLangs(i);
773: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
774: gAddLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
775: gAddSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
776: END IF;
777:
778: ELSE

Line 775: gAddSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;

771: gAddLanguages(xPendingCount) := xLanguages(i);
772: gAddSourceLangs(xPendingCount) := xSourceLangs(i);
773: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
774: gAddLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
775: gAddSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
776: END IF;
777:
778: ELSE
779: IF (xOldCategoryNames(i) IS NULL) THEN

Line 801: gUpdateLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;

797: IF (pType = CATEGORY_TYPE) THEN
798: gUpdateLanguages(xPendingCount) := xLanguages(i);
799: gUpdateSourceLangs(xPendingCount) := xSourceLangs(i);
800: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
801: gUpdateLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
802: gUpdateSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
803: END IF;
804: ELSE
805: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN

Line 802: gUpdateSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;

798: gUpdateLanguages(xPendingCount) := xLanguages(i);
799: gUpdateSourceLangs(xPendingCount) := xSourceLangs(i);
800: ELSIF (pType = TEMPLATE_HEADER_TYPE) THEN
801: gUpdateLanguages(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
802: gUpdateSourceLangs(xPendingCount) := ICX_POR_EXTRACTOR.gBaseLang;
803: END IF;
804: ELSE
805: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
806: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 857: IF (ICX_POR_EXTRACTOR.gLoaderValue.load_categories = 'Y') THEN

853: cClass tCursorType;
854:
855: BEGIN
856: xErrLoc := 100;
857: IF (ICX_POR_EXTRACTOR.gLoaderValue.load_categories = 'Y') THEN
858:
859: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
860: 'Extract oracle categories');
861:

Line 878: IF (ICX_POR_EXTRACTOR.gLoaderValue.load_template_headers = 'Y') THEN

874:
875: xErrLoc := 200;
876: gCompletedCount := 0;
877:
878: IF (ICX_POR_EXTRACTOR.gLoaderValue.load_template_headers = 'Y') THEN
879:
880: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
881: 'Extract template headers');
882:

Line 893: ICX_POR_EXTRACTOR.setLastRunDates('TEMPLATE_HEADER');

889: xErrLoc := 260;
890: CLOSE cClass;
891:
892: xErrLoc := 280;
893: ICX_POR_EXTRACTOR.setLastRunDates('TEMPLATE_HEADER');
894: END IF; -- load_template_headers
895:
896: xErrLoc := 300;
897: