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_UI_TEMPLATES

Line 730: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES

726: IF (array_to_resolve(j) = 0 AND(cz_pb_mgr.v_session_parameter <> cz_model_migration_pvt.migrate_model)) THEN
727:
728: IF NOT(ui_templ_id_tbl(j)=0 OR ui_templ_id_tbl(j) IS NULL) THEN
729:
730: SELECT seeded_flag INTO l_seeded_flag FROM CZ_UI_TEMPLATES
731: WHERE template_id=ui_templ_id_tbl(j) AND ui_def_id=0;
732:
733: IF l_seeded_flag='1' THEN
734: resolved_array(j) := 0;

Line 2566: 'UPDATE cz_ui_templates'

2562: LOOP
2563: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
2564: THEN
2565: l_update_str :=
2566: 'UPDATE cz_ui_templates'
2567: || cz_pb_mgr.v_db_link
2568: || ' t'
2569: || ' '
2570: || 'SET (TEMPLATE_NAME,TEMPLATE_TYPE,PARENT_CONTAINER_TYPE,BUTTON_BAR_TEMPLATE_ID'

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

2578: || '( SELECT TEMPLATE_NAME,TEMPLATE_TYPE,PARENT_CONTAINER_TYPE,:1,MESSAGE_TYPE,'
2579: || ' '
2580: || ':2,:3,LAYOUT_UI_STYLE,ROOT_REGION_TYPE,:4,ROOT_ELEMENT_SIGNATURE_ID,'
2581: || ' '
2582: || 'TEMPLATE_USAGE FROM cz_ui_templates WHERE ui_def_id = 0'
2583: || ' '
2584: || 'AND template_id = :5 )'
2585: || ' '
2586: || 'WHERE t.ui_def_id = 1'

Line 3518: FROM cz_ui_templates

3514: pbdebug := 22026;
3515:
3516: SELECT jrad_doc
3517: BULK COLLECT INTO l_jrad_doc_tbl
3518: FROM cz_ui_templates
3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
3520: AND cz_ui_templates.template_id = p_template_id
3521: AND cz_ui_templates.seeded_flag = '0'
3522: AND cz_ui_templates.deleted_flag = '0';

Line 3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id

3515:
3516: SELECT jrad_doc
3517: BULK COLLECT INTO l_jrad_doc_tbl
3518: FROM cz_ui_templates
3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
3520: AND cz_ui_templates.template_id = p_template_id
3521: AND cz_ui_templates.seeded_flag = '0'
3522: AND cz_ui_templates.deleted_flag = '0';
3523:

Line 3520: AND cz_ui_templates.template_id = p_template_id

3516: SELECT jrad_doc
3517: BULK COLLECT INTO l_jrad_doc_tbl
3518: FROM cz_ui_templates
3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
3520: AND cz_ui_templates.template_id = p_template_id
3521: AND cz_ui_templates.seeded_flag = '0'
3522: AND cz_ui_templates.deleted_flag = '0';
3523:
3524: IF (l_jrad_doc_tbl.COUNT > 0)

Line 3521: AND cz_ui_templates.seeded_flag = '0'

3517: BULK COLLECT INTO l_jrad_doc_tbl
3518: FROM cz_ui_templates
3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
3520: AND cz_ui_templates.template_id = p_template_id
3521: AND cz_ui_templates.seeded_flag = '0'
3522: AND cz_ui_templates.deleted_flag = '0';
3523:
3524: IF (l_jrad_doc_tbl.COUNT > 0)
3525: THEN

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

3518: FROM cz_ui_templates
3519: WHERE cz_ui_templates.ui_def_id = p_ui_def_id
3520: AND cz_ui_templates.template_id = p_template_id
3521: AND cz_ui_templates.seeded_flag = '0'
3522: AND cz_ui_templates.deleted_flag = '0';
3523:
3524: IF (l_jrad_doc_tbl.COUNT > 0)
3525: THEN
3526: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || '; commit; end; ';

Line 3567: FROM cz_ui_templates

