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 FND_GLOBAL

Line 462: p_descriptor_value, p_request_id, fnd_global.conc_program_id,

458: INSERT INTO icx_por_failed_lines
459: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
460: request_id, program_id, program_application_id, program_login_id)
461: VALUES (p_request_id, p_line_number, p_action, p_row_type, p_descriptor_key,
462: p_descriptor_value, p_request_id, fnd_global.conc_program_id,
463: fnd_global.prog_appl_id, fnd_global.conc_login_id);
464:
465: l_err_loc := 200;
466: COMMIT;

Line 463: fnd_global.prog_appl_id, fnd_global.conc_login_id);

459: (job_number, line_number, action, row_type, descriptor_key, descriptor_value,
460: request_id, program_id, program_application_id, program_login_id)
461: VALUES (p_request_id, p_line_number, p_action, p_row_type, p_descriptor_key,
462: p_descriptor_value, p_request_id, fnd_global.conc_program_id,
463: fnd_global.prog_appl_id, fnd_global.conc_login_id);
464:
465: l_err_loc := 200;
466: COMMIT;
467:

Line 494: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

490: INSERT INTO icx_por_failed_line_messages
491: (job_number, descriptor_key, message_name, line_number, request_id, program_id,
492: program_application_id, program_login_id)
493: VALUES (p_request_id, p_descriptor_key, p_message_name, p_line_number, p_request_id,
494: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
495:
496: l_err_loc := 200;
497: COMMIT;
498:

Line 549: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);

545: program_id, program_application_id, program_login_id)
546: VALUES (x_category_id, language_row.language_code, p_language, p_name,
547: p_description, p_type, p_key, upper(p_key), upper(p_name), p_request_id,
548: 'N', lpad('0', '300', '0'), p_user_id, sysdate, p_user_id, sysdate, p_login_id,
549: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id);
550:
551: END LOOP;
552:
553: l_err_loc := 400;

Line 622: program_id = fnd_global.conc_program_id,

618: last_update_date = sysdate,
619: last_update_login = p_login_id,
620: request_id = p_request_id,
621: rebuild_flag = decode(p_name, category_name, rebuild_flag, null, rebuild_flag, 'Y'),
622: program_id = fnd_global.conc_program_id,
623: program_application_id = fnd_global.prog_appl_id,
624: program_login_id = fnd_global.conc_login_id
625: WHERE rt_category_id = p_category_id
626: AND language = l_lang_table(i);

Line 623: program_application_id = fnd_global.prog_appl_id,

619: last_update_login = p_login_id,
620: request_id = p_request_id,
621: rebuild_flag = decode(p_name, category_name, rebuild_flag, null, rebuild_flag, 'Y'),
622: program_id = fnd_global.conc_program_id,
623: program_application_id = fnd_global.prog_appl_id,
624: program_login_id = fnd_global.conc_login_id
625: WHERE rt_category_id = p_category_id
626: AND language = l_lang_table(i);
627:

Line 624: program_login_id = fnd_global.conc_login_id

620: request_id = p_request_id,
621: rebuild_flag = decode(p_name, category_name, rebuild_flag, null, rebuild_flag, 'Y'),
622: program_id = fnd_global.conc_program_id,
623: program_application_id = fnd_global.prog_appl_id,
624: program_login_id = fnd_global.conc_login_id
625: WHERE rt_category_id = p_category_id
626: AND language = l_lang_table(i);
627:
628: l_err_loc := 300;

Line 750: fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id

746: (parent_category_id, child_category_id, created_by, creation_date,
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:

Line 1195: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id

1191: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,
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

Line 1221: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id

1217: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,
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);

Line 1749: p_user_id, sysdate, p_login_id, fnd_global.conc_program_id,

1745: SELECT x_descriptor_id, p_category_id, fnd_languages.language_code, p_language,
1746: p_name, decode(p_description, '#DEL', null, p_description), to_number(l_type),
1747: p_key, l_sequence, to_number(l_searchable), l_search_results_visible,
1748: l_item_detail_visible, p_request_id, 'N', p_user_id, sysdate,
1749: p_user_id, sysdate, p_login_id, fnd_global.conc_program_id,
1750: fnd_global.prog_appl_id, fnd_global.conc_login_id
1751: FROM fnd_languages
1752: WHERE installed_flag IN ('B', 'I');
1753:

Line 1750: fnd_global.prog_appl_id, fnd_global.conc_login_id

1746: p_name, decode(p_description, '#DEL', null, p_description), to_number(l_type),
1747: p_key, l_sequence, to_number(l_searchable), l_search_results_visible,
1748: l_item_detail_visible, p_request_id, 'N', p_user_id, sysdate,
1749: p_user_id, sysdate, p_login_id, fnd_global.conc_program_id,
1750: fnd_global.prog_appl_id, fnd_global.conc_login_id
1751: FROM fnd_languages
1752: WHERE installed_flag IN ('B', 'I');
1753:
1754: l_err_loc := 210;

