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 ICX_CAT_CATEGORIES_TL

Line 198: FROM icx_cat_categories_tl

194: l_err_loc := 325;
195:
196: SELECT instr(section_map, '0', l_start_pos, 1)
197: INTO l_first_zero_pos
198: FROM icx_cat_categories_tl
199: WHERE rt_category_id = 0
200: AND language = p_language;
201:
202: l_err_loc := 330;

Line 237: FROM icx_cat_categories_tl

233: l_err_loc := 350;
234:
235: SELECT instr(section_map, '0', l_start_pos, 1)
236: INTO l_first_zero_pos
237: FROM icx_cat_categories_tl
238: WHERE rt_category_id = p_cat_id
239: AND language = p_language;
240:
241: l_err_loc := 355;

Line 541: INSERT INTO icx_cat_categories_tl

537: FOR language_row IN installed_languages_csr LOOP
538:
539: l_err_loc := 300;
540:
541: INSERT INTO icx_cat_categories_tl
542: (rt_category_id, language, source_lang, category_name, description, type,
543: key, upper_key, upper_category_name, request_id, rebuild_flag, section_map,
544: created_by, creation_date, last_updated_by, last_update_date, last_update_login,
545: program_id, program_application_id, program_login_id)

Line 588: FROM icx_cat_categories_tl

584:
585: CURSOR translate_category_lang_csr
586: IS
587: SELECT language
588: FROM icx_cat_categories_tl
589: WHERE rt_category_id = p_category_id
590: and type = p_type
591: and source_lang = p_language
592: and source_lang <> language

Line 612: UPDATE icx_cat_categories_tl

608: -- only for those langauages that were sourced from current lang
609: -- and have not themselves been translated
610: -- only description can be specified as #DEL
611: FORALL i in 1..l_lang_table.COUNT
612: UPDATE icx_cat_categories_tl
613: SET category_name = nvl(p_name, category_name),
614: upper_category_name = nvl(upper(p_name), upper_category_name),
615: description = decode(p_description, '#DEL', null, null, description, p_description),
616: source_lang = p_language,

Line 676: FROM icx_cat_browse_trees browse, icx_cat_categories_tl cat

672:
673: CURSOR category_children_csr
674: IS
675: SELECT browse.child_category_id, cat.type, count(*)
676: FROM icx_cat_browse_trees browse, icx_cat_categories_tl cat
677: WHERE browse.child_category_id IN
678: (SELECT child_category_id
679: FROM icx_cat_browse_trees
680: WHERE parent_category_id = p_category_id)

Line 701: DELETE FROM icx_cat_categories_tl

697: l_err_loc := 300;
698: -- now we can safely begin the delete category process
699:
700: -- first delete the category itself
701: DELETE FROM icx_cat_categories_tl
702: WHERE rt_category_id = p_category_id;
703:
704: l_err_loc := 310;
705:

Line 818: FROM icx_cat_categories_tl

814: BEGIN
815:
816: SELECT rt_category_id, type
817: INTO x_category_id, l_current_type
818: FROM icx_cat_categories_tl
819: WHERE upper_key = upper(p_key)
820: AND language = p_language
821: AND rownum = 1;
822:

Line 913: FROM icx_cat_categories_tl

909: x_is_valid := 'N';
910: ELSE
911: l_err_loc := 520;
912: SELECT count(1) INTO l_count
913: FROM icx_cat_categories_tl
914: WHERE upper_category_name = UPPER(p_name);
915:
916: l_err_loc := 530;
917:

Line 943: FROM icx_cat_categories_tl

939:
940: IF (p_name IS NOT NULL) THEN
941: l_err_loc := 610;
942: SELECT count(1) INTO l_count
943: FROM icx_cat_categories_tl
944: WHERE upper_category_name = UPPER(p_name)
945: and rt_category_id <> x_category_id;
946:
947: l_err_loc := 620;

