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_CAT_SCHEMA_UPLOAD_PVT dependencies on DUAL

Line 86: FROM DUAL

82: -- descriptor keys
83: l_err_loc := 110;
84: SELECT 1
85: INTO l_num_val
86: FROM DUAL
87: WHERE EXISTS (SELECT 1
88: FROM icx_cat_attributes_tl
89: WHERE UPPER(key) = UPPER(p_key)
90: AND language = p_language);

Line 98: FROM DUAL

94: -- check that descriptor key has to be unique across all root descriptor
95: -- keys and descriptor keys within the category
96: SELECT 1
97: INTO l_num_val
98: FROM DUAL
99: WHERE EXISTS (SELECT 1
100: FROM icx_cat_attributes_tl
101: WHERE UPPER(key) = UPPER(p_key)
102: AND language = p_language

Line 131: FROM DUAL

127: l_err_loc := 220;
128: -- for base descriptor
129: SELECT 1
130: INTO l_num_val
131: FROM DUAL
132: WHERE EXISTS (SELECT 1
133: FROM icx_cat_attributes_tl
134: WHERE UPPER(attribute_name) = UPPER(p_name)
135: AND language = p_language);

Line 141: FROM DUAL

137: l_err_loc := 230;
138: -- for category descriptor
139: SELECT 1
140: INTO l_num_val
141: FROM DUAL
142: WHERE EXISTS (SELECT 1
143: FROM icx_cat_attributes_tl
144: WHERE UPPER(attribute_name) = UPPER(p_name)
145: AND language = p_language

Line 533: FROM dual;

529:
530: -- xxx why is the sequence icx_por_categoryid
531: SELECT icx_por_categoryid.nextval
532: INTO x_category_id
533: FROM dual;
534:
535: l_err_loc := 200;
536:
537: FOR language_row IN installed_languages_csr LOOP

Line 594: SELECT p_language FROM dual;

590: and type = p_type
591: and source_lang = p_language
592: and source_lang <> language
593: UNION
594: SELECT p_language FROM dual;
595:
596: BEGIN
597:
598: l_err_loc := 100;

Line 751: FROM dual

747: last_updated_by, last_update_date, last_update_login, request_id,
748: program_id, program_application_id, program_login_id)
749: SELECT 0, l_child_cat_table(i), p_user_id, sysdate, p_user_id, sysdate, p_login_id, p_request_id,
750: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id
751: FROM dual
752: WHERE l_child_cat_type_table(i) = 1
753: AND l_parent_cat_count_table(i) = 1;
754:
755: END IF; -- can_category_be...

Line 1021: FROM dual

1017:
1018: BEGIN
1019: SELECT 1
1020: INTO l_category_referenced
1021: FROM dual
1022: WHERE EXISTS (SELECT 1
1023: FROM icx_cat_items_ctx_hdrs_tlp
1024: WHERE ip_category_id = p_ip_category_id);
1025:

Line 1041: FROM dual

1037:
1038: BEGIN
1039: SELECT 1
1040: INTO l_category_referenced
1041: FROM dual
1042: WHERE EXISTS (SELECT 1
1043: FROM po_lines_all
1044: WHERE ip_category_id = p_ip_category_id);
1045:

Line 1060: FROM dual

1056:
1057: BEGIN
1058: SELECT 1
1059: INTO l_category_referenced
1060: FROM dual
1061: WHERE EXISTS (SELECT 1
1062: FROM po_lines_draft_all
1063: WHERE ip_category_id = p_ip_category_id);
1064:

Line 1078: FROM dual

1074:
1075: BEGIN
1076: SELECT 1
1077: INTO l_category_referenced
1078: FROM dual
1079: WHERE EXISTS (SELECT 1
1080: FROM pon_auction_item_prices_all
1081: WHERE ip_category_id = p_ip_category_id);
1082:

Line 1095: FROM dual

1091:
1092: BEGIN
1093: SELECT 1
1094: INTO l_category_referenced
1095: FROM dual
1096: WHERE EXISTS (SELECT 1
1097: FROM pon_item_prices_interface
1098: WHERE ip_category_id = p_ip_category_id);
1099:

Line 1112: FROM dual

1108:
1109: BEGIN
1110: SELECT 1
1111: INTO l_category_referenced
1112: FROM dual
1113: WHERE EXISTS (SELECT 1
1114: FROM pon_auc_items_interface
1115: WHERE ip_category_id = p_ip_category_id);
1116:

Line 1131: FROM dual

1127:
1128: BEGIN
1129: SELECT 1
1130: INTO l_category_referenced
1131: FROM dual
1132: WHERE EXISTS (SELECT 1
1133: FROM pon_item_prices_interface
1134: WHERE ip_category_name IN (SELECT category_name
1135: FROM icx_cat_categories_tl

Line 1196: FROM dual

1192: created_by, creation_date, last_updated_by, last_update_date, last_update_login,
1193: request_id, program_id, program_application_id, program_login_id)
1194: SELECT p_parent_id, p_child_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1195: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id
1196: FROM dual
1197: WHERE NOT EXISTS (SELECT 1
1198: FROM icx_cat_browse_trees
1199: WHERE parent_category_id = p_parent_id
1200: AND child_category_id = p_child_id);

Line 1222: FROM dual

1218: created_by, creation_date, last_updated_by, last_update_date, last_update_login,
1219: request_id, program_id, program_application_id, program_login_id)
1220: SELECT 0, p_parent_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1221: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id
1222: FROM dual
1223: WHERE NOT EXISTS (SELECT 1
1224: FROM icx_cat_browse_trees
1225: WHERE child_category_id = p_parent_id);
1226:

Line 1604: FROM dual

1600: l_err_loc := 560;
1601:
1602: BEGIN
1603: SELECT 1 INTO l_count
1604: FROM dual
1605: WHERE EXISTS (SELECT 1 FROM icx_cat_browse_trees
1606: WHERE parent_category_id = x_parent_id
1607: AND child_category_id = x_child_id);
1608:

Line 1735: FROM dual;

1731: -- now get the descriptor id from the sequence
1732: -- xxx change to icx_cat_attributes_s
1733: SELECT icx_por_descriptorid.nextval
1734: INTO x_descriptor_id
1735: FROM dual;
1736:
1737: l_err_loc := 200;
1738: -- now we create the descriptor
1739:

Line 2298: 'FROM dual ' ||

2294: -- now check in the po transaction table
2295: BEGIN
2296: EXECUTE IMMEDIATE
2297: 'SELECT 1 '||
2298: 'FROM dual ' ||
2299: 'WHERE EXISTS ( ' ||
2300: 'SELECT 1 ' ||
2301: 'FROM ' || l_stored_in_table ||
2302: ' WHERE ' || l_stored_in_table || '.' || l_stored_in_column || ' IS NOT NULL' ||

Line 2330: 'FROM dual ' ||

2326:
2327: BEGIN
2328: EXECUTE IMMEDIATE
2329: 'SELECT 1 '||
2330: 'FROM dual ' ||
2331: 'WHERE EXISTS ( ' ||
2332: 'SELECT 1 ' ||
2333: 'FROM ' || l_draft_stored_in_table ||
2334: ' WHERE ' || l_draft_stored_in_table || '.' || l_stored_in_column || ' IS NOT NULL' ||

Line 2351: FROM dual

2347:
2348: BEGIN
2349: SELECT 1
2350: INTO l_descriptor_referenced
2351: FROM dual
2352: WHERE EXISTS (SELECT 1
2353: FROM pon_auction_attributes
2354: WHERE ip_descriptor_id = p_descriptor_id
2355: AND ip_category_id = l_category_id);

Line 2369: FROM dual

2365:
2366: BEGIN
2367: SELECT 1
2368: INTO l_descriptor_referenced
2369: FROM dual
2370: WHERE EXISTS (SELECT 1
2371: FROM pon_auc_attributes_interface
2372: WHERE ip_descriptor_id = p_descriptor_id
2373: AND ip_category_id = l_category_id);

Line 2387: FROM dual

2383:
2384: BEGIN
2385: SELECT 1
2386: INTO l_descriptor_referenced
2387: FROM dual
2388: WHERE EXISTS (SELECT 1
2389: FROM pon_attributes_interface
2390: WHERE ip_descriptor_id = p_descriptor_id
2391: AND ip_category_id = l_category_id);

Line 2605: FROM DUAL

2601: IF (x_owner_id = 0) THEN
2602: l_err_loc := 552;
2603: SELECT 1
2604: INTO l_num_val
2605: FROM DUAL
2606: WHERE EXISTS (SELECT 1
2607: FROM icx_cat_attributes_tl
2608: WHERE UPPER(key) = UPPER(p_key)
2609: AND language = p_language);

Line 2614: FROM DUAL

2610: ELSE
2611: l_err_loc := 553;
2612: SELECT 1
2613: INTO l_num_val
2614: FROM DUAL
2615: WHERE EXISTS (SELECT 1
2616: FROM icx_cat_attributes_tl
2617: WHERE UPPER(key) = UPPER(p_key)
2618: AND language = p_language

Line 2656: FROM DUAL

2652: l_err_loc := 580;
2653: -- for base descriptor
2654: SELECT 1
2655: INTO l_num_val
2656: FROM DUAL
2657: WHERE EXISTS (SELECT 1
2658: FROM icx_cat_attributes_tl
2659: WHERE UPPER(attribute_name) = UPPER(p_name)
2660: AND language = p_language);

Line 2666: FROM DUAL

2662: l_err_loc := 590;
2663: -- for category descriptor
2664: SELECT 1
2665: INTO l_num_val
2666: FROM DUAL
2667: WHERE EXISTS (SELECT 1
2668: FROM icx_cat_attributes_tl
2669: WHERE UPPER(attribute_name) = UPPER(p_name)
2670: AND language = p_language

Line 2796: FROM dual

2792: l_err_loc := 700;
2793: -- for base descriptor
2794: SELECT 1
2795: INTO l_num_val
2796: FROM dual
2797: WHERE EXISTS (SELECT 1
2798: FROM icx_cat_attributes_tl
2799: WHERE UPPER(attribute_name) = UPPER(p_name)
2800: AND attribute_id <> x_descriptor_id);

Line 2806: FROM dual

2802: l_err_loc := 710;
2803: -- for category descriptor
2804: SELECT 1
2805: INTO l_num_val
2806: FROM dual
2807: WHERE EXISTS (SELECT 1
2808: FROM icx_cat_attributes_tl
2809: WHERE UPPER(attribute_name) = UPPER(p_name)
2810: AND (rt_category_id = x_owner_id OR

Line 3120: -- for special descriptors we have individual rows so we call it one

3116: FOR special_descriptor_row IN populate_special_descs_csr LOOP
3117:
3118: l_err_loc := 210;
3119:
3120: -- for special descriptors we have individual rows so we call it one
3121: -- descriptor at a time
3122:
3123: ICX_CAT_POPULATE_CTXSTRING_PVT.rePopulateBaseAttributes(special_descriptor_row.key,
3124: special_descriptor_row.searchable);