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_CATEGORY_ITEMS

Line 287: -- Insert ICX_CAT_CATEGORY_ITEMS

283: gUTPictureURLs DBMS_SQL.VARCHAR2_TABLE;
284: gUTManufacturers DBMS_SQL.VARCHAR2_TABLE;
285: gUTManufacturerPartNums DBMS_SQL.VARCHAR2_TABLE;
286:
287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS

Line 291: -- Update ICX_CAT_CATEGORY_ITEMS

287: -- Insert ICX_CAT_CATEGORY_ITEMS
288: gICRtItemIds DBMS_SQL.NUMBER_TABLE;
289: gICRtCategoryIds DBMS_SQL.NUMBER_TABLE;
290:
291: -- Update ICX_CAT_CATEGORY_ITEMS
292: gUCRtItemIds DBMS_SQL.NUMBER_TABLE;
293: gUCRtCategoryIds DBMS_SQL.NUMBER_TABLE;
294: gUCOldRtCategoryIds DBMS_SQL.NUMBER_TABLE;
295:

Line 574: -- Insert ICX_CAT_CATEGORY_ITEMS

570: gUTManufacturerPartNums.DELETE;
571: END IF;
572:
573: IF (pMode IN ('ALL', 'INSERT_CATEGORY_ITEMS')) THEN
574: -- Insert ICX_CAT_CATEGORY_ITEMS
575: gICRtItemIds.DELETE;
576: gICRtCategoryIds.DELETE;
577: END IF;
578:

Line 580: -- Update ICX_CAT_CATEGORY_ITEMS

576: gICRtCategoryIds.DELETE;
577: END IF;
578:
579: IF (pMode IN ('ALL', 'UPDATE_CATEGORY_ITEMS')) THEN
580: -- Update ICX_CAT_CATEGORY_ITEMS
581: gUCRtItemIds.DELETE;
582: gUCRtCategoryIds.DELETE;
583: gUCOldRtCategoryIds.DELETE;
584: END IF;

Line 1007: -- Insert ICX_CAT_CATEGORY_ITEMS

1003: ICX_POR_EXT_UTL.getTableElement(gUTManufacturers, pIndex) || ', ';
1004: xShot := xShot || ' gUTManufacturerPartNums: ' ||
1005: ICX_POR_EXT_UTL.getTableElement(gUTManufacturerPartNums, pIndex);
1006: ELSIF (pMode = 'INSERT_CATEGORY_ITEMS') THEN
1007: -- Insert ICX_CAT_CATEGORY_ITEMS
1008: xShot := xShot || ' gICRtItemIds: ' ||
1009: ICX_POR_EXT_UTL.getTableElement(gICRtItemIds, pIndex) || ', ';
1010: xShot := xShot || ' gICRtCategoryIds: ' ||
1011: ICX_POR_EXT_UTL.getTableElement(gICRtCategoryIds, pIndex);

Line 1013: -- Update ICX_CAT_CATEGORY_ITEMS

1009: ICX_POR_EXT_UTL.getTableElement(gICRtItemIds, pIndex) || ', ';
1010: xShot := xShot || ' gICRtCategoryIds: ' ||
1011: ICX_POR_EXT_UTL.getTableElement(gICRtCategoryIds, pIndex);
1012: ELSIF (pMode = 'UPDATE_CATEGORY_ITEMS') THEN
1013: -- Update ICX_CAT_CATEGORY_ITEMS
1014: xShot := xShot || ' gUCRtItemIds: ' ||
1015: ICX_POR_EXT_UTL.getTableElement(gUCRtItemIds, pIndex) || ', ';
1016: xShot := xShot || ' gUCRtCategoryIds: ' ||
1017: ICX_POR_EXT_UTL.getTableElement(gUCRtCategoryIds, pIndex) || ', ';

Line 2440: -- Insert ICX_CAT_CATEGORY_ITEMS

2436: clearTables(xActionMode);
2437:
2438: xErrLoc := 300;
2439: xActionMode := 'INSERT_CATEGORY_ITEMS';
2440: -- Insert ICX_CAT_CATEGORY_ITEMS
2441: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2442: FOR i in 1..gICRtItemIds.COUNT LOOP
2443: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2444: snapShot(i, xActionMode));

Line 2448: INSERT INTO icx_cat_category_items

2444: snapShot(i, xActionMode));
2445: END LOOP;
2446: END IF;
2447: FORALL i IN 1..gICRtItemIds.COUNT
2448: INSERT INTO icx_cat_category_items
2449: (rt_item_id, rt_category_id,
2450: last_update_login, last_updated_by, last_update_date,
2451: created_by, creation_date, request_id,
2452: program_application_id, program_id, program_update_date)

