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_SCHEMA_UPLOAD dependencies on ICX_CAT_CATEGORIES_TL

Line 55: FROM icx_cat_categories_tl ctl

51: AND dl.rebuild_flag = 'Y'
52: AND dl.rt_category_id<>0
53: UNION
54: SELECT ctl.rt_category_id catid
55: FROM icx_cat_categories_tl ctl
56: where ctl.request_id = p_request_id
57: AND ctl.rebuild_flag in ('D','B')
58: AND ctl.rt_category_id<>0
59: );

Line 77: FROM icx_cat_categories_tl

73: AND rt_category_id = 0)
74: --OEX_IP_PORTING AND class = 'ICX_BASE_ATTR')
75: OR EXISTS
76: (SELECT 1
77: FROM icx_cat_categories_tl
78: WHERE request_id = p_request_id
79: AND rebuild_flag = 'D'
80: AND rt_category_id = 0);
81: EXCEPTION

Line 99: icx_cat_categories_tl ctl

95: -- get sql table for base attributes
96: OPEN items_tl_cv FOR
97: SELECT tl.rowid, tl.rt_item_id, tl.language
98: FROM icx_cat_items_tlp tl,
99: icx_cat_categories_tl ctl
100: where tl.primary_category_id = ctl.rt_category_id
101: and tl.language = ctl.language
102: and ctl.request_id = p_request_id
103: AND ctl.rebuild_flag in ('C','B')

Line 157: UPDATE icx_cat_categories_tl

153:
154: xErrLoc := 600;
155:
156: -- reset rebuild_flag
157: UPDATE icx_cat_categories_tl
158: SET rebuild_flag = NULL
159: WHERE request_id = p_request_id;
160:
161: xErrLoc := 700;

Line 246: from icx_cat_categories_tl

242: xErrLoc := 100;
243:
244: select type
245: into xType
246: from icx_cat_categories_tl
247: where rt_category_id = p_parent_id
248: and rownum = 1;
249:
250: xErrLoc := 200;

Line 336: from icx_cat_categories_tl

332: xErrLoc := 100;
333:
334: select type
335: into xType
336: from icx_cat_categories_tl
337: where rt_category_id = p_parent_id
338: and rownum = 1;
339:
340: xErrLoc := 200;

Line 407: INSERT INTO ICX_CAT_CATEGORIES_TL

403:
404: xErrLoc := 300;
405:
406: --Changes for userId, loginId
407: INSERT INTO ICX_CAT_CATEGORIES_TL
408: (RT_CATEGORY_ID, LANGUAGE, SOURCE_LANG, CATEGORY_NAME,
409: DESCRIPTION, TYPE, KEY, UPPER_KEY, TITLE, CREATED_BY,
410: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
411: LAST_UPDATE_LOGIN, UPPER_CATEGORY_NAME, REQUEST_ID, REBUILD_FLAG,SECTION_MAP)

Line 760: FROM icx_cat_categories_tl

756: xCommitSize INTEGER := 2500;
757: xLangArray DBMS_SQL.VARCHAR2_TABLE;
758: CURSOR translateLangCsr IS
759: SELECT language
760: FROM icx_cat_categories_tl
761: WHERE rt_category_id = p_category_id
762: and type = p_type
763: and source_lang = p_language
764: and source_lang <> language

Line 793: UPDATE ICX_CAT_CATEGORIES_TL

789: -- 'C': catagory name changed
790: -- 'D': searchable descriptor deleted
791: -- 'B': both 'C' and 'D'
792: --Changes for userId, loginId
793: UPDATE ICX_CAT_CATEGORIES_TL
794: SET CATEGORY_NAME = NVL(p_name, CATEGORY_NAME),
795: UPPER_CATEGORY_NAME = NVL(upper(p_name), UPPER_CATEGORY_NAME),
796: DESCRIPTION = decode(p_description,'#DEL',null, null, DESCRIPTION,p_description),
797: SOURCE_LANG = p_language,

Line 844: UPDATE ICX_CAT_CATEGORIES_TL