Line 1811: program_id = fnd_global.conc_program_id,

1807: last_updated_by = p_user_id,
1808: last_update_date = sysdate,
1809: last_update_login = p_login_id,
1810: request_id = p_request_id,
1811: program_id = fnd_global.conc_program_id,
1812: program_application_id = fnd_global.prog_appl_id,
1813: program_login_id = fnd_global.conc_login_id
1814: WHERE descriptor_set_id = l_attribute_id;
1815:

Line 1812: program_application_id = fnd_global.prog_appl_id,

1808: last_update_date = sysdate,
1809: last_update_login = p_login_id,
1810: request_id = p_request_id,
1811: program_id = fnd_global.conc_program_id,
1812: program_application_id = fnd_global.prog_appl_id,
1813: program_login_id = fnd_global.conc_login_id
1814: WHERE descriptor_set_id = l_attribute_id;
1815:
1816: l_err_loc := 140;

Line 1813: program_login_id = fnd_global.conc_login_id

1809: last_update_login = p_login_id,
1810: request_id = p_request_id,
1811: program_id = fnd_global.conc_program_id,
1812: program_application_id = fnd_global.prog_appl_id,
1813: program_login_id = fnd_global.conc_login_id
1814: WHERE descriptor_set_id = l_attribute_id;
1815:
1816: l_err_loc := 140;
1817:

Line 1962: program_id = fnd_global.conc_program_id,

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,
1964: program_login_id = fnd_global.conc_login_id
1965: WHERE rt_category_id = p_category_id;
1966:

Line 1963: program_application_id = fnd_global.prog_appl_id,

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,
1964: program_login_id = fnd_global.conc_login_id
1965: WHERE rt_category_id = p_category_id;
1966:
1967: l_err_loc := 250;

Line 1964: program_login_id = fnd_global.conc_login_id

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,
1964: program_login_id = fnd_global.conc_login_id
1965: WHERE rt_category_id = p_category_id;
1966:
1967: l_err_loc := 250;
1968: -- now we update the attributes table with the section tag,

Line 1975: program_id = fnd_global.conc_program_id,

1971: SET section_tag = p_section_tag,
1972: stored_in_table = p_stored_in_table,
1973: stored_in_column = p_stored_in_column,
1974: request_id = p_request_id,
1975: program_id = fnd_global.conc_program_id,
1976: program_application_id = fnd_global.prog_appl_id,
1977: program_login_id = fnd_global.conc_login_id
1978: WHERE attribute_id = p_descriptor_id;
1979:

Line 1976: program_application_id = fnd_global.prog_appl_id,

1972: stored_in_table = p_stored_in_table,
1973: stored_in_column = p_stored_in_column,
1974: request_id = p_request_id,
1975: program_id = fnd_global.conc_program_id,
1976: program_application_id = fnd_global.prog_appl_id,
1977: program_login_id = fnd_global.conc_login_id
1978: WHERE attribute_id = p_descriptor_id;
1979:
1980: l_err_loc := 260;

Line 1977: program_login_id = fnd_global.conc_login_id

1973: stored_in_column = p_stored_in_column,
1974: request_id = p_request_id,
1975: program_id = fnd_global.conc_program_id,
1976: program_application_id = fnd_global.prog_appl_id,
1977: program_login_id = fnd_global.conc_login_id
1978: WHERE attribute_id = p_descriptor_id;
1979:
1980: l_err_loc := 260;
1981:

Line 2048: program_id = fnd_global.conc_program_id,

2044: -- now nullify the section tag in attributes table
2045: UPDATE icx_cat_attributes_tl
2046: SET section_tag = null,
2047: request_id = p_request_id,
2048: program_id = fnd_global.conc_program_id,
2049: program_application_id = fnd_global.prog_appl_id,
2050: program_login_id = fnd_global.conc_login_id
2051: WHERE attribute_id = p_descriptor_id;
2052:

Line 2049: program_application_id = fnd_global.prog_appl_id,

2045: UPDATE icx_cat_attributes_tl
2046: SET section_tag = null,
2047: request_id = p_request_id,
2048: program_id = fnd_global.conc_program_id,
2049: program_application_id = fnd_global.prog_appl_id,
2050: program_login_id = fnd_global.conc_login_id
2051: WHERE attribute_id = p_descriptor_id;
2052:
2053: l_err_loc := 140;

Line 2050: program_login_id = fnd_global.conc_login_id

2046: SET section_tag = null,
2047: request_id = p_request_id,
2048: program_id = fnd_global.conc_program_id,
2049: program_application_id = fnd_global.prog_appl_id,
2050: program_login_id = fnd_global.conc_login_id
2051: WHERE attribute_id = p_descriptor_id;
2052:
2053: l_err_loc := 140;
2054:

