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