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_EXPRESSION_NODES

Line 400: ELSIF(p_table_name = 'cz_expression_nodes')

396: THEN
397: cz_pb_mgr.v_cz_folders_id_old_tbl.DELETE;
398: cz_pb_mgr.v_cz_folders_id_new_tbl.DELETE;
399: END IF;
400: ELSIF(p_table_name = 'cz_expression_nodes')
401: THEN
402: IF (p_table_type = 'tbl')
403: THEN
404: cz_pb_mgr.v_cz_enodes_enode_id_new_tbl.DELETE;

Line 6527: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);

6523: delete_from_table('cz_archive_refs','archive_id','devl_project_id',v_database_link,'cz_pb_mgr.g_archive_id_ref','cz_pb_mgr.g_devl_proj_ref',cz_pb_mgr.g_archive_id_ref);
6524: delete_from_table('cz_localized_texts','intl_text_id',v_database_link,'cz_pb_mgr.v_cz_intl_text_new_ref',cz_pb_mgr.v_cz_intl_text_new_ref);
6525:
6526: delete_from_idx_tables('cz_rule_folders', 'rule_folder_id', cz_pb_mgr.v_cz_folders_id_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref);
6527: delete_from_idx_tables('cz_expression_nodes', 'expr_node_id', cz_pb_mgr.v_cz_enodes_enode_id_old_ref, cz_pb_mgr.v_cz_enodes_enode_id_idx_ref);
6528:
6529: DELETE FROM cz_pb_model_exports
6530: WHERE publication_id = cz_pb_mgr.v_publication_id;
6531:

Line 6920: -----procedure that retrieves the last update date from cz_expression nodes

6916: x_last_xfr_activity := NULL;
6917: END get_last_xfr_activity;
6918:
6919: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
6920: -----procedure that retrieves the last update date from cz_expression nodes
6921: -----required to check if rules have been changed since it was last published
6922: PROCEDURE get_max_expr_date(p_model_id cz_model_publications.model_id%TYPE, x_expr_node_date IN OUT NOCOPY DATE)
6923: AS
6924: BEGIN

Line 6927: FROM cz_expression_nodes t

6923: AS
6924: BEGIN
6925: SELECT MAX(last_update_date)
6926: INTO x_expr_node_date
6927: FROM cz_expression_nodes t
6928: WHERE t.deleted_flag = record_not_deleted
6929: AND t.expr_type <> 208
6930: AND EXISTS(SELECT 1
6931: FROM cz_rules

Line 9139: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;

9135: v_models model_id_table;
9136: record_index NUMBER := 0;
9137: not_exported_record_index NUMBER := 0;
9138: v_model_id cz_model_publications.model_id%TYPE;
9139: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;
9140: l_exp_models_idx_ref cz_pb_mgr.t_ref_idx_vc2;
9141: l_intl_text_date DATE;
9142: l_eff_set_date DATE;
9143: l_max_arc_date DATE;

Line 9236: FROM cz_expression_nodes t

9232:
9233: -------check if expr nodes have changed since the model was last published
9234: SELECT MAX(last_update_date)
9235: INTO v_expr_last_update
9236: FROM cz_expression_nodes t
9237: WHERE t.deleted_flag = '0'
9238: AND t.expr_type <> 208
9239: AND EXISTS(SELECT 1
9240: FROM cz_rules

Line 12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);

12216: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
12222: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
12223: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
12224: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);

Line 12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);

12217: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
12218: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
12219: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
12220: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
12221: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
12222: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
12223: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
12224: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
12225: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);

Line 15775: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);

15771: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
15772: THEN
15773: FOR m IN cz_pb_mgr.v_cz_rules_rule_id_old_ref.FIRST .. cz_pb_mgr.v_cz_rules_rule_id_old_ref.LAST
15774: LOOP
15775: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15776:
15777: BEGIN
15778: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
15779: THEN

Line 15780: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq

15776:
15777: BEGIN
15778: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
15779: THEN
15780: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15781: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15782: ,cz_pb_mgr.v_oraclesequenceincr
15783: )
15784: ,expr_node_id, ps_node_id, expr_parent_id

Line 15781: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link

15777: BEGIN
15778: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
15779: THEN
15780: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15781: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15782: ,cz_pb_mgr.v_oraclesequenceincr
15783: )
15784: ,expr_node_id, ps_node_id, expr_parent_id
15785: ,decode(model_ref_expl_id,-1,null,model_ref_expl_id), rule_id, argument_signature_id

Line 15792: FROM cz_expression_nodes t