840: xErrLoc := 180;
841:
842: -- commented out since type can not be changed.
843: /*if (p_type <> -1) then
844: UPDATE ICX_CAT_CATEGORIES_TL
845: SET TYPE = decode(p_type, -1, TYPE, p_type),
846: LAST_UPDATED_BY = 0,
847: LAST_UPDATE_DATE = sysdate,
848: LAST_UPDATE_LOGIN = 0,

Line 1012: ** Desc : Delete category from icx_cat_categories_tl;

1008: -------------------------------------------------------------------------
1009:
1010: /**
1011: ** Proc : delete_category
1012: ** Desc : Delete category from icx_cat_categories_tl;
1013: ** Delete local descriptors from icx_cat_descriptors_tl;
1014: ** Dlete items from icx_por_items, icx_por_items_tl and
1015: ** icx_cat_category_items;
1016: ** Delete links from icx_cat_browse_trees;

Line 1041: delete from icx_cat_categories_tl

1037: if (p_category_id <= 0) then
1038: return;
1039: end if;
1040:
1041: delete from icx_cat_categories_tl
1042: where rt_category_id = p_category_id;
1043:
1044: xErrLoc := 200;
1045:

Line 1073: FROM icx_cat_categories_tl

1069: xErrLoc := 820;
1070:
1071: if ( l_count = 0 ) then
1072: SELECT type INTO l_type
1073: FROM icx_cat_categories_tl
1074: WHERE rt_category_id = c_child.child_category_id
1075: AND language = USERENV('LANG');
1076: xErrLoc := 830;
1077:

Line 1121: from icx_cat_categories_tl cat,

1117: --
1118: CURSOR child_categories_csr (p_category_id NUMBER) IS
1119: select distinct cat.rt_category_id,
1120: cat.type
1121: from icx_cat_categories_tl cat,
1122: icx_cat_browse_trees toc
1123: where toc.parent_category_id = p_category_id
1124: and toc.child_category_id = cat.rt_category_id;
1125:

Line 1234: update icx_cat_categories_tl

1230: -- 'B': both 'C' and 'D'
1231:
1232: -- rebuild index if the deleted descriptor is searchable
1233: if (xSearchable = YES) then
1234: update icx_cat_categories_tl
1235: set rebuild_flag = decode(rebuild_flag,'C','B','B','B','D'),
1236: REQUEST_ID =p_request_id
1237: where rt_category_id = xCategoryID;
1238: end if;

Line 1334: FROM icx_cat_categories_tl

1330: BEGIN
1331: l_progress := '002_1';
1332:
1333: SELECT rt_category_id INTO p_owner_id
1334: FROM icx_cat_categories_tl
1335: WHERE upper_key = UPPER(p_owner_key)
1336: AND language = p_language
1337: AND type IN (0,2);
1338:

Line 1352: FROM icx_cat_categories_tl

1348: BEGIN
1349: l_progress := '002_3';
1350:
1351: SELECT rt_category_id INTO p_owner_id
1352: FROM icx_cat_categories_tl
1353: WHERE upper_category_name = UPPER(p_owner_name)
1354: AND language = p_language
1355: AND type IN (0,2);
1356:

Line 1745: FROM icx_cat_categories_tl

1741: l_progress := '000_1';
1742:
1743: BEGIN
1744: SELECT rt_category_id, type INTO p_category_id, l_current_type
1745: FROM icx_cat_categories_tl
1746: WHERE upper_key = UPPER(p_key)
1747: AND language = p_language
1748: AND rownum = 1;
1749:

Line 1789: FROM icx_cat_categories_tl

1785: l_progress := '004';
1786: l_num_val := 0;
1787:
1788: SELECT count(1) INTO l_num_val
1789: FROM icx_cat_categories_tl
1790: WHERE upper_category_name = UPPER(p_name);
1791: --AND language = p_language
1792:
1793: IF (l_num_val > 0) THEN

Line 1826: FROM icx_cat_categories_tl

1822: IF (p_name IS NOT NULL) THEN
1823: l_num_val := 0;
1824:
1825: SELECT count(1) INTO l_num_val
1826: FROM icx_cat_categories_tl
1827: WHERE upper_category_name = UPPER(p_name)
1828: --AND language = p_language
1829: AND rt_category_id <> p_category_id;
1830:

Line 1991: FROM icx_cat_categories_tl

1987: l_progress := '020';
1988:
1989: -- check if parent key exists
1990: SELECT rt_category_id, type INTO p_parent_id, l_parent_type
1991: FROM icx_cat_categories_tl
1992: WHERE upper_key = UPPER(p_parent_key)
1993: AND language = p_language;
1994:
1995: IF (l_parent_type = 2) THEN

Line 2018: FROM icx_cat_categories_tl

2014: l_progress := '040';
2015:
2016: -- check if parent key exists
2017: SELECT rt_category_id, type INTO l_num_val, l_parent_type
2018: FROM icx_cat_categories_tl
2019: WHERE upper_category_name = UPPER(p_parent_name)
2020: AND language = p_language;
2021:
2022: IF (p_parent_id IS NOT NULL) THEN

Line 2067: FROM icx_cat_categories_tl

2063: IF (p_child_key IS NOT NULL) THEN
2064: BEGIN
2065: -- check if child key exists
2066: SELECT rt_category_id INTO p_child_id
2067: FROM icx_cat_categories_tl
2068: WHERE upper_key = UPPER(p_child_key)
2069: AND language = p_language;
2070:
2071: EXCEPTION

Line 2086: FROM icx_cat_categories_tl

2082: IF (p_child_name IS NOT NULL) THEN
2083: BEGIN
2084: -- check if child key exists
2085: SELECT rt_category_id INTO l_num_val
2086: FROM icx_cat_categories_tl
2087: WHERE upper_category_name = UPPER(p_child_name)
2088: AND language = p_language;
2089:
2090: IF (p_child_id IS NOT NULL) THEN

Line 2211: ** Before calling this the rows in icx_cat_categories_tl with the

2207: /**
2208: ** Proc : release_section_tag
2209: ** Desc : Called when a descriptor is to be deleted or made not searchable
2210: ** SHOULD BE CALLED BEFORE THE DESCRIPTOR IS ACTUALLY DELETED
2211: ** Before calling this the rows in icx_cat_categories_tl with the
2212: ** given rt_category_id should be locked thru a SELECT...FOR UPDATE
2213: ** to avoid concurrent access to the SECTION_MAP column. The calling
2214: ** code is responsible for committing the changes.
2215: ** Parameters:

Line 2229: FROM icx_cat_categories_tl

2225: xErrLoc := 100;
2226:
2227: -- Find the section map, we can use any row with p_category_id
2228: SELECT section_map INTO v_section_map
2229: FROM icx_cat_categories_tl
2230: WHERE rt_category_id = p_category_id AND ROWNUM = 1;
2231:
2232: xErrLoc := 200;
2233:

Line 2260: UPDATE icx_cat_categories_tl SET section_map = v_section_map

2256: substr(v_section_map,v_bit_position+1);
2257:
2258: xErrLoc := 400;
2259:
2260: UPDATE icx_cat_categories_tl SET section_map = v_section_map
2261: WHERE rt_category_id = p_category_id;
2262:
2263: COMMIT;
2264: EXCEPTION

Line 2276: ** Before calling this the rows in icx_cat_categories_tl with the

2272: ** Proc : assign_section_tag
2273: ** Desc : Assigns a section tag to a given searchable descriptor. If the
2274: ** descriptor is already assigned a tag then the assigned tag will
2275: ** be returned.
2276: ** Before calling this the rows in icx_cat_categories_tl with the
2277: ** given rt_category_id should be locked thru a SELECT...FOR UPDATE
2278: ** to avoid concurrent access to the SECTION_MAP column. The calling
2279: ** code is responsible for committing the changes.
2280: ** Parameters:

Line 2324: FROM icx_cat_categories_tl

2320: -- validate_descriptor would have thrown the error,
2321: -- ICX_POR_CAT_ATT_NUM_EXCEED or ICX_POR_BASE_ATT_NUM_EXCEED
2322: if (p_type = 0) then
2323: SELECT section_map, INSTR(section_map,'0', 1, 1) INTO v_section_map, p_section_tag
2324: FROM icx_cat_categories_tl
2325: WHERE rt_category_id = p_category_id
2326: AND rownum = 1;
2327: elsif (p_type = 1) then
2328: SELECT section_map, INSTR(section_map,'0', 101, 1) INTO v_section_map, p_section_tag

Line 2329: FROM icx_cat_categories_tl

2325: WHERE rt_category_id = p_category_id
2326: AND rownum = 1;
2327: elsif (p_type = 1) then
2328: SELECT section_map, INSTR(section_map,'0', 101, 1) INTO v_section_map, p_section_tag
2329: FROM icx_cat_categories_tl
2330: WHERE rt_category_id = p_category_id
2331: AND rownum = 1;
2332: elsif (p_type =2) then
2333: SELECT section_map, INSTR(section_map,'0', 201, 1) INTO v_section_map, p_section_tag

Line 2334: FROM icx_cat_categories_tl

2330: WHERE rt_category_id = p_category_id
2331: AND rownum = 1;
2332: elsif (p_type =2) then
2333: SELECT section_map, INSTR(section_map,'0', 201, 1) INTO v_section_map, p_section_tag
2334: FROM icx_cat_categories_tl
2335: WHERE rt_category_id = p_category_id
2336: AND rownum = 1;
2337: end if;
2338:

Line 2391: UPDATE icx_cat_categories_tl SET section_map = v_section_map

2387: END IF;
2388:
2389: xErrLoc := 200;
2390:
2391: UPDATE icx_cat_categories_tl SET section_map = v_section_map
2392: WHERE rt_category_id = p_category_id;
2393:
2394: xErrLoc := 300;
2395:

Line 2421: ** Before calling this the rows in icx_cat_categories_tl with the

2417: ** Proc : assign_all_section_tags
2418: ** Desc : Assigns section tags to all searchable descriptors of a given
2419: ** category. This is intended to be called during the upgrade to 6.2
2420: ** or when batch update of a category is needed
2421: ** Before calling this the rows in icx_cat_categories_tl with the
2422: ** given rt_category_id should be locked thru a SELECT...FOR UPDATE
2423: ** to avoid concurrent access to the SECTION_MAP column. The calling
2424: ** code is responsible for committing the changes.
2425: ** Parameters:

Line 2558: UPDATE icx_cat_categories_tl SET section_map = v_section_map

2554: END LOOP;
2555:
2556: xErrLoc := 400;
2557:
2558: UPDATE icx_cat_categories_tl SET section_map = v_section_map
2559: WHERE rt_category_id = p_category_id;
2560:
2561: xErrLoc := 500;
2562: COMMIT;

Line 3202: FROM icx_cat_categories_tl

3198: xCommitSize INTEGER := 2500;
3199: xLangArray ECM_LANG_ARRAY;
3200: CURSOR translateLangCsr IS
3201: SELECT language
3202: FROM icx_cat_categories_tl
3203: WHERE rt_category_id = p_category_id
3204: and type = 2
3205: and source_lang = p_language
3206: and source_lang <> language