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_LINES_TLP

Line 216: --INSERT icx_cat_fav_list_lines_tlp for catalog items

212: gDRURtItemIdTbl DBMS_SQL.NUMBER_TABLE;
213: gDRUPoInterfaceHeaderIdTbl DBMS_SQL.NUMBER_TABLE;
214: gDRUPoInterfaceLineIdTbl DBMS_SQL.NUMBER_TABLE;
215:
216: --INSERT icx_cat_fav_list_lines_tlp for catalog items
217: gIFLCFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
218: gIFLCNewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
219: gIFLCOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
220: gIFLCRtItemIdTbl DBMS_SQL.NUMBER_TABLE;

Line 225: --INSERT icx_cat_fav_list_lines_tlp for other items

221: gIFLCSourceTypeTbl DBMS_SQL.VARCHAR2_TABLE;
222: gIFLCOrgIdTbl DBMS_SQL.NUMBER_TABLE;
223: gIFLCLanguageTbl DBMS_SQL.VARCHAR2_TABLE;
224:
225: --INSERT icx_cat_fav_list_lines_tlp for other items
226: gIFLOFavoriteListIdTbl DBMS_SQL.NUMBER_TABLE;
227: gIFLONewFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
228: gIFLOOldFavoriteListLineIdTbl DBMS_SQL.NUMBER_TABLE;
229: gIFLOOrgIdTbl DBMS_SQL.NUMBER_TABLE;

Line 340: --INSERT icx_cat_fav_list_lines_tlp for catalog items

336: gDRUPoInterfaceLineIdTbl.DELETE;
337: END IF;
338:
339: IF (p_action_mode IN ('ALL', 'INSERT_FAV_LINES_CATALOG')) THEN
340: --INSERT icx_cat_fav_list_lines_tlp for catalog items
341: gIFLCFavoriteListIdTbl.DELETE;
342: gIFLCNewFavoriteListLineIdTbl.DELETE;
343: gIFLCOldFavoriteListLineIdTbl.DELETE;
344: gIFLCRtItemIdTbl.DELETE;

Line 351: --INSERT icx_cat_fav_list_lines_tlp for other items

347: gIFLCLanguageTbl.DELETE;
348: END IF;
349:
350: IF (p_action_mode IN ('ALL', 'INSERT_FAV_LINES_OTHER')) THEN
351: --INSERT icx_cat_fav_list_lines_tlp for other items
352: gIFLOFavoriteListIdTbl.DELETE;
353: gIFLONewFavoriteListLineIdTbl.DELETE;
354: gIFLOOldFavoriteListLineIdTbl.DELETE;
355: gIFLOOrgIdTbl.DELETE;

Line 546: --INSERT icx_cat_fav_list_lines_tlp for catalog items

542: ICX_CAT_UTIL_PVT.getTableElement(gDRUPoInterfaceLineIdTbl, p_index) || ', ';
543: END IF;
544:
545: IF (p_action_mode = 'INSERT_FAV_LINES_CATALOG') THEN
546: --INSERT icx_cat_fav_list_lines_tlp for catalog items
547: l_string := l_string || ' gIFLCFavoriteListIdTbl: ' ||
548: ICX_CAT_UTIL_PVT.getTableElement(gIFLCFavoriteListIdTbl, p_index) || ', ';
549: l_string := l_string || ' gIFLCNewFavoriteListLineIdTbl: ' ||
550: ICX_CAT_UTIL_PVT.getTableElement(gIFLCNewFavoriteListLineIdTbl, p_index) || ', ';

Line 564: --INSERT icx_cat_fav_list_lines_tlp for other items

560: ICX_CAT_UTIL_PVT.getTableElement(gIFLCLanguageTbl, p_index) || ', ';
561: END IF;
562:
563: IF (p_action_mode = 'INSERT_FAV_LINES_OTHER') THEN
564: --INSERT icx_cat_fav_list_lines_tlp for other items
565: l_string := l_string || ' gIFLOFavoriteListIdTbl: ' ||
566: ICX_CAT_UTIL_PVT.getTableElement(gIFLOFavoriteListIdTbl, p_index) || ', ';
567: l_string := l_string || ' gIFLONewFavoriteListLineIdTbl: ' ||
568: ICX_CAT_UTIL_PVT.getTableElement(gIFLONewFavoriteListLineIdTbl, p_index) || ', ';

Line 947: --INSERT icx_cat_fav_list_lines_tlp for catalog items

