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_CAT_CATEGORIES_TL

Line 10: category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE,

6: --------------------------------------------------------------
7:
8: TYPE tClassification IS RECORD (
9: category_id NUMBER,
10: category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE,
11: language VARCHAR2(4),
12: source_lang VARCHAR2(4),
13: rt_category_id NUMBER,
14: old_category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE);

Line 14: old_category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE);

10: category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE,
11: language VARCHAR2(4),
12: source_lang VARCHAR2(4),
13: rt_category_id NUMBER,
14: old_category_name ICX_CAT_CATEGORIES_TL.CATEGORY_NAME%TYPE);
15:
16: TYPE tCursorType IS REF CURSOR;
17:
18: --------------------------------------------------------------

Line 21: gLastCategoryKey icx_cat_categories_TL.KEY%TYPE;

17:
18: --------------------------------------------------------------
19: -- Global Variables --
20: --------------------------------------------------------------
21: gLastCategoryKey icx_cat_categories_TL.KEY%TYPE;
22: gLastRtCategoryId NUMBER := -1;
23: gCompletedCount PLS_INTEGER := 0;
24:
25: --------------------------------------------------------------

Line 140: ICX_POR_EXT_UTL.debug('Insert icx_cat_categories_tl');

136: xErrLoc := 200;
137:
138: -- Add categories
139: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
140: ICX_POR_EXT_UTL.debug('Insert icx_cat_categories_tl');
141: END IF;
142:
143: FORALL i IN 1..gAddRtCategoryIds.COUNT
144: INSERT INTO icx_cat_categories_tl(

Line 144: INSERT INTO icx_cat_categories_tl(

140: ICX_POR_EXT_UTL.debug('Insert icx_cat_categories_tl');
141: END IF;
142:
143: FORALL i IN 1..gAddRtCategoryIds.COUNT
144: INSERT INTO icx_cat_categories_tl(
145: rt_category_id, category_name, key, title, type, language,
146: source_lang, upper_category_name, upper_key, section_map,
147: created_by, creation_date, last_updated_by, last_update_date,
148: last_update_login, request_id, program_application_id,

Line 172: INSERT INTO icx_cat_categories_tl(

168: 'installed languages');
169: END IF;
170: -- Replicate accross installed langs
171: FORALL i IN 1..gAddRtCategoryIds.COUNT
172: INSERT INTO icx_cat_categories_tl(
173: rt_category_id, category_name, key, title, type, language,
174: source_lang, upper_category_name, upper_key, section_map,
175: created_by, creation_date, last_updated_by, last_update_date,
176: last_update_login, request_id, program_application_id,

Line 207: -- Bug: 3291430 - Also populate rt_category_id with value from icx_cat_categories_tl

203: -- Workaround, as Bulktable cannot be referenced inside a not exists clause.
204:
205: FORALL i IN 1..gAddRtCategoryIds.COUNT
206: INSERT INTO icx_por_category_data_sources (
207: -- Bug: 3291430 - Also populate rt_category_id with value from icx_cat_categories_tl
208: rt_category_id,
209: category_key,
210: external_source, external_source_key,
211: created_by, creation_date, last_updated_by, last_update_date,

Line 220: FROM icx_cat_categories_tl

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
224: not exists (select 1

Line 335: ICX_POR_EXT_UTL.debug('Update ICX_CAT_CATEGORIES_TL');

331: END IF;
332:
333: xErrLoc := 400;
334: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.INFO_LEVEL THEN
335: ICX_POR_EXT_UTL.debug('Update ICX_CAT_CATEGORIES_TL');
336: END IF;
337:
338: FORALL i IN 1..gUpdateRtCategoryIds.COUNT
339: UPDATE icx_cat_categories_tl

Line 339: UPDATE icx_cat_categories_tl

335: ICX_POR_EXT_UTL.debug('Update ICX_CAT_CATEGORIES_TL');
336: END IF;
337:
338: FORALL i IN 1..gUpdateRtCategoryIds.COUNT
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,

Line 498: ' icx_cat_categories_tl icat, ' ||

494: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
495: xString := xString ||
496: 'from imtl_categories_kfv mck, ' ||
497: ' imtl_categories_tl mctl, ' ||
498: ' icx_cat_categories_tl icat, ' ||
499: ' icx_cat_categories_tl icat2 ';
500: IF xValidateFlag = 'Y' THEN
501: xString := xString ||
502: ', imtl_category_set_valid_cats mcsvc ';

Line 499: ' icx_cat_categories_tl icat2 ';

495: xString := xString ||
496: 'from imtl_categories_kfv mck, ' ||
497: ' imtl_categories_tl mctl, ' ||
498: ' icx_cat_categories_tl icat, ' ||
499: ' icx_cat_categories_tl icat2 ';
500: IF xValidateFlag = 'Y' THEN
501: xString := xString ||
502: ', imtl_category_set_valid_cats mcsvc ';
503: END IF;

Line 508: ' icx_cat_categories_tl icat, ' ||

504: ELSE
505: xString := xString ||
506: 'from mtl_categories_kfv mck, ' ||
507: ' mtl_categories_tl mctl, ' ||
508: ' icx_cat_categories_tl icat, ' ||
509: ' icx_cat_categories_tl icat2 ';
510: IF xValidateFlag = 'Y' THEN
511: xString := xString ||
512: ', mtl_category_set_valid_cats mcsvc ';

Line 509: ' icx_cat_categories_tl icat2 ';

505: xString := xString ||
506: 'from mtl_categories_kfv mck, ' ||
507: ' mtl_categories_tl mctl, ' ||
508: ' icx_cat_categories_tl icat, ' ||
509: ' icx_cat_categories_tl icat2 ';
510: IF xValidateFlag = 'Y' THEN
511: xString := xString ||
512: ', mtl_category_set_valid_cats mcsvc ';
513: END IF;

Line 587: ' icx_cat_categories_tl icat ';

583: xErrLoc := 430;
584: IF ICX_POR_EXT_TEST.gTestMode = 'Y' THEN
585: xString := xString ||
586: 'from ipo_reqexpress_headers_all templates, ' ||
587: ' icx_cat_categories_tl icat ';
588: ELSE
589: xString := xString ||
590: 'from po_reqexpress_headers_all templates, ' ||
591: ' icx_cat_categories_tl icat ';

Line 591: ' icx_cat_categories_tl icat ';

587: ' icx_cat_categories_tl icat ';
588: ELSE
589: xString := xString ||
590: 'from po_reqexpress_headers_all templates, ' ||
591: ' icx_cat_categories_tl icat ';
592: END IF;
593:
594: xErrLoc := 440;
595: xString := xString ||