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_EXT_ITEMS_TLP

Line 397: vTableName := 'ICX_CAT_EXT_ITEMS_TLP';

393: vSearchableDescCount PLS_INTEGER := 0;
394: vSQLTab ICX_POR_CTX_SQL_PKG.SQLTab;
395: BEGIN
396:
397: vTableName := 'ICX_CAT_EXT_ITEMS_TLP';
398:
399: -- Category_Change
400: vUpdateItemsNonTLSQL1 := 'update ' || vTableName ||
401: ' set (last_update_login, last_updated_by, last_update_date ';

Line 475: ' FROM ' || p_table_name || ' it, icx_cat_ext_items_tlp i ' ||

471: -- the first matching row(rownum=1);
472: p_category_info.updateNonTLSQL := vUpdateItemsNonTLSQL1 ||
473: ') = (SELECT :p_user_login, :p_user_id, sysdate' ||
474: vUpdateItemsNonTLSQL2 ||
475: ' FROM ' || p_table_name || ' it, icx_cat_ext_items_tlp i ' ||
476: ' WHERE i.rt_item_id = :old_item_id' ||
477: ' AND it.rowid = :p_rowid AND ' || to_char(p_category_id) ||
478: ' = :p_category_id AND :update_action = :p_action and rownum=1)' ||
479: ' WHERE rt_item_id = :old_item_id' ||

Line 486: ' FROM ' || p_table_name || ' it, icx_cat_ext_items_tlp i ' ||

482: -- Category_Change
483: p_category_info.updateTLSQL := vUpdateItemsTLSQL1 ||
484: ') = (SELECT :p_request_id, :p_user_login, :p_user_id, sysdate' ||
485: vUpdateItemsTLSQL2 ||
486: ' FROM ' || p_table_name || ' it, icx_cat_ext_items_tlp i ' ||
487: ' WHERE i.rt_item_id = :old_item_id' ||
488: ' AND it.rowid = :p_rowid AND ' || to_char(p_category_id) ||
489: ' = :p_category_id AND :update_action = :p_action' ||
490: ' AND it.language = i.language)' ||

Line 501: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors

497: p_category_info.descriptor_count := 0;
498: p_category_info.updateTLSQL := null;
499: p_category_info.updateNonTLSQL := null;
500: --Bug#3657792
501: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
502: --vTranslateItemsSQL1 and vTranslateItemsSQL2 will be null, if there are no local descriptors,
503: --so, insert into icx_cat_ext_items_tlp will only insert the required columns
504: --like rt_item_id, language etc
505: --p_category_info.translateSQL := null;

Line 503: --so, insert into icx_cat_ext_items_tlp will only insert the required columns

499: p_category_info.updateNonTLSQL := null;
500: --Bug#3657792
501: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
502: --vTranslateItemsSQL1 and vTranslateItemsSQL2 will be null, if there are no local descriptors,
503: --so, insert into icx_cat_ext_items_tlp will only insert the required columns
504: --like rt_item_id, language etc
505: --p_category_info.translateSQL := null;
506: END IF;
507:

Line 509: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors

505: --p_category_info.translateSQL := null;
506: END IF;
507:
508: --Bug#3657792
509: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
510: --vTranslateItemsSQL1 and vTranslateItemsSQL2 will be null, if there are no local descriptors,
511: --so, insert into icx_cat_ext_items_tlp will only insert the required columns
512: --like rt_item_id, language etc
513: xErrLoc := 305;

Line 511: --so, insert into icx_cat_ext_items_tlp will only insert the required columns

507:
508: --Bug#3657792
509: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
510: --vTranslateItemsSQL1 and vTranslateItemsSQL2 will be null, if there are no local descriptors,
511: --so, insert into icx_cat_ext_items_tlp will only insert the required columns
512: --like rt_item_id, language etc
513: xErrLoc := 305;
514: p_category_info.translateSQL := vTranslateItemsSQL1 || ') SELECT ' ||
515: 'i.rt_item_id, it.language, it.org_id,'||

Line 519: vTranslateItemsSQL2 || ' FROM icx_cat_ext_items_tlp i, ' || p_table_name ||

515: 'i.rt_item_id, it.language, it.org_id,'||
516: 'it.rt_category_id, ''Y'',' ||
517: ':p_user_id, sysdate, ' ||
518: ':p_user_id, sysdate, :p_user_login ' ||
519: vTranslateItemsSQL2 || ' FROM icx_cat_ext_items_tlp i, ' || p_table_name ||
520: ' it WHERE i.rt_item_id = :old_item_id AND it.rowid = :p_rowid AND ' ||
521: to_char(p_category_id) || ' = :p_category_id AND '||
522: ' :update_action = :p_action and it.language<>i.language ' ||
523: ' AND rownum = 1 ';