Line 2464: -- Update ICX_CAT_CATEGORY_ITEMS

2460: clearTables(xActionMode);
2461:
2462: xErrLoc := 320;
2463: xActionMode := 'UPDATE_CATEGORY_ITEMS';
2464: -- Update ICX_CAT_CATEGORY_ITEMS
2465: IF (ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DETIL_LEVEL) THEN
2466: FOR i in 1..gUCRtItemIds.COUNT LOOP
2467: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DETIL_LEVEL,
2468: snapShot(i, xActionMode));

Line 2472: UPDATE icx_cat_category_items

2468: snapShot(i, xActionMode));
2469: END LOOP;
2470: END IF;
2471: FORALL i IN 1..gUCRtItemIds.COUNT
2472: UPDATE icx_cat_category_items
2473: SET rt_category_id = gUCRtCategoryIds(i),
2474: last_updated_by = ICX_POR_EXTRACTOR.gUserId,
2475: last_update_date = SYSDATE,
2476: last_update_login = ICX_POR_EXTRACTOR.gLoginId,

Line 2559: DELETE FROM icx_cat_category_items

2555: WHERE rowid = gDPRowIds(i);
2556:
2557: xErrLoc := 390;
2558: FORALL i IN 1..gDPTemplateCategoryIds.COUNT
2559: DELETE FROM icx_cat_category_items
2560: WHERE rt_category_id = gDPTemplateCategoryIds(i)
2561: AND rt_item_id = gDPRtItemIds(i);
2562: clearTables(xActionMode);
2563:

Line 2832: DELETE FROM icx_cat_category_items ci

2828: AND price_type IN ('BULKLOAD', 'CONTRACT');
2829:
2830: xErrLoc := 555;
2831: FORALL i IN 1..xRtItemIds.COUNT
2832: DELETE FROM icx_cat_category_items ci
2833: WHERE rt_item_id = xRtItemIds(i)
2834: AND EXISTS (SELECT 'template header'
2835: FROM icx_cat_categories_tl c
2836: WHERE c.rt_category_id = ci.rt_category_id

Line 4691: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |

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 |
4693: -- | |_____________________________________________|
4694: -- | | Item Match |
4695: -- | | ---------- |

Line 4700: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |

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' |
4702: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |
4703: -- | |* reset active_flag for both rt_item_id and |
4704: -- | | price_rt_item_id |

Line 4702: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

4698: -- | |* IF match_primary_category_id <> |
4699: -- | | primary_category_id |
4700: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |
4701: -- | |* IF match_template_flag = 'N' |
4702: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |
4703: -- | |* reset active_flag for both rt_item_id and |
4704: -- | | price_rt_item_id |
4705: -- | |* cleanup item for price_rt_item_id |
4706: -- | |* set item source for inventory_item_id |

Line 4712: -- | |* create ICX_CAT_CATEGORY_ITEMS for |

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 |
4716: -- | |* set active_flag to 'Y |

Line 4715: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

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 |
4716: -- | |* set active_flag to 'Y |
4717: -- | |* reset active_flag for price_rt_item_id |
4718: -- | |* cleanup item for price_rt_item_id |
4719: -- | |* set item source for inventory_item_id |

Line 4727: -- | | THEN update ICX_CAT_CATEGORY_ITEMS |

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 |
4729: -- | |* IF match_template_flag = 'N' |
4730: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |
4731: -- | |* reset active_flag for rt_item_id |

Line 4730: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

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 |
4733: -- | |_____________________________________________|
4734: -- | | New Item |

Line 4738: -- | |* create ICX_CAT_CATEGORY_ITEMS for |

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 |
4742: -- | |* set active_flag to 'Y |

Line 4741: -- | | THEN create ICX_CAT_CATEGORY_ITEMS |

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 |
4742: -- | |* set active_flag to 'Y |
4743: -- | |* set item source for inventory_item_id |
4744: -- |_____________|_____________________________________________|
4745: -- | Delete Price|* delete ICX_CAT_ITEM_PRICES |

Line 7462: DELETE icx_cat_category_items

7458: WHERE rowid = gDPRowIds(i);
7459:
7460: xErrLoc := 260;
7461: FORALL i IN 1..gDPTemplateCategoryIds.COUNT
7462: DELETE icx_cat_category_items
7463: WHERE rt_category_id = gDPTemplateCategoryIds(i)
7464: AND rt_item_id = gDPRtItemIds(i);
7465:
7466: xErrLoc := 280;