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_UI_TEMPLATES

Line 984: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES

980: IF (array_to_resolve(j) = 0 AND(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)) THEN
981:
982: IF NOT(ui_templ_id_tbl(j)=0 OR ui_templ_id_tbl(j) IS NULL) THEN
983:
984: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
985: WHERE template_id=ui_templ_id_tbl(j) AND ui_def_id=0;
986:
987: IF l_seeded_flag='1' THEN
988: resolved_array(j) := 0;

Line 3172: 'UPDATE cz_ui_templates'

3168: LOOP
3169: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
3170: THEN
3171: l_update_str :=
3172: 'UPDATE cz_ui_templates'
3173: || cz_pb_mgr.v_db_link
3174: || ' t'
3175: || ' '
3176: || 'SET (TEMPLATE_NAME,TEMPLATE_TYPE,PARENT_CONTAINER_TYPE,BUTTON_BAR_TEMPLATE_ID'

Line 3188: || 'TEMPLATE_USAGE FROM cz_ui_templates WHERE ui_def_id = 0'

3184: || '( SELECT TEMPLATE_NAME,TEMPLATE_TYPE,PARENT_CONTAINER_TYPE,:1,MESSAGE_TYPE,'
3185: || ' '
3186: || ':2,:3,LAYOUT_UI_STYLE,ROOT_REGION_TYPE,:4,ROOT_ELEMENT_SIGNATURE_ID,'
3187: || ' '
3188: || 'TEMPLATE_USAGE FROM cz_ui_templates WHERE ui_def_id = 0'
3189: || ' '
3190: || 'AND template_id = :5 )'
3191: || ' '
3192: || 'WHERE t.ui_def_id = 1'

Line 4153: FROM cz_ui_templates

4149: pbdebug := 22026;
4150:
4151: SELECT jrad_doc
4152: BULK COLLECT INTO l_jrad_doc_tbl
4153: FROM cz_ui_templates
4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
4155: AND cz_ui_templates.template_id = p_template_id
4156: AND cz_ui_templates.seeded_flag = '0'
4157: AND cz_ui_templates.deleted_flag = '0';

Line 4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id

4150:
4151: SELECT jrad_doc
4152: BULK COLLECT INTO l_jrad_doc_tbl
4153: FROM cz_ui_templates
4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
4155: AND cz_ui_templates.template_id = p_template_id
4156: AND cz_ui_templates.seeded_flag = '0'
4157: AND cz_ui_templates.deleted_flag = '0';
4158:

Line 4155: AND cz_ui_templates.template_id = p_template_id

4151: SELECT jrad_doc
4152: BULK COLLECT INTO l_jrad_doc_tbl
4153: FROM cz_ui_templates
4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
4155: AND cz_ui_templates.template_id = p_template_id
4156: AND cz_ui_templates.seeded_flag = '0'
4157: AND cz_ui_templates.deleted_flag = '0';
4158:
4159: --Bug#10417318:Modified delete for JRAD_CHUNKS as explained earlier.

Line 4156: AND cz_ui_templates.seeded_flag = '0'

4152: BULK COLLECT INTO l_jrad_doc_tbl
4153: FROM cz_ui_templates
4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
4155: AND cz_ui_templates.template_id = p_template_id
4156: AND cz_ui_templates.seeded_flag = '0'
4157: AND cz_ui_templates.deleted_flag = '0';
4158:
4159: --Bug#10417318:Modified delete for JRAD_CHUNKS as explained earlier.
4160: IF (l_jrad_doc_tbl.COUNT > 0)

Line 4157: AND cz_ui_templates.deleted_flag = '0';

4153: FROM cz_ui_templates
4154: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
4155: AND cz_ui_templates.template_id = p_template_id
4156: AND cz_ui_templates.seeded_flag = '0'
4157: AND cz_ui_templates.deleted_flag = '0';
4158:
4159: --Bug#10417318:Modified delete for JRAD_CHUNKS as explained earlier.
4160: IF (l_jrad_doc_tbl.COUNT > 0)
4161: THEN

Line 4205: FROM cz_ui_templates

