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

Line 611: and stored_in_table = 'ICX_CAT_ITEMS_TLP'

607: searchable
608: from icx_cat_descriptors_tl
609: where rt_category_id = p_category_id
610: and language = gJobLanguage
611: and stored_in_table = 'ICX_CAT_ITEMS_TLP'
612: order by rt_descriptor_id;
613: vColName VARCHAR2(30);
614: xErrLoc PLS_INTEGER := 100;
615: vRootDescCount PLS_INTEGER := 0;

Line 623: vUpdateItemsTLSQL1 := 'update icx_cat_items_tlp set ( ' ||

619: BEGIN
620:
621: -- No need to put any value in the ctx_ column, so it's not
622: -- included
623: vUpdateItemsTLSQL1 := 'update icx_cat_items_tlp set ( ' ||
624: 'request_id, last_updated_by, last_update_date, last_update_login, primary_category_name ';
625: --Bug#2729038
626: vUpdateItemsNonTLSQL1 := 'update icx_cat_items_tlp set ( ctx_desc, ' ||
627: 'primary_category_id, last_updated_by, last_update_date, last_update_login ';

Line 626: vUpdateItemsNonTLSQL1 := 'update icx_cat_items_tlp set ( ctx_desc, ' ||

622: -- included
623: vUpdateItemsTLSQL1 := 'update icx_cat_items_tlp set ( ' ||
624: 'request_id, last_updated_by, last_update_date, last_update_login, primary_category_name ';
625: --Bug#2729038
626: vUpdateItemsNonTLSQL1 := 'update icx_cat_items_tlp set ( ctx_desc, ' ||
627: 'primary_category_id, last_updated_by, last_update_date, last_update_login ';
628: vTranslateItemsSQL1 := 'insert into icx_cat_items_tlp ( ctx_desc, ' ||
629: ' rt_item_id, language, org_id, supplier_id, '||
630: ' item_source_type, search_type, primary_category_id, primary_category_name, '||

Line 628: vTranslateItemsSQL1 := 'insert into icx_cat_items_tlp ( ctx_desc, ' ||

624: 'request_id, last_updated_by, last_update_date, last_update_login, primary_category_name ';
625: --Bug#2729038
626: vUpdateItemsNonTLSQL1 := 'update icx_cat_items_tlp set ( ctx_desc, ' ||
627: 'primary_category_id, last_updated_by, last_update_date, last_update_login ';
628: vTranslateItemsSQL1 := 'insert into icx_cat_items_tlp ( ctx_desc, ' ||
629: ' rt_item_id, language, org_id, supplier_id, '||
630: ' item_source_type, search_type, primary_category_id, primary_category_name, '||
631: ' created_by, creation_date, ' ||
632: ' last_updated_by, last_update_date, last_update_login ';

Line 676: -- are stored in icx_cat_items_tlp, formulate the update sql...

672: vDescInfoTab(vSearchableDescCount) := vDescInfo;
673: END IF;
674:
675: -- For all root descriptors that are updateable and
676: -- are stored in icx_cat_items_tlp, formulate the update sql...
677: -- Some of the descriptors are not updateable. check can_update() function
678: IF (can_update(root_desc.key) AND (root_desc.stored_in_table = 'ICX_CAT_ITEMS_TLP')) then
679:
680: IF (root_desc.type = 2) THEN

Line 678: IF (can_update(root_desc.key) AND (root_desc.stored_in_table = 'ICX_CAT_ITEMS_TLP')) then

674:
675: -- For all root descriptors that are updateable and
676: -- are stored in icx_cat_items_tlp, formulate the update sql...
677: -- Some of the descriptors are not updateable. check can_update() function
678: IF (can_update(root_desc.key) AND (root_desc.stored_in_table = 'ICX_CAT_ITEMS_TLP')) then
679:
680: IF (root_desc.type = 2) THEN
681: vRootTLDescCount := vRootTLDescCount + 1;
682: vUpdateItemsTLSQL1 := vUpdateItemsTLSQL1 || ', ' || vColName;

Line 706: END IF; -- if(root_desc.stored_in_table = 'ICX_CAT_ITEMS_TLP')

702: ',''#DEL'',null,null,i.' || vColName ||
703: ',it.' || vColName || ')';
704: END IF; -- if (root_desc.type = 2)
705:
706: END IF; -- if(root_desc.stored_in_table = 'ICX_CAT_ITEMS_TLP')
707:
708: END LOOP; -- FOR root_desc IN ....
709:
710: xErrLoc := 300;

Line 720: vUpdateItemsNonTLSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||

716: --Bug#2729038
717: gUpdateItemsNonTLSQL := vUpdateItemsNonTLSQL1 || ') = (SELECT ' ||
718: '''1'''||
719: ', it.rt_category_id, :p_user_id, sysdate, :p_user_login ' ||
720: vUpdateItemsNonTLSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||
721: ' it WHERE i.rt_item_id = :old_item_id AND it.rowid = :p_rowid AND' ||
722: ' :update_action = :p_action and rownum=1) WHERE rt_item_id = :old_item_id';
723:
724: -- Update only translated descriptors