Line 1500: -- ICX_CAT_EXT_ITEMS_TLP

1496: AND v_action = gSystemActions(i);
1497:
1498: xErrLoc := 300;
1499:
1500: -- ICX_CAT_EXT_ITEMS_TLP
1501: -- Category_Change
1502: FORALL i in 1..gRowIds.COUNT
1503: INSERT into icx_cat_ext_items_tlp(rt_item_id, language, org_id, request_id,
1504: rt_category_id, primary_flag,

Line 1503: INSERT into icx_cat_ext_items_tlp(rt_item_id, language, org_id, request_id,

1499:
1500: -- ICX_CAT_EXT_ITEMS_TLP
1501: -- Category_Change
1502: FORALL i in 1..gRowIds.COUNT
1503: INSERT into icx_cat_ext_items_tlp(rt_item_id, language, org_id, request_id,
1504: rt_category_id, primary_flag,
1505: text_cat_attribute1, text_cat_attribute2, text_cat_attribute3,
1506: text_cat_attribute4, text_cat_attribute5, text_cat_attribute6,
1507: text_cat_attribute7, text_cat_attribute8, text_cat_attribute9,

Line 1936: -- ICX_CAT_EXT_ITEMS_TLP

1932: AND v_action = gSystemActions(i);
1933:
1934: xErrLoc := 300;
1935:
1936: -- ICX_CAT_EXT_ITEMS_TLP
1937: FORALL i in 1..gRowIds.COUNT
1938: DELETE from icx_cat_ext_items_tlp
1939: WHERE rt_item_id = gItemIds(i)
1940: AND v_action = gSystemActions(i);

Line 1938: DELETE from icx_cat_ext_items_tlp

1934: xErrLoc := 300;
1935:
1936: -- ICX_CAT_EXT_ITEMS_TLP
1937: FORALL i in 1..gRowIds.COUNT
1938: DELETE from icx_cat_ext_items_tlp
1939: WHERE rt_item_id = gItemIds(i)
1940: AND v_action = gSystemActions(i);
1941:
1942: xErrLoc := 400;

Line 2030: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors

2026: xErrLoc := 300+i;
2027: v_catid := gDistinctCategoryIds(i);
2028:
2029: --Bug#3657792
2030: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
2031: --So put the cursor gCategoryInfo(v_catid).translateSQL to insert into icx_cat_ext_items_tlp
2032: --outside of the if check (gCategoryInfo(v_catid).descriptor_count > 0)
2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;

Line 2031: --So put the cursor gCategoryInfo(v_catid).translateSQL to insert into icx_cat_ext_items_tlp

2027: v_catid := gDistinctCategoryIds(i);
2028:
2029: --Bug#3657792
2030: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
2031: --So put the cursor gCategoryInfo(v_catid).translateSQL to insert into icx_cat_ext_items_tlp
2032: --outside of the if check (gCategoryInfo(v_catid).descriptor_count > 0)
2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;

Line 2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language

2029: --Bug#3657792
2030: --Insert into icx_cat_ext_items_tlp should be done even if there are no local descriptors
2031: --So put the cursor gCategoryInfo(v_catid).translateSQL to insert into icx_cat_ext_items_tlp
2032: --outside of the if check (gCategoryInfo(v_catid).descriptor_count > 0)
2033: -- Insert into ICX_CAT_EXT_ITEMS_TLP for the new language
2034: xErrLoc := 500;
2035: v_cursor_id := DBMS_SQL.open_cursor;
2036: DBMS_SQL.parse(v_cursor_id, gCategoryInfo(v_catid).translateSQL,
2037: DBMS_SQL.NATIVE);

Line 5002: update icx_cat_ext_items_tlp set rt_category_id=gChangedNewCatIds(i),

4998: ||', gChangedCatActions.COUNT:'||to_char(gChangedCatActions.COUNT));
4999: end if;
5000:
5001: FORALL i in 1..gChangedCatItemIds.COUNT
5002: update icx_cat_ext_items_tlp set rt_category_id=gChangedNewCatIds(i),
5003: text_cat_attribute1 = null, text_cat_attribute2 = null, text_cat_attribute3 = null,
5004: text_cat_attribute4 = null, text_cat_attribute5 = null, text_cat_attribute6 = null,
5005: text_cat_attribute7 = null, text_cat_attribute8 = null, text_cat_attribute9 = null,
5006: text_cat_attribute10 = null, text_cat_attribute11 = null, text_cat_attribute12 = null,