4201: END IF;
4202:
4203: SELECT ui_def_id, template_id
4204: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
4205: FROM cz_ui_templates
4206: WHERE cz_ui_templates.deleted_flag = '0'
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(

Line 4206: WHERE cz_ui_templates.deleted_flag = '0'

4202:
4203: SELECT ui_def_id, template_id
4204: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
4205: FROM cz_ui_templates
4206: WHERE cz_ui_templates.deleted_flag = '0'
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id

Line 4207: AND cz_ui_templates.seeded_flag = '0'

4203: SELECT ui_def_id, template_id
4204: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
4205: FROM cz_ui_templates
4206: WHERE cz_ui_templates.deleted_flag = '0'
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs

Line 4208: AND ( cz_ui_templates.ui_def_id = 0

4204: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
4205: FROM cz_ui_templates
4206: WHERE cz_ui_templates.deleted_flag = '0'
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'

Line 4209: OR cz_ui_templates.ui_def_id IN(

4205: FROM cz_ui_templates
4206: WHERE cz_ui_templates.deleted_flag = '0'
4207: AND cz_ui_templates.seeded_flag = '0'
4208: AND ( cz_ui_templates.ui_def_id = 0
4209: OR cz_ui_templates.ui_def_id IN(
4210: SELECT ui_def_id
4211: FROM cz_ui_defs
4212: WHERE cz_ui_defs.deleted_flag = '0'
4213: AND cz_ui_defs.devl_project_id IN(SELECT object_id

Line 5415: l_str := 'update cz_ui_templates'|| CZ_PB_MGR.v_db_link || ' set template_rev_nbr=template_rev_nbr+1 '

5411: ELSE
5412: l_ui_def_id := 1;
5413: END IF;
5414:
5415: l_str := 'update cz_ui_templates'|| CZ_PB_MGR.v_db_link || ' set template_rev_nbr=template_rev_nbr+1 '
5416: || ' where template_id=:1 and ui_def_id=:2';
5417:
5418: FOR i IN l_template_id_ref.FIRST..l_template_id_ref.LAST
5419: LOOP

Line 5506: ----insert into cz_ui_templates

5502: RAISE;
5503: END insert_template_elements;
5504:
5505: ------------------------------------------------------------
5506: ----insert into cz_ui_templates
5507: PROCEDURE insert_ui_templates
5508: IS
5509: rec_count NUMBER := 0;
5510: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 5563: --with a value of '1' for CZ_UI_TEMPLATES record.

5559:
5560: -----resplve templates
5561: --bug 5191745
5562: --before the fix, even for model migration, the ui_def_ids were being populated
5563: --with a value of '1' for CZ_UI_TEMPLATES record.
5564: --The ideal fix would have been to call 'resolve_tmpl_ui_defs' on its own, because
5565: --'resolve_tmpl_ui_defs' already checks for model migration condition
5566: --and assigns the ui_def_id correctly.
5567: --But there is a possibility that it would introduce regression in publishing

Line 5591: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');

5587: END LOOP;
5588: -- END IF;
5589:
5590: -- main msg and title intl text records handled in insert_jrad_ui_intl_texts
5591: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
5592: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'title ids of cz ui templates');
5593:
5594: plsql_table_list.DELETE;
5595: rec_count := 1;

Line 5592: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'title ids of cz ui templates');

5588: -- END IF;
5589:
5590: -- main msg and title intl text records handled in insert_jrad_ui_intl_texts
5591: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
5592: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'title ids of cz ui templates');
5593:
5594: plsql_table_list.DELETE;
5595: rec_count := 1;
5596: plsql_table_list(rec_count).col_name := 'template_id';

Line 5618: insert_into_table('CZ_UI_TEMPLATES'

5614: rec_count := rec_count + 1;
5615: plsql_table_list(rec_count).col_name := 'button_bar_templ_uidef_id';
5616: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_but_uidef_id';
5617:
5618: insert_into_table('CZ_UI_TEMPLATES'
5619: ,'template_id'
5620: ,'ui_def_id'
5621: ,cz_pb_mgr.v_db_link
5622: ,plsql_table_list

Line 5939: FROM cz_ui_templates

5935: LOOP
5936: BEGIN
5937: SELECT 1
5938: INTO l_tmp_id
5939: FROM cz_ui_templates
5940: WHERE cz_ui_templates.ui_def_id IS NULL AND cz_ui_templates.template_id = p_templates_tbl(tempid);
5941: EXCEPTION
5942: WHEN NO_DATA_FOUND
5943: THEN

Line 5940: WHERE cz_ui_templates.ui_def_id IS NULL AND cz_ui_templates.template_id = p_templates_tbl(tempid);

5936: BEGIN
5937: SELECT 1
5938: INTO l_tmp_id
5939: FROM cz_ui_templates
5940: WHERE cz_ui_templates.ui_def_id IS NULL AND cz_ui_templates.template_id = p_templates_tbl(tempid);
5941: EXCEPTION
5942: WHEN NO_DATA_FOUND
5943: THEN
5944: l_tmp_id := 0;

Line 6315: ----insert into cz_ui_templates

6311: l_new_document VARCHAR2(255);
6312: BEGIN
6313: ----insert intl texts of JRAD UI(s)
6314: insert_jrad_ui_intl_texts;
6315: ----insert into cz_ui_templates
6316: insert_ui_templates;
6317: -----insert ref templates
6318: insert_ref_templates;
6319:

Line 7894: FROM cz_ui_templates

7890:
7891: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7892: IS
7893: SELECT last_update_date
7894: FROM cz_ui_templates
7895: WHERE cz_ui_templates.ui_def_id = p_ui_def_id AND cz_ui_templates.deleted_flag = '0'
7896: ORDER BY last_update_date DESC;
7897:
7898: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)

Line 7895: WHERE cz_ui_templates.ui_def_id = p_ui_def_id AND cz_ui_templates.deleted_flag = '0'

7891: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7892: IS
7893: SELECT last_update_date
7894: FROM cz_ui_templates
7895: WHERE cz_ui_templates.ui_def_id = p_ui_def_id AND cz_ui_templates.deleted_flag = '0'
7896: ORDER BY last_update_date DESC;
7897:
7898: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7899: IS

Line 8504: FROM cz_ui_templates

8500: IS
8501: BEGIN
8502: SELECT last_update_date
8503: INTO x_max_date
8504: FROM cz_ui_templates
8505: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
8506: EXCEPTION
8507: WHEN OTHERS
8508: THEN

Line 8505: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;

8501: BEGIN
8502: SELECT last_update_date
8503: INTO x_max_date
8504: FROM cz_ui_templates
8505: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
8506: EXCEPTION
8507: WHEN OTHERS
8508: THEN
8509: x_max_date := cz_utils.epoch_begin;

Line 8526: FROM cz_ui_templates

8522: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
8523: LOOP
8524: SELECT last_update_date
8525: INTO l_last_update_date
8526: FROM cz_ui_templates
8527: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
8528: AND cz_ui_templates.deleted_flag = record_not_deleted
8529: AND cz_ui_templates.ui_def_id = 0;
8530:

Line 8527: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)

8523: LOOP
8524: SELECT last_update_date
8525: INTO l_last_update_date
8526: FROM cz_ui_templates
8527: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
8528: AND cz_ui_templates.deleted_flag = record_not_deleted
8529: AND cz_ui_templates.ui_def_id = 0;
8530:
8531: IF (l_last_update_date > l_prev_date)

Line 8528: AND cz_ui_templates.deleted_flag = record_not_deleted

8524: SELECT last_update_date
8525: INTO l_last_update_date
8526: FROM cz_ui_templates
8527: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
8528: AND cz_ui_templates.deleted_flag = record_not_deleted
8529: AND cz_ui_templates.ui_def_id = 0;
8530:
8531: IF (l_last_update_date > l_prev_date)
8532: THEN

Line 8529: AND cz_ui_templates.ui_def_id = 0;

8525: INTO l_last_update_date
8526: FROM cz_ui_templates
8527: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
8528: AND cz_ui_templates.deleted_flag = record_not_deleted
8529: AND cz_ui_templates.ui_def_id = 0;
8530:
8531: IF (l_last_update_date > l_prev_date)
8532: THEN
8533: x_max_update_date := l_last_update_date;

Line 9013: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq,

9009: BEGIN
9010: l_template_id := get_target_template(p_template_id);
9011: IF (l_template_id = -1) THEN
9012: l_template_id :=
9013: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq,
9014: 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
9015: END IF;
9016:
9017: RETURN l_template_id;

Line 9014: 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);

9010: l_template_id := get_target_template(p_template_id);
9011: IF (l_template_id = -1) THEN
9012: l_template_id :=
9013: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq,
9014: 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
9015: END IF;
9016:
9017: RETURN l_template_id;
9018: EXCEPTION

Line 9046: FROM cz_ui_templates

9042: AND cz_model_publications.deleted_flag = '0';
9043:
9044: SELECT last_update_date
9045: INTO l_uit_update_date
9046: FROM cz_ui_templates
9047: WHERE ui_def_id = 0 AND template_id = p_template_id AND deleted_flag = '0';
9048:
9049: -- if template changed since last publication
9050: IF (l_uit_update_date > l_last_update_date) THEN

Line 9078: l_jrad_doc VARCHAR2(255); -- cz_ui_templates.jrad_doc%TYPE;

9074: l_all_tmpl_map cz_pb_mgr.t_ref_idx_vc2;
9075: l_temp_tbl cz_pb_mgr.t_ref;
9076: l_rec_count PLS_INTEGER;
9077: l_template_id NUMBER;
9078: l_jrad_doc VARCHAR2(255); -- cz_ui_templates.jrad_doc%TYPE;
9079:
9080: -- used for synch operation and insert operation resp
9081: l_parent_container_type NUMBER;
9082: l_root_element_signature_id NUMBER;

Line 9083: l_template_name VARCHAR2(255); -- cz_ui_templates.TEMPLATE_NAME%TYPE;

9079:
9080: -- used for synch operation and insert operation resp
9081: l_parent_container_type NUMBER;
9082: l_root_element_signature_id NUMBER;
9083: l_template_name VARCHAR2(255); -- cz_ui_templates.TEMPLATE_NAME%TYPE;
9084: l_root_region_type VARCHAR2(255); -- cz_ui_templates.ROOT_REGION_TYPE%TYPE;
9085:
9086: remote_uct ref_cursor;
9087:

Line 9084: l_root_region_type VARCHAR2(255); -- cz_ui_templates.ROOT_REGION_TYPE%TYPE;

9080: -- used for synch operation and insert operation resp
9081: l_parent_container_type NUMBER;
9082: l_root_element_signature_id NUMBER;
9083: l_template_name VARCHAR2(255); -- cz_ui_templates.TEMPLATE_NAME%TYPE;
9084: l_root_region_type VARCHAR2(255); -- cz_ui_templates.ROOT_REGION_TYPE%TYPE;
9085:
9086: remote_uct ref_cursor;
9087:
9088: document_synch EXCEPTION;

Line 9165: FROM cz_ui_templates

9161: FROM cz_ui_collect_tmpls_v
9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
9167: AND cz_ui_templates.ui_def_id = 0);
9168:
9169: check_template_status(l_temp_tbl);

Line 9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'

9162: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
9167: AND cz_ui_templates.ui_def_id = 0);
9168:
9169: check_template_status(l_temp_tbl);
9170: END LOOP;

