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_FUNC_COMP_SPECS

Line 326: ELSIF(p_table_name = 'cz_func_comp_specs')

322: cz_pb_mgr.v_child_expl_id_ref.DELETE;
323: cz_pb_mgr.v_referring_node_id_ref.DELETE;
324: cz_pb_mgr.v_ref_model_id_ref.DELETE;
325: END IF;
326: ELSIF(p_table_name = 'cz_func_comp_specs')
327: THEN
328: IF (p_table_type = 'tbl')
329: THEN
330: cz_pb_mgr.v_cz_func_comp_old_tbl.DELETE;

Line 7237: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);

7233: delete_from_table('cz_ui_actions','ui_def_id','ui_action_id',v_database_link,'cz_pb_mgr.g_ui_actns_ui_uidef_ref','cz_pb_mgr.g_ui_actns_ui_act_id_ref',cz_pb_mgr.g_ui_actns_ui_uidef_ref);
7234: delete_from_table('cz_ui_images','ui_def_id','image_usage_code','entity_code',v_database_link,'cz_pb_mgr.l_ui_images_ui_ref','cz_pb_mgr.l_ui_images_usg_tbl','cz_pb_mgr.l_ui_images_enty_tbl',cz_pb_mgr.l_ui_images_ui_ref);
7235: delete_from_table('cz_signatures','signature_id',v_database_link,'cz_pb_mgr.v_sig_new_ref',cz_pb_mgr.v_sig_new_ref);
7236: delete_from_table('cz_signature_arguments','argument_signature_id','argument_index',v_database_link,'cz_pb_mgr.v_arg_sig_tbl','cz_pb_mgr.v_arg_ind_old_tbl',cz_pb_mgr.v_arg_sig_tbl);
7237: delete_from_table('cz_func_comp_specs','func_comp_id',v_database_link,'cz_pb_mgr.v_cz_func_comp_new_ref',cz_pb_mgr.v_cz_func_comp_new_ref);
7238: delete_from_table('cz_populators','populator_id',v_database_link,'cz_pb_mgr.v_populators_new_id_ref',cz_pb_mgr.v_populators_new_id_ref);
7239: delete_from_table('cz_filter_sets','filter_set_id',v_database_link,'cz_pb_mgr.v_filter_sets_new_id_ref',cz_pb_mgr.v_filter_sets_new_id_ref);
7240: delete_from_table('cz_archives','archive_id',v_database_link,'cz_pb_mgr.g_archives_new_ref',cz_pb_mgr.g_archives_new_ref);
7241:

Line 8438: v_update_date cz_func_comp_specs.last_update_date%TYPE;

8434: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8435: ----get last update date for FC
8436: PROCEDURE get_fc_date(p_model_array IN cz_pb_mgr.t_ref, x_max_update_date IN OUT NOCOPY DATE)
8437: AS
8438: v_update_date cz_func_comp_specs.last_update_date%TYPE;
8439: BEGIN
8440: IF (p_model_array.COUNT > 0)
8441: THEN
8442: x_max_update_date := cz_utils.epoch_begin;

Line 8449: FROM cz_func_comp_specs

8445: LOOP
8446: BEGIN
8447: SELECT MAX(last_update_date)
8448: INTO v_update_date
8449: FROM cz_func_comp_specs
8450: WHERE cz_func_comp_specs.devl_project_id = p_model_array(i) AND cz_func_comp_specs.deleted_flag = record_not_deleted;
8451: EXCEPTION
8452: WHEN OTHERS
8453: THEN

Line 8450: WHERE cz_func_comp_specs.devl_project_id = p_model_array(i) AND cz_func_comp_specs.deleted_flag = record_not_deleted;

8446: BEGIN
8447: SELECT MAX(last_update_date)
8448: INTO v_update_date
8449: FROM cz_func_comp_specs
8450: WHERE cz_func_comp_specs.devl_project_id = p_model_array(i) AND cz_func_comp_specs.deleted_flag = record_not_deleted;
8451: EXCEPTION
8452: WHEN OTHERS
8453: THEN
8454: v_update_date := NULL;

Line 9383: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;

9379: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;
9380: v_models_tbl cz_pb_mgr.t_ref;
9381: record_count PLS_INTEGER := 0;
9382: v_last_update_date cz_ui_defs.last_update_date%TYPE;
9383: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;
9384: v_eff_update_date DATE;
9385: v_last_xfr_activity cz_pb_model_exports.last_xfr_activity%TYPE;
9386: l_max_template_date cz_pb_model_exports.last_xfr_activity%TYPE;
9387: l_capt_update_date DATE;

