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_ITEM dependencies on ICX_CAT_EXT_ITEMS_TLP

Line 296: -- Insert ICX_CAT_EXT_ITEMS_TLP

292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:
296: -- Insert ICX_CAT_EXT_ITEMS_TLP
297: gIERtItemIds DBMS_SQL.NUMBER_TABLE;
298: -- bug 2925403
299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;

Line 303: -- Update ICX_CAT_EXT_ITEMS_TLP

299: gIELanguages DBMS_SQL.VARCHAR2_TABLE;
300: gIEOrgIds DBMS_SQL.NUMBER_TABLE;
301: gIERtCategoryIds DBMS_SQL.NUMBER_TABLE;
302:
303: -- Update ICX_CAT_EXT_ITEMS_TLP
304: gUERtItemIds DBMS_SQL.NUMBER_TABLE;
305: -- bug 2925403
306: gUELanguages DBMS_SQL.VARCHAR2_TABLE;
307: gUERtCategoryIds DBMS_SQL.NUMBER_TABLE;

Line 587: -- Insert ICX_CAT_EXT_ITEMS_TLP

583: gUCOldRtCategoryIds.DELETE;
584: END IF;
585:
586: IF (pMode IN ('ALL', 'INSERT_EXT_ITEMS')) THEN
587: -- Insert ICX_CAT_EXT_ITEMS_TLP
588: gIERtItemIds.DELETE;
589: gIELanguages.DELETE;
590: gIEOrgIds.DELETE;
591: gIERtCategoryIds.DELETE;

Line 595: -- Update ICX_CAT_EXT_ITEMS_TLP

591: gIERtCategoryIds.DELETE;
592: END IF;
593:
594: IF (pMode IN ('ALL', 'UPDATE_EXT_ITEMS')) THEN
595: -- Update ICX_CAT_EXT_ITEMS_TLP
596: gUERtItemIds.DELETE;
597: gUELanguages.DELETE;
598: gUERtCategoryIds.DELETE;
599: gUEOldRtCategoryIds.DELETE;

Line 1021: -- Insert ICX_CAT_EXT_ITEMS_TLP

1017: ICX_POR_EXT_UTL.getTableElement(gUCRtCategoryIds, pIndex) || ', ';
1018: xShot := xShot || ' gUCOldRtCategoryIds: ' ||
1019: ICX_POR_EXT_UTL.getTableElement(gUCOldRtCategoryIds, pIndex);
1020: ELSIF (pMode = 'INSERT_EXT_ITEMS') THEN
1021: -- Insert ICX_CAT_EXT_ITEMS_TLP
1022: xShot := xShot || ' gIERtItemIds: ' ||
1023: ICX_POR_EXT_UTL.getTableElement(gIERtItemIds, pIndex) || ', ';
1024: xShot := xShot || ' gIEOrgIds: ' ||
1025: ICX_POR_EXT_UTL.getTableElement(gIEOrgIds, pIndex) || ', ';

Line 1029: -- Update ICX_CAT_EXT_ITEMS_TLP

1025: ICX_POR_EXT_UTL.getTableElement(gIEOrgIds, pIndex) || ', ';
1026: xShot := xShot || ' gIERtCategoryIds: ' ||
1027: ICX_POR_EXT_UTL.getTableElement(gIERtCategoryIds, pIndex);
1028: ELSIF (pMode = 'UPDATE_EXT_ITEMS') THEN
1029: -- Update ICX_CAT_EXT_ITEMS_TLP
1030: xShot := xShot || ' gUERtItemIds: ' ||
1031: ICX_POR_EXT_UTL.getTableElement(gUERtItemIds, pIndex) || ', ';
1032: xShot := xShot || ' gUERtCategoryIds: ' ||
1033: ICX_POR_EXT_UTL.getTableElement(gUERtCategoryIds, pIndex) || ', ';

Line 2488: -- Insert ICX_CAT_EXT_ITEMS_TLP

