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_TEMPLATE_ELEMENTS

Line 5182: l_persistent_element_id CZ_UI_TEMPLATE_ELEMENTS.persistent_element_id%TYPE := p_persistent_element_id;

5178:
5179: --Bug 5525718 - In case of migration the ui_def_id should be 0
5180:
5181: l_ui_def_id NUMBER := 1;
5182: l_persistent_element_id CZ_UI_TEMPLATE_ELEMENTS.persistent_element_id%TYPE := p_persistent_element_id;
5183:
5184: BEGIN
5185:
5186: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN

Line 5192: 'insert into cz_ui_template_elements'

5188: l_persistent_element_id := p_element_id;
5189: END IF;
5190:
5191: l_str :=
5192: 'insert into cz_ui_template_elements'
5193: || p_link_name
5194: || ' (TEMPLATE_ID,UI_DEF_ID,'
5195: || ' '
5196: || 'ELEMENT_TYPE,ELEMENT_ID,PERSISTENT_ELEMENT_ID,DELETED_FLAG,seeded_flag)'

Line 5214: -------bug#13517253 physical delete from cz_localized_texts before deleteing the cz_ui_template_elements.

5210: IS
5211: l_str VARCHAR2(2000);
5212: BEGIN
5213:
5214: -------bug#13517253 physical delete from cz_localized_texts before deleteing the cz_ui_template_elements.
5215: ---- Else this leads to the unwanted data in this table for every template publication.
5216: -------mpothubo.
5217:
5218:

Line 5231: || ' (SELECT element_id FROM cz_ui_template_elements'

5227: || ' AND NVL(seeded_flag, ''0'') = ''0'''
5228: || ' AND deleted_flag = ''0'''
5229: || ' AND intl_text_id'
5230: || ' IN'
5231: || ' (SELECT element_id FROM cz_ui_template_elements'
5232: || p_link_name
5233: || ' WHERE element_type = ''8'''
5234: || ' AND ui_def_id= :2'
5235: || ' AND template_id = :3'

Line 5244: log_timing_message('No. of Records updated in cz_localized_texts (cz_ui_template_elements.element_id) : ' || sql%rowcount );

5240: EXECUTE IMMEDIATE l_str
5241: USING p_ui_def_id, p_ui_def_id, p_template_id ;
5242:
5243: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5244: log_timing_message('No. of Records updated in cz_localized_texts (cz_ui_template_elements.element_id) : ' || sql%rowcount );
5245: log_timing_message('End of update of cz_localized_texts ');
5246: END IF;
5247:
5248: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN

Line 5249: log_timing_message('Start of delete of cz_ui_template_elements ');

5245: log_timing_message('End of update of cz_localized_texts ');
5246: END IF;
5247:
5248: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5249: log_timing_message('Start of delete of cz_ui_template_elements ');
5250: END IF;
5251:
5252: l_str :=
5253: 'DELETE FROM cz_ui_template_elements' || p_link_name || ' t' || ' ' || 'WHERE t.template_id = :1' || ' ' || 'AND t.ui_def_id = :2' ;

Line 5253: 'DELETE FROM cz_ui_template_elements' || p_link_name || ' t' || ' ' || 'WHERE t.template_id = :1' || ' ' || 'AND t.ui_def_id = :2' ;

5249: log_timing_message('Start of delete of cz_ui_template_elements ');
5250: END IF;
5251:
5252: l_str :=
5253: 'DELETE FROM cz_ui_template_elements' || p_link_name || ' t' || ' ' || 'WHERE t.template_id = :1' || ' ' || 'AND t.ui_def_id = :2' ;
5254:
5255: EXECUTE IMMEDIATE l_str
5256: USING p_template_id, p_ui_def_id;
5257:

Line 5259: log_timing_message('No. of Records deleted in cz_ui_template_elements ' || sql%rowcount );

5255: EXECUTE IMMEDIATE l_str
5256: USING p_template_id, p_ui_def_id;
5257:
5258: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5259: log_timing_message('No. of Records deleted in cz_ui_template_elements ' || sql%rowcount );
5260: log_timing_message('End of delete of cz_ui_template_elements ');
5261: END IF;
5262:
5263: EXCEPTION