Line 727: vUpdateItemsTLSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||

723:
724: -- Update only translated descriptors
725: gUpdateItemsTLSQL := vUpdateItemsTLSQL1 || ') = (SELECT ' ||
726: ':p_request_id, :p_user_id, sysdate, :p_user_login, it.category_name ' ||
727: vUpdateItemsTLSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||
728: ' it WHERE i.rt_item_id = :old_item_id AND it.rowid = :p_rowid AND' ||
729: ' :update_action = :p_action and it.language=i.language)' ||
730: ' WHERE language = :p_language' ||
731: ' AND rt_item_id = :old_item_id';

Line 741: vTranslateItemsSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||

737: '''SUPPLIER'', ''SUPPLIER'', '||
738: 'it.rt_category_id, it.category_name,' ||
739: 'i.created_by, i.creation_date, ' ||
740: ':p_user_id, sysdate, :p_user_login ' ||
741: vTranslateItemsSQL2 || ' FROM icx_cat_items_tlp i, ' || pTableName ||
742: ' it WHERE i.rt_item_id = :old_item_id AND it.rowid = :p_rowid AND' ||
743: ' :update_action = :p_action and it.language<>i.language ' ||
744: ' AND rownum = 1 ' ;
745:

Line 1044: FROM icx_cat_items_tlp tl

1040: INSERT INTO icx_cat_items_ctx_tlp
1041: (rt_item_id, language, sequence, ctx_desc, org_id)
1042: SELECT gDistinctItemIds(i), tl.language, v_sequence,
1043: to_char(gDistinctBuyerIds(i)), gDistinctBuyerIds(i)
1044: FROM icx_cat_items_tlp tl
1045: WHERE tl.rt_item_id = gDistinctItemIds(i)
1046: AND NOT EXISTS
1047: (SELECT 1 FROM icx_cat_items_ctx_tlp
1048: WHERE rt_item_id = gDistinctItemIds(i)

Line 1180: Also updates the category information in icx_cat_items_tlp

1176: || xErrLoc || '): ' || SQLERRM);
1177: END process_batch_delete_prices;
1178:
1179: /* Populates ICX_POR_CATEGORY_ITEMS for items in the current batch
1180: Also updates the category information in icx_cat_items_tlp
1181: when category is changed for an item
1182: */
1183: PROCEDURE process_batch_common IS
1184: i PLS_INTEGER;

Line 1268: -- ICX_CAT_ITEMS_TLP

1264: AND v_action = gSystemActions(i);
1265:
1266: xErrLoc := 200;
1267:
1268: -- ICX_CAT_ITEMS_TLP
1269: FORALL i in 1..gRowIds.COUNT
1270: INSERT into icx_cat_items_tlp(rt_item_id, language, org_id, supplier_id,
1271: item_source_type, search_type, primary_category_id,
1272: primary_category_name, supplier, supplier_part_num,

Line 1270: INSERT into icx_cat_items_tlp(rt_item_id, language, org_id, supplier_id,

1266: xErrLoc := 200;
1267:
1268: -- ICX_CAT_ITEMS_TLP
1269: FORALL i in 1..gRowIds.COUNT
1270: INSERT into icx_cat_items_tlp(rt_item_id, language, org_id, supplier_id,
1271: item_source_type, search_type, primary_category_id,
1272: primary_category_name, supplier, supplier_part_num,
1273: supplier_part_auxid, manufacturer,--Bug#2611529
1274: manufacturer_url, supplier_url, --Bug#2611529

Line 1721: -- of the ICX_CAT_ITEMS_TLP

1717: WHERE rt_item_id = gCurrentItemIds(i) ;
1718:
1719:
1720: -- gUpdateItemsNonTLSQL: SQL to update the non-translated portion
1721: -- of the ICX_CAT_ITEMS_TLP
1722: -- gUpdateItemsTLSQL: SQL to update the translated portion
1723: -- of the ICX_CAT_ITEMS_TLP
1724:
1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors

Line 1723: -- of the ICX_CAT_ITEMS_TLP

1719:
1720: -- gUpdateItemsNonTLSQL: SQL to update the non-translated portion
1721: -- of the ICX_CAT_ITEMS_TLP
1722: -- gUpdateItemsTLSQL: SQL to update the translated portion
1723: -- of the ICX_CAT_ITEMS_TLP
1724:
1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;

Line 1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors

1721: -- of the ICX_CAT_ITEMS_TLP
1722: -- gUpdateItemsTLSQL: SQL to update the translated portion
1723: -- of the ICX_CAT_ITEMS_TLP
1724:
1725: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1726: xErrLoc := 100;
1727: v_cursor_id := DBMS_SQL.open_cursor;
1728: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
1729: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors

1734: DBMS_SQL.bind_array(v_cursor_id, ':p_action', gSystemActions);
1735: v_count := DBMS_SQL.execute(v_cursor_id);
1736: DBMS_SQL.close_cursor(v_cursor_id);
1737:
1738: -- ICX_CAT_ITEMS_TLP: Update the Translated Root descriptors
1739: xErrLoc := 200;
1740: v_cursor_id := DBMS_SQL.open_cursor;
1741: DBMS_SQL.parse(v_cursor_id, gUpdateItemsTLSQL, DBMS_SQL.NATIVE);
1742: DBMS_SQL.bind_variable(v_cursor_id, ':p_language', gJobLanguage, 4);

Line 1885: FROM icx_cat_items_tlp tl,

1881: SELECT gItemIds(i), tl.language, v_sequence,
1882: to_char(pll.org_id), pll.org_id,
1883: gUserLogin, gUserId, sysdate,
1884: gUserId, sysdate
1885: FROM icx_cat_items_tlp tl,
1886: (SELECT DISTINCT org_id
1887: FROM icx_cat_item_prices pll
1888: WHERE rt_item_id = gCurrentItemIds(i)
1889: ) pll

Line 1921: -- ICX_CAT_ITEMS_TLP

1917: AND v_action = gSystemActions(i);
1918:
1919: xErrLoc := 200;
1920:
1921: -- ICX_CAT_ITEMS_TLP
1922: FORALL i in 1..gRowIds.COUNT
1923: DELETE from icx_cat_items_tlp
1924: WHERE rt_item_id = gItemIds(i)
1925: AND v_action = gSystemActions(i);

Line 1923: DELETE from icx_cat_items_tlp

1919: xErrLoc := 200;
1920:
1921: -- ICX_CAT_ITEMS_TLP
1922: FORALL i in 1..gRowIds.COUNT
1923: DELETE from icx_cat_items_tlp
1924: WHERE rt_item_id = gItemIds(i)
1925: AND v_action = gSystemActions(i);
1926:
1927: xErrLoc := 250;

Line 1982: -- ICX_CAT_ITEMS_TLP: Insert new Row

1978: v_sequence PLS_INTEGER := 10001;
1979: xErrLoc PLS_INTEGER := 100;
1980: v_delete_ctx_sql VARCHAR2(255);
1981: BEGIN
1982: -- ICX_CAT_ITEMS_TLP: Insert new Row
1983: xErrLoc := 100;
1984: v_cursor_id := DBMS_SQL.open_cursor;
1985: DBMS_SQL.parse(v_cursor_id, gTranslateItemsSQL, DBMS_SQL.NATIVE);
1986: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);

Line 1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors

1993: v_count := DBMS_SQL.execute(v_cursor_id);
1994: DBMS_SQL.close_cursor(v_cursor_id);
1995:
1996: xErrLoc := 200;
1997: -- ICX_CAT_ITEMS_TLP: Update the Non-Translated Root descriptors
1998: v_cursor_id := DBMS_SQL.open_cursor;
1999: DBMS_SQL.parse(v_cursor_id, gUpdateItemsNonTLSQL, DBMS_SQL.NATIVE);
2000: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_id', gUserId);
2001: DBMS_SQL.bind_variable(v_cursor_id, ':p_user_login', gUserLogin);

Line 2126: FROM icx_cat_items_tlp tl,

2122: INSERT INTO icx_cat_items_ctx_tlp
2123: (rt_item_id, language, sequence, ctx_desc, org_id)
2124: SELECT gItemIds(i), tl.language, v_sequence,
2125: to_char(pll.org_id), pll.org_id
2126: FROM icx_cat_items_tlp tl,
2127: (SELECT DISTINCT org_id
2128: FROM icx_cat_item_prices pll
2129: WHERE rt_item_id = gCurrentItemIds(i)
2130: ) pll

Line 2365: and stored_in_table = 'ICX_CAT_ITEMS_TLP'

2361: searchable
2362: from icx_cat_descriptors_tl
2363: where rt_category_id = p_category_id
2364: and language = gJobLanguage
2365: and stored_in_table = 'ICX_CAT_ITEMS_TLP'
2366: and rt_descriptor_id >= 100000
2367: order by rt_descriptor_id;
2368: BEGIN
2369: xErrLoc := 100;

Line 3945: icx_cat_items_tlp tl

3941: it.unit_of_measure
3942: ,it.system_action
3943: FROM ICX_CAT_ITEMS_GT it,
3944: icx_cat_items_b i, --Bug#2714487: dont join with category_items
3945: icx_cat_items_tlp tl
3946: WHERE it.supplier = i.supplier (+)
3947: AND it.supplier_part_num = i.supplier_part_num (+)
3948: AND it.supplier_part_auxid = i.supplier_part_auxid (+) --Bug#2611529
3949: AND it.org_id = i.org_id(+)

Line 5070: update icx_cat_items_tlp

5066: -- since primary_category_name is not updated for the translated rows in
5067: -- build_root_sql() as primary_category_name is a translated attribute.
5068: FOR i in 1..xLangArray.COUNT LOOP
5069: FORALL j in 1..gChangedCatItemIds.COUNT
5070: update icx_cat_items_tlp
5071: set primary_category_name = (select category_name from icx_cat_categories_tl
5072: where rt_category_id = gChangedNewCatIds(j)
5073: and language = xLangArray(i))
5074: where rt_item_id = gChangedCatItemIds(j) and language = xLangArray(i);