Line 9167: AND cz_ui_templates.ui_def_id = 0);

9163: AND cz_ui_collect_tmpls_v.template_id IN
9164: (SELECT template_id
9165: FROM cz_ui_templates
9166: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
9167: AND cz_ui_templates.ui_def_id = 0);
9168:
9169: check_template_status(l_temp_tbl);
9170: END LOOP;
9171: END IF;

Line 9188: FROM cz_ui_templates t

9184: AND cz_ui_ref_templates.seeded_flag = '0'
9185: AND cz_ui_ref_templates.ref_template_ui_def_id = '0'
9186: AND cz_ui_ref_templates.ref_template_id IN
9187: (SELECT template_id
9188: FROM cz_ui_templates t
9189: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
9190: START WITH cz_ui_ref_templates.template_id = l_all_tmpl_tbl(i) AND cz_ui_ref_templates.template_ui_def_id = '0'
9191: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
9192: AND PRIOR ref_template_ui_def_id = cz_ui_ref_templates.template_ui_def_id

Line 9206: FROM cz_ui_templates

9202: IF l_rec_count > 0 THEN
9203: FOR i IN 1 .. l_rec_count LOOP
9204: l_temp_tbl.DELETE;
9205: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
9206: FROM cz_ui_templates
9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL

Line 9207: WHERE cz_ui_templates.deleted_flag = '0'

9203: FOR i IN 1 .. l_rec_count LOOP
9204: l_temp_tbl.DELETE;
9205: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
9206: FROM cz_ui_templates
9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)

