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.CZ_PB_MGR dependencies on CZ_INTL_TEXTS

Line 2389: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq

2385: l_ui_def_id_tbl.DELETE;
2386: l_model_id_tbl.DELETE;
2387:
2388: BEGIN
2389: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2390: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2391: ,cz_pb_mgr.v_oraclesequenceincr
2392: )
2393: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)

Line 2390: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link

2386: l_model_id_tbl.DELETE;
2387:
2388: BEGIN
2389: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2390: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2391: ,cz_pb_mgr.v_oraclesequenceincr
2392: )
2393: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2394: BULK COLLECT INTO v_cz_intl_text_new_tbl

Line 2396: FROM cz_intl_texts

2392: )
2393: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2394: BULK COLLECT INTO v_cz_intl_text_new_tbl
2395: ,v_cz_intl_text_old_tbl, l_ui_def_id_tbl, l_model_id_tbl
2396: FROM cz_intl_texts
2397: WHERE intl_text_id = p_intl_text_id_ref(c) AND deleted_flag = '0' AND NVL(seeded_flag, '0') = '0';
2398: EXCEPTION
2399: WHEN NO_DATA_FOUND
2400: THEN

Line 2405: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);

2401: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
2402: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2403: WHEN OTHERS
2404: THEN
2405: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
2406: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2407: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
2408: END;
2409:

Line 2440: resolve_ids(cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz intl texts');

2436: END IF;
2437: END LOOP;
2438:
2439: IF p_intl_text <> 'prop num value of cz prop vals' THEN
2440: resolve_ids(cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz intl texts');
2441: END IF;
2442: resolve_ids(cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz intl texts');
2443:
2444: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)

Line 2442: resolve_ids(cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz intl texts');

2438:
2439: IF p_intl_text <> 'prop num value of cz prop vals' THEN
2440: resolve_ids(cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz intl texts');
2441: END IF;
2442: resolve_ids(cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz intl texts');
2443:
2444: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
2445: THEN
2446: --------populate plsql_table_list for intl texts

Line 5499: FROM cz_intl_texts txt, cz_ui_defs ui

5495:
5496: BEGIN
5497: SELECT intl_text_id
5498: BULK COLLECT INTO l_intl_text_id_tbl
5499: FROM cz_intl_texts txt, cz_ui_defs ui
5500: WHERE txt.model_id = cz_pb_mgr.v_models_to_be_exported(i)
5501: AND txt.deleted_flag = '0'
5502: AND NVL(txt.seeded_flag, '0') = '0'
5503: AND NVL(txt.ui_def_id, -1) = ui.ui_def_id

Line 7112: FROM cz_intl_texts

7108:
7109: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)
7110: IS
7111: SELECT last_update_date
7112: FROM cz_intl_texts
7113: WHERE intl_text_id IN(SELECT f.tool_tip_id
7114: FROM cz_ui_nodes f
7115: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7116: UNION

Line 7132: FROM cz_intl_texts

7128:
7129: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)
7130: IS
7131: SELECT last_update_date
7132: FROM cz_intl_texts
7133: WHERE intl_text_id IN(SELECT caption_text_id
7134: FROM cz_ui_pages
7135: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7136: ORDER BY last_update_date DESC;

Line 7155: FROM cz_intl_texts

7151:
7152: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)
7153: IS
7154: SELECT last_update_date
7155: FROM cz_intl_texts
7156: WHERE intl_text_id IN(SELECT caption_text_id
7157: FROM cz_ui_page_refs
7158: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7159: ORDER BY last_update_date DESC;

Line 8707: FROM cz_intl_texts

8703: LOOP
8704: BEGIN
8705: SELECT MAX(last_update_date)
8706: INTO l_capt_update_date
8707: FROM cz_intl_texts
8708: WHERE model_id = v_models_tbl(i);
8709: EXCEPTION
8710: WHEN OTHERS
8711: THEN

Line 10313: FROM cz_intl_texts

10309: BEGIN
10310: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST LOOP
10311: l_text_id_tbl.DELETE;
10312: SELECT intl_text_id BULK COLLECT INTO l_text_id_tbl
10313: FROM cz_intl_texts
10314: WHERE model_id = cz_pb_mgr.v_models_to_be_exported(i)
10315: AND deleted_flag = '0' AND (seeded_flag IS NULL OR seeded_flag = '0')
10316: AND intl_text_id IN (SELECT reason_id
10317: FROM cz_rules

Line 22987: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq

22983: ,cz_pb_mgr.v_oraclesequenceincr
22984: );
22985: ELSIF(what_id = 'INTL_TEXT')
22986: THEN
22987: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
22988: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
22989: ,cz_pb_mgr.v_oraclesequenceincr
22990: );
22991:

Line 22988: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link

22984: );
22985: ELSIF(what_id = 'INTL_TEXT')
22986: THEN
22987: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
22988: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
22989: ,cz_pb_mgr.v_oraclesequenceincr
22990: );
22991:
22992: END IF;