Line 5260: log_timing_message('End of delete of cz_ui_template_elements ');

5256: USING p_template_id, p_ui_def_id;
5257:
5258: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
5259: log_timing_message('No. of Records deleted in cz_ui_template_elements ' || sql%rowcount );
5260: log_timing_message('End of delete of cz_ui_template_elements ');
5261: END IF;
5262:
5263: EXCEPTION
5264: WHEN OTHERS

Line 5438: -----insert into cz_ui_template_elements

5434: --actions. So, there was a possibility that some other element type id will get overriden. The resolution is moved to the
5435: --collect_global_actions procedure.
5436: FOR i IN CZ_PB_MGR.l_template_id_ref.FIRST .. CZ_PB_MGR.l_template_id_ref.LAST
5437: LOOP
5438: -----insert into cz_ui_template_elements
5439: insert_template_elements(CZ_PB_MGR.l_template_id_ref(i)
5440: ,l_ui_def_id
5441: ,CZ_PB_MGR.l_element_type_ref(i)
5442: ,CZ_PB_MGR.l_element_id_ref(i)

Line 8930: FROM cz_ui_template_elements

8926: l_pers_elem_tbl.DELETE;
8927:
8928: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8929: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8930: FROM cz_ui_template_elements
8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8932: AND cz_ui_template_elements.ui_def_id = 0
8933: AND cz_ui_template_elements.deleted_flag = '0'
8934: AND cz_ui_template_elements.seeded_flag <> seed_data;

Line 8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)

8927:
8928: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8929: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8930: FROM cz_ui_template_elements
8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8932: AND cz_ui_template_elements.ui_def_id = 0
8933: AND cz_ui_template_elements.deleted_flag = '0'
8934: AND cz_ui_template_elements.seeded_flag <> seed_data;
8935:

Line 8932: AND cz_ui_template_elements.ui_def_id = 0

8928: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8929: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8930: FROM cz_ui_template_elements
8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8932: AND cz_ui_template_elements.ui_def_id = 0
8933: AND cz_ui_template_elements.deleted_flag = '0'
8934: AND cz_ui_template_elements.seeded_flag <> seed_data;
8935:
8936: IF (l_template_id_tbl.COUNT > 0)

Line 8933: AND cz_ui_template_elements.deleted_flag = '0'

8929: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8930: FROM cz_ui_template_elements
8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8932: AND cz_ui_template_elements.ui_def_id = 0
8933: AND cz_ui_template_elements.deleted_flag = '0'
8934: AND cz_ui_template_elements.seeded_flag <> seed_data;
8935:
8936: IF (l_template_id_tbl.COUNT > 0)
8937: THEN

Line 8934: AND cz_ui_template_elements.seeded_flag <> seed_data;

8930: FROM cz_ui_template_elements
8931: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8932: AND cz_ui_template_elements.ui_def_id = 0
8933: AND cz_ui_template_elements.deleted_flag = '0'
8934: AND cz_ui_template_elements.seeded_flag <> seed_data;
8935:
8936: IF (l_template_id_tbl.COUNT > 0)
8937: THEN
8938: rec_count := cz_pb_mgr.l_template_id_ref.COUNT;

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

8962: THEN
8963: NULL;
8964: WHEN OTHERS
8965: THEN
8966: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_template_elements', 'SQLERRM', SQLERRM);
8967: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_TMPLELEM', SQLCODE);
8968: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8969: RAISE;
8970: END collect_template_elements;

Line 9230: (SELECT element_id FROM cz_ui_template_elements

9226: l_temp_tbl.DELETE;
9227: SELECT processing_page_templ_id BULK COLLECT INTO l_temp_tbl
9228: FROM cz_ui_actions act
9229: WHERE deleted_flag = '0' AND ui_def_id = 0 AND ui_action_id IN
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

Line 9516: FROM cz_ui_template_elements

9512: LOOP
9513: BEGIN
9514: SELECT MAX(last_update_date)
9515: INTO l_capt_update_date
9516: FROM cz_ui_template_elements
9517: WHERE template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i);
9518: EXCEPTION
9519: WHEN OTHERS
9520: THEN