Line 9208: AND cz_ui_templates.seeded_flag = '0'

9204: l_temp_tbl.DELETE;
9205: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
9206: FROM cz_ui_templates
9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN

Line 9209: AND cz_ui_templates.ui_def_id = 0

9205: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
9206: FROM cz_ui_templates
9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN
9213: (SELECT template_id

Line 9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL

9206: FROM cz_ui_templates
9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN
9213: (SELECT template_id
9214: FROM cz_ui_templates t

Line 9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)

9207: WHERE cz_ui_templates.deleted_flag = '0'
9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN
9213: (SELECT template_id
9214: FROM cz_ui_templates t
9215: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);

Line 9212: AND cz_ui_templates.button_bar_template_id IN

9208: AND cz_ui_templates.seeded_flag = '0'
9209: AND cz_ui_templates.ui_def_id = 0
9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN
9213: (SELECT template_id
9214: FROM cz_ui_templates t
9215: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);
9216:

Line 9214: FROM cz_ui_templates t

9210: AND cz_ui_templates.button_bar_template_id IS NOT NULL
9211: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
9212: AND cz_ui_templates.button_bar_template_id IN
9213: (SELECT template_id
9214: FROM cz_ui_templates t
9215: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);
9216:
9217: check_template_status(l_temp_tbl);
9218: END LOOP;

Line 9234: AND EXISTS (SELECT NULL FROM cz_ui_templates

9230: (SELECT element_id FROM cz_ui_template_elements
9231: WHERE deleted_flag = '0' AND element_type = 552
9232: AND template_id = l_new_tmpl_tbl(i)
9233: AND ui_def_id = 0 and seeded_flag = '0')
9234: AND EXISTS (SELECT NULL FROM cz_ui_templates
9235: WHERE deleted_flag = '0' AND ui_def_id = 0
9236: AND template_id = act.processing_page_templ_id AND seeded_flag = '0');
9237:
9238: check_template_status(l_temp_tbl);

Line 9246: FOR j IN (SELECT * FROM cz_ui_templates

9242: IF (l_new_tmpl_tbl.COUNT > 0) THEN
9243: l_rec_count := 0;
9244:
9245: FOR i IN l_new_tmpl_tbl.FIRST .. l_new_tmpl_tbl.LAST LOOP
9246: FOR j IN (SELECT * FROM cz_ui_templates
9247: WHERE template_id = l_new_tmpl_tbl(i) AND ui_def_id = '0' AND deleted_flag = '0') LOOP
9248: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model THEN
9249: -- The synch check will be performed here
9250: -- The template name will be checked over the link

Line 9259: || 'root_element_signature_id from cz_ui_templates'

9255: l_root_region_type := NULL;
9256: l_root_element_signature_id := NULL;
9257:
9258: OPEN remote_uct FOR 'Select template_name,template_id,parent_container_type,root_region_type,'
9259: || 'root_element_signature_id from cz_ui_templates'
9260: || cz_pb_mgr.v_db_link || 't '
9261: || 'where t.ui_def_id = ''0'' and t.template_usage = ''0'' and '
9262: || 't.deleted_flag = ''0'' and t.seeded_flag = ''0'' and '
9263: || 't.template_name = :1 and t.template_type = :2 and nvl(t.message_type,-1) = nvl(:3,-1)'

Line 9273: cz_pb_mgr.v_err_message := cz_utils.get_text('UCT synch error', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);

9269: IF l_template_name IS NOT NULL AND
9270: ( l_parent_container_type <> j.parent_container_type
9271: OR l_root_region_type <> j.root_region_type
9272: OR l_root_element_signature_id <> j.root_element_signature_id ) THEN
9273: cz_pb_mgr.v_err_message := cz_utils.get_text('UCT synch error', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
9274: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
9275: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9276: RAISE document_synch;
9277: END IF;

Line 9330: FROM cz_ui_templates

9326: IF l_old_tmpl_tbl.COUNT > 0 THEN
9327: l_rec_count := 0;
9328: FOR i IN l_old_tmpl_tbl.FIRST..l_old_tmpl_tbl.LAST LOOP
9329: SELECT jrad_doc INTO l_jrad_doc
9330: FROM cz_ui_templates
9331: WHERE template_id = l_old_tmpl_tbl(i) AND ui_def_id = 0 AND deleted_flag = '0';
9332:
9333: l_rec_count := l_rec_count + 1;
9334: CZ_PB_MGR.g_tmpl_jrad_old_tbl(l_rec_count) := l_jrad_doc;

Line 9351: FROM cz_ui_templates

9347: -- which are in l_new_tmpl_tbl
9348: IF l_new_tmpl_tbl.COUNT > 0 THEN
9349: FOR i IN l_new_tmpl_tbl.FIRST..l_new_tmpl_tbl.LAST LOOP
9350: SELECT jrad_doc INTO l_jrad_doc
9351: FROM cz_ui_templates
9352: WHERE template_id = l_new_tmpl_tbl(i) AND ui_def_id = 0 AND deleted_flag = '0';
9353:
9354: l_rec_count := l_rec_count + 1;
9355: cz_pb_mgr.g_tmpl_jrad_old_tbl(l_rec_count) := l_jrad_doc;

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

9364: END IF;
9365:
9366: EXCEPTION
9367: WHEN OTHERS THEN
9368: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
9369: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
9370: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
9371: RAISE;
9372: END get_oa_tmpls;

Line 18135: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq

18131: cz_pb_mgr.g_ui_templates_button_tbl.DELETE;
18132:
18133: IF (cz_pb_mgr.v_server_id = 0)
18134: THEN
18135: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq
18136: , 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link
18137: ,cz_pb_mgr.v_oraclesequenceincr
18138: )
18139: ,template_id, main_message_id, title_id

Line 18136: , 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link

18132:
18133: IF (cz_pb_mgr.v_server_id = 0)
18134: THEN
18135: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates_seq
18136: , 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link
18137: ,cz_pb_mgr.v_oraclesequenceincr
18138: )
18139: ,template_id, main_message_id, title_id
18140: ,jrad_doc, -1, 0

Line 18146: FROM cz_ui_templates

18142: BULK COLLECT INTO cz_pb_mgr.g_ui_templates_new_temp_id_ref
18143: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref, cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.g_ui_templates_title_ref
18144: ,cz_pb_mgr.g_ui_templates_jrad_new_ref, cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_intl_text_ui_tbl
18145: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
18146: FROM cz_ui_templates
18147: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;
18148: ELSE
18149: SELECT template_id, template_id, main_message_id
18150: ,title_id, jrad_doc, -1

Line 18147: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;

18143: ,cz_pb_mgr.g_ui_templates_old_temp_id_ref, cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.g_ui_templates_title_ref
18144: ,cz_pb_mgr.g_ui_templates_jrad_new_ref, cz_pb_mgr.v_intl_text_model_tbl, cz_pb_mgr.v_intl_text_ui_tbl
18145: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
18146: FROM cz_ui_templates
18147: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;
18148: ELSE
18149: SELECT template_id, template_id, main_message_id
18150: ,title_id, jrad_doc, -1
18151: ,0, 0

Line 18155: FROM cz_ui_templates

18151: ,0, 0
18152: BULK COLLECT INTO cz_pb_mgr.g_ui_templates_new_temp_id_ref, cz_pb_mgr.g_ui_templates_old_temp_id_ref, cz_pb_mgr.g_ui_templates_msg_id_ref
18153: ,cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.g_ui_templates_jrad_new_ref, cz_pb_mgr.v_intl_text_model_tbl
18154: ,cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.g_ui_templates_ui_def_old_ref
18155: FROM cz_ui_templates
18156: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;
18157: END IF;
18158:
18159: ------main msg

Line 18156: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;

18152: BULK COLLECT INTO cz_pb_mgr.g_ui_templates_new_temp_id_ref, cz_pb_mgr.g_ui_templates_old_temp_id_ref, cz_pb_mgr.g_ui_templates_msg_id_ref
18153: ,cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.g_ui_templates_jrad_new_ref, cz_pb_mgr.v_intl_text_model_tbl
18154: ,cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.g_ui_templates_ui_def_old_ref
18155: FROM cz_ui_templates
18156: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;
18157: END IF;
18158:
18159: ------main msg
18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);

Line 18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);