Line 2074: program_id = fnd_global.conc_program_id,

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,
2076: program_login_id = fnd_global.conc_login_id
2077: WHERE rt_category_id = p_category_id;
2078:

Line 2075: program_application_id = fnd_global.prog_appl_id,

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,
2076: program_login_id = fnd_global.conc_login_id
2077: WHERE rt_category_id = p_category_id;
2078:
2079: l_err_loc := 160;

Line 2076: program_login_id = fnd_global.conc_login_id

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,
2076: program_login_id = fnd_global.conc_login_id
2077: WHERE rt_category_id = p_category_id;
2078:
2079: l_err_loc := 160;
2080:

Line 2147: program_id = fnd_global.conc_program_id,

2143: last_updated_by = p_user_id,
2144: last_update_date = sysdate,
2145: last_update_login = p_login_id,
2146: request_id = p_request_id,
2147: program_id = fnd_global.conc_program_id,
2148: program_application_id = fnd_global.prog_appl_id,
2149: program_login_id = fnd_global.conc_login_id
2150: WHERE attribute_id = p_descriptor_id
2151: AND language = p_language;

Line 2148: program_application_id = fnd_global.prog_appl_id,

2144: last_update_date = sysdate,
2145: last_update_login = p_login_id,
2146: request_id = p_request_id,
2147: program_id = fnd_global.conc_program_id,
2148: program_application_id = fnd_global.prog_appl_id,
2149: program_login_id = fnd_global.conc_login_id
2150: WHERE attribute_id = p_descriptor_id
2151: AND language = p_language;
2152:

Line 2149: program_login_id = fnd_global.conc_login_id

2145: last_update_login = p_login_id,
2146: request_id = p_request_id,
2147: program_id = fnd_global.conc_program_id,
2148: program_application_id = fnd_global.prog_appl_id,
2149: program_login_id = fnd_global.conc_login_id
2150: WHERE attribute_id = p_descriptor_id
2151: AND language = p_language;
2152:
2153: l_err_loc := 130;

Line 2166: program_id = fnd_global.conc_program_id,

2162: last_updated_by = p_user_id,
2163: last_update_date = sysdate,
2164: last_update_login = p_login_id,
2165: request_id = p_request_id,
2166: program_id = fnd_global.conc_program_id,
2167: program_application_id = fnd_global.prog_appl_id,
2168: program_login_id = fnd_global.conc_login_id
2169: WHERE attribute_id = p_descriptor_id;
2170:

Line 2167: program_application_id = fnd_global.prog_appl_id,

2163: last_update_date = sysdate,
2164: last_update_login = p_login_id,
2165: request_id = p_request_id,
2166: program_id = fnd_global.conc_program_id,
2167: program_application_id = fnd_global.prog_appl_id,
2168: program_login_id = fnd_global.conc_login_id
2169: WHERE attribute_id = p_descriptor_id;
2170:
2171: l_err_loc := 140;

Line 2168: program_login_id = fnd_global.conc_login_id

2164: last_update_login = p_login_id,
2165: request_id = p_request_id,
2166: program_id = fnd_global.conc_program_id,
2167: program_application_id = fnd_global.prog_appl_id,
2168: program_login_id = fnd_global.conc_login_id
2169: WHERE attribute_id = p_descriptor_id;
2170:
2171: l_err_loc := 140;
2172:

Line 3215: l_request_id := fnd_global.conc_request_id;

3211:
3212: l_err_loc := 100;
3213:
3214: -- get the concurrent request ID
3215: l_request_id := fnd_global.conc_request_id;
3216:
3217: l_err_loc := 150;
3218:
3219: update_job_status(l_request_id, 'RUNNING');

Line 3265: l_request_id := fnd_global.conc_request_id;

3261:
3262: l_err_loc := 100;
3263:
3264: -- get the concurrent request ID
3265: l_request_id := fnd_global.conc_request_id;
3266:
3267: l_err_loc := 150;
3268:
3269: update_job_status(l_request_id, 'RUNNING');

Line 3312: last_updated_by = fnd_global.user_id,

3308: l_err_loc := 100;
3309:
3310: UPDATE icx_cat_batch_jobs
3311: SET job_status = p_job_status,
3312: last_updated_by = fnd_global.user_id,
3313: last_update_date = sysdate,
3314: last_update_login = fnd_global.login_id
3315: WHERE job_number = p_job_number;
3316:

Line 3314: last_update_login = fnd_global.login_id

3310: UPDATE icx_cat_batch_jobs
3311: SET job_status = p_job_status,
3312: last_updated_by = fnd_global.user_id,
3313: last_update_date = sysdate,
3314: last_update_login = fnd_global.login_id
3315: WHERE job_number = p_job_number;
3316:
3317: l_err_loc := 200;
3318: