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_HEADERS

Line 474: ELSIF(p_table_name = 'cz_lce_headers')

470: cz_pb_mgr.v_cz_des_cells_sopt_id_ref.DELETE;
471: cz_pb_mgr.v_cz_des_cells_popt_id_ref.DELETE;
472: cz_pb_mgr.v_cz_des_cells_sexpl_id_ref.DELETE;
473: END IF;
474: ELSIF(p_table_name = 'cz_lce_headers')
475: THEN
476: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
478: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;

Line 476: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;

472: cz_pb_mgr.v_cz_des_cells_sexpl_id_ref.DELETE;
473: END IF;
474: ELSIF(p_table_name = 'cz_lce_headers')
475: THEN
476: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
478: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
479: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
480: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

Line 477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;

473: END IF;
474: ELSIF(p_table_name = 'cz_lce_headers')
475: THEN
476: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
478: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
479: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
480: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
481: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

Line 480: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

476: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
478: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
479: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
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')

Line 481: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

477: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
478: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
479: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
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

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

6484: ,v_database_link
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
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

Line 10103: --------copy data into cz_lce_headers

10099: RAISE;
10100: END insert_lce_load_specs;
10101:
10102: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10103: --------copy data into cz_lce_headers
10104: PROCEDURE copy_lce_headers
10105: IS
10106: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10107: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;

Line 10108: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;

10104: PROCEDURE copy_lce_headers
10105: IS
10106: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10107: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10108: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10109: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10110: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10111: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10112: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;

Line 10109: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;

10105: IS
10106: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10107: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10108: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10109: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10110: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10111: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10112: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10113: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;

Line 10110: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;

10106: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10107: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10108: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10109: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10110: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10111: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10112: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10113: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;
10114: v_specs_lce_header_id_tbl cz_pb_mgr.t_ref;

Line 10111: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;

10107: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10108: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10109: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10110: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10111: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10112: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10113: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;
10114: v_specs_lce_header_id_tbl cz_pb_mgr.t_ref;
10115: v_specs_required_expl_id_tbl cz_pb_mgr.t_ref;

Line 10128: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

10124: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
10125: THEN
10126: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10127: THEN
10128: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10129: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10130: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10131: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10132: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;

Line 10129: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

10125: THEN
10126: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10127: THEN
10128: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10129: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10130: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10131: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10132: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
10133: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;

Line 10130: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;

10126: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10127: THEN
10128: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10129: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10130: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10131: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10132: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
10133: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;
10134:

Line 10137: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;

10133: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;
10134:
10135: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10136: LOOP
10137: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
10138: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
10139: v_cz_lce_comp_id_tbl.DELETE;
10140: v_cz_lce_expl_id_tbl.DELETE;
10141:

Line 10138: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;

10134:
10135: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10136: LOOP
10137: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
10138: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
10139: v_cz_lce_comp_id_tbl.DELETE;
10140: v_cz_lce_expl_id_tbl.DELETE;
10141:
10142: BEGIN

Line 10143: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq

10139: v_cz_lce_comp_id_tbl.DELETE;
10140: v_cz_lce_expl_id_tbl.DELETE;
10141:
10142: BEGIN
10143: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq
10144: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10145: ,cz_pb_mgr.v_oraclesequenceincr
10146: )
10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id

Line 10144: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link

10140: v_cz_lce_expl_id_tbl.DELETE;
10141:
10142: BEGIN
10143: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq
10144: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10145: ,cz_pb_mgr.v_oraclesequenceincr
10146: )
10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl

Line 10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl

10144: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10145: ,cz_pb_mgr.v_oraclesequenceincr
10146: )
10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10149: ,cz_pb_mgr.v_cz_lce_headers_old_tbl, v_cz_lce_comp_id_tbl, v_cz_lce_expl_id_tbl, v_cz_lce_devl_id_tbl
10150: FROM cz_lce_headers
10151: WHERE cz_lce_headers.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_headers.deleted_flag = record_not_deleted;
10152: EXCEPTION