3563: END IF;
3564:
3565: SELECT ui_def_id, template_id
3566: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
3567: FROM cz_ui_templates
3568: WHERE cz_ui_templates.deleted_flag = '0'
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(

Line 3568: WHERE cz_ui_templates.deleted_flag = '0'

3564:
3565: SELECT ui_def_id, template_id
3566: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
3567: FROM cz_ui_templates
3568: WHERE cz_ui_templates.deleted_flag = '0'
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id

Line 3569: AND cz_ui_templates.seeded_flag = '0'

3565: SELECT ui_def_id, template_id
3566: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
3567: FROM cz_ui_templates
3568: WHERE cz_ui_templates.deleted_flag = '0'
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs

Line 3570: AND ( cz_ui_templates.ui_def_id = 0

3566: BULK COLLECT INTO l_ui_def_id_tbl, l_template_id_tbl
3567: FROM cz_ui_templates
3568: WHERE cz_ui_templates.deleted_flag = '0'
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'

Line 3571: OR cz_ui_templates.ui_def_id IN(

3567: FROM cz_ui_templates
3568: WHERE cz_ui_templates.deleted_flag = '0'
3569: AND cz_ui_templates.seeded_flag = '0'
3570: AND ( cz_ui_templates.ui_def_id = 0
3571: OR cz_ui_templates.ui_def_id IN(
3572: SELECT ui_def_id
3573: FROM cz_ui_defs
3574: WHERE cz_ui_defs.deleted_flag = '0'
3575: AND cz_ui_defs.devl_project_id IN(SELECT object_id

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

4705: ELSE
4706: l_ui_def_id := 1;
4707: END IF;
4708:
4709: l_str := 'update cz_ui_templates'|| CZ_PB_MGR.v_db_link || ' set template_rev_nbr=template_rev_nbr+1 '
4710: || ' where template_id=:1 and ui_def_id=:2';
4711:
4712: FOR i IN l_template_id_ref.FIRST..l_template_id_ref.LAST
4713: LOOP

Line 4800: ----insert into cz_ui_templates

4796: RAISE;
4797: END insert_template_elements;
4798:
4799: ------------------------------------------------------------
4800: ----insert into cz_ui_templates
4801: PROCEDURE insert_ui_templates
4802: IS
4803: rec_count NUMBER := 0;
4804: plsql_table_list cz_pb_mgr.col_plsql_table_list;

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

4836:
4837: -----resplve templates
4838: --bug 5191745
4839: --before the fix, even for model migration, the ui_def_ids were being populated
4840: --with a value of '1' for CZ_UI_TEMPLATES record.
4841: --The ideal fix would have been to call 'resolve_tmpl_ui_defs' on its own, because
4842: --'resolve_tmpl_ui_defs' already checks for model migration condition
4843: --and assigns the ui_def_id correctly.
4844: --But there is a possibility that it would introduce regression in publishing

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

4864: END LOOP;
4865: -- END IF;
4866:
4867: -- main msg and title intl text records handled in insert_jrad_ui_intl_texts
4868: 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');
4869: 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');
4870:
4871: plsql_table_list.DELETE;
4872: rec_count := 1;

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

4865: -- END IF;
4866:
4867: -- main msg and title intl text records handled in insert_jrad_ui_intl_texts
4868: 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');
4869: 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');
4870:
4871: plsql_table_list.DELETE;
4872: rec_count := 1;
4873: plsql_table_list(rec_count).col_name := 'template_id';

Line 4895: insert_into_table('CZ_UI_TEMPLATES'

4891: rec_count := rec_count + 1;
4892: plsql_table_list(rec_count).col_name := 'button_bar_templ_uidef_id';
4893: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_templates_but_uidef_id';
4894:
4895: insert_into_table('CZ_UI_TEMPLATES'
4896: ,'template_id'
4897: ,'ui_def_id'
4898: ,cz_pb_mgr.v_db_link
4899: ,plsql_table_list

Line 5193: FROM cz_ui_templates

5189: LOOP
5190: BEGIN
5191: SELECT 1
5192: INTO l_tmp_id
5193: FROM cz_ui_templates
5194: WHERE cz_ui_templates.ui_def_id IS NULL AND cz_ui_templates.template_id = p_templates_tbl(tempid);
5195: EXCEPTION
5196: WHEN NO_DATA_FOUND
5197: THEN

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

5190: BEGIN
5191: SELECT 1
5192: INTO l_tmp_id
5193: FROM cz_ui_templates
5194: WHERE cz_ui_templates.ui_def_id IS NULL AND cz_ui_templates.template_id = p_templates_tbl(tempid);
5195: EXCEPTION
5196: WHEN NO_DATA_FOUND
5197: THEN
5198: l_tmp_id := 0;

Line 5565: ----insert into cz_ui_templates

5561: l_new_document VARCHAR2(255);
5562: BEGIN
5563: ----insert intl texts of JRAD UI(s)
5564: insert_jrad_ui_intl_texts;
5565: ----insert into cz_ui_templates
5566: insert_ui_templates;
5567: -----insert ref templates
5568: insert_ref_templates;
5569: ----collect ui pages

Line 7171: FROM cz_ui_templates

7167:
7168: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7169: IS
7170: SELECT last_update_date
7171: FROM cz_ui_templates
7172: WHERE cz_ui_templates.ui_def_id = p_ui_def_id AND cz_ui_templates.deleted_flag = '0'
7173: ORDER BY last_update_date DESC;
7174:
7175: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)

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

7168: CURSOR ui_templs_cur(p_ui_def_id NUMBER)
7169: IS
7170: SELECT last_update_date
7171: FROM cz_ui_templates
7172: WHERE cz_ui_templates.ui_def_id = p_ui_def_id AND cz_ui_templates.deleted_flag = '0'
7173: ORDER BY last_update_date DESC;
7174:
7175: CURSOR ui_cont_templs_cur(p_ui_def_id NUMBER)
7176: IS

Line 7781: FROM cz_ui_templates

7777: IS
7778: BEGIN
7779: SELECT last_update_date
7780: INTO x_max_date
7781: FROM cz_ui_templates
7782: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
7783: EXCEPTION
7784: WHEN OTHERS
7785: THEN

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

7778: BEGIN
7779: SELECT last_update_date
7780: INTO x_max_date
7781: FROM cz_ui_templates
7782: WHERE cz_ui_templates.template_id = p_template_id AND cz_ui_templates.deleted_flag = record_not_deleted;
7783: EXCEPTION
7784: WHEN OTHERS
7785: THEN
7786: x_max_date := cz_utils.epoch_begin;

Line 7803: FROM cz_ui_templates

7799: FOR i IN p_global_templs_ref.FIRST .. p_global_templs_ref.LAST
7800: LOOP
7801: SELECT last_update_date
7802: INTO l_last_update_date
7803: FROM cz_ui_templates
7804: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
7805: AND cz_ui_templates.deleted_flag = record_not_deleted
7806: AND cz_ui_templates.ui_def_id = 0;
7807:

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

7800: LOOP
7801: SELECT last_update_date
7802: INTO l_last_update_date
7803: FROM cz_ui_templates
7804: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
7805: AND cz_ui_templates.deleted_flag = record_not_deleted
7806: AND cz_ui_templates.ui_def_id = 0;
7807:
7808: IF (l_last_update_date > l_prev_date)

Line 7805: AND cz_ui_templates.deleted_flag = record_not_deleted

7801: SELECT last_update_date
7802: INTO l_last_update_date
7803: FROM cz_ui_templates
7804: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
7805: AND cz_ui_templates.deleted_flag = record_not_deleted
7806: AND cz_ui_templates.ui_def_id = 0;
7807:
7808: IF (l_last_update_date > l_prev_date)
7809: THEN

Line 7806: AND cz_ui_templates.ui_def_id = 0;

7802: INTO l_last_update_date
7803: FROM cz_ui_templates
7804: WHERE cz_ui_templates.template_id = p_global_templs_ref(i)
7805: AND cz_ui_templates.deleted_flag = record_not_deleted
7806: AND cz_ui_templates.ui_def_id = 0;
7807:
7808: IF (l_last_update_date > l_prev_date)
7809: THEN
7810: x_max_update_date := l_last_update_date;

Line 8288: l_template_id := cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates,

8284: l_template_id NUMBER;
8285: BEGIN
8286: l_template_id := get_target_template(p_template_id);
8287: IF (l_template_id = -1) THEN
8288: l_template_id := cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates,
8289: 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
8290: END IF;
8291:
8292: RETURN l_template_id;

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

8285: BEGIN
8286: l_template_id := get_target_template(p_template_id);
8287: IF (l_template_id = -1) THEN
8288: l_template_id := cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates,
8289: 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link, cz_pb_mgr.v_oraclesequenceincr);
8290: END IF;
8291:
8292: RETURN l_template_id;
8293: EXCEPTION

Line 8321: FROM cz_ui_templates

8317: AND cz_model_publications.deleted_flag = '0';
8318:
8319: SELECT last_update_date
8320: INTO l_uit_update_date
8321: FROM cz_ui_templates
8322: WHERE ui_def_id = 0 AND template_id = p_template_id AND deleted_flag = '0';
8323:
8324: -- if template changed since last publication
8325: IF (l_uit_update_date > l_last_update_date) THEN

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

8348: l_all_tmpl_map cz_pb_mgr.t_ref_idx_vc2;
8349: l_temp_tbl cz_pb_mgr.t_ref;
8350: l_rec_count PLS_INTEGER;
8351: l_template_id NUMBER;
8352: l_jrad_doc VARCHAR2(255); -- cz_ui_templates.jrad_doc%TYPE;
8353:
8354: -- used for synch operation and insert operation resp
8355: l_parent_container_type NUMBER;
8356: l_root_element_signature_id NUMBER;

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

8353:
8354: -- used for synch operation and insert operation resp
8355: l_parent_container_type NUMBER;
8356: l_root_element_signature_id NUMBER;
8357: l_template_name VARCHAR2(255); -- cz_ui_templates.TEMPLATE_NAME%TYPE;
8358: l_root_region_type VARCHAR2(255); -- cz_ui_templates.ROOT_REGION_TYPE%TYPE;
8359:
8360: remote_uct ref_cursor;
8361:

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

8354: -- used for synch operation and insert operation resp
8355: l_parent_container_type NUMBER;
8356: l_root_element_signature_id NUMBER;
8357: l_template_name VARCHAR2(255); -- cz_ui_templates.TEMPLATE_NAME%TYPE;
8358: l_root_region_type VARCHAR2(255); -- cz_ui_templates.ROOT_REGION_TYPE%TYPE;
8359:
8360: remote_uct ref_cursor;
8361:
8362: document_synch EXCEPTION;

Line 8435: FROM cz_ui_templates

8431: FROM cz_ui_collect_tmpls_v
8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
8437: AND cz_ui_templates.ui_def_id = 0);
8438:
8439: check_template_status(l_temp_tbl);

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

8432: WHERE cz_ui_collect_tmpls_v.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_ref(i)
8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
8437: AND cz_ui_templates.ui_def_id = 0);
8438:
8439: check_template_status(l_temp_tbl);
8440: END LOOP;

Line 8437: AND cz_ui_templates.ui_def_id = 0);

8433: AND cz_ui_collect_tmpls_v.template_id IN
8434: (SELECT template_id
8435: FROM cz_ui_templates
8436: WHERE cz_ui_templates.deleted_flag = '0' AND cz_ui_templates.seeded_flag = '0'
8437: AND cz_ui_templates.ui_def_id = 0);
8438:
8439: check_template_status(l_temp_tbl);
8440: END LOOP;
8441: END IF;

Line 8454: FROM cz_ui_templates t

8450: WHERE cz_ui_ref_templates.deleted_flag = '0'
8451: AND cz_ui_ref_templates.seeded_flag = '0'
8452: AND cz_ui_ref_templates.ref_template_id IN
8453: (SELECT template_id
8454: FROM cz_ui_templates t
8455: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0)
8456: START WITH cz_ui_ref_templates.template_id = l_new_tmpl_tbl(i)
8457: CONNECT BY PRIOR ref_template_id = cz_ui_ref_templates.template_id
8458: AND PRIOR cz_ui_ref_templates.deleted_flag = '0';

Line 8471: FROM cz_ui_templates

8467: IF l_rec_count > 0 THEN
8468: FOR i IN 1 .. l_rec_count LOOP
8469: l_temp_tbl.DELETE;
8470: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
8471: FROM cz_ui_templates
8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL

Line 8472: WHERE cz_ui_templates.deleted_flag = '0'

8468: FOR i IN 1 .. l_rec_count LOOP
8469: l_temp_tbl.DELETE;
8470: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
8471: FROM cz_ui_templates
8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)

Line 8473: AND cz_ui_templates.seeded_flag = '0'

8469: l_temp_tbl.DELETE;
8470: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
8471: FROM cz_ui_templates
8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN

Line 8474: AND cz_ui_templates.ui_def_id = 0

8470: SELECT button_bar_template_id BULK COLLECT INTO l_temp_tbl
8471: FROM cz_ui_templates
8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN
8478: (SELECT template_id

Line 8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL

8471: FROM cz_ui_templates
8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN
8478: (SELECT template_id
8479: FROM cz_ui_templates t

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

8472: WHERE cz_ui_templates.deleted_flag = '0'
8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN
8478: (SELECT template_id
8479: FROM cz_ui_templates t
8480: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);

Line 8477: AND cz_ui_templates.button_bar_template_id IN

8473: AND cz_ui_templates.seeded_flag = '0'
8474: AND cz_ui_templates.ui_def_id = 0
8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN
8478: (SELECT template_id
8479: FROM cz_ui_templates t
8480: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);
8481:

Line 8479: FROM cz_ui_templates t

8475: AND cz_ui_templates.button_bar_template_id IS NOT NULL
8476: AND cz_ui_templates.template_id = l_new_tmpl_tbl(i)
8477: AND cz_ui_templates.button_bar_template_id IN
8478: (SELECT template_id
8479: FROM cz_ui_templates t
8480: WHERE t.deleted_flag = '0' AND t.seeded_flag = '0' AND t.ui_def_id = 0);
8481:
8482: check_template_status(l_temp_tbl);
8483: END LOOP;

Line 8499: AND EXISTS (SELECT NULL FROM cz_ui_templates

8495: (SELECT element_id FROM cz_ui_template_elements
8496: WHERE deleted_flag = '0' AND element_type = 552
8497: AND template_id = l_new_tmpl_tbl(i)
8498: AND ui_def_id = 0 and seeded_flag = '0')
8499: AND EXISTS (SELECT NULL FROM cz_ui_templates
8500: WHERE deleted_flag = '0' AND ui_def_id = 0
8501: AND template_id = act.processing_page_templ_id AND seeded_flag = '0');
8502:
8503: check_template_status(l_temp_tbl);

Line 8511: FOR j IN (SELECT * FROM cz_ui_templates

8507: IF (l_new_tmpl_tbl.COUNT > 0) THEN
8508: l_rec_count := 0;
8509:
8510: FOR i IN l_new_tmpl_tbl.FIRST .. l_new_tmpl_tbl.LAST LOOP
8511: FOR j IN (SELECT * FROM cz_ui_templates
8512: WHERE template_id = l_new_tmpl_tbl(i) AND ui_def_id = '0' AND deleted_flag = '0') LOOP
8513: IF cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model THEN
8514: -- The synch check will be performed here
8515: -- The template name will be checked over the link

Line 8524: || 'root_element_signature_id from cz_ui_templates'

8520: l_root_region_type := NULL;
8521: l_root_element_signature_id := NULL;
8522:
8523: OPEN remote_uct FOR 'Select template_name,template_id,parent_container_type,root_region_type,'
8524: || 'root_element_signature_id from cz_ui_templates'
8525: || cz_pb_mgr.v_db_link || 't '
8526: || 'where t.ui_def_id = ''0'' and t.template_usage = ''0'' and '
8527: || 't.deleted_flag = ''0'' and t.seeded_flag = ''0'' and '
8528: || 't.template_name = :1 and t.template_type = :2 and nvl(t.message_type,-1) = nvl(:3,-1)'

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

8534: IF l_template_name IS NOT NULL AND
8535: ( l_parent_container_type <> j.parent_container_type
8536: OR l_root_region_type <> j.root_region_type
8537: OR l_root_element_signature_id <> j.root_element_signature_id ) THEN
8538: cz_pb_mgr.v_err_message := cz_utils.get_text('UCT synch error', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
8539: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
8540: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8541: RAISE document_synch;
8542: END IF;

Line 8595: FROM cz_ui_templates

8591: IF l_old_tmpl_tbl.COUNT > 0 THEN
8592: l_rec_count := 0;
8593: FOR i IN l_old_tmpl_tbl.FIRST..l_old_tmpl_tbl.LAST LOOP
8594: SELECT jrad_doc INTO l_jrad_doc
8595: FROM cz_ui_templates
8596: WHERE template_id = l_old_tmpl_tbl(i) AND ui_def_id = 0 AND deleted_flag = '0';
8597:
8598: l_rec_count := l_rec_count + 1;
8599: CZ_PB_MGR.g_tmpl_jrad_old_tbl(l_rec_count) := l_jrad_doc;

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

8608: END IF;
8609:
8610: EXCEPTION
8611: WHEN OTHERS THEN
8612: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_templates', 'SQLERRM', SQLERRM);
8613: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIGLTEMPLATES', SQLCODE);
8614: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8615: RAISE;
8616: END get_oa_tmpls;

Line 16992: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates

16988: cz_pb_mgr.g_ui_templates_button_tbl.DELETE;
16989:
16990: IF (cz_pb_mgr.v_server_id = 0)
16991: THEN
16992: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates
16993: , 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link
16994: ,cz_pb_mgr.v_oraclesequenceincr
16995: )
16996: ,template_id, main_message_id, title_id

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

16989:
16990: IF (cz_pb_mgr.v_server_id = 0)
16991: THEN
16992: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_templates
16993: , 'cz_ui_templates_s.nextval' || cz_pb_mgr.v_db_link
16994: ,cz_pb_mgr.v_oraclesequenceincr
16995: )
16996: ,template_id, main_message_id, title_id
16997: ,jrad_doc, -1, 0

Line 17003: FROM cz_ui_templates

16999: BULK COLLECT INTO cz_pb_mgr.g_ui_templates_new_temp_id_ref
17000: ,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
17001: ,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
17002: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
17003: FROM cz_ui_templates
17004: 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;
17005: ELSE
17006: SELECT template_id, template_id, main_message_id
17007: ,title_id, jrad_doc, -1

Line 17004: 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;

17000: ,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
17001: ,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
17002: ,cz_pb_mgr.g_ui_templates_ui_def_old_ref
17003: FROM cz_ui_templates
17004: 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;
17005: ELSE
17006: SELECT template_id, template_id, main_message_id
17007: ,title_id, jrad_doc, -1
17008: ,0, 0

Line 17012: FROM cz_ui_templates

17008: ,0, 0
17009: 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
17010: ,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
17011: ,cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.g_ui_templates_ui_def_old_ref
17012: FROM cz_ui_templates
17013: 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;
17014: END IF;
17015:
17016: ------main msg

Line 17013: 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;

17009: 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
17010: ,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
17011: ,cz_pb_mgr.v_intl_text_ui_tbl, cz_pb_mgr.g_ui_templates_ui_def_old_ref
17012: FROM cz_ui_templates
17013: 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;
17014: END IF;
17015:
17016: ------main msg
17017: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);

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

17013: 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;
17014: END IF;
17015:
17016: ------main msg
17017: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
17018: 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');
17019: ----title id
17020: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
17021: 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 17018: 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');

17014: END IF;
17015:
17016: ------main msg
17017: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
17018: 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');
17019: ----title id
17020: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
17021: 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');
17022:

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

17016: ------main msg
17017: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
17018: 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');
17019: ----title id
17020: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
17021: 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');
17022:
17023: IF (cz_pb_mgr.g_ui_templates_jrad_new_ref.COUNT > 0)
17024: THEN

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

17017: insert_intl_texts(cz_pb_mgr.g_ui_templates_msg_id_ref, 'main message ids of cz ui templates', TRUE);
17018: 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');
17019: ----title id
17020: insert_intl_texts(cz_pb_mgr.g_ui_templates_title_ref, 'main message ids of cz ui templates', TRUE);
17021: 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');
17022:
17023: IF (cz_pb_mgr.g_ui_templates_jrad_new_ref.COUNT > 0)
17024: THEN
17025: FOR doc IN cz_pb_mgr.g_ui_templates_jrad_new_ref.FIRST .. cz_pb_mgr.g_ui_templates_jrad_new_ref.LAST

Line 18332: FROM cz_ui_templates

18328: l_count NUMBER := 0;
18329: BEGIN
18330: SELECT 1
18331: INTO l_count
18332: FROM cz_ui_templates
18333: WHERE cz_ui_templates.template_id = p_template_id
18334: AND cz_ui_templates.ui_def_id = 0
18335: AND cz_ui_templates.deleted_flag = record_not_deleted
18336: AND ROWNUM < 2;

Line 18333: WHERE cz_ui_templates.template_id = p_template_id

18329: BEGIN
18330: SELECT 1
18331: INTO l_count
18332: FROM cz_ui_templates
18333: WHERE cz_ui_templates.template_id = p_template_id
18334: AND cz_ui_templates.ui_def_id = 0
18335: AND cz_ui_templates.deleted_flag = record_not_deleted
18336: AND ROWNUM < 2;
18337: EXCEPTION

Line 18334: AND cz_ui_templates.ui_def_id = 0

18330: SELECT 1
18331: INTO l_count
18332: FROM cz_ui_templates
18333: WHERE cz_ui_templates.template_id = p_template_id
18334: AND cz_ui_templates.ui_def_id = 0
18335: AND cz_ui_templates.deleted_flag = record_not_deleted
18336: AND ROWNUM < 2;
18337: EXCEPTION
18338: WHEN NO_DATA_FOUND

Line 18335: AND cz_ui_templates.deleted_flag = record_not_deleted

18331: INTO l_count
18332: FROM cz_ui_templates
18333: WHERE cz_ui_templates.template_id = p_template_id
18334: AND cz_ui_templates.ui_def_id = 0
18335: AND cz_ui_templates.deleted_flag = record_not_deleted
18336: AND ROWNUM < 2;
18337: EXCEPTION
18338: WHEN NO_DATA_FOUND
18339: THEN