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_ACTIONS

Line 3107: 'UPDATE cz_ui_actions'

3103: LOOP
3104: IF (cz_pb_mgr.g_ui_actns_ui_uidef_old_ref(i) = 0)
3105: THEN
3106: l_update_str :=
3107: 'UPDATE cz_ui_actions'
3108: || cz_pb_mgr.v_db_link
3109: || ' t'
3110: || ' '
3111: || 'SET (CONTEXT_COMPONENT_ID,RENDER_CONDITION_ID,UI_ACTION_TYPE,'

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

3125: || 'TARGET_WINDOW_TYPE,TARGET_WINDOW_NAME,:4,URL_PROPERTY_ID,'
3126: || 'TARGET_PERSISTENT_NODE_ID,TARGET_NODE_PATH,TARGET_PAGE_SET_ID,'
3127: || 'TARGET_PAGE_ID,TARGET_URL,FRAME_NAME,TARGET_ANCHOR,'
3128: || ':5,:6,:7,:8,:9 '
3129: || 'FROM cz_ui_actions WHERE ui_def_id = 0'
3130: || ' '
3131: || 'AND ui_action_id = :10 )'
3132: || ' '
3133: || 'WHERE t.ui_def_id = 1'

Line 5824: FROM cz_ui_actions

5820: ,PROCESSING_CAPTION_TEXT_ID, PAGE_TITLE_TEXT_ID, MAIN_MESSAGE_TEXT_ID
5821: BULK COLLECT INTO l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
5822: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5823: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5824: FROM cz_ui_actions
5825: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5826: AND cz_ui_actions.deleted_flag = record_not_deleted
5827: AND cz_ui_actions.seeded_flag <> seed_data;
5828:

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

5821: BULK COLLECT INTO l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
5822: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5823: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5824: FROM cz_ui_actions
5825: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5826: AND cz_ui_actions.deleted_flag = record_not_deleted
5827: AND cz_ui_actions.seeded_flag <> seed_data;
5828:
5829: -- Processing page ER#9656558

Line 5826: AND cz_ui_actions.deleted_flag = record_not_deleted

5822: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
5823: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5824: FROM cz_ui_actions
5825: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5826: AND cz_ui_actions.deleted_flag = record_not_deleted
5827: AND cz_ui_actions.seeded_flag <> seed_data;
5828:
5829: -- Processing page ER#9656558
5830: -- insert processing page related texts here

Line 5827: AND cz_ui_actions.seeded_flag <> seed_data;

5823: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
5824: FROM cz_ui_actions
5825: WHERE cz_ui_actions.ui_def_id = p_old_ui_def_tbl(uidef)
5826: AND cz_ui_actions.deleted_flag = record_not_deleted
5827: AND cz_ui_actions.seeded_flag <> seed_data;
5828:
5829: -- Processing page ER#9656558
5830: -- insert processing page related texts here
5831: insert_intl_texts(l_prc_caption_tbl, 'processing page caption intl texts');

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

5857: THEN
5858: NULL;
5859: WHEN OTHERS
5860: THEN
5861: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
5862: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
5863: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
5864: RAISE;
5865: END bulk_collect_ui_actions;

Line 6500: ,'cz_ui_actions.target_ui_def_id'

6496: resolve_ref_ids_not_found(cz_pb_mgr.g_ui_actns_ui_uidef_ref
6497: ,cz_pb_mgr.v_cz_ui_defs_old_ref
6498: ,cz_pb_mgr.v_cz_ui_defs_idx_ref
6499: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
6500: ,'cz_ui_actions.target_ui_def_id'
6501: ,cz_pb_mgr.v_status_code
6502: );
6503: insert_into_table('cz_ui_actions'
6504: ,'ui_action_id'

Line 6503: insert_into_table('cz_ui_actions'

6499: ,cz_pb_mgr.g_ui_actns_ui_tgtui_ref
6500: ,'cz_ui_actions.target_ui_def_id'
6501: ,cz_pb_mgr.v_status_code
6502: );
6503: insert_into_table('cz_ui_actions'
6504: ,'ui_action_id'
6505: ,'ui_def_id'
6506: ,cz_pb_mgr.v_db_link
6507: ,plsql_table_list

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

7229: IF g_skip_templaction_rollback THEN
7230: refine_ui_action_array;
7231: END IF;
7232:
7233: 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);
7234: 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);
7235: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
7236: 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);
7237: 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 7908: FROM cz_ui_actions

7904:
7905: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7906: IS
7907: SELECT last_update_date
7908: FROM cz_ui_actions
7909: WHERE cz_ui_actions.ui_def_id = p_ui_def_id
7910: ORDER BY last_update_date DESC;
7911:
7912: CURSOR ui_images_cur(p_ui_def_id NUMBER)

Line 7909: WHERE cz_ui_actions.ui_def_id = p_ui_def_id

