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 449: ELSIF(p_table_name = 'cz_expression_nodes')

445: THEN
446: cz_pb_mgr.v_cz_folders_id_old_tbl.DELETE;
447: cz_pb_mgr.v_cz_folders_id_new_tbl.DELETE;
448: END IF;
449: ELSIF(p_table_name = 'cz_expression_nodes')
450: THEN
451: IF (p_table_type = 'tbl')
452: THEN
453: cz_pb_mgr.v_cz_enodes_enode_id_new_tbl.DELETE;

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

7244: 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);
7245: 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);
7246:
7247: 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);
7248: 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);
7249:
7250: DELETE FROM cz_pb_model_exports
7251: WHERE publication_id = cz_pb_mgr.v_publication_id;
7252:

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

7639: x_last_xfr_activity := NULL;
7640: END get_last_xfr_activity;
7641:
7642: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7643: -----procedure that retrieves the last update date from cz_expression nodes
7644: -----required to check if rules have been changed since it was last published
7645: PROCEDURE get_max_expr_date(p_model_id cz_model_publications.model_id%TYPE, x_expr_node_date IN OUT NOCOPY DATE)
7646: AS
7647: BEGIN

Line 7650: FROM cz_expression_nodes t

7646: AS
7647: BEGIN
7648: SELECT MAX(last_update_date)
7649: INTO x_expr_node_date
7650: FROM cz_expression_nodes t
7651: WHERE t.deleted_flag = record_not_deleted
7652: AND t.expr_type <> 208
7653: AND EXISTS(SELECT 1
7654: FROM cz_rules

Line 9895: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;

9891: v_models model_id_table;
9892: record_index NUMBER := 0;
9893: not_exported_record_index NUMBER := 0;
9894: v_model_id cz_model_publications.model_id%TYPE;
9895: v_expr_last_update cz_expression_nodes.last_update_date%TYPE;
9896: l_exp_models_idx_ref cz_pb_mgr.t_ref_idx_vc2;
9897: l_intl_text_date DATE;
9898: l_eff_set_date DATE;
9899: l_max_arc_date DATE;

Line 9992: FROM cz_expression_nodes t

9988:
9989: -------check if expr nodes have changed since the model was last published
9990: SELECT MAX(last_update_date)
9991: INTO v_expr_last_update
9992: FROM cz_expression_nodes t
9993: WHERE t.deleted_flag = '0'
9994: AND t.expr_type <> 208
9995: AND EXISTS(SELECT 1
9996: FROM cz_rules

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

13208: clear_tables('cz_item_masters', 'tbl', cz_pb_mgr.v_status_code);
13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
13214: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
13215: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
13216: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);

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

13209: clear_tables('cz_item_masters', 'ref', cz_pb_mgr.v_status_code);
13210: clear_tables('cz_rule_folders', 'tbl', cz_pb_mgr.v_status_code);
13211: clear_tables('cz_rule_folders', 'ref', cz_pb_mgr.v_status_code);
13212: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
13213: clear_tables('cz_expression_nodes', 'ref', cz_pb_mgr.v_status_code);
13214: clear_tables('cz_rules', 'ref', cz_pb_mgr.v_status_code);
13215: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
13216: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
13217: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);

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

16885: IF (cz_pb_mgr.v_cz_rules_rule_id_old_ref.COUNT > 0)
16886: THEN
16887: 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
16888: LOOP
16889: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
16890:
16891: BEGIN
16892: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
16893: THEN

Line 16894: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq

16890:
16891: BEGIN
16892: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
16893: THEN
16894: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16895: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16896: ,cz_pb_mgr.v_oraclesequenceincr
16897: )
16898: ,expr_node_id, ps_node_id, expr_parent_id

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

16891: BEGIN
16892: IF (cz_pb_mgr.v_session_parameter IN(model_copy, cz_model_migration_pvt.migrate_model))
16893: THEN
16894: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16895: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16896: ,cz_pb_mgr.v_oraclesequenceincr
16897: )
16898: ,expr_node_id, ps_node_id, expr_parent_id
16899: ,decode(model_ref_expl_id,-1,null,model_ref_expl_id), rule_id, argument_signature_id