Line 12891: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);

12887: THEN
12888: log_timing_message('start bulk collect of func comp specs');
12889: END IF;
12890:
12891: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12892:
12893: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
12894: THEN
12895: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST

Line 12897: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);

12893: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
12894: THEN
12895: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST
12896: LOOP
12897: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12898: v_cz_func_devl_old_tbl.DELETE;
12899: v_cz_func_cid_old_tbl.DELETE;
12900: v_cz_func_expl_old_tbl.DELETE;
12901: v_cz_func_fld_old_tbl.DELETE;

Line 12905: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_func_comp_specs_seq

12901: v_cz_func_fld_old_tbl.DELETE;
12902: v_object_type_tbl.DELETE;
12903:
12904: BEGIN
12905: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_func_comp_specs_seq
12906: , 'cz_func_comp_specs_s.nextval' || cz_pb_mgr.v_db_link
12907: ,cz_pb_mgr.v_oraclesequenceincr
12908: )
12909: ,func_comp_id, devl_project_id, component_id, model_ref_expl_id

Line 12906: , 'cz_func_comp_specs_s.nextval' || cz_pb_mgr.v_db_link

12902: v_object_type_tbl.DELETE;
12903:
12904: BEGIN
12905: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_func_comp_specs_seq
12906: , 'cz_func_comp_specs_s.nextval' || cz_pb_mgr.v_db_link
12907: ,cz_pb_mgr.v_oraclesequenceincr
12908: )
12909: ,func_comp_id, devl_project_id, component_id, model_ref_expl_id
12910: ,rule_folder_id, 'FNC'

Line 12914: FROM cz_func_comp_specs t

12910: ,rule_folder_id, 'FNC'
12911: BULK COLLECT INTO cz_pb_mgr.v_cz_func_comp_new_tbl
12912: ,cz_pb_mgr.v_cz_func_comp_old_tbl, v_cz_func_devl_old_tbl, v_cz_func_cid_old_tbl, v_cz_func_expl_old_tbl
12913: ,v_cz_func_fld_old_tbl, v_object_type_tbl
12914: FROM cz_func_comp_specs t
12915: WHERE t.model_ref_expl_id = cz_pb_mgr.v_cz_model_ref_expls_old_ref(i) AND t.deleted_flag = '0';
12916: EXCEPTION
12917: WHEN NO_DATA_FOUND
12918: THEN

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

12919: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
12920: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.FUNCCOMP', SQLCODE);
12921: WHEN OTHERS
12922: THEN
12923: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_func_comp_specs', 'SQLERRM', SQLERRM);
12924: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
12925: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
12926: RAISE;
12927: END;

Line 13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);

13197: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);

Line 13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);

13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);
13205: clear_tables('cz_ui_nodes', 'ref', cz_pb_mgr.v_status_code);
13206: clear_tables('cz_ps_prop_vals', 'ref', cz_pb_mgr.v_status_code);

Line 16192: ----------insert into cz_func_comp_specs