7905: CURSOR ui_actions_cur(p_ui_def_id NUMBER)
7906: IS
7907: SELECT last_update_date
7908: FROM cz_ui_actions
7909: WHERE cz_ui_actions.ui_def_id = p_ui_def_id
7910: ORDER BY last_update_date DESC;
7911:
7912: CURSOR ui_images_cur(p_ui_def_id NUMBER)
7913: IS

Line 8672: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq

8668: l_pg_title_tbl.DELETE;
8669: l_main_msg_tbl.DELETE;
8670:
8671: IF (p_elem_type_ref(i) = 552) THEN
8672: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq
8673: , 'cz_ui_actions_s.nextval' || cz_pb_mgr.v_db_link
8674: ,cz_pb_mgr.v_oraclesequenceincr
8675: )
8676: ,ui_action_id, ui_def_id, target_ui_def_id, target_expl_node_id, context_component_id

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

8669: l_main_msg_tbl.DELETE;
8670:
8671: IF (p_elem_type_ref(i) = 552) THEN
8672: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_ui_actions_seq
8673: , 'cz_ui_actions_s.nextval' || cz_pb_mgr.v_db_link
8674: ,cz_pb_mgr.v_oraclesequenceincr
8675: )
8676: ,ui_action_id, ui_def_id, target_ui_def_id, target_expl_node_id, context_component_id
8677: ,render_condition_id, PROCESSING_PAGE_TEMPL_ID, PROC_PAGE_TEMPL_UI_DEF_ID

Line 8683: FROM cz_ui_actions

8679: BULK COLLECT INTO l_ui_actns_ui_act_new_id_tbl
8680: ,l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
8681: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
8682: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
8683: FROM cz_ui_actions
8684: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
8685: AND cz_ui_actions.ui_def_id = 0
8686: AND cz_ui_actions.deleted_flag = record_not_deleted
8687: AND cz_ui_actions.seeded_flag <> seed_data;

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

8680: ,l_ui_actns_ui_act_id_tbl, l_ui_actns_ui_uidef_tbl, l_ui_actns_ui_tgtui_tbl
8681: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
8682: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
8683: FROM cz_ui_actions
8684: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
8685: AND cz_ui_actions.ui_def_id = 0
8686: AND cz_ui_actions.deleted_flag = record_not_deleted
8687: AND cz_ui_actions.seeded_flag <> seed_data;
8688: END IF;

Line 8685: AND cz_ui_actions.ui_def_id = 0

8681: ,l_ui_actns_tgtexpl_tbl, l_ui_actns_ctx_comp_tbl, l_ui_actns_ren_cond_tbl
8682: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
8683: FROM cz_ui_actions
8684: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
8685: AND cz_ui_actions.ui_def_id = 0
8686: AND cz_ui_actions.deleted_flag = record_not_deleted
8687: AND cz_ui_actions.seeded_flag <> seed_data;
8688: END IF;
8689:

Line 8686: AND cz_ui_actions.deleted_flag = record_not_deleted

8682: ,l_prcpg_templ_tbl,l_prcpg_tmpui_tbl,l_prc_caption_tbl,l_pg_title_tbl,l_main_msg_tbl
8683: FROM cz_ui_actions
8684: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
8685: AND cz_ui_actions.ui_def_id = 0
8686: AND cz_ui_actions.deleted_flag = record_not_deleted
8687: AND cz_ui_actions.seeded_flag <> seed_data;
8688: END IF;
8689:
8690: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN

Line 8687: AND cz_ui_actions.seeded_flag <> seed_data;

8683: FROM cz_ui_actions
8684: WHERE cz_ui_actions.ui_action_id = p_elem_id_tbl(i)
8685: AND cz_ui_actions.ui_def_id = 0
8686: AND cz_ui_actions.deleted_flag = record_not_deleted
8687: AND cz_ui_actions.seeded_flag <> seed_data;
8688: END IF;
8689:
8690: IF (l_ui_actns_ui_act_id_tbl.COUNT > 0) THEN
8691: FOR j IN l_ui_actns_ui_act_id_tbl.FIRST .. l_ui_actns_ui_act_id_tbl.LAST

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

8750: EXCEPTION
8751: WHEN NO_DATA_FOUND THEN
8752: NULL;
8753: WHEN OTHERS THEN
8754: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_actions', 'SQLERRM', SQLERRM);
8755: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIACTIONS', SQLCODE);
8756: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
8757: RAISE;
8758: END collect_global_actions;

Line 9228: FROM cz_ui_actions act

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

Line 11710: ,'cz_ui_actions.target_ui_def_id'

11706: ,'cz_ui_refs.ref_ui_def_id'
11707: ,'cz_ui_page_refs.target_ui_def_id'
11708: ,'cz_ui_page_elements.target_page_ui_def_id'
11709: ,'cz_ui_ref_templates.ref_template_ui_def_id'
11710: ,'cz_ui_actions.target_ui_def_id'
11711: )
11712: )
11713: THEN
11714: BEGIN