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_DESCRIPTORS_TL

Line 48: FROM icx_cat_descriptors_tl dl

44: SELECT distinct catid
45: FROM (
46: SELECT
47: dl.rt_category_id catid
48: FROM icx_cat_descriptors_tl dl
49: WHERE dl.request_id = p_request_id
50: --OEX_IP_PORTING AND dl.class = 'ICX_CAT_ATTR'
51: AND dl.rebuild_flag = 'Y'
52: AND dl.rt_category_id<>0

Line 70: FROM icx_cat_descriptors_tl

66: INTO rebuildBase
67: FROM dual
68: WHERE EXISTS
69: (SELECT 1
70: FROM icx_cat_descriptors_tl
71: WHERE request_id = p_request_id
72: AND rebuild_flag = 'Y'
73: AND rt_category_id = 0)
74: --OEX_IP_PORTING AND class = 'ICX_BASE_ATTR')

Line 162: UPDATE icx_cat_descriptors_tl

158: SET rebuild_flag = NULL
159: WHERE request_id = p_request_id;
160:
161: xErrLoc := 700;
162: UPDATE icx_cat_descriptors_tl
163: SET rebuild_flag = NULL
164: WHERE request_id = p_request_id;
165: COMMIT;
166:

Line 511: from icx_cat_descriptors_tl

507: END IF;
508:
509: IF (p_sequence IS NULL) THEN
510: select floor(max(sequence))+1 into l_sequence
511: from icx_cat_descriptors_tl
512: where rt_category_id = p_category_id
513: and language = p_language;
514: --OEX_IP_PORTING and class in ('ICX_BASE_ATTR','IPD_BASE_ATTR', 'POM_PRICE_ATTR', 'ICX_CAT_ATTR');
515: ElSE

Line 596: -- Insert into icx_cat_descriptors_tl table

592: -- reset_category_view(p_category_id);
593:
594: xErrLoc := 700;
595:
596: -- Insert into icx_cat_descriptors_tl table
597:
598: xErrLoc := 750;
599:
600: --Changes for userId, loginId

Line 636: ** Desc : Insert a new local descriptor into icx_cat_descriptors_tl.

632:
633:
634: /**
635: ** Proc : create_descriptor_metadata
636: ** Desc : Insert a new local descriptor into icx_cat_descriptors_tl.
637: ** This method simply pulls out the metadata section of a descriptor
638: ** that gets inserted into ICX_DESCRIPTORS_TL. This is done to
639: ** separate the insertion of data, from the creation of a dynamic
640: ** table. And is called directly in online category creation.

Line 695: INSERT INTO icx_cat_descriptors_tl

691:
692: xErrLoc := 100;
693:
694: --Changes for userId, loginId
695: INSERT INTO icx_cat_descriptors_tl
696: (RT_DESCRIPTOR_ID, RT_CATEGORY_ID, LANGUAGE, SOURCE_LANG,
697: DESCRIPTOR_NAME, DESCRIPTION, TYPE, KEY, TITLE, SEQUENCE,
698: DEFAULTVALUE, MULTI_VALUE_TYPE, MULTI_VALUE_KEY,
699: REQUIRED, REFINABLE, SEARCHABLE, SEARCH_RESULTS_VISIBLE,

Line 917: -- in icx_cat_descriptors_tl, which is done in the

913: xErrLoc := 100;
914:
915: -- added type in select list..need this for assign_section_tag
916: -- you need the type to determine the stored_in_column and store it
917: -- in icx_cat_descriptors_tl, which is done in the
918: -- assign_section_tag procedure
919: select rt_category_id, to_char(searchable), to_char(type)
920: into xCategoryID, xSearchable, xType
921: from icx_cat_descriptors_tl

Line 921: from icx_cat_descriptors_tl

917: -- in icx_cat_descriptors_tl, which is done in the
918: -- assign_section_tag procedure
919: select rt_category_id, to_char(searchable), to_char(type)
920: into xCategoryID, xSearchable, xType
921: from icx_cat_descriptors_tl
922: where rt_descriptor_id = p_descriptor_id
923: --OEX_IP_PORTING AND class IN ('ICX_BASE_ATTR','IPD_BASE_ATTR', 'POM_PRICE_ATTR', 'ICX_CAT_ATTR')
924: and rownum = 1;
925:

Line 943: UPDATE icx_cat_descriptors_tl

939: xRebuildFlag := 'Y';
940: end if;
941:
942: --Changes for userId, loginId
943: UPDATE icx_cat_descriptors_tl
944: SET DESCRIPTOR_NAME = NVL(p_name, DESCRIPTOR_NAME),
945: DESCRIPTION = decode(p_description,'#DEL',null, null, DESCRIPTION,p_description),
946: SOURCE_LANG = p_language,
947: CREATION_DATE = sysdate,

Line 969: UPDATE icx_cat_descriptors_tl

965: p_searchable is not null or
966: p_required is not null or
967: p_multivalue is not null or
968: p_refinable is not null) then
969: UPDATE icx_cat_descriptors_tl
970: SET DEFAULTVALUE = NVL(p_default_value, DEFAULTVALUE),
971: SEQUENCE = decode(p_sequence,null,sequence,'#DEL',null,to_number(p_sequence)),
972: SEARCH_RESULTS_VISIBLE = TO_NUMBER(NVL(p_search_results_visible,
973: SEARCH_RESULTS_VISIBLE)),

Line 1013: ** Delete local descriptors from icx_cat_descriptors_tl;

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;
1017: **/

