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_ACTIONS

Line 2501: 'UPDATE cz_ui_actions'

2497: LOOP
2498: IF (cz_pb_mgr.g_ui_actns_ui_uidef_old_ref(i) = 0)
2499: THEN
2500: l_update_str :=
2501: 'UPDATE cz_ui_actions'
2502: || cz_pb_mgr.v_db_link
2503: || ' t'
2504: || ' '
2505: || 'SET (CONTEXT_COMPONENT_ID,RENDER_CONDITION_ID,UI_ACTION_TYPE,'

Line 2523: || 'FROM cz_ui_actions WHERE ui_def_id = 0'

2519: || 'TARGET_WINDOW_TYPE,TARGET_WINDOW_NAME,:4,URL_PROPERTY_ID,'
2520: || 'TARGET_PERSISTENT_NODE_ID,TARGET_NODE_PATH,TARGET_PAGE_SET_ID,'
2521: || 'TARGET_PAGE_ID,TARGET_URL,FRAME_NAME,TARGET_ANCHOR,'
2522: || ':5,:6,:7,:8,:9 '
2523: || 'FROM cz_ui_actions WHERE ui_def_id = 0'
2524: || ' '
2525: || 'AND ui_action_id = :10 )'
2526: || ' '
2527: || 'WHERE t.ui_def_id = 1'

Line 5084: FROM cz_ui_actions

5080: ,PROCESSING_CAPTION_TEXT_ID, PAGE_TITLE_TEXT_ID, MAIN_MESSAGE_TEXT_ID
5081: BULK COLLECT INTO l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
5082: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5083: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5084: FROM cz_ui_actions
5085: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5086: AND cz_ui_actions.deleted_flag = record_not_deleted
5087: AND cz_ui_actions.seeded_flag <> seed_data;
5088:

Line 5085: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)

5081: BULK COLLECT INTO l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
5082: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5083: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5084: FROM cz_ui_actions
5085: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5086: AND cz_ui_actions.deleted_flag = record_not_deleted
5087: AND cz_ui_actions.seeded_flag <> seed_data;
5088:
5089: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN

Line 5086: AND cz_ui_actions.deleted_flag = record_not_deleted

5082: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5083: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5084: FROM cz_ui_actions
5085: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5086: AND cz_ui_actions.deleted_flag = record_not_deleted
5087: AND cz_ui_actions.seeded_flag <> seed_data;
5088:
5089: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN
5090: FOR uitmp IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST

Line 5087: AND cz_ui_actions.seeded_flag <> seed_data;

5083: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5084: FROM cz_ui_actions
5085: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5086: AND cz_ui_actions.deleted_flag = record_not_deleted
5087: AND cz_ui_actions.seeded_flag <> seed_data;
5088:
5089: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN
5090: FOR uitmp IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST
5091: LOOP

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

5111: THEN
5112: NULL;
5113: WHEN OTHERS
5114: THEN
5115: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
5116: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
5117: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5118: RAISE;
5119: END bulk_collect_ui_actions;

Line 5746: ,'cz_ui_actions.target_ui_def_id'

5742: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
5743: ,cz_pb_mgr.v_cz_ui_defs_old_ref
5744: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
5745: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
5746: ,'cz_ui_actions.target_ui_def_id'
5747: ,cz_pb_mgr.v_status_code
5748: );
5749: insert_into_table('cz_ui_actions'
5750: ,'ui_action_id'

Line 5749: insert_into_table('cz_ui_actions'

5745: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
5746: ,'cz_ui_actions.target_ui_def_id'
5747: ,cz_pb_mgr.v_status_code
5748: );
5749: insert_into_table('cz_ui_actions'
5750: ,'ui_action_id'
5751: ,'ui_def_id'
5752: ,cz_pb_mgr.v_db_link
5753: ,plsql_table_list

Line 6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);

6508: delete_from_table('cz_ui_cont_type_templs','ui_def_id','content_type',v_database_link,'cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref','cz_pb_mgr.l_cnt_typ_tmpls_cont_ref',cz_pb_mgr.l_cnt_typ_tmpls_new_uidef_ref);
6509: delete_from_table('cz_ui_ref_templates','template_id','template_ui_def_id',
6510: 'ref_template_id','ref_template_ui_def_id',v_database_link,'cz_pb_mgr.g_TEMPLATE_ID_ref','cz_pb_mgr.g_TEMPLATE_UI_ref',
6511: 'cz_pb_mgr.g_REF_TEMPLATE_ID_ref','cz_pb_mgr.g_REF_TEMPL_UI_ref',cz_pb_mgr.g_TEMPLATE_ID_ref);
6512: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
6513: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
6514: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
6515: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
6516: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);

