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_CATEGORY_ITEMS

Line 44: -- ICX_CAT_EXT_ITEMS_TLP, ICX_CAT_CATEGORY_ITEMS

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;
48: gISupplierPartNums DBMS_SQL.VARCHAR2_TABLE;

Line 56: -- Global PL/SQL tables for template headers of ICX_CAT_CATEGORY_ITEMS

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
57: gCIRtItemIds DBMS_SQL.NUMBER_TABLE;
58: gCITemplateIds DBMS_SQL.VARCHAR2_TABLE;
59:
60: -- Global PL/SQL tables for ICX_CAT_ITEM_PRICES

Line 355: FROM icx_cat_category_items ci

351: xRtCategoryId NUMBER;
352: BEGIN
353: SELECT ci.rt_category_id
354: INTO xRtCategoryId
355: FROM icx_cat_category_items ci
356: WHERE ci.rt_item_id = pRtItemId
357: AND EXISTS (SELECT 'primary category'
358: FROM icx_cat_categories_tl cat
359: WHERE cat.rt_category_id = ci.rt_category_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 1235: 'Primary category into ICX_CAT_CATEGORY_ITEMS');

1231: END IF;
1232:
1233: xErrLoc := 300;
1234: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1235: 'Primary category into ICX_CAT_CATEGORY_ITEMS');
1236:
1237: FORALL i IN 1..gIRtItemIds.COUNT
1238: INSERT INTO ICX_CAT_CATEGORY_ITEMS
1239: (rt_item_id, rt_category_id,

Line 1238: INSERT INTO ICX_CAT_CATEGORY_ITEMS

1234: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1235: 'Primary category into ICX_CAT_CATEGORY_ITEMS');
1236:
1237: FORALL i IN 1..gIRtItemIds.COUNT
1238: INSERT INTO ICX_CAT_CATEGORY_ITEMS
1239: (rt_item_id, rt_category_id,
1240: last_update_login, last_updated_by, last_update_date,
1241: created_by, creation_date, request_id,
1242: program_application_id, program_id, program_update_date)

Line 1333: -- Create template headers into ICX_CAT_CATEGORY_ITEMS

1329: ICX_POR_EXT_UTL.pushError(snapShot(SQL%ROWCOUNT+1, xMode));
1330: raise ICX_POR_EXT_UTL.gException;
1331: END updateItemsTLP;
1332:
1333: -- Create template headers into ICX_CAT_CATEGORY_ITEMS
1334: PROCEDURE createTempCategoryItems IS
1335: xErrLoc PLS_INTEGER;
1336: xReturnErr VARCHAR2(2000);
1337: xMode VARCHAR2(20) := 'CAT_ITEM';

Line 1345: 'Template headers into ICX_CAT_CATEGORY_ITEMS');

1341: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1342: 'createTempCategoryItems[Count: ' || gCIRtItemIds.COUNT || ']');
1343:
1344: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1345: 'Template headers into ICX_CAT_CATEGORY_ITEMS');
1346:
1347: xErrLoc := 100;
1348: IF (ICX_POR_EXT_UTL.gDebugLevel = ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
1349: FOR i in 1..gCIRtItemIds.COUNT LOOP

Line 1356: INSERT INTO ICX_CAT_CATEGORY_ITEMS

1352: END LOOP;
1353: END IF;
1354:
1355: FORALL i IN 1..gCIRtItemIds.COUNT
1356: INSERT INTO ICX_CAT_CATEGORY_ITEMS
1357: (rt_item_id, rt_category_id,
1358: last_update_login, last_updated_by, last_update_date,
1359: created_by, creation_date, request_id,
1360: program_application_id, program_id, program_update_date)

Line 1621: FROM icx_cat_category_items ci,

1617: AND EXISTS (SELECT 'category attributes'
1618: FROM icx_por_descriptors_tl des
1619: WHERE des.rt_category_id = cat.rt_category_id)
1620: AND EXISTS (SELECT 'items belong to this category'
1621: FROM icx_cat_category_items ci,
1622: icx_cat_items_b i
1623: WHERE cat.rt_category_id = ci.rt_category_id
1624: AND i.rt_item_id = ci.rt_item_id);
1625:

Line 1632: FROM icx_cat_category_items ci,

1628: SELECT i.rt_item_id rt_item_id,
1629: decode(i.object_version_number, 1,
1630: i.rt_item_id,
1631: i.object_version_number) old_rt_item_id
1632: FROM icx_cat_category_items ci,
1633: icx_cat_items_b i
1634: WHERE ci.rt_category_id = pRtCategoryId
1635: AND ci.rt_item_id = i.rt_item_id;
1636:

Line 2547: -- ICX_CAT_CATEGORY_ITEMS

2543: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2544: xIcxSchema || '.icx_cat_ext_items_tlp';
2545:
2546: xErrLoc := 400;
2547: -- ICX_CAT_CATEGORY_ITEMS
2548: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2549: xIcxSchema || '.icx_cat_category_items';
2550:
2551: xErrLoc := 500;

Line 2549: xIcxSchema || '.icx_cat_category_items';

2545:
2546: xErrLoc := 400;
2547: -- ICX_CAT_CATEGORY_ITEMS
2548: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||
2549: xIcxSchema || '.icx_cat_category_items';
2550:
2551: xErrLoc := 500;
2552: -- ICX_CAT_ITEM_PRICES
2553: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||