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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_INTL_TEXTS

Line 2919: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq

2915: l_ui_def_id_tbl.DELETE;
2916: l_model_id_tbl.DELETE;
2917:
2918: BEGIN
2919: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2920: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2921: ,cz_pb_mgr.v_oraclesequenceincr
2922: )
2923: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)

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

2916: l_model_id_tbl.DELETE;
2917:
2918: BEGIN
2919: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2920: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2921: ,cz_pb_mgr.v_oraclesequenceincr
2922: )
2923: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2924: BULK COLLECT INTO v_cz_intl_text_new_tbl

Line 2926: FROM cz_intl_texts

2922: )
2923: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2924: BULK COLLECT INTO v_cz_intl_text_new_tbl
2925: ,v_cz_intl_text_old_tbl, l_ui_def_id_tbl, l_model_id_tbl
2926: FROM cz_intl_texts
2927: WHERE intl_text_id = p_intl_text_id_ref(c) AND deleted_flag = '0' AND NVL(seeded_flag, '0') = '0';
2928: EXCEPTION
2929: WHEN NO_DATA_FOUND
2930: THEN

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

2931: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
2932: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2933: WHEN OTHERS
2934: THEN
2935: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
2936: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
2937: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
2938: END;
2939:

Line 2988: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq

2984: l_ui_def_id_tbl.DELETE;
2985: l_model_id_tbl.DELETE;
2986:
2987: BEGIN
2988: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2989: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2990: ,cz_pb_mgr.v_oraclesequenceincr
2991: )
2992: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)

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

2985: l_model_id_tbl.DELETE;
2986:
2987: BEGIN
2988: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
2989: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
2990: ,cz_pb_mgr.v_oraclesequenceincr
2991: )
2992: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2993: BULK COLLECT INTO v_cz_intl_text_new_tbl

Line 2995: FROM cz_intl_texts

2991: )
2992: ,intl_text_id, DECODE(ui_def_id, -1, NULL, ui_def_id), NVL(model_id, -1)
2993: BULK COLLECT INTO v_cz_intl_text_new_tbl
2994: ,v_cz_intl_text_old_tbl, l_ui_def_id_tbl, l_model_id_tbl
2995: FROM cz_intl_texts
2996: WHERE intl_text_id = p_intl_text_id_ref(c) AND deleted_flag = '0' AND NVL(seeded_flag, '0') = '0';
2997: EXCEPTION
2998: WHEN NO_DATA_FOUND
2999: THEN

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

3000: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
3001: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
3002: WHEN OTHERS
3003: THEN
3004: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_intl_texts', 'SQLERRM', SQLERRM);
3005: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.INSERTINTLBULK', SQLCODE);
3006: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3007: END;
3008:

Line 3030: -- log_timing_message('SPITRE rework calling resolve_ids for - model id of cz intl texts');

3026: END IF;
3027: END IF;
3028: END LOOP;
3029: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3030: -- log_timing_message('SPITRE rework calling resolve_ids for - model id of cz intl texts');
3031: --END IF;
3032: 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');
3033: END IF;
3034:

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

3028: END LOOP;
3029: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3030: -- log_timing_message('SPITRE rework calling resolve_ids for - model id of cz intl texts');
3031: --END IF;
3032: 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');
3033: END IF;
3034:
3035: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');

Line 3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');

3032: 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');
3033: END IF;
3034:
3035: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');
3037: --END IF;
3038: 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');
3039:
3040: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)

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

3034:
3035: --IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
3036: -- log_timing_message('SPITRE rework calling resolve_ids for - ui def id of cz intl texts');
3037: --END IF;
3038: 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');
3039:
3040: IF (cz_pb_mgr.v_cz_intl_text_new_ref.COUNT > 0)
3041: THEN
3042: --------populate plsql_table_list for intl texts

Line 6249: FROM cz_intl_texts txt, cz_ui_defs ui

6245:
6246: BEGIN
6247: SELECT intl_text_id
6248: BULK COLLECT INTO l_intl_text_id_tbl
6249: FROM cz_intl_texts txt, cz_ui_defs ui
6250: WHERE txt.model_id = cz_pb_mgr.v_models_to_be_exported(i)
6251: AND txt.deleted_flag = '0'
6252: AND NVL(txt.seeded_flag, '0') = '0'
6253: AND NVL(txt.ui_def_id, -1) = ui.ui_def_id

Line 7835: FROM cz_intl_texts

7831:
7832: CURSOR ui_intl_texts_cur(p_ui_def_id NUMBER)
7833: IS
7834: SELECT last_update_date
7835: FROM cz_intl_texts
7836: WHERE intl_text_id IN(SELECT f.tool_tip_id
7837: FROM cz_ui_nodes f
7838: WHERE f.ui_def_id = p_ui_def_id AND f.deleted_flag = '0'
7839: UNION

Line 7855: FROM cz_intl_texts

7851:
7852: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)
7853: IS
7854: SELECT last_update_date
7855: FROM cz_intl_texts
7856: WHERE intl_text_id IN(SELECT caption_text_id
7857: FROM cz_ui_pages
7858: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7859: ORDER BY last_update_date DESC;

Line 7878: FROM cz_intl_texts

7874:
7875: CURSOR ui_page_refs_capt_cur(p_ui_def_id NUMBER)
7876: IS
7877: SELECT last_update_date
7878: FROM cz_intl_texts
7879: WHERE intl_text_id IN(SELECT caption_text_id
7880: FROM cz_ui_page_refs
7881: WHERE cz_ui_page_refs.ui_def_id = p_ui_def_id)
7882: ORDER BY last_update_date DESC;

Line 9463: FROM cz_intl_texts

9459: LOOP
9460: BEGIN
9461: SELECT MAX(last_update_date)
9462: INTO l_capt_update_date
9463: FROM cz_intl_texts
9464: WHERE model_id = v_models_tbl(i);
9465: EXCEPTION
9466: WHEN OTHERS
9467: THEN

Line 11069: FROM cz_intl_texts

11065: BEGIN
11066: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST LOOP
11067: l_text_id_tbl.DELETE;
11068: SELECT intl_text_id BULK COLLECT INTO l_text_id_tbl
11069: FROM cz_intl_texts
11070: WHERE model_id = cz_pb_mgr.v_models_to_be_exported(i)
11071: AND deleted_flag = '0' AND (seeded_flag IS NULL OR seeded_flag = '0')
11072: AND intl_text_id IN (SELECT reason_id
11073: FROM cz_rules

Line 24440: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq

24436: ,cz_pb_mgr.v_oraclesequenceincr
24437: );
24438: ELSIF(what_id = 'INTL_TEXT')
24439: THEN
24440: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
24441: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
24442: ,cz_pb_mgr.v_oraclesequenceincr
24443: );
24444:

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

24437: );
24438: ELSIF(what_id = 'INTL_TEXT')
24439: THEN
24440: RETURN cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_intl_texts_seq
24441: , 'cz_intl_texts_s.nextval' || cz_pb_mgr.v_db_link
24442: ,cz_pb_mgr.v_oraclesequenceincr
24443: );
24444:
24445: END IF;