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_DES_CHART_FEATURES

Line 501: ELSIF(p_table_name = 'cz_des_chart_features')

497: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
498: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
499: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
500: END IF;
501: ELSIF(p_table_name = 'cz_des_chart_features')
502: THEN
503: IF (p_table_type = 'ref')
504: THEN
505: cz_pb_mgr.v_cz_des_feature_id_old_ref.DELETE;

Line 7202: delete_from_table('cz_des_chart_features'

7198: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
7199: );
7200: delete_from_table('cz_lce_headers', 'lce_header_id', v_database_link, 'cz_pb_mgr.v_cz_lce_headers_new_ref', cz_pb_mgr.v_cz_lce_headers_new_ref);
7201: delete_from_table('cz_rules', 'rule_id', v_database_link, 'cz_pb_mgr.v_cz_rules_rule_id_new_ref', cz_pb_mgr.v_cz_rules_rule_id_new_ref);
7202: delete_from_table('cz_des_chart_features'
7203: ,'rule_id'
7204: ,v_database_link
7205: ,'cz_pb_mgr.v_cz_des_feature_rid_new_ref'
7206: ,cz_pb_mgr.v_cz_des_feature_rid_new_ref

Line 12745: || 'INSERT INTO cz_des_chart_features'

12741: || 'FOR I IN cz_pb_mgr.v_cz_des_feature_id_old_ref.FIRST..cz_pb_mgr.v_cz_des_feature_id_old_ref.LAST'
12742: || ' '
12743: || 'LOOP'
12744: || ' '
12745: || 'INSERT INTO cz_des_chart_features'
12746: || cz_pb_mgr.v_db_link
12747: || '('
12748: || ' '
12749: || 'RULE_ID'

Line 12791: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);

12787: COMMIT;
12788: EXCEPTION
12789: WHEN OTHERS
12790: THEN
12791: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
12792: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
12793: x_status := PUBLICATION_ERROR;
12794: RAISE;
12795: END;

Line 12792: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);

12788: EXCEPTION
12789: WHEN OTHERS
12790: THEN
12791: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
12792: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
12793: x_status := PUBLICATION_ERROR;
12794: RAISE;
12795: END;
12796:

Line 13215: clear_tables('cz_des_chart_features', 'ref', 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);
13218: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
13219: EXCEPTION

Line 17045: -------------insert into cz_des_chart_features

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
17046: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
17047:
17048: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
17049: THEN

Line 17046: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);

17042:
17043: IF (p_copy_rules_flag = 'YES') THEN
17044:
17045: -------------insert into cz_des_chart_features
17046: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
17047:
17048: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
17049: THEN
17050: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST

Line 17060: FROM cz_des_chart_features t

17056:
17057: BEGIN
17058: SELECT feature_id, rule_id, model_ref_expl_id, feature_type
17059: BULK COLLECT INTO v_cz_des_feature_id_old_tbl, v_cz_des_feature_rule_id_tbl, v_cz_des_feature_mrefl_id_tbl, v_cz_des_feature_ft_typ_tbl
17060: FROM cz_des_chart_features t
17061: WHERE t.rule_id IN(
17062: SELECT rule_id
17063: FROM cz_rules
17064: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)

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

17070: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
17071: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
17072: WHEN OTHERS
17073: THEN
17074: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
17075: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
17076: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17077: RAISE;
17078: END;

Line 17098: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');

17094: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17095: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17096:
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
17100: ELSE
17101: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
17102: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);

Line 17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');

17095: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17096:
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
17100: ELSE
17101: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
17102: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
17103: END IF;

Line 17107: ------insert new records into cz_des_chart_features

17103: END IF;
17104:
17105: resolve_ids(cz_pb_mgr.v_cz_des_feature_rid_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart features');
17106:
17107: ------insert new records into cz_des_chart_features
17108: insert_des_chart_features(cz_pb_mgr.v_status_code);
17109: -------------release local pl/sql tables of des chart features
17110: v_cz_des_feature_id_old_tbl.DELETE;
17111: v_cz_des_feature_rule_id_tbl.DELETE;