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_CELLS

Line 37: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id

33: ENTITY_TYPE_RULE CONSTANT VARCHAR2(3) := 'RUL';
34: ENTITY_TYPE_PROPERTY CONSTANT VARCHAR2(3) := 'PRP';
35:
36: -- special fields in id resolution
37: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
38: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
39: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
40: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
41: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';

Line 512: ELSIF(p_table_name = 'cz_des_chart_cells')

508: cz_pb_mgr.v_cz_des_feature_rule_id_ref.DELETE;
509: cz_pb_mgr.v_cz_des_feature_mrefl_id_ref.DELETE;
510: cz_pb_mgr.v_cz_des_feature_ft_typ_ref.DELETE;
511: END IF;
512: ELSIF(p_table_name = 'cz_des_chart_cells')
513: THEN
514: IF (p_table_type = 'ref')
515: THEN
516: cz_pb_mgr.v_cz_des_cells_rule_id_new_ref.DELETE;

Line 7208: delete_from_table('cz_des_chart_cells'

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
7207: );
7208: delete_from_table('cz_des_chart_cells'
7209: ,'rule_id'
7210: ,v_database_link
7211: ,'cz_pb_mgr.v_cz_des_cells_rule_id_new_ref'
7212: ,cz_pb_mgr.v_cz_des_cells_rule_id_new_ref

Line 12814: || 'INSERT INTO cz_des_chart_cells'

12810: || 'FOR I IN cz_pb_mgr.v_cz_des_cells_rule_id_old_ref.FIRST..cz_pb_mgr.v_cz_des_cells_rule_id_old_ref.LAST'
12811: || ' '
12812: || 'LOOP'
12813: || ' '
12814: || 'INSERT INTO cz_des_chart_cells'
12815: || cz_pb_mgr.v_db_link
12816: || '('
12817: || ' '
12818: || 'RULE_ID'

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

12866: COMMIT;
12867: EXCEPTION
12868: WHEN OTHERS
12869: THEN
12870: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
12871: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
12872: x_status := PUBLICATION_ERROR;
12873: RAISE;
12874: END;

Line 12871: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);

12867: EXCEPTION
12868: WHEN OTHERS
12869: THEN
12870: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
12871: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
12872: x_status := PUBLICATION_ERROR;
12873: RAISE;
12874: END;
12875:

Line 13216: clear_tables('cz_des_chart_cells', '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
13220: WHEN OTHERS

Line 17114: ------------insert into cz_des_chart_cells

17110: v_cz_des_feature_id_old_tbl.DELETE;
17111: v_cz_des_feature_rule_id_tbl.DELETE;
17112: v_cz_des_feature_mrefl_id_tbl.DELETE;
17113: v_cz_des_feature_ft_typ_tbl.DELETE;
17114: ------------insert into cz_des_chart_cells
17115: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
17116:
17117: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
17118: THEN

Line 17115: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);

17111: v_cz_des_feature_rule_id_tbl.DELETE;
17112: v_cz_des_feature_mrefl_id_tbl.DELETE;
17113: v_cz_des_feature_ft_typ_tbl.DELETE;
17114: ------------insert into cz_des_chart_cells
17115: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
17116:
17117: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
17118: THEN
17119: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST

Line 17133: FROM cz_rules rul, cz_des_chart_cells dcc

17129: SELECT rul.rule_id, secondary_feature_id, primary_opt_id, secondary_opt_id
17130: , secondary_feat_expl_id, mark_char, rule_type
17131: BULK COLLECT INTO v_cz_des_cells_rule_id_tbl, v_cz_des_cells_sf_id_tbl, v_cz_des_cells_popt_id_tbl, v_cz_des_cells_sopt_id_tbl
17132: ,v_cz_des_cells_sexpl_id_tbl, v_cz_des_cells_mark_char_tbl, v_rule_type_tbl
17133: FROM cz_rules rul, cz_des_chart_cells dcc
17134: WHERE rul.deleted_flag = '0' AND rul.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
17135: AND rul.rule_id = dcc.rule_id AND dcc.deleted_flag = '0';
17136: EXCEPTION
17137: WHEN NO_DATA_FOUND

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

17139: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
17140: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
17141: WHEN OTHERS
17142: THEN
17143: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
17144: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
17145: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17146: RAISE;
17147: END;

Line 17169: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);

17165: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
17166: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17167:
17168: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
17169: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');

Line 17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');

17168: resolve_ids(cz_pb_mgr.v_cz_des_cells_rule_id_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart cells');
17169: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
17175: ELSE
17176: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);

Line 17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');

17169: resolve_ids(cz_pb_mgr.v_cz_des_cells_popt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'cz_des_chart_cells.primary_opt_id',FLD_IGNORE_NOW);
17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
17175: ELSE
17176: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
17177: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);

Line 17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');

17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
17175: ELSE
17176: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
17177: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
17178: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);

Line 17181: ------insert new records into cz_des_chart_cells

17177: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
17178: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);
17179: END IF;
17180:
17181: ------insert new records into cz_des_chart_cells
17182: insert_des_chart_cells(cz_pb_mgr.v_status_code);
17183:
17184: --during model migration, if a rule_seq has a rule whose effectivity_set_id already
17185: --exists on the target, then set the rule effectivity to be

Line 17196: -------------release local pl/sql tables of cz des chart cells

17192: THEN
17193: mm_resolve_rule_seq_effsetid;
17194: END IF;
17195:
17196: -------------release local pl/sql tables of cz des chart cells
17197: v_cz_des_cells_rule_id_tbl.DELETE;
17198: v_cz_des_cells_sf_id_tbl.DELETE;
17199: v_cz_des_cells_sopt_id_tbl.DELETE;
17200: v_cz_des_cells_popt_id_tbl.DELETE;