Line 16906: FROM cz_expression_nodes t

16902: ,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
16903: ,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
16904: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
16905: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
16906: FROM cz_expression_nodes t
16907: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
16908: ELSE
16909: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16910: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link

Line 16909: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq

16905: ,cz_pb_mgr.v_cz_enodes_prop_id_tbl
16906: FROM cz_expression_nodes t
16907: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
16908: ELSE
16909: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16910: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16911: ,cz_pb_mgr.v_oraclesequenceincr
16912: )
16913: ,expr_node_id, ps_node_id, expr_parent_id

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

16906: FROM cz_expression_nodes t
16907: WHERE t.rule_id = cz_pb_mgr.v_cz_rules_rule_id_old_ref(m) AND t.deleted_flag = '0';
16908: ELSE
16909: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_expression_nodes_seq
16910: , 'cz_expression_nodes_s.nextval' || cz_pb_mgr.v_db_link
16911: ,cz_pb_mgr.v_oraclesequenceincr
16912: )
16913: ,expr_node_id, ps_node_id, expr_parent_id
16914: ,decode(model_ref_expl_id,-1,null,model_ref_expl_id), rule_id, argument_signature_id

Line 16920: FROM cz_expression_nodes t

16916: BULK COLLECT INTO cz_pb_mgr.v_cz_enodes_enode_id_new_tbl
16917: ,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
16918: ,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
16919: ,cz_pb_mgr.v_cz_enodes_par_sig_id_tbl
16920: FROM cz_expression_nodes t
16921: 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;
16922: END IF;
16923: EXCEPTION
16924: WHEN NO_DATA_FOUND

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

16926: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16927: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
16928: WHEN OTHERS
16929: THEN
16930: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_expression_nodes', 'SQLERRM', SQLERRM);
16931: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.EXPRNODES', SQLCODE);
16932: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16933: RAISE;
16934: END;

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

16987: 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);
16988: 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);
16989:
16990: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16991: 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');
16992: 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');
16993: 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);
16994: ELSE
16995: 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 16992: 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');

16988: 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);
16989:
16990: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16991: 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');
16992: 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');
16993: 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);
16994: ELSE
16995: 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);
16996: 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 17001: --------populate plsql_table_list for cz_expression_nodes

16997: END IF;
16998:
16999: 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');
17000:
17001: --------populate plsql_table_list for cz_expression_nodes
17002: plsql_table_list.DELETE;
17003: rec_count := 1;
17004: plsql_table_list(rec_count).col_name := 'expr_node_id';
17005: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_enode_id_new_ref';

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

17028: plsql_table_list(rec_count).col_name := 'property_id';
17029: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
17030: END IF;
17031:
17032: ------insert new records into cz_expression_nodes
17033: insert_into_table('cz_expression_nodes'
17034: ,'expr_node_id'
17035: ,cz_pb_mgr.v_db_link
17036: ,plsql_table_list

Line 17033: insert_into_table('cz_expression_nodes'

17029: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_enodes_prop_id_ref';
17030: END IF;
17031:
17032: ------insert new records into cz_expression_nodes
17033: insert_into_table('cz_expression_nodes'
17034: ,'expr_node_id'
17035: ,cz_pb_mgr.v_db_link
17036: ,plsql_table_list
17037: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'

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

17036: ,plsql_table_list
17037: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'
17038: ,cz_pb_mgr.v_cz_enodes_enode_id_old_ref
17039: );
17040: --------release tbl pl/sql tables of cz expression nodes
17041: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
17042:
17043: IF (p_copy_rules_flag = 'YES') THEN
17044:

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

17037: ,'cz_pb_mgr.v_cz_enodes_enode_id_old_ref'
17038: ,cz_pb_mgr.v_cz_enodes_enode_id_old_ref
17039: );
17040: --------release tbl pl/sql tables of cz expression nodes
17041: clear_tables('cz_expression_nodes', 'tbl', cz_pb_mgr.v_status_code);
17042:
17043: IF (p_copy_rules_flag = 'YES') THEN
17044:
17045: -------------insert into cz_des_chart_features