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_ITEMS_TLP

Line 42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,

38: supplier_part_num icx_cat_items_b.supplier_part_num%TYPE,
39: internal_item_id NUMBER,
40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,
41: inventory_organization_id NUMBER,
42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,
43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,

Line 43: item_search_type icx_cat_items_tlp.search_type%TYPE,

39: internal_item_id NUMBER,
40: internal_item_num icx_cat_items_b.internal_item_num%TYPE,
41: inventory_organization_id NUMBER,
42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,
43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,
47: picture icx_cat_items_tlp.picture%TYPE,

Line 46: description icx_cat_items_tlp.description%TYPE,

42: item_source_type icx_cat_items_tlp.item_source_type%TYPE,
43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,
47: picture icx_cat_items_tlp.picture%TYPE,
48: picture_url icx_cat_items_tlp.picture_url%TYPE,
49: price_type icx_cat_item_prices.price_type%TYPE,
50: asl_id NUMBER,

Line 47: picture icx_cat_items_tlp.picture%TYPE,

43: item_search_type icx_cat_items_tlp.search_type%TYPE,
44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,
47: picture icx_cat_items_tlp.picture%TYPE,
48: picture_url icx_cat_items_tlp.picture_url%TYPE,
49: price_type icx_cat_item_prices.price_type%TYPE,
50: asl_id NUMBER,
51: supplier_site_id NUMBER,

Line 48: picture_url icx_cat_items_tlp.picture_url%TYPE,

44: mtl_category_id NUMBER,
45: category_key icx_cat_categories_tl.key%TYPE,
46: description icx_cat_items_tlp.description%TYPE,
47: picture icx_cat_items_tlp.picture%TYPE,
48: picture_url icx_cat_items_tlp.picture_url%TYPE,
49: price_type icx_cat_item_prices.price_type%TYPE,
50: asl_id NUMBER,
51: supplier_site_id NUMBER,
52: contract_id NUMBER,

Line 75: manufacturer ICX_CAT_ITEMS_TLP.manufacturer%TYPE,

71: unit_of_measure icx_cat_item_prices.unit_of_measure%TYPE,
72: functional_price NUMBER,
73: contract_num icx_cat_item_prices.contract_num%TYPE,
74: contract_line_num NUMBER,
75: manufacturer ICX_CAT_ITEMS_TLP.manufacturer%TYPE,
76: manufacturer_part_num ICX_CAT_ITEMS_TLP.manufacturer_part_num%TYPE,
77: rate_type ICX_CAT_ITEM_PRICES.rate_type%TYPE,
78: rate_date DATE,
79: rate NUMBER,

Line 76: manufacturer_part_num ICX_CAT_ITEMS_TLP.manufacturer_part_num%TYPE,

72: functional_price NUMBER,
73: contract_num icx_cat_item_prices.contract_num%TYPE,
74: contract_line_num NUMBER,
75: manufacturer ICX_CAT_ITEMS_TLP.manufacturer%TYPE,
76: manufacturer_part_num ICX_CAT_ITEMS_TLP.manufacturer_part_num%TYPE,
77: rate_type ICX_CAT_ITEM_PRICES.rate_type%TYPE,
78: rate_date DATE,
79: rate NUMBER,
80: supplier_number ICX_CAT_ITEM_PRICES.supplier_number%TYPE,

Line 254: -- Insert ICX_CAT_ITEMS_TLP

250: gUBInternalItemNums DBMS_SQL.VARCHAR2_TABLE;
251: gUBExtractorUpdatedFlags DBMS_SQL.VARCHAR2_TABLE;
252: gUBJobNumbers DBMS_SQL.NUMBER_TABLE;
253:
254: -- Insert ICX_CAT_ITEMS_TLP
255: gITRtItemIds DBMS_SQL.NUMBER_TABLE;
256: gITLanguages DBMS_SQL.VARCHAR2_TABLE;
257: gITOrgIds DBMS_SQL.NUMBER_TABLE;
258: gITSupplierIds DBMS_SQL.NUMBER_TABLE;

Line 273: -- Update ICX_CAT_ITEMS_TLP