16188: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_rf_id_ref';
16189: rec_count := rec_count + 1;
16190: plsql_table_list(rec_count).col_name := 'effectivity_set_id';
16191: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_rules_eff_id_ref';
16192: ----------insert into cz_func_comp_specs
16193: insert_into_table('cz_rule_folders'
16194: ,'rule_folder_id'
16195: ,'object_type'
16196: ,cz_pb_mgr.v_db_link

Line 16772: resolve_ids(cz_pb_mgr.v_cz_func_fld_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder id of cz_func_comp_specs');

16768: cz_pb_mgr.v_cz_func_fld_old_ref(i):=v_model_root_folder_map(cz_pb_mgr.v_cz_func_devl_old_ref(i));
16769: END IF;
16770: END LOOP;
16771: END IF;
16772: resolve_ids(cz_pb_mgr.v_cz_func_fld_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder id of cz_func_comp_specs');
16773:
16774: IF (cz_pb_mgr.g_log_timing = publication_timing)
16775: THEN
16776: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');

Line 16776: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');

16772: resolve_ids(cz_pb_mgr.v_cz_func_fld_old_ref, cz_pb_mgr.v_cz_folders_id_idx_ref, 'rule folder id of cz_func_comp_specs');
16773:
16774: IF (cz_pb_mgr.g_log_timing = publication_timing)
16775: THEN
16776: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
16777: END IF;
16778:
16779: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
16780:

Line 16779: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');

16775: THEN
16776: log_timing_message('start resolve_ids devl project id of cz_func_comp_specs');
16777: END IF;
16778:
16779: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
16780:
16781: IF (cz_pb_mgr.g_log_timing = publication_timing)
16782: THEN
16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');

Line 16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');

16779: resolve_ids(cz_pb_mgr.v_cz_func_devl_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl project id of cz_func_comp_specs');
16780:
16781: IF (cz_pb_mgr.g_log_timing = publication_timing)
16782: THEN
16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
16784: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
16785: END IF;
16786:
16787: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);

Line 16784: log_timing_message('start resolve_ids component id of cz_func_comp_specs');

16780:
16781: IF (cz_pb_mgr.g_log_timing = publication_timing)
16782: THEN
16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
16784: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
16785: END IF;
16786:
16787: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
16788:

Line 16787: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);

16783: log_timing_message('end resolve_ids devl project id of cz_func_comp_specs');
16784: log_timing_message('start resolve_ids component id of cz_func_comp_specs');
16785: END IF;
16786:
16787: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
16788:
16789: IF (cz_pb_mgr.g_log_timing = publication_timing)
16790: THEN
16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');

Line 16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');

16787: resolve_ids(cz_pb_mgr.v_cz_func_cid_old_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component id of cz_func_comp_specs', FLD_RULE_COMPONENT_ID);
16788:
16789: IF (cz_pb_mgr.g_log_timing = publication_timing)
16790: THEN
16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
16792: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
16793: END IF;
16794:
16795: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');

Line 16795: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');

16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
16792: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
16793: END IF;
16794:
16795: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');
16796:
16797: IF (cz_pb_mgr.g_log_timing = publication_timing)
16798: THEN
16799: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');

Line 16802: --------populate plsql_table_list for cz func comp specs

16798: THEN
16799: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');
16800: END IF;
16801:
16802: --------populate plsql_table_list for cz func comp specs
16803: plsql_table_list.DELETE;
16804: rec_count := 1;
16805: plsql_table_list(rec_count).col_name := 'func_comp_id';
16806: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_comp_new_ref';

Line 16820: ----------insert into cz_func_comp_specs

16816: rec_count := rec_count + 1;
16817: plsql_table_list(rec_count).col_name := 'rule_folder_id';
16818: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
16819:
16820: ----------insert into cz_func_comp_specs
16821: IF (cz_pb_mgr.g_log_timing = publication_timing)
16822: THEN
16823: log_timing_message('start insert_into_table cz_func_comp_specs');
16824: END IF;

Line 16823: log_timing_message('start insert_into_table cz_func_comp_specs');

16819:
16820: ----------insert into cz_func_comp_specs
16821: IF (cz_pb_mgr.g_log_timing = publication_timing)
16822: THEN
16823: log_timing_message('start insert_into_table cz_func_comp_specs');
16824: END IF;
16825:
16826: insert_into_table('cz_func_comp_specs'
16827: ,'func_comp_id'

Line 16826: insert_into_table('cz_func_comp_specs'

16822: THEN
16823: log_timing_message('start insert_into_table cz_func_comp_specs');
16824: END IF;
16825:
16826: insert_into_table('cz_func_comp_specs'
16827: ,'func_comp_id'
16828: ,cz_pb_mgr.v_db_link
16829: ,plsql_table_list
16830: ,'cz_pb_mgr.v_cz_func_comp_old_ref'

Line 16836: log_timing_message('end insert_into_table cz_func_comp_specs');

16832: );
16833:
16834: IF (cz_pb_mgr.g_log_timing = publication_timing)
16835: THEN
16836: log_timing_message('end insert_into_table cz_func_comp_specs');
16837: END IF;
16838:
16839: -----insert new records into cz_rule_folders
16840: plsql_table_list.DELETE;

Line 16853: ----------insert into cz_func_comp_specs

16849: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_devl_old_ref';
16850: rec_count := rec_count + 1;
16851: plsql_table_list(rec_count).col_name := 'parent_rule_folder_id';
16852: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_func_fld_old_ref';
16853: ----------insert into cz_func_comp_specs
16854: insert_into_table('cz_rule_folders'
16855: ,'rule_folder_id'
16856: ,'object_type'
16857: ,cz_pb_mgr.v_db_link