18156: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.ui_def_id = 0 AND cz_ui_templates.deleted_flag = record_not_deleted;
18157: END IF;
18158:
18159: ------main msg
18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
18161: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18162: ----title id
18163: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
18164: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');

Line 18161: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');

18157: END IF;
18158:
18159: ------main msg
18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
18161: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18162: ----title id
18163: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
18164: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18165:

Line 18163: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);

18159: ------main msg
18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
18161: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18162: ----title id
18163: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
18164: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18165:
18166: IF (cz_pb_mgr.g_ui_templates_jrad_new_ref.COUNT > 0)
18167: THEN

Line 18164: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');

18160: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
18161: resolve_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18162: ----title id
18163: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
18164: resolve_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'main message ids of cz ui templates');
18165:
18166: IF (cz_pb_mgr.g_ui_templates_jrad_new_ref.COUNT > 0)
18167: THEN
18168: FOR doc IN cz_pb_mgr.g_ui_templates_jrad_new_ref.FIRST .. cz_pb_mgr.g_ui_templates_jrad_new_ref.LAST

Line 19469: FROM cz_ui_templates

19465: l_count NUMBER := 0;
19466: BEGIN
19467: SELECT 1
19468: INTO l_count
19469: FROM cz_ui_templates
19470: WHERE cz_ui_templates.template_id = p_template_id
19471: AND cz_ui_templates.ui_def_id = 0
19472: AND cz_ui_templates.deleted_flag = record_not_deleted
19473: AND ROWNUM < 2;

