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_CAT_FPI_UPGRADE dependencies on ICX_CAT_ITEMS_TLP

Line 31: -- Dynamic SQL to update ICX_CAT_ITEMS_TLP, ICX_CAT_EXT_ITEMS_TLP

27: -- Global Variables --
28: --------------------------------------------------------------
29: -- Current Item
30: gCurrentItem tItemRecord;
31: -- Dynamic SQL to update ICX_CAT_ITEMS_TLP, ICX_CAT_EXT_ITEMS_TLP
32: gDynSqlBaseAttributes VARCHAR2(4000);
33: gDynSqlCatAttributes VARCHAR2(4000);
34: gReturnErr VARCHAR2(4000) := NULL;
35: gLogLevel PLS_INTEGER := ICX_POR_EXT_UTL.DEBUG_LEVEL;

Line 43: -- Global PL/SQL tables for ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP,

39:
40: --------------------------------------------------------------
41: -- Global PL/SQL Tables --
42: --------------------------------------------------------------
43: -- Global PL/SQL tables for ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP,
44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
45: gIRtItemIds DBMS_SQL.NUMBER_TABLE;
46: gIOldRtItemIds DBMS_SQL.NUMBER_TABLE;
47: gIOrgIds DBMS_SQL.NUMBER_TABLE;

Line 52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,

48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;
49: gIRtCategoryIds DBMS_SQL.NUMBER_TABLE;
50: gIExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
51:
52: -- Global PL/SQL tables for description of ICX_CAT_ITEMS_TLP,
53: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
54: gITItemDescriptions DBMS_SQL.VARCHAR2_TABLE;
55:
56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS

Line 478: 'UPDATE ICX_CAT_ITEMS_TLP tlp ' ||

474: IF (pRtCategoryId = 0) THEN
475: IF (xUpdateColumns IS NOT NULL) THEN
476: xErrLoc := 350;
477: gDynSqlBaseAttributes :=
478: 'UPDATE ICX_CAT_ITEMS_TLP tlp ' ||
479: 'SET (' || xUpdateColumns || ') = ' ||
480: '(SELECT ' || xSelectColumns ||
481: ' FROM ICX_POR_ITEMS i, ICX_POR_ITEMS_TL tl ' ||
482: ' WHERE i.rt_item_id = :old_rt_item_id ' ||

Line 1118: -- Move data into ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS

1114: ICX_POR_EXT_UTL.pushError(xReturnErr);
1115: raise ICX_POR_EXT_UTL.gException;
1116: END processItems;
1117:
1118: -- Move data into ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS
1119: PROCEDURE moveItems IS
1120: xErrLoc PLS_INTEGER;
1121: xReturnErr VARCHAR2(2000);
1122:

Line 1167: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_TLP');

1163:
1164: COMMIT;
1165:
1166: xErrLoc := 150;
1167: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_TLP');
1168:
1169: FORALL i IN 1..gIRtItemIds.COUNT
1170: INSERT INTO ICX_CAT_ITEMS_TLP
1171: (rt_item_id, language, org_id,

Line 1170: INSERT INTO ICX_CAT_ITEMS_TLP

1166: xErrLoc := 150;
1167: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL, 'ICX_CAT_ITEMS_TLP');
1168:
1169: FORALL i IN 1..gIRtItemIds.COUNT
1170: INSERT INTO ICX_CAT_ITEMS_TLP
1171: (rt_item_id, language, org_id,
1172: supplier_id, item_source_type, search_type,
1173: primary_category_id, primary_category_name,
1174: internal_item_id, internal_item_num,

Line 1213: 'Dynamic SQL to update base attributes of ICX_CAT_ITEMS_TLP');

1209: COMMIT;
1210:
1211: xErrLoc := 200;
1212: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1213: 'Dynamic SQL to update base attributes of ICX_CAT_ITEMS_TLP');
1214:
1215: IF (gDynSqlBaseAttributes IS NOT NULL) THEN
1216: xErrLoc := 210;
1217: xCursorId := DBMS_SQL.open_cursor;

Line 1286: -- Update item_description of ICX_CAT_ITEMS_TLP

1282: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1283: raise ICX_POR_EXT_UTL.gException;
1284: END moveItems;
1285:
1286: -- Update item_description of ICX_CAT_ITEMS_TLP
1287: PROCEDURE updateItemsTLP IS
1288: xErrLoc PLS_INTEGER;
1289: xReturnErr VARCHAR2(2000);
1290: xMode VARCHAR2(20) := 'TLP';

Line 1306: 'Update item_description of ICX_CAT_ITEMS_TLP');

1302: END IF;
1303:
1304: xErrLoc := 100;
1305: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1306: 'Update item_description of ICX_CAT_ITEMS_TLP');
1307:
1308: FORALL i IN 1..gITRtItemIds.COUNT
1309: UPDATE ICX_CAT_ITEMS_TLP
1310: SET description = gITItemDescriptions(i)

Line 1309: UPDATE ICX_CAT_ITEMS_TLP

1305: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1306: 'Update item_description of ICX_CAT_ITEMS_TLP');
1307:
1308: FORALL i IN 1..gITRtItemIds.COUNT
1309: UPDATE ICX_CAT_ITEMS_TLP
1310: SET description = gITItemDescriptions(i)
1311: WHERE rt_item_id = gITRtItemIds(i)
1312: AND language = (SELECT language_code
1313: FROM fnd_languages

Line 2537: -- ICX_CAT_ITEMS_TLP

2533: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2534: xIcxSchema || '.icx_cat_items_b';
2535:
2536: xErrLoc := 200;
2537: -- ICX_CAT_ITEMS_TLP
2538: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2539: xIcxSchema || '.icx_cat_items_tlp';
2540:
2541: xErrLoc := 300;

Line 2539: xIcxSchema || '.icx_cat_items_tlp';

2535:
2536: xErrLoc := 200;
2537: -- ICX_CAT_ITEMS_TLP
2538: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2539: xIcxSchema || '.icx_cat_items_tlp';
2540:
2541: xErrLoc := 300;
2542: -- ICX_CAT_EXT_ITEMS_TLP
2543: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||