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_LCE_LOAD_SPECS

Line 484: ELSIF(p_table_name = 'cz_lce_load_specs')

480: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
481: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
482: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
483: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
484: ELSIF(p_table_name = 'cz_lce_load_specs')
485: THEN
486: cz_pb_mgr.v_specs_net_type_ref.DELETE;
487: cz_pb_mgr.v_specs_attach_expl_id_ref.DELETE;
488: cz_pb_mgr.v_specs_lce_header_id_ref.DELETE;

Line 10048: || 'INSERT INTO cz_lce_load_specs'

10044: || 'FOR I IN cz_pb_mgr.v_specs_attach_expl_id_ref.FIRST..cz_pb_mgr.v_specs_attach_expl_id_ref.LAST'
10045: || ' '
10046: || 'LOOP'
10047: || ' '
10048: || 'INSERT INTO cz_lce_load_specs'
10049: || cz_pb_mgr.v_db_link
10050: || '(ATTACHMENT_EXPL_ID'
10051: || ' '
10052: || ',LCE_HEADER_ID'

Line 10211: ------insert data into cz_lce_load_specs

10207: ,plsql_table_list
10208: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'
10209: ,cz_pb_mgr.v_cz_lce_headers_old_ref
10210: );
10211: ------insert data into cz_lce_load_specs
10212: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
10213: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN
10214: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10215: LOOP

Line 10212: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);

10208: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'
10209: ,cz_pb_mgr.v_cz_lce_headers_old_ref
10210: );
10211: ------insert data into cz_lce_load_specs
10212: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
10213: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN
10214: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10215: LOOP
10216: BEGIN

Line 10229: FROM cz_lce_load_specs

10225: SELECT attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id
10226: ,model_id, net_type, alias_name
10227: BULK COLLECT INTO v_specs_attach_expl_id_tbl, v_specs_lce_header_id_tbl, v_specs_required_expl_id_tbl, v_specs_attach_comp_id_tbl
10228: ,v_specs_model_id_tbl, v_specs_net_type_tbl, v_specs_alias_name_tbl
10229: FROM cz_lce_load_specs
10230: WHERE cz_lce_load_specs.model_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_load_specs.deleted_flag = record_not_deleted;
10231: EXCEPTION
10232: WHEN NO_DATA_FOUND
10233: THEN

Line 10230: WHERE cz_lce_load_specs.model_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_load_specs.deleted_flag = record_not_deleted;

10226: ,model_id, net_type, alias_name
10227: BULK COLLECT INTO v_specs_attach_expl_id_tbl, v_specs_lce_header_id_tbl, v_specs_required_expl_id_tbl, v_specs_attach_comp_id_tbl
10228: ,v_specs_model_id_tbl, v_specs_net_type_tbl, v_specs_alias_name_tbl
10229: FROM cz_lce_load_specs
10230: WHERE cz_lce_load_specs.model_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_load_specs.deleted_flag = record_not_deleted;
10231: EXCEPTION
10232: WHEN NO_DATA_FOUND
10233: THEN
10234: NULL;

Line 10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');

10256: END LOOP;
10257: END IF;
10258:
10259: --------resolve attachment expl id
10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
10261: --------resolve lce_header id
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');

Line 10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');

10258:
10259: --------resolve attachment expl id
10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
10261: --------resolve lce_header id
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');

Line 10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');

10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
10261: --------resolve lce_header id
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');

Line 10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');

10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');
10269: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
10270: ,cz_pb_mgr.v_specs_lce_header_id_ref

Line 10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');

10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');
10269: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
10270: ,cz_pb_mgr.v_specs_lce_header_id_ref
10271: ,cz_pb_mgr.v_specs_required_expl_id_ref
10272: ,cz_pb_mgr.v_specs_attach_comp_id_ref

Line 12226: clear_tables('cz_lce_load_specs', '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
12229: THEN
12230: cz_pb_mgr.v_err_message := 'Error in clearing all tables : ' || SQLERRM;