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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on CZ_DES_CHART_FEATURES

Line 452: ELSIF(p_table_name = 'cz_des_chart_features')

448: cz_pb_mgr.v_cz_rules_obj_ref.DELETE;
449: cz_pb_mgr.v_cz_rules_sig_idx_ref.DELETE;
450: cz_pb_mgr.v_cz_rules_ui_ref.DELETE;
451: END IF;
452: ELSIF(p_table_name = 'cz_des_chart_features')
453: THEN
454: IF (p_table_type = 'ref')
455: THEN
456: cz_pb_mgr.v_cz_des_feature_id_old_ref.DELETE;

Line 6490: delete_from_table('cz_des_chart_features'

6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
6487: );
6488: 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);
6489: 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);
6490: delete_from_table('cz_des_chart_features'
6491: ,'rule_id'
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

Line 11781: || 'INSERT INTO cz_des_chart_features'

11777: || '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'
11778: || ' '
11779: || 'LOOP'
11780: || ' '
11781: || 'INSERT INTO cz_des_chart_features'
11782: || cz_pb_mgr.v_db_link
11783: || '('
11784: || ' '
11785: || 'RULE_ID'

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

11823: COMMIT;
11824: EXCEPTION
11825: WHEN OTHERS
11826: THEN
11827: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
11828: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
11829: x_status := PUBLICATION_ERROR;
11830: RAISE;
11831: END;

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

11824: EXCEPTION
11825: WHEN OTHERS
11826: THEN
11827: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_TABLE_POPULATION_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
11828: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LOAD_DATA:CZ_DES_CHART_FEATURES', SQLCODE);
11829: x_status := PUBLICATION_ERROR;
11830: RAISE;
11831: END;
11832:

Line 12223: clear_tables('cz_des_chart_features', 'ref', 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);
12226: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
12227: EXCEPTION

Line 15931: -------------insert into cz_des_chart_features

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
15932: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
15933:
15934: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
15935: THEN

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

15928:
15929: IF (p_copy_rules_flag = 'YES') THEN
15930:
15931: -------------insert into cz_des_chart_features
15932: clear_tables('cz_des_chart_features', 'ref', cz_pb_mgr.v_status_code);
15933:
15934: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
15935: THEN
15936: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST

Line 15946: FROM cz_des_chart_features t

15942:
15943: BEGIN
15944: SELECT feature_id, rule_id, model_ref_expl_id, feature_type
15945: 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
15946: FROM cz_des_chart_features t
15947: WHERE t.rule_id IN(
15948: SELECT rule_id
15949: FROM cz_rules
15950: WHERE cz_rules.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i)

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

15956: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
15957: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
15958: WHEN OTHERS
15959: THEN
15960: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_des_chart_features', 'SQLERRM', SQLERRM);
15961: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.DESCHARTFEAT', SQLCODE);
15962: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15963: RAISE;
15964: END;

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

15980: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_models_to_be_exported */
15981: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15982:
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: 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');
15985: 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');
15986: ELSE
15987: 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);
15988: 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 15985: 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');

15981: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15982:
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: 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');
15985: 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');
15986: ELSE
15987: 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);
15988: 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);
15989: END IF;

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

15989: END IF;
15990:
15991: 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');
15992:
15993: ------insert new records into cz_des_chart_features
15994: insert_des_chart_features(cz_pb_mgr.v_status_code);
15995: -------------release local pl/sql tables of des chart features
15996: v_cz_des_feature_id_old_tbl.DELETE;
15997: v_cz_des_feature_rule_id_tbl.DELETE;