15788: ,cz_pb_mgr.v_cz_enodes_enode_id_old_tbl, cz_pb_mgr.v_cz_enodes_psnode_id_tbl, cz_pb_mgr.v_cz_enodes_pexpr_id_tbl
15789: ,cz_pb_mgr.v_cz_enodes_mrefl_id_tbl, cz_pb_mgr.v_cz_enodes_rule_id_tbl, cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl
15790: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
15791: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
15792: FROM cz_expression_nodes t
15793: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
15794: ELSE
15795: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15796: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link

Line 15795: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq

15791: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
15792: FROM cz_expression_nodes t
15793: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
15794: ELSE
15795: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15796: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15797: ,cz_pb_mgr.v_oraclesequenceincr
15798: )
15799: ,expr_node_id, ps_node_id, expr_parent_id

Line 15796: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link

15792: FROM cz_expression_nodes t
15793: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
15794: ELSE
15795: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
15796: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
15797: ,cz_pb_mgr.v_oraclesequenceincr
15798: )
15799: ,expr_node_id, ps_node_id, expr_parent_id
15800: ,decode(model_ref_expl_id,-1,null,model_ref_expl_id), rule_id, argument_signature_id

Line 15806: FROM cz_expression_nodes t

15802: BULK COLLECT INTO cz_pb_mgr.v_cz_enodes_enode_id_new_tbl
15803: ,cz_pb_mgr.v_cz_enodes_enode_id_old_tbl, cz_pb_mgr.v_cz_enodes_psnode_id_tbl, cz_pb_mgr.v_cz_enodes_pexpr_id_tbl
15804: ,cz_pb_mgr.v_cz_enodes_mrefl_id_tbl, cz_pb_mgr.v_cz_enodes_rule_id_tbl, cz_pb_mgr.v_cz_enodes_arg_sig_id_tbl
15805: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
15806: FROM cz_expression_nodes t
15807: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0' AND t.expr_type <> 208;
15808: END IF;
15809: EXCEPTION
15810: WHEN NO_DATA_FOUND

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

15812: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15813: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
15814: WHEN OTHERS
15815: THEN
15816: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_expression_nodes', 'SQLERRM', SQLERRM);
15817: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
15818: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15819: RAISE;
15820: END;

Line 15877: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');

15873: resolve_ids(cz_pb_mgr.v_cz_enodes_arg_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'arg sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15874: resolve_ids(cz_pb_mgr.v_cz_enodes_par_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'param sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15875:
15876: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15877: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
15879: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
15880: ELSE
15881: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);

Line 15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');

15874: resolve_ids(cz_pb_mgr.v_cz_enodes_par_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'param sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
15875:
15876: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15877: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
15878: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
15879: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
15880: ELSE
15881: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
15882: resolve_ids(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'ps node ids of expression nodes',FLD_IGNORE_NOW);

Line 15887: --------populate plsql_table_list for cz_expression_nodes

15883: END IF;
15884:
15885: resolve_ids(cz_pb_mgr.v_cz_enodes_rule_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of expression nodes');
15886:
15887: --------populate plsql_table_list for cz_expression_nodes
15888: plsql_table_list.DELETE;
15889: rec_count := 1;
15890: plsql_table_list(rec_count).col_name := 'expr_node_id';
15891: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_enode_id_new_ref';

Line 15918: ------insert new records into cz_expression_nodes

15914: plsql_table_list(rec_count).col_name := 'property_id';
15915: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
15916: END IF;
15917:
15918: ------insert new records into cz_expression_nodes
15919: insert_into_table('cz_expression_nodes'
15920: ,'expr_node_id'
15921: ,cz_pb_mgr.v_db_link
15922: ,plsql_table_list

Line 15919: insert_into_table('cz_expression_nodes'

15915: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
15916: END IF;
15917:
15918: ------insert new records into cz_expression_nodes
15919: insert_into_table('cz_expression_nodes'
15920: ,'expr_node_id'
15921: ,cz_pb_mgr.v_db_link
15922: ,plsql_table_list
15923: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'

Line 15926: --------release tbl pl/sql tables of cz expression nodes

15922: ,plsql_table_list
15923: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'
15924: ,cz_pb_mgr.v_cz_enodes_enode_id_old_ref
15925: );
15926: --------release tbl pl/sql tables of cz expression nodes
15927: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15928:
15929: IF (p_copy_rules_flag = 'YES') THEN
15930:

Line 15927: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);

15923: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'
15924: ,cz_pb_mgr.v_cz_enodes_enode_id_old_ref
15925: );
15926: --------release tbl pl/sql tables of cz expression nodes
15927: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
15928:
15929: IF (p_copy_rules_flag = 'YES') THEN
15930:
15931: -------------insert into cz_des_chart_features