2484: clearTables(xActionMode);
2485:
2486: xErrLoc := 340;
2487: xActionMode := 'INSERT_EXT_ITEMS';
2488: -- Insert ICX_CAT_EXT_ITEMS_TLP
2489: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2490: FOR i in 1..gIERtItemIds.COUNT LOOP
2491: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2492: snapShot(i, xActionMode));

Line 2496: INSERT INTO icx_cat_ext_items_tlp

2492: snapShot(i, xActionMode));
2493: END LOOP;
2494: END IF;
2495: FORALL i IN 1..gIERtItemIds.COUNT
2496: INSERT INTO icx_cat_ext_items_tlp
2497: (rt_item_id, language, org_id,
2498: rt_category_id, primary_flag,
2499: last_update_login, last_updated_by, last_update_date,
2500: created_by, creation_date, request_id,

Line 2520: -- Update ICX_CAT_EXT_ITEMS_TLP

2516: clearTables(xActionMode);
2517:
2518: xErrLoc := 360;
2519: xActionMode := 'UPDATE_EXT_ITEMS';
2520: -- Update ICX_CAT_EXT_ITEMS_TLP
2521: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2522: FOR i in 1..gUERtItemIds.COUNT LOOP
2523: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2524: snapShot(i, xActionMode));

Line 2528: UPDATE icx_cat_ext_items_tlp

2524: snapShot(i, xActionMode));
2525: END LOOP;
2526: END IF;
2527: FORALL i IN 1..gUERtItemIds.COUNT
2528: UPDATE icx_cat_ext_items_tlp
2529: SET rt_category_id = gUERtCategoryIds(i),
2530: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2531: last_update_date = SYSDATE,
2532: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

Line 4205: 'icx_cat_ext_items_tlp t ' ||

4201: -- only translated items are extracted. pseudo translated items
4202: -- are not extracted. e.g. Item created in english, but rows get added to
4203: -- other installed langs. extract the item only in english
4204: xString := xString ||
4205: 'icx_cat_ext_items_tlp t ' ||
4206: 'WHERE m.inventory_item_id = :internal_item_id ' ||
4207: 'AND m.organization_id = :inventory_organization_id ' ||
4208: 'AND m.language = m.source_lang ' ||
4209: 'AND m.language IN (SELECT language_code ' ||

Line 4265: 'FROM fnd_languages f, icx_cat_ext_items_tlp i ' ||

4261: -- One-time items
4262: -- Bug # 3991340
4263: xString :=
4264: 'SELECT f.language_code, i.rt_item_id ' ||
4265: 'FROM fnd_languages f, icx_cat_ext_items_tlp i ' ||
4266: 'WHERE ' ||
4267: 'f.language_code = i.language(+) AND ' ||
4268: 'i.rt_item_id(+) = :rt_item_id AND ' ||
4269: 'f.installed_flag IN (''B''';

Line 4344: -- ICX_CAT_EXT_ITEMS_TLP

4340: gICRtItemIds(xIndex) := gCurrentPrice.rt_item_id;
4341: gICRtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4342:
4343: /* bug 2925403
4344: -- ICX_CAT_EXT_ITEMS_TLP
4345: xErrLoc := 300;
4346: gTransactionCount := gTransactionCount +
4347: ICX_POR_EXTRACTOR.gInstalledLanguageCount;
4348: xIndex := gIERtItemIds.COUNT + 1;

Line 4373: -- ICX_CAT_EXT_ITEMS_TLP

4369: gUCRtCategoryIds(xIndex) := gCurrentPrice.primary_category_id;
4370: gUCOldRtCategoryIds(xIndex) := gCurrentPrice.match_primary_category_id;
4371:
4372: /* bug 2925403
4373: -- ICX_CAT_EXT_ITEMS_TLP
4374: xErrLoc := 300;
4375: gTransactionCount := gTransactionCount +
4376: ICX_POR_EXTRACTOR.gInstalledLanguageCount;
4377: xIndex := gUERtItemIds.COUNT + 1;