APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_CAT_EXT_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 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 494: 'UPDATE ICX_CAT_EXT_ITEMS_TLP tlp ' ||

490: ELSE
491: IF (xUpdateColumns IS NOT NULL) THEN
492: xErrLoc := 370;
493: gDynSqlCatAttributes :=
494: 'UPDATE ICX_CAT_EXT_ITEMS_TLP tlp ' ||
495: 'SET (' || xUpdateColumns || ') = ' ||
496: '(SELECT ' || xSelectColumns ||
497: ' FROM ICX_POR_C' || pRtCategoryId || '_TL c' ||
498: ' WHERE c.rt_item_id = :old_rt_item_id ' ||

Line 1252: 'ICX_CAT_EXT_ITEMS_TLP');

1248: COMMIT;
1249:
1250: xErrLoc := 400;
1251: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1252: 'ICX_CAT_EXT_ITEMS_TLP');
1253:
1254: FORALL i IN 1..gIRtItemIds.COUNT
1255: INSERT INTO ICX_CAT_EXT_ITEMS_TLP
1256: (rt_item_id, language, org_id,

Line 1255: INSERT INTO ICX_CAT_EXT_ITEMS_TLP

1251: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1252: 'ICX_CAT_EXT_ITEMS_TLP');
1253:
1254: FORALL i IN 1..gIRtItemIds.COUNT
1255: INSERT INTO ICX_CAT_EXT_ITEMS_TLP
1256: (rt_item_id, language, org_id,
1257: rt_category_id, primary_flag,
1258: last_update_login, last_updated_by, last_update_date,
1259: created_by, creation_date, request_id,

Line 1606: -- Update category attributes of ICX_CAT_EXT_ITEMS_TLP

1602: ICX_POR_EXT_UTL.pushError(xReturnErr);
1603: raise ICX_POR_EXT_UTL.gException;
1604: END moveData;
1605:
1606: -- Update category attributes of ICX_CAT_EXT_ITEMS_TLP
1607: -- Note: We use icx_cat_items_b.object_version_number to
1608: -- store old_rt_item_id during the upgrade process
1609: PROCEDURE updateExtItemsTLP IS
1610: CURSOR cAllCategories IS

Line 1650: 'Update category attributes of ICX_CAT_EXT_ITEMS_TLP');

1646:
1647: BEGIN
1648: xErrLoc := 50;
1649: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.MUST_LEVEL,
1650: 'Update category attributes of ICX_CAT_EXT_ITEMS_TLP');
1651:
1652: FOR all_category IN cAllCategories LOOP
1653: xErrLoc := 100;
1654: -- Fetch category attributes

Line 1681: -- Dynamic SQL to update category attributes of ICX_CAT_EXT_ITEMS_TLP

1677: 'xOldRtItemIds('||i||'): '||xOldRtItemIds(i));
1678: END LOOP;
1679: END IF;
1680:
1681: -- Dynamic SQL to update category attributes of ICX_CAT_EXT_ITEMS_TLP
1682:
1683: xErrLoc := 220;
1684: xCursorId := DBMS_SQL.open_cursor;
1685: xErrLoc := 230;

Line 2542: -- ICX_CAT_EXT_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 ' ||
2544: xIcxSchema || '.icx_cat_ext_items_tlp';
2545:
2546: xErrLoc := 400;

Line 2544: xIcxSchema || '.icx_cat_ext_items_tlp';

2540:
2541: xErrLoc := 300;
2542: -- ICX_CAT_EXT_ITEMS_TLP
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 ' ||