943: l_err_loc := 1800;
944:
945: IF (p_action_mode = 'INSERT_FAV_LINES_CATALOG') THEN
946: l_err_loc := 1900;
947: --INSERT icx_cat_fav_list_lines_tlp for catalog items
948: l_log_string := ' gIFLCFavoriteListIdTbl: ' ||
949: ICX_CAT_UTIL_PVT.getTableElement(gIFLCFavoriteListIdTbl, p_index) || '; ';
950: FND_LOG.string(p_log_level, l_module_name, l_log_string);
951:

Line 982: --INSERT icx_cat_fav_list_lines_tlp for other items

978: l_err_loc := 2000;
979:
980: IF (p_action_mode = 'INSERT_FAV_LINES_OTHER') THEN
981: l_err_loc := 2100;
982: --INSERT icx_cat_fav_list_lines_tlp for other items
983: l_log_string := ' gIFLOFavoriteListIdTbl: ' ||
984: ICX_CAT_UTIL_PVT.getTableElement(gIFLOFavoriteListIdTbl, p_index) || '; ';
985: FND_LOG.string(p_log_level, l_module_name, l_log_string);
986:

Line 1908: INSERT INTO icx_cat_fav_list_lines_tlp

1904:
1905: l_err_loc := 350;
1906: l_action_mode := 'INSERT_FAV_LINES_CATALOG';
1907: FORALL i in 1..gIFLCFavoriteListIdTbl.COUNT
1908: INSERT INTO icx_cat_fav_list_lines_tlp
1909: (
1910: favorite_list_line_id, favorite_list_id,
1911: last_update_date, last_updated_by, last_update_login,
1912: creation_date, created_by,

Line 1939: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for catalog items:' ||SQL%ROWCOUNT);

1935: IF (gIFLCFavoriteListIdTbl.COUNT > 0) THEN
1936: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1937: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
1938: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
1939: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for catalog items:' ||SQL%ROWCOUNT);
1940: END IF;
1941: END IF;
1942:
1943: l_err_loc := 370;

Line 1949: INSERT INTO icx_cat_fav_list_lines_tlp

1945:
1946: l_err_loc := 380;
1947: l_action_mode := 'INSERT_FAV_LINES_OTHER';
1948: FORALL i in 1..gIFLOFavoriteListIdTbl.COUNT
1949: INSERT INTO icx_cat_fav_list_lines_tlp
1950: (
1951: favorite_list_line_id, favorite_list_id,
1952: last_update_date, last_updated_by, last_update_login,
1953: creation_date, created_by,

Line 2023: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for other items:' ||SQL%ROWCOUNT);

2019: IF (gIFLOFavoriteListIdTbl.COUNT > 0) THEN
2020: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2021: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
2022: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
2023: 'No: of rows inserted into icx_cat_fav_list_lines_tlp for other items:' ||SQL%ROWCOUNT);
2024: END IF;
2025: END IF;
2026:
2027: l_err_loc := 400;

Line 6429: FROM icx_cat_fav_list_lines_tlp new_fav

6425: AND fav.template_name = items.req_template_name
6426: AND fav.template_line_num = items.req_template_line_num
6427: AND fav.item_id = items.inventory_item_id
6428: AND NOT EXISTS ( SELECT NULL
6429: FROM icx_cat_fav_list_lines_tlp new_fav
6430: WHERE new_fav.favorite_list_id = fav.favorite_list_id
6431: AND new_fav.favorite_list_line_id = fav.favorite_list_line_id)
6432: ORDER BY favorite_list_id, favorite_list_line_id, fav.source_doc_line_id,
6433: fav.template_name, fav.template_line_num, fav.item_id,

Line 6449: FROM icx_cat_fav_list_lines_tlp new_fav

6445: AND users.user_id = prf_vals.level_value (+)
6446: AND prf_vals.profile_option_id (+) = p_profile_option_id
6447: AND prf_vals.level_id (+) = 10004
6448: AND NOT EXISTS ( SELECT NULL
6449: FROM icx_cat_fav_list_lines_tlp new_fav
6450: WHERE new_fav.favorite_list_id = fav_lines.favorite_list_id
6451: AND new_fav.favorite_list_line_id = fav_lines.favorite_list_line_id )
6452: GROUP BY fav_hdrs.favorite_list_id, fav_hdrs.employee_id, users.user_id,
6453: prf_vals.profile_option_value

Line 7313: WHERE NOT EXISTS ( SELECT 'x' FROM icx_cat_fav_list_lines_tlp lines

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
7317: BULK COLLECT INTO l_favorite_list_id_tbl, l_employee_id_tbl;