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_TEMPLATE_ELEMENTS

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

4517:
4518: --Bug 5525718 - In case of migration the ui_def_id should be 0
4519:
4520: l_ui_def_id NUMBER := 1;
4521: l_persistent_element_id CZ_UI_TEMPLATE_ELEMENTS.persistent_element_id%TYPE := p_persistent_element_id;
4522:
4523: BEGIN
4524:
4525: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN

Line 4531: 'insert into cz_ui_template_elements'

4527: l_persistent_element_id := p_element_id;
4528: END IF;
4529:
4530: l_str :=
4531: 'insert into cz_ui_template_elements'
4532: || p_link_name
4533: || ' (TEMPLATE_ID,UI_DEF_ID,'
4534: || ' '
4535: || 'ELEMENT_TYPE,ELEMENT_ID,PERSISTENT_ELEMENT_ID,DELETED_FLAG,seeded_flag)'

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

4549: IS
4550: l_str VARCHAR2(2000);
4551: BEGIN
4552: l_str :=
4553: 'DELETE FROM cz_ui_template_elements' || p_link_name || ' t' || ' ' || 'WHERE t.template_id = :1' || ' ' || 'AND t.ui_def_id = :2' ;
4554:
4555: EXECUTE IMMEDIATE l_str
4556: USING p_template_id, p_ui_def_id;
4557: EXCEPTION

Line 4732: -----insert into cz_ui_template_elements

4728: --actions. So, there was a possibility that some other element type id will get overriden. The resolution is moved to the
4729: --collect_global_actions procedure.
4730: FOR i IN CZ_PB_MGR.l_template_id_ref.FIRST .. CZ_PB_MGR.l_template_id_ref.LAST
4731: LOOP
4732: -----insert into cz_ui_template_elements
4733: insert_template_elements(CZ_PB_MGR.l_template_id_ref(i)
4734: ,l_ui_def_id
4735: ,CZ_PB_MGR.l_element_type_ref(i)
4736: ,CZ_PB_MGR.l_element_id_ref(i)

Line 8206: FROM cz_ui_template_elements

8202: l_pers_elem_tbl.DELETE;
8203:
8204: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8205: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8206: FROM cz_ui_template_elements
8207: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8208: AND cz_ui_template_elements.ui_def_id = 0
8209: AND cz_ui_template_elements.deleted_flag = '0'
8210: AND cz_ui_template_elements.seeded_flag <> seed_data;

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

8203:
8204: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8205: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8206: FROM cz_ui_template_elements
8207: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8208: AND cz_ui_template_elements.ui_def_id = 0
8209: AND cz_ui_template_elements.deleted_flag = '0'
8210: AND cz_ui_template_elements.seeded_flag <> seed_data;
8211:

Line 8208: AND cz_ui_template_elements.ui_def_id = 0

8204: SELECT template_id, ui_def_id, element_type, element_id, persistent_element_id
8205: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8206: FROM cz_ui_template_elements
8207: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8208: AND cz_ui_template_elements.ui_def_id = 0
8209: AND cz_ui_template_elements.deleted_flag = '0'
8210: AND cz_ui_template_elements.seeded_flag <> seed_data;
8211:
8212: IF (l_template_id_tbl.COUNT > 0)

Line 8209: AND cz_ui_template_elements.deleted_flag = '0'

8205: BULK COLLECT INTO l_template_id_tbl, l_ui_def_id_tbl, l_element_type_tbl, l_element_id_tbl, l_pers_elem_tbl
8206: FROM cz_ui_template_elements
8207: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8208: AND cz_ui_template_elements.ui_def_id = 0
8209: AND cz_ui_template_elements.deleted_flag = '0'
8210: AND cz_ui_template_elements.seeded_flag <> seed_data;
8211:
8212: IF (l_template_id_tbl.COUNT > 0)
8213: THEN

Line 8210: AND cz_ui_template_elements.seeded_flag <> seed_data;

8206: FROM cz_ui_template_elements
8207: WHERE cz_ui_template_elements.template_id = p_template_ref(i)
8208: AND cz_ui_template_elements.ui_def_id = 0
8209: AND cz_ui_template_elements.deleted_flag = '0'
8210: AND cz_ui_template_elements.seeded_flag <> seed_data;
8211:
8212: IF (l_template_id_tbl.COUNT > 0)
8213: THEN
8214: rec_count := cz_pb_mgr.l_template_id_ref.COUNT;

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

8238: THEN
8239: NULL;
8240: WHEN OTHERS
8241: THEN
8242: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_template_elements', 'SQLERRM', SQLERRM);
8243: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_TMPLELEM', SQLCODE);
8244: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8245: RAISE;
8246: END collect_template_elements;

Line 8495: (SELECT element_id FROM cz_ui_template_elements

8491: l_temp_tbl.DELETE;
8492: SELECT processing_page_templ_id BULK COLLECT INTO l_temp_tbl
8493: FROM cz_ui_actions act
8494: WHERE deleted_flag = '0' AND ui_def_id = 0 AND ui_action_id IN
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

Line 8760: FROM cz_ui_template_elements

8756: LOOP
8757: BEGIN
8758: SELECT MAX(last_update_date)
8759: INTO l_capt_update_date
8760: FROM cz_ui_template_elements
8761: WHERE template_id = cz_pb_mgr.g_ui_templates_old_temp_id_ref(i);
8762: EXCEPTION
8763: WHEN OTHERS
8764: THEN