Line 10149: ,cz_pb_mgr.v_cz_lce_headers_old_tbl, v_cz_lce_comp_id_tbl, v_cz_lce_expl_id_tbl, v_cz_lce_devl_id_tbl

10145: ,cz_pb_mgr.v_oraclesequenceincr
10146: )
10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10149: ,cz_pb_mgr.v_cz_lce_headers_old_tbl, v_cz_lce_comp_id_tbl, v_cz_lce_expl_id_tbl, v_cz_lce_devl_id_tbl
10150: FROM cz_lce_headers
10151: WHERE cz_lce_headers.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_headers.deleted_flag = record_not_deleted;
10152: EXCEPTION
10153: WHEN NO_DATA_FOUND

Line 10150: FROM cz_lce_headers

10146: )
10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10149: ,cz_pb_mgr.v_cz_lce_headers_old_tbl, v_cz_lce_comp_id_tbl, v_cz_lce_expl_id_tbl, v_cz_lce_devl_id_tbl
10150: FROM cz_lce_headers
10151: WHERE cz_lce_headers.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_headers.deleted_flag = record_not_deleted;
10152: EXCEPTION
10153: WHEN NO_DATA_FOUND
10154: THEN

Line 10151: WHERE cz_lce_headers.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_headers.deleted_flag = record_not_deleted;

10147: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10148: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10149: ,cz_pb_mgr.v_cz_lce_headers_old_tbl, v_cz_lce_comp_id_tbl, v_cz_lce_expl_id_tbl, v_cz_lce_devl_id_tbl
10150: FROM cz_lce_headers
10151: WHERE cz_lce_headers.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_lce_headers.deleted_flag = record_not_deleted;
10152: EXCEPTION
10153: WHEN NO_DATA_FOUND
10154: THEN
10155: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

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

10155: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10156: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10157: WHEN OTHERS
10158: THEN
10159: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10160: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10161: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10162: END;
10163:

Line 10164: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;

10160: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10161: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10162: END;
10163:
10164: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10165:
10166: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10167: THEN
10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST

Line 10166: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)

10162: END;
10163:
10164: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10165:
10166: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10167: THEN
10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10169: LOOP
10170: rec_count := rec_count + 1;

Line 10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST

10164: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10165:
10166: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10167: THEN
10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10169: LOOP
10170: rec_count := rec_count + 1;
10171: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10172: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);

Line 10171: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);

10167: THEN
10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10169: LOOP
10170: rec_count := rec_count + 1;
10171: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10172: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10173: cz_pb_mgr.v_cz_lce_headers_idx_ref(cz_pb_mgr.v_cz_lce_headers_old_tbl(k)):=cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10174: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10175: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);

Line 10172: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);

10168: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10169: LOOP
10170: rec_count := rec_count + 1;
10171: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10172: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10173: cz_pb_mgr.v_cz_lce_headers_idx_ref(cz_pb_mgr.v_cz_lce_headers_old_tbl(k)):=cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10174: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10175: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);
10176: cz_pb_mgr.v_cz_lce_devl_id_ref(rec_count) := v_cz_lce_devl_id_tbl(k);

Line 10173: cz_pb_mgr.v_cz_lce_headers_idx_ref(cz_pb_mgr.v_cz_lce_headers_old_tbl(k)):=cz_pb_mgr.v_cz_lce_headers_new_tbl(k);

10169: LOOP
10170: rec_count := rec_count + 1;
10171: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10172: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10173: cz_pb_mgr.v_cz_lce_headers_idx_ref(cz_pb_mgr.v_cz_lce_headers_old_tbl(k)):=cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10174: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10175: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);
10176: cz_pb_mgr.v_cz_lce_devl_id_ref(rec_count) := v_cz_lce_devl_id_tbl(k);
10177: END LOOP;

Line 10182: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)