Line 1135: FROM icx_cat_categories_tl

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
1136: WHERE rt_category_id = p_ip_category_id));
1137:
1138: l_err_loc := 750;
1139:

Line 1178: FROM icx_cat_categories_tl

1174: l_err_loc := 100;
1175:
1176: SELECT type
1177: INTO l_type
1178: FROM icx_cat_categories_tl
1179: WHERE rt_category_id = p_parent_id
1180: AND rownum = 1;
1181:
1182: l_err_loc := 110;

Line 1272: FROM icx_cat_categories_tl

1268: -- xxx should we add a link from child to root if no parent exists
1269:
1270: SELECT type
1271: INTO l_type
1272: FROM icx_cat_categories_tl
1273: WHERE rt_category_id = p_parent_id
1274: AND rownum = 1;
1275:
1276: l_err_loc := 110;

Line 1374: FROM icx_cat_categories_tl

1370: BEGIN
1371:
1372: SELECT rt_category_id, type
1373: INTO x_parent_id, l_parent_type
1374: FROM icx_cat_categories_tl
1375: WHERE upper_key = UPPER(p_parent_key)
1376: AND language = p_language;
1377:
1378: l_err_loc := 180;

Line 1401: FROM icx_cat_categories_tl

1397: BEGIN
1398:
1399: SELECT rt_category_id, type
1400: INTO l_parent_id_from_name, l_parent_type
1401: FROM icx_cat_categories_tl
1402: WHERE upper_category_name = UPPER(p_parent_name)
1403: AND language = p_language;
1404:
1405: l_err_loc := 220;

Line 1480: FROM icx_cat_categories_tl

1476: BEGIN
1477:
1478: SELECT rt_category_id
1479: INTO x_child_id
1480: FROM icx_cat_categories_tl
1481: WHERE upper_key = UPPER(p_child_key)
1482: AND language = p_language;
1483:
1484: l_err_loc := 350;

Line 1507: FROM icx_cat_categories_tl

1503: BEGIN
1504:
1505: SELECT rt_category_id
1506: INTO l_child_id_from_name
1507: FROM icx_cat_categories_tl
1508: WHERE upper_category_name = UPPER(p_child_name)
1509: AND language = p_language;
1510:
1511: l_err_loc := 390;

Line 1833: -- Before calling this the rows in icx_cat_categories_tl with the

1829:
1830: -- Procedure to assign the section tag to a given descriptor
1831: -- If the descriptor is already assigned a section tag it will be returned
1832: -- xxx we are not doing select for update now?
1833: -- Before calling this the rows in icx_cat_categories_tl with the
1834: -- given rt_category_id should be locked thru a SELECT...FOR UPDATE
1835: -- to avoid concurrent access to the SECTION_MAP column. The calling
1836: -- code is responsible for committing the changes.
1837: PROCEDURE assign_section_tag

Line 1874: FROM icx_cat_categories_tl

1870:
1871: l_err_loc := 120;
1872: SELECT section_map, INSTR(section_map, '0', 1, 1)
1873: INTO l_section_map, p_section_tag
1874: FROM icx_cat_categories_tl
1875: WHERE rt_category_id = p_category_id
1876: AND rownum = 1;
1877:
1878: ELSIF (p_type = 1) THEN

Line 1883: FROM icx_cat_categories_tl

1879:
1880: l_err_loc := 130;
1881: SELECT section_map, INSTR(section_map, '0', 101, 1)
1882: INTO l_section_map, p_section_tag
1883: FROM icx_cat_categories_tl
1884: WHERE rt_category_id = p_category_id
1885: AND rownum = 1;
1886:
1887: ELSIF (p_type = 2) THEN

Line 1892: FROM icx_cat_categories_tl

1888:
1889: l_err_loc := 140;
1890: SELECT section_map, INSTR(section_map, '0', 201, 1)
1891: INTO l_section_map, p_section_tag
1892: FROM icx_cat_categories_tl
1893: WHERE rt_category_id = p_category_id
1894: AND rownum = 1;
1895: END IF;
1896:

Line 1959: UPDATE icx_cat_categories_tl

1955:
1956: l_err_loc := 240;
1957: -- now we update the category table with the section map
1958:
1959: UPDATE icx_cat_categories_tl
1960: SET section_map = l_section_map,
1961: request_id = p_request_id,
1962: program_id = fnd_global.conc_program_id,
1963: program_application_id = fnd_global.prog_appl_id,

Line 2002: -- Before calling this the rows in icx_cat_categories_tl with the

1998:
1999: -- Procedure to release the section tag to a given descriptor
2000: -- should be called before the descriptor is actually deleted
2001: -- xxx we are not doing select for update now?
2002: -- Before calling this the rows in icx_cat_categories_tl with the
2003: -- given rt_category_id should be locked thru a SELECT...FOR UPDATE
2004: -- to avoid concurrent access to the SECTION_MAP column. The calling
2005: -- code is responsible for committing the changes.
2006: PROCEDURE release_section_tag

Line 2024: FROM icx_cat_categories_tl

2020:
2021: -- first get the existing section map
2022: SELECT section_map
2023: INTO l_section_map
2024: FROM icx_cat_categories_tl
2025: WHERE rt_category_id = p_category_id
2026: AND rownum = 1;
2027:
2028: l_err_loc := 110;

Line 2071: UPDATE icx_cat_categories_tl

2067:
2068: l_err_loc := 150;
2069: -- now update the section map in the categories table
2070:
2071: UPDATE icx_cat_categories_tl
2072: SET section_map = l_section_map,
2073: request_id = p_request_id,
2074: program_id = fnd_global.conc_program_id,
2075: program_application_id = fnd_global.prog_appl_id,

Line 2468: FROM icx_cat_categories_tl

2464: l_err_loc := 130;
2465:
2466: SELECT rt_category_id
2467: INTO x_owner_id
2468: FROM icx_cat_categories_tl
2469: WHERE upper_key = UPPER(p_owner_key)
2470: AND language = p_language
2471: AND type IN (0,2);
2472:

Line 2493: FROM icx_cat_categories_tl

2489: l_err_loc := 160;
2490:
2491: SELECT rt_category_id
2492: INTO l_owner_id_from_name
2493: FROM icx_cat_categories_tl
2494: WHERE upper_category_name = UPPER(p_owner_name)
2495: AND language = p_language
2496: AND type IN (0,2);
2497:

Line 2722: FROM icx_cat_categories_tl

2718: l_err_loc := 645;
2719:
2720: SELECT instr(section_map, '0', l_start_pos, 1)
2721: INTO l_first_zero_pos
2722: FROM icx_cat_categories_tl
2723: WHERE rt_category_id = 0
2724: AND language = p_language;
2725:
2726: l_err_loc := 650;

Line 2762: FROM icx_cat_categories_tl

2758: l_err_loc := 672;
2759:
2760: SELECT instr(section_map, '0', l_start_pos, 1)
2761: INTO l_first_zero_pos
2762: FROM icx_cat_categories_tl
2763: WHERE rt_category_id = x_owner_id
2764: AND language = p_language;
2765:
2766: l_err_loc := 675;

Line 3061: FROM icx_cat_categories_tl

3057: -- cursor to handle category name change
3058: CURSOR populate_category_csr
3059: IS
3060: SELECT rt_category_id, category_name, language
3061: FROM icx_cat_categories_tl
3062: WHERE request_id = p_request_id
3063: AND rebuild_flag = 'Y';
3064:
3065: -- cursor to handle special descriptor update

Line 3170: UPDATE icx_cat_categories_tl

3166:
3167: l_err_loc := 500;
3168:
3169: -- reset rebuild flag to null
3170: UPDATE icx_cat_categories_tl
3171: SET rebuild_flag = null
3172: WHERE rebuild_flag is not null;
3173:
3174: l_err_loc := 600;