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_R12_UPGRADE_PVT dependencies on ICX_CAT_FAV_LIST_HEADERS

Line 6266: INSERT INTO icx_cat_fav_list_headers

6262: 'Started at:' || TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS') );
6263: END IF;
6264:
6265: l_err_loc := 150;
6266: INSERT INTO icx_cat_fav_list_headers
6267: (
6268: employee_id, favorite_list_id, favorite_list_name,
6269: last_update_date, last_updated_by, last_update_login,
6270: creation_date, created_by,

Line 6288: FROM icx_cat_fav_list_headers new_fav_hdrs

6284: attribute11, attribute12, attribute13, attribute14, attribute15,
6285: primary_flag
6286: FROM por_favorite_list_headers old_fav_hdrs
6287: WHERE NOT EXISTS (SELECT NULL
6288: FROM icx_cat_fav_list_headers new_fav_hdrs
6289: WHERE new_fav_hdrs.employee_id = old_fav_hdrs.employee_id
6290: AND new_fav_hdrs.favorite_list_id = old_fav_hdrs.favorite_list_id);
6291:
6292: l_err_loc := 200;

Line 6296: 'No: of rows inserted into icx_cat_fav_list_headers during upgrade:' || SQL%ROWCOUNT);

6292: l_err_loc := 200;
6293: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6294: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,
6295: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6296: 'No: of rows inserted into icx_cat_fav_list_headers during upgrade:' || SQL%ROWCOUNT);
6297: END IF;
6298:
6299: l_err_loc := 250;
6300: COMMIT;

Line 6303: -- Update the primary_flag in icx_cat_fav_list_headers

6299: l_err_loc := 250;
6300: COMMIT;
6301:
6302: l_err_loc := 300;
6303: -- Update the primary_flag in icx_cat_fav_list_headers
6304: l_continue := TRUE;
6305: WHILE l_continue LOOP
6306: l_err_loc := 400;
6307: UPDATE icx_cat_fav_list_headers favout

Line 6307: UPDATE icx_cat_fav_list_headers favout

6303: -- Update the primary_flag in icx_cat_fav_list_headers
6304: l_continue := TRUE;
6305: WHILE l_continue LOOP
6306: l_err_loc := 400;
6307: UPDATE icx_cat_fav_list_headers favout
6308: SET primary_flag = 'Y'
6309: WHERE primary_flag is null
6310: AND favorite_list_name = 'POR_FAVORITE_LIST'
6311: AND NOT EXISTS (SELECT 'x' FROM icx_cat_fav_list_headers favin

Line 6311: AND NOT EXISTS (SELECT 'x' FROM icx_cat_fav_list_headers favin

6307: UPDATE icx_cat_fav_list_headers favout
6308: SET primary_flag = 'Y'
6309: WHERE primary_flag is null
6310: AND favorite_list_name = 'POR_FAVORITE_LIST'
6311: AND NOT EXISTS (SELECT 'x' FROM icx_cat_fav_list_headers favin
6312: WHERE favin.employee_id = favout.employee_id
6313: AND favin.primary_flag = 'Y')
6314: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size;
6315:

Line 6328: 'No: of rows updated in icx_cat_fav_list_headers for primary_flag:' || l_row_count);

6324: l_err_loc := 550;
6325: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6326: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
6327: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
6328: 'No: of rows updated in icx_cat_fav_list_headers for primary_flag:' || l_row_count);
6329: END IF;
6330:
6331: l_err_loc := 600;
6332: COMMIT;

Line 7312: DELETE FROM icx_cat_fav_list_headers hdrs

7308: l_favorite_list_id_tbl.DELETE;
7309: l_employee_id_tbl.DELETE;
7310:
7311: l_err_loc := 12000;
7312: DELETE FROM icx_cat_fav_list_headers hdrs
7313: WHERE NOT EXISTS ( SELECT 'x' FROM icx_cat_fav_list_lines_tlp lines
7314: WHERE lines.favorite_list_id = hdrs.favorite_list_id)
7315: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size
7316: RETURNING favorite_list_id, employee_id

Line 7334: 'No: of rows deleted from icx_cat_fav_list_headers for which there are no lines:' || l_row_count);

7330: IF (l_favorite_list_id_tbl.COUNT > 0) THEN
7331: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7332: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7333: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7334: 'No: of rows deleted from icx_cat_fav_list_headers for which there are no lines:' || l_row_count);
7335: FOR i IN 1..l_favorite_list_id_tbl.COUNT LOOP
7336: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
7337: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
7338: 'l_favorite_list_id_tbl(i):' || l_favorite_list_id_tbl(i) ||