269: gITPictureURLs DBMS_SQL.VARCHAR2_TABLE;
270: gITManufacturers DBMS_SQL.VARCHAR2_TABLE;
271: gITManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
272:
273: -- Update ICX_CAT_ITEMS_TLP
274: gUTRtItemIds DBMS_SQL.NUMBER_TABLE;
275: gUTLanguages DBMS_SQL.VARCHAR2_TABLE;
276: gUTItemSourceTypes DBMS_SQL.VARCHAR2_TABLE;
277: gUTSearchTypes DBMS_SQL.VARCHAR2_TABLE;

Line 537: -- Insert ICX_CAT_ITEMS_TLP

533: gUBJobNumbers.DELETE;
534: END IF;
535:
536: IF (pMode IN ('ALL', 'INSERT_ITEMS_TLP')) THEN
537: -- Insert ICX_CAT_ITEMS_TLP
538: gITRtItemIds.DELETE;
539: gITLanguages.DELETE;
540: gITOrgIds.DELETE;
541: gITSupplierIds.DELETE;

Line 558: -- Update ICX_CAT_ITEMS_TLP

554: gITManufacturerPartNums.DELETE;
555: END IF;
556:
557: IF (pMode IN ('ALL', 'UPDATE_ITEMS_TLP')) THEN
558: -- Update ICX_CAT_ITEMS_TLP
559: gUTRtItemIds.DELETE;
560: gUTLanguages.DELETE;
561: gUTItemSourceTypes.DELETE;
562: gUTSearchTypes.DELETE;

Line 945: -- Insert ICX_CAT_ITEMS_TLP

941: ICX_POR_EXT_UTL.getTableElement(gUBExtractorUpdatedFlags, pIndex) || ', ';
942: xShot := xShot || ' gUBJobNumbers: ' ||
943: ICX_POR_EXT_UTL.getTableElement(gUBJobNumbers, pIndex);
944: ELSIF (pMode = 'INSERT_ITEMS_TLP') THEN
945: -- Insert ICX_CAT_ITEMS_TLP
946: xShot := xShot || ' gITRtItemIds: ' ||
947: ICX_POR_EXT_UTL.getTableElement(gITRtItemIds, pIndex) || ', ';
948: xShot := xShot || ' gITLanguages: ' ||
949: ICX_POR_EXT_UTL.getTableElement(gITLanguages, pIndex) || ', ';

Line 981: -- Update ICX_CAT_ITEMS_TLP

977: ICX_POR_EXT_UTL.getTableElement(gITManufacturers, pIndex) || ', ';
978: xShot := xShot || ' gITManufacturerPartNums: ' ||
979: ICX_POR_EXT_UTL.getTableElement(gITManufacturerPartNums, pIndex);
980: ELSIF (pMode = 'UPDATE_ITEMS_TLP') THEN
981: -- Update ICX_CAT_ITEMS_TLP
982: xShot := xShot || ' gUTRtItemIds: ' ||
983: ICX_POR_EXT_UTL.getTableElement(gUTRtItemIds, pIndex) || ', ';
984: xShot := xShot || ' gUTLanguages: ' ||
985: ICX_POR_EXT_UTL.getTableElement(gUTLanguages, pIndex) || ', ';

Line 1675: UPDATE icx_cat_items_tlp

1671:
1672: xErrLoc := 300;
1673: IF gExtractImageDet = 'Y' THEN
1674: FORALL i IN 1..xUPItemRtItemIds.COUNT
1675: UPDATE icx_cat_items_tlp
1676: SET description = xUPItemDescriptions(i),
1677: picture = xUPItemPictures(i),
1678: picture_url = xUPItemPictureUrls(i),
1679: thumbnail_image = xUPItemPictures(i),

Line 1697: UPDATE icx_cat_items_tlp

1693: ', sql%rowcount:' ||to_char(sql%rowcount));
1694: END IF;
1695: ELSE
1696: FORALL i IN 1..xUPItemRtItemIds.COUNT
1697: UPDATE icx_cat_items_tlp
1698: SET description = xUPItemDescriptions(i),
1699: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
1700: last_update_date = SYSDATE,
1701: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

Line 2312: -- Insert ICX_CAT_ITEMS_TLP

2308: clearTables(xActionMode);
2309:
2310: xErrLoc := 280;
2311: xActionMode := 'INSERT_ITEMS_TLP';
2312: -- Insert ICX_CAT_ITEMS_TLP
2313: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2314: FOR i in 1..gITRtItemIds.COUNT LOOP
2315: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2316: snapShot(i, xActionMode));

Line 2321: INSERT INTO icx_cat_items_tlp

2317: END LOOP;
2318: END IF;
2319: IF gExtractImageDet = 'Y' THEN
2320: FORALL i IN 1..gITRtItemIds.COUNT
2321: INSERT INTO icx_cat_items_tlp
2322: (rt_item_id, language, org_id,
2323: supplier_id, item_source_type, search_type,
2324: primary_category_id, primary_category_name,
2325: internal_item_id, internal_item_num,

Line 2350: INSERT INTO icx_cat_items_tlp

2346: ICX_POR_EXTRACTOR.gProgramApplicationId,
2347: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2348: ELSE
2349: FORALL i IN 1..gITRtItemIds.COUNT
2350: INSERT INTO icx_cat_items_tlp
2351: (rt_item_id, language, org_id,
2352: supplier_id, item_source_type, search_type,
2353: primary_category_id, primary_category_name,
2354: internal_item_id, internal_item_num,

Line 2382: -- Update ICX_CAT_ITEMS_TLP

2378: clearTables(xActionMode);
2379:
2380: xErrLoc := 290;
2381: xActionMode := 'UPDATE_ITEMS_TLP';
2382: -- Update ICX_CAT_ITEMS_TLP
2383: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2384: FOR i in 1..gUTRtItemIds.COUNT LOOP
2385: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2386: snapShot(i, xActionMode));

Line 2391: UPDATE icx_cat_items_tlp

2387: END LOOP;
2388: END IF;
2389: IF gExtractImageDet = 'Y' THEN
2390: FORALL i IN 1..gUTRtItemIds.COUNT
2391: UPDATE icx_cat_items_tlp
2392: SET item_source_type = gUTItemSourceTypes(i),
2393: search_type = gUTSearchTypes(i),
2394: primary_category_id = gUTPrimaryCategoryIds(i),
2395: primary_category_name = gUTPrimaryCategoryNames(i),

Line 2415: UPDATE icx_cat_items_tlp

2411: WHERE rt_item_id = gUTRtItemIds(i)
2412: AND language = gUTLanguages(i);
2413: ELSE
2414: FORALL i IN 1..gUTRtItemIds.COUNT
2415: UPDATE icx_cat_items_tlp
2416: SET item_source_type = gUTItemSourceTypes(i),
2417: search_type = gUTSearchTypes(i),
2418: primary_category_id = gUTPrimaryCategoryIds(i),
2419: primary_category_name = gUTPrimaryCategoryNames(i),

Line 2691: UPDATE icx_cat_items_tlp

2687: ICX_POR_EXTRACTOR.gProgramApplicationId,
2688: ICX_POR_EXTRACTOR.gProgramId, SYSDATE);
2689:
2690: FORALL i IN 1..gIPGARtItemIds.COUNT
2691: UPDATE icx_cat_items_tlp
2692: SET request_id = ICX_POR_EXTRACTOR.gRequestId
2693: WHERE rt_item_id = gIPGARtItemIds(i);
2694:
2695: clearTables(xActionMode);

Line 2985: icx_cat_items_tlp t

2981: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
2982: i.rt_item_id,
2983: gCurrentPrice.template_id) match_template_flag
2984: FROM icx_cat_items_b i,
2985: icx_cat_items_tlp t
2986: WHERE i.internal_item_id = gCurrentPrice.internal_item_id
2987: AND i.org_id = gCurrentPrice.org_id
2988: AND (i.supplier IS NULL AND gCurrentPrice.supplier IS NULL OR
2989: i.supplier = gCurrentPrice.supplier)

Line 3028: icx_cat_items_tlp t

3024: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3025: p.rt_item_id,
3026: gCurrentPrice.template_id) match_template_flag
3027: FROM icx_cat_item_prices p,
3028: icx_cat_items_tlp t
3029: WHERE p.inventory_item_id = gCurrentPrice.internal_item_id
3030: AND p.org_id = gCurrentPrice.org_id
3031: AND p.price_type IN ('PURCHASING_ITEM',
3032: 'INTERNAL_TEMPLATE',

Line 3053: icx_cat_items_tlp t

3049: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3050: i.rt_item_id,
3051: gCurrentPrice.template_id) match_template_flag
3052: FROM icx_cat_items_b i,
3053: icx_cat_items_tlp t
3054: WHERE i.internal_item_id IS NULL
3055: AND i.org_id = gCurrentPrice.org_id
3056: AND i.supplier = gCurrentPrice.supplier
3057: AND i.supplier_part_num = gCurrentPrice.supplier_part_num

Line 3092: icx_cat_items_tlp t

3088: ICX_POR_EXT_ITEM.getMatchTempalteFlag(gCurrentPrice.price_type,
3089: p.rt_item_id,
3090: gCurrentPrice.template_id) match_template_flag
3091: FROM icx_cat_item_prices p,
3092: icx_cat_items_tlp t
3093: WHERE p.inventory_item_id IS NULL
3094: AND p.org_id = gCurrentPrice.org_id
3095: AND p.contract_id = gCurrentPrice.contract_id
3096: AND p.contract_line_id = gCurrentPrice.contract_line_id

Line 3694: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;

3690:
3691: PROCEDURE insertItemsTLP IS
3692: xString VARCHAR2(2000);
3693: cTranslations tCursorType;
3694: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3695: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3696: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3697: xErrLoc PLS_INTEGER := 100;
3698: xIndex PLS_INTEGER := 0;

Line 3695: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;

3691: PROCEDURE insertItemsTLP IS
3692: xString VARCHAR2(2000);
3693: cTranslations tCursorType;
3694: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3695: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3696: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3697: xErrLoc PLS_INTEGER := 100;
3698: xIndex PLS_INTEGER := 0;
3699:

Line 3696: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;

3692: xString VARCHAR2(2000);
3693: cTranslations tCursorType;
3694: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3695: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3696: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3697: xErrLoc PLS_INTEGER := 100;
3698: xIndex PLS_INTEGER := 0;
3699:
3700: BEGIN

Line 3855: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;

3851:
3852: PROCEDURE updateItemsTLP IS
3853: xString VARCHAR2(2000);
3854: cTranslations tCursorType;
3855: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3856: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3857: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3858: xRtItemId NUMBER;
3859: xErrLoc PLS_INTEGER := 100;

Line 3856: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;

3852: PROCEDURE updateItemsTLP IS
3853: xString VARCHAR2(2000);
3854: cTranslations tCursorType;
3855: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3856: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3857: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3858: xRtItemId NUMBER;
3859: xErrLoc PLS_INTEGER := 100;
3860: xIndex PLS_INTEGER := 0;

Line 3857: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;

3853: xString VARCHAR2(2000);
3854: cTranslations tCursorType;
3855: xDescription ICX_CAT_ITEMS_TLP.description%TYPE;
3856: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
3857: xCategoryName ICX_CAT_ITEMS_TLP.primary_category_name%TYPE;
3858: xRtItemId NUMBER;
3859: xErrLoc PLS_INTEGER := 100;
3860: xIndex PLS_INTEGER := 0;
3861: BEGIN

Line 3885: 'icx_cat_items_tlp t ' ||

3881: -- only translated items are extracted. pseudo translated items
3882: -- are not extracted. e.g. Item created in english, but rows get added to
3883: -- other installed langs. extract the item only in english
3884: xString := xString ||
3885: 'icx_cat_items_tlp t ' ||
3886: 'WHERE m.inventory_item_id = :internal_item_id ' ||
3887: 'AND m.organization_id = :inventory_organization_id ' ||
3888: 'AND ctl.rt_category_id = :ctl_category_id ' ||
3889: 'AND ctl.language = m.language ' ||

Line 3979: 'FROM fnd_languages f, icx_cat_items_tlp i ' ||

3975: ELSE
3976: -- One-time items
3977: -- Bug # 3991340
3978: xString := 'SELECT f.language_code, i.rt_item_id ' ||
3979: 'FROM fnd_languages f, icx_cat_items_tlp i ' ||
3980: 'WHERE ' ||
3981: 'f.language_code = i.language(+) AND ' ||
3982: 'i.rt_item_id(+) = :rt_item_id AND ' ||
3983: 'f.installed_flag IN (''B''';

Line 4072: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;

4068: -- bug 2925403
4069: PROCEDURE insertExtItemsTLP IS
4070: xString VARCHAR2(2000);
4071: cTranslations tCursorType;
4072: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
4073: xErrLoc PLS_INTEGER := 100;
4074: xIndex PLS_INTEGER := 0;
4075:
4076: BEGIN

Line 4179: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;

4175: -- bug 2925403
4176: PROCEDURE updateExtItemsTLP IS
4177: xString VARCHAR2(2000);
4178: cTranslations tCursorType;
4179: xLanguage ICX_CAT_ITEMS_TLP.language%TYPE;
4180: xRtItemId NUMBER;
4181: xErrLoc PLS_INTEGER := 100;
4182: xIndex PLS_INTEGER := 0;
4183:

Line 4688: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4684: -- | |_____________________________________________|
4685: -- | | Price Match |
4686: -- | | ---------------- |
4687: -- | |* update ICX_CAT_ITEM_PRICES |
4688: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4689: -- | |* IF match_primary_category_id <> |
4690: -- | | primary_category_id |
4691: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4692: -- | |* don't have to reset active_flag |

Line 4697: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4693: -- | |_____________________________________________|
4694: -- | | Item Match |
4695: -- | | ---------- |
4696: -- | |* update ICX_CAT_ITEM_PRICES |
4697: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4698: -- | |* IF match_primary_category_id <> |
4699: -- | | primary_category_id |
4700: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4701: -- | |* IF match_template_flag = 'N' |

Line 4711: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4707: -- | |_____________________________________________|
4708: -- | | New Item |
4709: -- | | -------- |
4710: -- | |* update ICX_CAT_ITEM_PRICES |
4711: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4712: -- | |* create ICX_CAT_CATEGORY_ITEMS for |
4713: -- | | mtl_category_id |
4714: -- | |* IF template_id IS NOT NULL |
4715: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

Line 4724: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4720: -- |_____________|_____________________________________________|
4721: -- | New Price | Item Match |
4722: -- | | ---------- |
4723: -- | |* create ICX_CAT_ITEM_PRICES |
4724: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4725: -- | |* IF match_primary_category_id <> |
4726: -- | | primary_category_id |
4727: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4728: -- | | update ICX_CAT_ITEMS_TLP |

Line 4728: -- | | update ICX_CAT_ITEMS_TLP |

4724: -- | |* update ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4725: -- | |* IF match_primary_category_id <> |
4726: -- | | primary_category_id |
4727: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4728: -- | | update ICX_CAT_ITEMS_TLP |
4729: -- | |* IF match_template_flag = 'N' |
4730: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |
4731: -- | |* reset active_flag for rt_item_id |
4732: -- | |* set item source for inventory_item_id |

Line 4737: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |

4733: -- | |_____________________________________________|
4734: -- | | New Item |
4735: -- | | -------- |
4736: -- | |* create ICX_CAT_ITEM_PRICES |
4737: -- | |* create ICX_CAT_ITEMS_B, ICX_CAT_ITEMS_TLP |
4738: -- | |* create ICX_CAT_CATEGORY_ITEMS for |
4739: -- | | mtl_category_id |
4740: -- | |* IF template_id IS NOT NULL |
4741: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

Line 6826: 3. While updating icx_cat_items_tlp we can utilize forall instead of processing one vendor at a time

6822: 1. Dont expect a huge number of vendor_names that needs changes in catalog items table
6823: Even if there are huge number of vendor_names that will be returned by the cursor cUpdatedVendorNames
6824: doing a bulk fetch will only increase the size of plsql tables
6825: 2. We can take the advantage of doing bulk fetch for cUpdatedVendorNames
6826: 3. While updating icx_cat_items_tlp we can utilize forall instead of processing one vendor at a time
6827: anyway we will be processing only 2500 rows at a time, since we have the rownum constraint.
6828: */
6829: xErrLoc := 160;
6830: IF (ICX_POR_EXT_UTL.getDatabaseVersion < 9.0) THEN

Line 6896: UPDATE icx_cat_items_tlp

6892: xErrLoc := 280;
6893: -- Since the vendor name changes need to be built into
6894: -- interMedia index, have to set the column jobNum
6895: FORALL i IN 1..xRtItemIds.COUNT
6896: UPDATE icx_cat_items_tlp
6897: SET supplier = xNewVendorNames(i),
6898: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
6899: last_update_date = SYSDATE,
6900: last_update_login = ICX_POR_EXTRACTOR.gLoginId,