Line 1046: delete from icx_cat_descriptors_tl

1042: where rt_category_id = p_category_id;
1043:
1044: xErrLoc := 200;
1045:
1046: delete from icx_cat_descriptors_tl
1047: where rt_category_id = p_category_id;
1048:
1049: xErrLoc := 300;
1050:

Line 1200: from icx_cat_descriptors_tl

1196: select rt_category_id, to_char(searchable), to_char(type),
1197: stored_in_table, stored_in_column
1198: into xCategoryID, xSearchable, xType,
1199: xStoredInTable, xStoredInColumn
1200: from icx_cat_descriptors_tl
1201: where rt_descriptor_id = p_descriptor_id
1202: --OEX_IP_PORTING AND class IN ('ICX_BASE_ATTR', 'IPD_BASE_ATTR', 'POM_PRICE_ATTR', 'ICX_CAT_ATTR')
1203: and rownum = 1;
1204:

Line 1218: delete from icx_cat_descriptors_tl

1214: release_section_tag(xCategoryID, p_descriptor_id);
1215:
1216: xErrLoc := 400;
1217:
1218: delete from icx_cat_descriptors_tl
1219: where rt_descriptor_id = p_descriptor_id;
1220:
1221: xErrLoc := 600;
1222:

Line 1393: FROM icx_cat_descriptors_tl

1389: INTO p_descriptor_id, p_owner_id, l_current_type,
1390: l_name, l_sequence, l_searchvisible, l_searchable,
1391: l_detailvisible, l_class, l_required, l_multivalue,
1392: l_customizelevel
1393: FROM icx_cat_descriptors_tl
1394: WHERE UPPER(key) = UPPER(p_key)
1395: AND language = p_language
1396: AND rt_category_id = p_owner_id
1397: --OEX_IP_PORTING AND class in('ICX_BASE_ATTR','IPD_BASE_ATTR','POM_PRICE_ATTR','ICX_CAT_ATTR')

Line 1452: SELECT 1 FROM icx_cat_descriptors_tl

1448: IF (p_owner_id = 0) THEN
1449: -- check uniqueness against all the descriptor names
1450: SELECT 1 INTO l_num_val
1451: FROM dual WHERE EXISTS (
1452: SELECT 1 FROM icx_cat_descriptors_tl
1453: WHERE UPPER(descriptor_name) = UPPER(p_name));
1454: --AND language = p_language
1455: --OEX_IP_PORTING AND class in('ICX_BASE_ATTR','IPD_BASE_ATTR','POM_PRICE_ATTR','ICX_CAT_ATTR'));
1456: ELSE

