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 533: ELSIF(p_table_name = 'cz_lce_load_specs')

529: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
530: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
531: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
532: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
533: ELSIF(p_table_name = 'cz_lce_load_specs')
534: THEN
535: cz_pb_mgr.v_specs_net_type_ref.DELETE;
536: cz_pb_mgr.v_specs_attach_expl_id_ref.DELETE;
537: cz_pb_mgr.v_specs_lce_header_id_ref.DELETE;

Line 10804: || 'INSERT INTO cz_lce_load_specs'

10800: || 'FOR I IN cz_pb_mgr.v_specs_attach_expl_id_ref.FIRST..cz_pb_mgr.v_specs_attach_expl_id_ref.LAST'
10801: || ' '
10802: || 'LOOP'
10803: || ' '
10804: || 'INSERT INTO cz_lce_load_specs'
10805: || cz_pb_mgr.v_db_link
10806: || '(ATTACHMENT_EXPL_ID'
10807: || ' '
10808: || ',LCE_HEADER_ID'

Line 10967: ------insert data into cz_lce_load_specs

10963: ,plsql_table_list
10964: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'
10965: ,cz_pb_mgr.v_cz_lce_headers_old_ref
10966: );
10967: ------insert data into cz_lce_load_specs
10968: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
10969: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN
10970: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10971: LOOP

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

10964: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'
10965: ,cz_pb_mgr.v_cz_lce_headers_old_ref
10966: );
10967: ------insert data into cz_lce_load_specs
10968: clear_tables('cz_lce_load_specs', 'ref', cz_pb_mgr.v_status_code);
10969: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN
10970: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10971: LOOP
10972: BEGIN

Line 10985: FROM cz_lce_load_specs

10981: SELECT attachment_expl_id, lce_header_id, required_expl_id, attachment_comp_id
10982: ,model_id, net_type, alias_name
10983: 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
10984: ,v_specs_model_id_tbl, v_specs_net_type_tbl, v_specs_alias_name_tbl
10985: FROM cz_lce_load_specs
10986: 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;
10987: EXCEPTION
10988: WHEN NO_DATA_FOUND
10989: THEN

Line 10986: 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;

10982: ,model_id, net_type, alias_name
10983: 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
10984: ,v_specs_model_id_tbl, v_specs_net_type_tbl, v_specs_alias_name_tbl
10985: FROM cz_lce_load_specs
10986: 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;
10987: EXCEPTION
10988: WHEN NO_DATA_FOUND
10989: THEN
10990: NULL;

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

11012: END LOOP;
11013: END IF;
11014:
11015: --------resolve attachment expl id
11016: 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');
11017: --------resolve lce_header id
11018: 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');
11019: --------resolve required expl id
11020: 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 11018: 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');

11014:
11015: --------resolve attachment expl id
11016: 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');
11017: --------resolve lce_header id
11018: 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');
11019: --------resolve required expl id
11020: 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');
11021: --------resolve attachment comp id
11022: 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 11020: 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');

11016: 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');
11017: --------resolve lce_header id
11018: 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');
11019: --------resolve required expl id
11020: 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');
11021: --------resolve attachment comp id
11022: 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');
11023: --------resolve model id
11024: 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 11022: 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');

11018: 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');
11019: --------resolve required expl id
11020: 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');
11021: --------resolve attachment comp id
11022: 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');
11023: --------resolve model id
11024: 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');
11025: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
11026: ,cz_pb_mgr.v_specs_lce_header_id_ref

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

11020: 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');
11021: --------resolve attachment comp id
11022: 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');
11023: --------resolve model id
11024: 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');
11025: insert_lce_load_specs(cz_pb_mgr.v_specs_attach_expl_id_ref
11026: ,cz_pb_mgr.v_specs_lce_header_id_ref
11027: ,cz_pb_mgr.v_specs_required_expl_id_ref
11028: ,cz_pb_mgr.v_specs_attach_comp_id_ref

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