10178: END IF;
10179: END LOOP;
10180: END IF;
10181:
10182: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10183: THEN
10184: ------resolve component ids of cz lce headers
10185: resolve_ids(cz_pb_mgr.v_cz_lce_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of lce headers');
10186: -------resolve model ref expl id

Line 10184: ------resolve component ids of cz lce headers

10180: END IF;
10181:
10182: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10183: THEN
10184: ------resolve component ids of cz lce headers
10185: resolve_ids(cz_pb_mgr.v_cz_lce_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of lce headers');
10186: -------resolve model ref expl id
10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');
10188: -------resolve model ref expl id

Line 10190: ------------insert into cz lce headers

10186: -------resolve model ref expl id
10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');
10188: -------resolve model ref expl id
10189: resolve_ids(cz_pb_mgr.v_cz_lce_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl proj id of lce headers');
10190: ------------insert into cz lce headers
10191: plsql_table_list.DELETE;
10192: rec_count := 1;
10193: plsql_table_list(rec_count).col_name := 'lce_header_id';
10194: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_headers_new_ref';

Line 10194: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_headers_new_ref';

10190: ------------insert into cz lce headers
10191: plsql_table_list.DELETE;
10192: rec_count := 1;
10193: plsql_table_list(rec_count).col_name := 'lce_header_id';
10194: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_headers_new_ref';
10195: rec_count := rec_count + 1;
10196: plsql_table_list(rec_count).col_name := 'component_id';
10197: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_comp_id_ref';
10198: rec_count := rec_count + 1;

Line 10204: insert_into_table('cz_lce_headers'

10200: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_expl_id_ref';
10201: rec_count := rec_count + 1;
10202: plsql_table_list(rec_count).col_name := 'devl_project_id';
10203: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_devl_id_ref';
10204: insert_into_table('cz_lce_headers'
10205: ,'lce_header_id'
10206: ,cz_pb_mgr.v_db_link
10207: ,plsql_table_list
10208: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'

Line 10208: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'

10204: insert_into_table('cz_lce_headers'
10205: ,'lce_header_id'
10206: ,cz_pb_mgr.v_db_link
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);

Line 10209: ,cz_pb_mgr.v_cz_lce_headers_old_ref

10205: ,'lce_header_id'
10206: ,cz_pb_mgr.v_db_link
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

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 10297: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);

10293: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10294: RAISE;
10295: WHEN OTHERS
10296: THEN
10297: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10298: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCEHDRS', SQLCODE);
10299: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10300: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
10301: RAISE;

Line 10361: IF (cz_pb_mgr.v_cz_lce_headers_old_ref.COUNT > 0)

10357: l_text_id_tbl CZ_PB_MGR.t_ref;
10358: BEGIN
10359: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
10360: THEN
10361: IF (cz_pb_mgr.v_cz_lce_headers_old_ref.COUNT > 0)
10362: THEN
10363: v_text_hdr_ref.DELETE;
10364: v_text_seq_ref.DELETE;
10365: v_lce_text_ref.DELETE;

Line 10367: FOR i IN cz_pb_mgr.v_cz_lce_headers_old_ref.FIRST .. cz_pb_mgr.v_cz_lce_headers_old_ref.LAST

10363: v_text_hdr_ref.DELETE;
10364: v_text_seq_ref.DELETE;
10365: v_lce_text_ref.DELETE;
10366:
10367: FOR i IN cz_pb_mgr.v_cz_lce_headers_old_ref.FIRST .. cz_pb_mgr.v_cz_lce_headers_old_ref.LAST
10368: LOOP
10369: BEGIN
10370: v_text_hdr_tbl.DELETE;
10371: v_text_seq_tbl.DELETE;

Line 10377: WHERE cz_lce_texts.lce_header_id = cz_pb_mgr.v_cz_lce_headers_old_ref(i)

10373:
10374: SELECT lce_header_id, seq_nbr, lce_text
10375: BULK COLLECT INTO v_text_hdr_tbl, v_text_seq_tbl, v_lce_text_tbl
10376: FROM cz_lce_texts
10377: WHERE cz_lce_texts.lce_header_id = cz_pb_mgr.v_cz_lce_headers_old_ref(i)
10378: ORDER BY lce_header_id, seq_nbr;
10379: EXCEPTION
10380: WHEN NO_DATA_FOUND
10381: THEN

Line 10409: resolve_ids(v_text_hdr_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce header id of cz lce texts');

10405:
10406: IF (v_text_hdr_ref.COUNT > 0)
10407: THEN
10408: -------------Resolving lce header id
10409: resolve_ids(v_text_hdr_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce header id of cz lce texts');
10410: END IF;
10411:
10412: -------replace reason ids in lce text
10413: IF (v_lce_text_ref.COUNT > 0) THEN

Line 12225: clear_tables('cz_lce_headers', 'ref', 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
12229: THEN

Line 16090: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);

16086: v_cz_des_cells_popt_id_tbl.DELETE;
16087: v_cz_des_cells_sexpl_id_tbl.DELETE;
16088:
16089: ELSE
16090: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);
16091: END IF;
16092: EXCEPTION
16093: WHEN OTHERS
16094: THEN

Line 18547: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;

18543: l_model_name cz_devl_projects.NAME%TYPE;
18544: l_root_model_name cz_devl_projects.NAME%TYPE;
18545: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;
18546: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;
18547: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
18548: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
18549: l_engine_type cz_devl_projects.config_engine_type%TYPE;
18550: l_is_solver_model BOOLEAN;
18551:

Line 18548: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;

18544: l_root_model_name cz_devl_projects.NAME%TYPE;
18545: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;
18546: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;
18547: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
18548: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
18549: l_engine_type cz_devl_projects.config_engine_type%TYPE;
18550: l_is_solver_model BOOLEAN;
18551:
18552: CURSOR model_cur(in_root_model NUMBER) IS

Line 18581: FROM cz_lce_headers

18577: FROM cz_fce_files
18578: WHERE component_id = p_model_id AND deleted_flag = '0';
18579: ELSE
18580: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
18581: FROM cz_lce_headers
18582: WHERE cz_lce_headers.component_id = p_model_id AND cz_lce_headers.deleted_flag = '0';
18583: END IF;
18584:
18585: IF l_root_logic_last_update_date IS NULL OR l_root_logic_last_update_date < l_prj_last_logic_update THEN

Line 18582: WHERE cz_lce_headers.component_id = p_model_id AND cz_lce_headers.deleted_flag = '0';

18578: WHERE component_id = p_model_id AND deleted_flag = '0';
18579: ELSE
18580: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
18581: FROM cz_lce_headers
18582: WHERE cz_lce_headers.component_id = p_model_id AND cz_lce_headers.deleted_flag = '0';
18583: END IF;
18584:
18585: IF l_root_logic_last_update_date IS NULL OR l_root_logic_last_update_date < l_prj_last_logic_update THEN
18586: x_return_status := 1;

Line 18614: FROM cz_lce_headers

18610: FROM cz_fce_files
18611: WHERE component_id = l_component_id AND deleted_flag = '0';
18612: ELSE
18613: SELECT MAX(last_update_date) INTO l_logic_last_update_date
18614: FROM cz_lce_headers
18615: WHERE cz_lce_headers.component_id = l_component_id AND cz_lce_headers.deleted_flag = '0';
18616: END IF;
18617: END IF;
18618:

Line 18615: WHERE cz_lce_headers.component_id = l_component_id AND cz_lce_headers.deleted_flag = '0';

18611: WHERE component_id = l_component_id AND deleted_flag = '0';
18612: ELSE
18613: SELECT MAX(last_update_date) INTO l_logic_last_update_date
18614: FROM cz_lce_headers
18615: WHERE cz_lce_headers.component_id = l_component_id AND cz_lce_headers.deleted_flag = '0';
18616: END IF;
18617: END IF;
18618:
18619: IF l_prj_last_logic_update IS NULL OR l_logic_last_update_date IS NULL OR