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 DUAL

Line 67: FROM dual

63: -- check if we need to rebuild ctx str for base attribute
64: BEGIN
65: SELECT 1
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

Line 268: FROM DUAL

264: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
265: CREATED_BY, CREATION_DATE)
266: SELECT p_parent_id, p_child_id,
267: p_login_id, p_user_id, sysdate, p_user_id, sysdate
268: FROM DUAL
269: WHERE NOT EXISTS (SELECT NULL
270: FROM icx_cat_browse_trees
271: WHERE parent_category_id = p_parent_id
272: AND child_category_id = p_child_id);

Line 294: FROM DUAL

290: (PARENT_CATEGORY_ID, CHILD_CATEGORY_ID,
291: LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE,
292: CREATED_BY, CREATION_DATE)
293: SELECT 0, p_parent_id, p_login_id, p_user_id, sysdate, p_user_id, sysdate
294: FROM DUAL
295: WHERE NOT EXISTS (SELECT NULL
296: FROM icx_cat_browse_trees
297: WHERE child_category_id = p_parent_id);
298: END IF;

Line 398: from DUAL;

394: xErrLoc := 100;
395:
396: select icx_por_categoryid.nextval
397: into p_category_id
398: from DUAL;
399:
400: xErrLoc := 200;
401:
402: FOR language_row IN installed_languages_csr LOOP

Line 571: from dual;

567: -- Get the new descriptor id
568:
569: select icx_por_descriptorid.nextval
570: into p_descriptor_id
571: from dual;
572:
573: xErrLoc := 300;
574:
575: if (l_type = TEXT_TYPE or l_type = TRANSLATABLE_TEXT_TYPE) then

Line 682: from dual;

678: -- create_descriptor that calls it, unlike the edit case
679: if (p_descriptor_id = -1) then
680: select icx_por_descriptorid.nextval
681: into p_descriptor_id_out
682: from dual;
683: end if;
684:
685: -- set the class value
686: IF (p_category_id = 0) THEN

Line 766: SELECT p_language FROM DUAL;

762: and type = p_type
763: and source_lang = p_language
764: and source_lang <> language
765: UNION
766: SELECT p_language FROM DUAL;
767:
768: BEGIN
769:
770: xErrLoc := 100;

Line 1451: FROM dual WHERE EXISTS (

1447:
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'));

Line 1460: FROM dual WHERE EXISTS (

1456: ELSE
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

Line 1490: FROM dual WHERE EXISTS (

1486:
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

Line 1498: FROM dual WHERE EXISTS (

1494: ELSE
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);

Line 1529: FROM dual WHERE EXISTS (

1525: l_num_val := 0;
1526:
1527: IF (p_owner_id = 0) THEN
1528: SELECT 1 INTO l_num_val
1529: FROM dual WHERE EXISTS (
1530: SELECT 1 FROM icx_cat_category_items);
1531:
1532: ELSE
1533: SELECT 1 INTO l_num_val

Line 1534: FROM dual WHERE EXISTS (

1530: SELECT 1 FROM icx_cat_category_items);
1531:
1532: ELSE
1533: SELECT 1 INTO l_num_val
1534: FROM dual WHERE EXISTS (
1535: SELECT 1 FROM icx_cat_category_items
1536: WHERE rt_category_id = p_owner_id);
1537:
1538: END IF;

Line 1620: FROM dual WHERE EXISTS (

1616:
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

Line 1629: FROM dual WHERE EXISTS (

1625: ELSE
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);

Line 1861: FROM dual

1857: l_progress := '006_1';
1858:
1859: -- check if there are any items in this category
1860: SELECT 1 INTO l_num_val
1861: FROM dual
1862: WHERE EXISTS (SELECT 1 FROM icx_cat_category_items
1863: WHERE rt_category_id = p_category_id);
1864:
1865: InsertError(p_request_id, 'ICX_POR_CATEGORY_KEY', 'ICX_POR_CAT_HAS_ITEMS',

Line 2132: FROM dual

2128: ELSIF (p_system_action = 'DELETE') THEN
2129:
2130: BEGIN
2131: SELECT 1 INTO l_num_val
2132: FROM dual
2133: WHERE exists (SELECT 1 FROM icx_cat_browse_trees
2134: WHERE parent_category_id = p_parent_id
2135: AND child_category_id = p_child_id);
2136:

Line 2181: FROM sys.dual;

2177: if (p_request_id is null) then
2178: l_progress := '002';
2179: SELECT icx_por_batch_jobs_s.nextval
2180: INTO p_request_id
2181: FROM sys.dual;
2182: end if;
2183:
2184: l_progress := '004';
2185: INSERT into icx_por_failed_line_messages (

Line 3100: update_tlp_sql_string := update_tlp_sql_string ||' ('||update_tlp_set_string||' ) = (select ' || update_tlp_value_string|| ' from dual) where primary_category_id = :cat_id';

3096: xErrLoc := 700;
3097:
3098: IF vRtCategoryIds(i) = 0 THEN
3099: update_tlp_sql_string := 'UPDATE ICX_CAT_ITEMS_TLP SET ';
3100: update_tlp_sql_string := update_tlp_sql_string ||' ('||update_tlp_set_string||' ) = (select ' || update_tlp_value_string|| ' from dual) where primary_category_id = :cat_id';
3101: xErrLoc := 750;
3102: DBMS_SQL.parse(v_cursor_id, update_tlp_sql_string, dbms_sql.native);
3103: -- Reset the values for reading next set of Base attributes for
3104: -- the next category

Line 3111: update_exttlp_sql_string := update_exttlp_sql_string||' ('||update_exttlp_set_string||' ) = (select ' || update_exttlp_value_string|| ' from dual) where rt_category_id = :cat_id';

3107: update_tlp_value_string := null;
3108: ELSE
3109: -- Process the category attributes just read for this category
3110: update_exttlp_sql_string := 'UPDATE ICX_CAT_EXT_ITEMS_TLP SET ';
3111: update_exttlp_sql_string := update_exttlp_sql_string||' ('||update_exttlp_set_string||' ) = (select ' || update_exttlp_value_string|| ' from dual) where rt_category_id = :cat_id';
3112: xErrLoc := 750;
3113: DBMS_SQL.parse(v_cursor_id, update_exttlp_sql_string, dbms_sql.native);
3114: -- Reset the values for reading next set of category attributes for
3115: -- the next category

Line 3208: SELECT p_language FROM DUAL;

3204: and type = 2
3205: and source_lang = p_language
3206: and source_lang <> language
3207: UNION
3208: SELECT p_language FROM DUAL;
3209: BEGIN
3210: --Set the commit size
3211: xErrLoc := 100;
3212: fnd_profile.get('POR_LOAD_PURGE_COMMIT_SIZE', xCommitSize);