Line 19470: WHERE cz_ui_templates.template_id = p_template_id

19466: BEGIN
19467: SELECT 1
19468: INTO l_count
19469: FROM cz_ui_templates
19470: WHERE cz_ui_templates.template_id = p_template_id
19471: AND cz_ui_templates.ui_def_id = 0
19472: AND cz_ui_templates.deleted_flag = record_not_deleted
19473: AND ROWNUM < 2;
19474: EXCEPTION

Line 19471: AND cz_ui_templates.ui_def_id = 0

19467: SELECT 1
19468: INTO l_count
19469: FROM cz_ui_templates
19470: WHERE cz_ui_templates.template_id = p_template_id
19471: AND cz_ui_templates.ui_def_id = 0
19472: AND cz_ui_templates.deleted_flag = record_not_deleted
19473: AND ROWNUM < 2;
19474: EXCEPTION
19475: WHEN NO_DATA_FOUND

Line 19472: AND cz_ui_templates.deleted_flag = record_not_deleted

19468: INTO l_count
19469: FROM cz_ui_templates
19470: WHERE cz_ui_templates.template_id = p_template_id
19471: AND cz_ui_templates.ui_def_id = 0
19472: AND cz_ui_templates.deleted_flag = record_not_deleted
19473: AND ROWNUM < 2;
19474: EXCEPTION
19475: WHEN NO_DATA_FOUND
19476: THEN