Line 1461: SELECT 1 FROM icx_cat_descriptors_tl

1457: -- check uniqueness against root descriptors and the
1458: -- descriptors inside that particular category
1459: SELECT 1 INTO l_num_val
1460: FROM dual WHERE EXISTS (
1461: SELECT 1 FROM icx_cat_descriptors_tl
1462: WHERE UPPER(descriptor_name) = UPPER(p_name)
1463: AND (rt_category_id = p_owner_id OR rt_category_id = 0));
1464: --AND language = p_language
1465: --OEX_IP_PORTING AND class in('ICX_BASE_ATTR','IPD_BASE_ATTR','POM_PRICE_ATTR','ICX_CAT_ATTR'));

Line 1491: SELECT 1 FROM icx_cat_descriptors_tl

1487: IF (p_owner_id = 0) THEN
1488: -- check uniqueness against all the descriptor keys
1489: SELECT 1 INTO l_num_val
1490: FROM dual WHERE EXISTS (
1491: SELECT 1 FROM icx_cat_descriptors_tl
1492: WHERE UPPER(key) = UPPER(p_key)
1493: AND language = p_language);
1494: ELSE
1495: -- check uniqueness against root descriptors and the

Line 1499: SELECT 1 FROM icx_cat_descriptors_tl

1495: -- check uniqueness against root descriptors and the
1496: -- descriptors inside that particular category
1497: SELECT 1 INTO l_num_val
1498: FROM dual WHERE EXISTS (
1499: SELECT 1 FROM icx_cat_descriptors_tl
1500: WHERE UPPER(key) = UPPER(p_key)
1501: AND (rt_category_id = p_owner_id OR rt_category_id = 0)
1502: AND language = p_language);
1503: END IF;

Line 1560: FROM icx_cat_descriptors_tl

1556: -- validate rule: Number of Base Attriutes < 100 (per descriptor TYPE)
1557: l_num_val := 0;
1558:
1559: SELECT COUNT(*) INTO l_num_val
1560: FROM icx_cat_descriptors_tl
1561: WHERE rt_category_id = 0
1562: AND language = p_language
1563: AND to_char(type) = p_type; -- OEX_IP_PORTING
1564:

Line 1578: FROM icx_cat_descriptors_tl

1574: IF (p_owner_id IS NOT NULL AND p_owner_id <> 0) THEN
1575: l_num_val := 0;
1576:
1577: SELECT COUNT(*) INTO l_num_val
1578: FROM icx_cat_descriptors_tl
1579: WHERE rt_category_id = p_owner_id
1580: AND language = p_language
1581: AND to_char(type) = p_type; -- OEX_IP_PORTING
1582:

Line 1621: SELECT 1 FROM icx_cat_descriptors_tl

1617: IF (p_owner_id = 0) THEN
1618: -- check uniqueness against all the other descriptor names
1619: SELECT 1 INTO l_num_val
1620: FROM dual WHERE EXISTS (
1621: SELECT 1 FROM icx_cat_descriptors_tl
1622: WHERE UPPER(descriptor_name) = UPPER(p_name)
1623: AND rt_descriptor_id <> p_descriptor_id);
1624: --AND language = p_language
1625: ELSE

Line 1630: SELECT 1 FROM icx_cat_descriptors_tl

1626: -- check uniqueness against root descriptors and the other
1627: -- descriptors inside that particular category
1628: SELECT 1 INTO l_num_val
1629: FROM dual WHERE EXISTS (
1630: SELECT 1 FROM icx_cat_descriptors_tl
1631: WHERE UPPER(descriptor_name) = UPPER(p_name)
1632: AND (rt_category_id = p_owner_id OR rt_category_id = 0)
1633: AND rt_descriptor_id <> p_descriptor_id);
1634: --AND language = p_language

Line 2235: FROM icx_cat_descriptors_tl