Line 7185: FROM cz_ui_actions

7181:
7182: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7183: IS
7184: SELECT last_update_date
7185: FROM cz_ui_actions
7186: WHERE cz_ui_actions.ui_def_id = p_ui_def_id
7187: ORDER BY last_update_date DESC;
7188:
7189: CURSOR ui_images_cur(p_ui_def_id NUMBER)

Line 7186: WHERE cz_ui_actions.ui_def_id = p_ui_def_id

7182: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7183: IS
7184: SELECT last_update_date
7185: FROM cz_ui_actions
7186: WHERE cz_ui_actions.ui_def_id = p_ui_def_id
7187: ORDER BY last_update_date DESC;
7188:
7189: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7190: IS

Line 7948: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq

7944: l_pg_title_tbl.DELETE;
7945: l_main_msg_tbl.DELETE;
7946:
7947: IF (p_elem_type_ref(i) = 552) THEN
7948: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq
7949: , 'cz_ui_actions_s.nextval' || cz_pb_mgr.v_db_link
7950: ,cz_pb_mgr.v_oraclesequenceincr
7951: )
7952: ,ui_action_id, ui_def_id, target_ui_def_id, target_expl_node_id, context_component_id

Line 7949: , 'cz_ui_actions_s.nextval' || cz_pb_mgr.v_db_link

7945: l_main_msg_tbl.DELETE;
7946:
7947: IF (p_elem_type_ref(i) = 552) THEN
7948: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq
7949: , 'cz_ui_actions_s.nextval' || cz_pb_mgr.v_db_link
7950: ,cz_pb_mgr.v_oraclesequenceincr
7951: )
7952: ,ui_action_id, ui_def_id, target_ui_def_id, target_expl_node_id, context_component_id
7953: ,render_condition_id, PROCESSING_PAGE_TEMPL_ID, PROC_PAGE_TEMPL_UI_DEF_ID

Line 7959: FROM cz_ui_actions

7955: BULK COLLECT INTO l_ui_actns_ui_act_new_id_tbl
7956: ,l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
7957: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
7958: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
7959: FROM cz_ui_actions
7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
7961: AND cz_ui_actions.ui_def_id = 0
7962: AND cz_ui_actions.deleted_flag = record_not_deleted
7963: AND cz_ui_actions.seeded_flag <> seed_data;

Line 7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)

7956: ,l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
7957: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
7958: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
7959: FROM cz_ui_actions
7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
7961: AND cz_ui_actions.ui_def_id = 0
7962: AND cz_ui_actions.deleted_flag = record_not_deleted
7963: AND cz_ui_actions.seeded_flag <> seed_data;
7964: END IF;

Line 7961: AND cz_ui_actions.ui_def_id = 0

7957: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
7958: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
7959: FROM cz_ui_actions
7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
7961: AND cz_ui_actions.ui_def_id = 0
7962: AND cz_ui_actions.deleted_flag = record_not_deleted
7963: AND cz_ui_actions.seeded_flag <> seed_data;
7964: END IF;
7965:

Line 7962: AND cz_ui_actions.deleted_flag = record_not_deleted

7958: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
7959: FROM cz_ui_actions
7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
7961: AND cz_ui_actions.ui_def_id = 0
7962: AND cz_ui_actions.deleted_flag = record_not_deleted
7963: AND cz_ui_actions.seeded_flag <> seed_data;
7964: END IF;
7965:
7966: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN

Line 7963: AND cz_ui_actions.seeded_flag <> seed_data;

7959: FROM cz_ui_actions
7960: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
7961: AND cz_ui_actions.ui_def_id = 0
7962: AND cz_ui_actions.deleted_flag = record_not_deleted
7963: AND cz_ui_actions.seeded_flag <> seed_data;
7964: END IF;
7965:
7966: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN
7967: FOR j IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST

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

8026: EXCEPTION
8027: WHEN NO_DATA_FOUND THEN
8028: NULL;
8029: WHEN OTHERS THEN
8030: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
8031: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
8032: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8033: RAISE;
8034: END collect_global_actions;

Line 8493: FROM cz_ui_actions act

8489: IF l_rec_count > 0 THEN
8490: FOR i IN 1 .. l_rec_count LOOP
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)

Line 10954: ,'cz_ui_actions.target_ui_def_id'

10950: ,'cz_ui_refs.ref_ui_def_id'
10951: ,'cz_ui_page_refs.target_ui_def_id'
10952: ,'cz_ui_page_elements.target_page_ui_def_id'
10953: ,'cz_ui_ref_templates.ref_template_ui_def_id'
10954: ,'cz_ui_actions.target_ui_def_id'
10955: )
10956: )
10957: THEN
10958: BEGIN