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 30: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id

26: ENTITY_TYPE_RULE CONSTANT VARCHAR2(3) := 'RUL';
27: ENTITY_TYPE_PROPERTY CONSTANT VARCHAR2(3) := 'PRP';
28:
29: -- special fields in id resolution
30: -- cz_des_chart_cells.primary_opt_id, secondary_opt_id, secondary_feature_id
31: -- cz_des_chart_feature.feature_id, cz_rules.rule_folder_id,
32: -- cz_ps_nodes.reference_id, cz_ui_nodes.ui_node_ref_id
33: FLD_PSN_REFERENCE_ID CONSTANT VARCHAR2(9) := 'PSNREFID';
34: FLD_RULE_COMPONENT_ID CONSTANT VARCHAR2(9) := 'RULCOMID';

Line 463: ELSIF(p_table_name = 'cz_des_chart_cells')

459: cz_pb_mgr.v_cz_des_feature_rule_id_ref.DELETE;
460: cz_pb_mgr.v_cz_des_feature_mrefl_id_ref.DELETE;
461: cz_pb_mgr.v_cz_des_feature_ft_typ_ref.DELETE;
462: END IF;
463: ELSIF(p_table_name = 'cz_des_chart_cells')
464: THEN
465: IF (p_table_type = 'ref')
466: THEN
467: cz_pb_mgr.v_cz_des_cells_rule_id_new_ref.DELETE;

Line 6496: delete_from_table('cz_des_chart_cells'

6492: ,v_database_link
6493: ,'cz_pb_mgr.v_cz_des_feature_rid_new_ref'
6494: ,cz_pb_mgr.v_cz_des_feature_rid_new_ref
6495: );
6496: delete_from_table('cz_des_chart_cells'
6497: ,'rule_id'
6498: ,v_database_link
6499: ,'cz_pb_mgr.v_cz_des_cells_rule_id_new_ref'
6500: ,cz_pb_mgr.v_cz_des_cells_rule_id_new_ref

Line 11850: || 'INSERT INTO cz_des_chart_cells'

11846: || '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'
11847: || ' '
11848: || 'LOOP'
11849: || ' '
11850: || 'INSERT INTO cz_des_chart_cells'
11851: || cz_pb_mgr.v_db_link
11852: || '('
11853: || ' '
11854: || 'RULE_ID'

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

11902: COMMIT;
11903: EXCEPTION
11904: WHEN OTHERS
11905: THEN
11906: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
11907: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
11908: x_status := PUBLICATION_ERROR;
11909: RAISE;
11910: END;

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

11903: EXCEPTION
11904: WHEN OTHERS
11905: THEN
11906: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
11907: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_CELLS', SQLCODE);
11908: x_status := PUBLICATION_ERROR;
11909: RAISE;
11910: END;
11911:

Line 12224: clear_tables('cz_des_chart_cells', '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);
12226: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
12227: EXCEPTION
12228: WHEN OTHERS

Line 16000: ------------insert into cz_des_chart_cells

15996: v_cz_des_feature_id_old_tbl.DELETE;
15997: v_cz_des_feature_rule_id_tbl.DELETE;
15998: v_cz_des_feature_mrefl_id_tbl.DELETE;
15999: v_cz_des_feature_ft_typ_tbl.DELETE;
16000: ------------insert into cz_des_chart_cells
16001: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
16002:
16003: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
16004: THEN

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

15997: v_cz_des_feature_rule_id_tbl.DELETE;
15998: v_cz_des_feature_mrefl_id_tbl.DELETE;
15999: v_cz_des_feature_ft_typ_tbl.DELETE;
16000: ------------insert into cz_des_chart_cells
16001: clear_tables('cz_des_chart_cells', 'ref', cz_pb_mgr.v_status_code);
16002:
16003: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
16004: THEN
16005: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST

Line 16019: FROM cz_rules rul, cz_des_chart_cells dcc

16015: SELECT rul.rule_id, secondary_feature_id, primary_opt_id, secondary_opt_id
16016: , secondary_feat_expl_id, mark_char, rule_type
16017: 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
16018: ,v_cz_des_cells_sexpl_id_tbl, v_cz_des_cells_mark_char_tbl, v_rule_type_tbl
16019: FROM cz_rules rul, cz_des_chart_cells dcc
16020: WHERE rul.deleted_flag = '0' AND rul.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)
16021: AND rul.rule_id = dcc.rule_id AND dcc.deleted_flag = '0';
16022: EXCEPTION
16023: WHEN NO_DATA_FOUND

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

16025: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
16026: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
16027: WHEN OTHERS
16028: THEN
16029: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_cells', 'SQLERRM', SQLERRM);
16030: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCELLS', SQLCODE);
16031: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16032: RAISE;
16033: END;

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

16051: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
16052: END IF; /* end if of cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
16053:
16054: 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');
16055: 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);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: 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');
16059: 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 16058: 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');

16054: 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');
16055: 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);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: 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');
16059: 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');
16060: 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');
16061: ELSE
16062: 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 16059: 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');

16055: 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);
16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: 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');
16059: 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');
16060: 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');
16061: ELSE
16062: 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);
16063: 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 16060: 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');

16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: 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');
16059: 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');
16060: 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');
16061: ELSE
16062: 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);
16063: 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);
16064: 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 16067: ------insert new records into cz_des_chart_cells

16063: 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);
16064: 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);
16065: END IF;
16066:
16067: ------insert new records into cz_des_chart_cells
16068: insert_des_chart_cells(cz_pb_mgr.v_status_code);
16069:
16070: --during model migration, if a rule_seq has a rule whose effectivity_set_id already
16071: --exists on the target, then set the rule effectivity to be

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

16078: THEN
16079: mm_resolve_rule_seq_effsetid;
16080: END IF;
16081:
16082: -------------release local pl/sql tables of cz des chart cells
16083: v_cz_des_cells_rule_id_tbl.DELETE;
16084: v_cz_des_cells_sf_id_tbl.DELETE;
16085: v_cz_des_cells_sopt_id_tbl.DELETE;
16086: v_cz_des_cells_popt_id_tbl.DELETE;