2231:
2232: xErrLoc := 200;
2233:
2234: SELECT section_tag INTO v_bit_position
2235: FROM icx_cat_descriptors_tl
2236: WHERE rt_descriptor_id = p_descriptor_id
2237: AND ROWNUM = 1;
2238:
2239: IF v_bit_position IS NULL THEN

Line 2246: UPDATE icx_cat_descriptors_tl SET section_tag = NULL

2242: END IF;
2243:
2244: xErrLoc := 300;
2245:
2246: UPDATE icx_cat_descriptors_tl SET section_tag = NULL
2247: WHERE rt_descriptor_id = p_descriptor_id;
2248:
2249: IF p_category_id > 0 THEN
2250: v_bit_position := v_bit_position - 5000;

Line 2303: FROM icx_cat_descriptors_tl

2299:
2300: -- Check whether a section tag is already assigned
2301: SELECT section_tag, stored_in_table, stored_in_column
2302: INTO l_section_tag, l_stored_in_table, l_stored_in_column
2303: FROM icx_cat_descriptors_tl
2304: WHERE rt_descriptor_id = p_descriptor_id
2305: AND rownum = 1;
2306:
2307: IF (p_section_tag IS NOT NULL) THEN

Line 2396: UPDATE icx_cat_descriptors_tl SET section_tag = p_section_tag,

2392: WHERE rt_category_id = p_category_id;
2393:
2394: xErrLoc := 300;
2395:
2396: UPDATE icx_cat_descriptors_tl SET section_tag = p_section_tag,
2397: stored_in_table = l_stored_in_table,
2398: stored_in_column = l_stored_in_column
2399: WHERE rt_descriptor_id = p_descriptor_id;
2400:

Line 2447: SELECT rt_descriptor_id, section_tag, type FROM icx_cat_descriptors_tl

2443: -- Get the descriptor id..
2444: -- Needed to determine the section tag values
2445: -- Assign section map/section tag only for non-seeded attributes
2446: CURSOR get_assigned_descriptors(x_category_id NUMBER, x_language VARCHAR2) IS
2447: SELECT rt_descriptor_id, section_tag, type FROM icx_cat_descriptors_tl
2448: WHERE rt_category_id = x_category_id
2449: AND language = x_language
2450: AND section_tag IS NOT NULL
2451: AND rt_descriptor_id >1000

Line 2456: SELECT rt_descriptor_id, type FROM icx_cat_descriptors_tl

2452: ORDER BY rt_descriptor_id
2453: ;
2454:
2455: CURSOR get_unassigned_descriptors(x_category_id NUMBER,x_language VARCHAR2) IS
2456: SELECT rt_descriptor_id, type FROM icx_cat_descriptors_tl
2457: WHERE rt_category_id = x_category_id
2458: AND language = x_language
2459: AND section_tag IS NULL
2460: AND rt_descriptor_id >1000

Line 2503: UPDATE icx_cat_descriptors_tl

2499: get_stored_in_values(rec.rt_descriptor_id, p_category_id, rec.type, rec.section_tag,
2500: l_stored_in_table, l_stored_in_column);
2501: xErrLoc := 240;
2502:
2503: UPDATE icx_cat_descriptors_tl
2504: SET stored_in_column = l_stored_in_column,
2505: stored_in_table = l_stored_in_table
2506: WHERE rt_descriptor_id = rec.rt_descriptor_id
2507: AND (stored_in_column is null OR stored_in_table is null);

Line 2549: UPDATE icx_cat_descriptors_tl

2545:
2546: get_stored_in_values(rec.rt_descriptor_id, p_category_id, rec.type, v_stored_section_tag,
2547: l_stored_in_table, l_stored_in_column);
2548:
2549: UPDATE icx_cat_descriptors_tl
2550: SET section_tag = v_stored_section_tag,
2551: stored_in_column = l_stored_in_column,
2552: stored_in_table = l_stored_in_table
2553: WHERE rt_descriptor_id = rec.rt_descriptor_id;