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 523: ELSIF(p_table_name = 'cz_lce_headers')

519: cz_pb_mgr.v_cz_des_cells_sopt_id_ref.DELETE;
520: cz_pb_mgr.v_cz_des_cells_popt_id_ref.DELETE;
521: cz_pb_mgr.v_cz_des_cells_sexpl_id_ref.DELETE;
522: END IF;
523: ELSIF(p_table_name = 'cz_lce_headers')
524: THEN
525: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
527: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;

Line 525: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;

521: cz_pb_mgr.v_cz_des_cells_sexpl_id_ref.DELETE;
522: END IF;
523: ELSIF(p_table_name = 'cz_lce_headers')
524: THEN
525: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
527: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
528: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
529: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

Line 526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;

522: END IF;
523: ELSIF(p_table_name = 'cz_lce_headers')
524: THEN
525: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
527: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
528: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
529: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
530: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

Line 529: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

525: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
527: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
528: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
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')

Line 530: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

526: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
527: cz_pb_mgr.v_cz_intl_text_idx_ref.DELETE;
528: cz_pb_mgr.v_cz_intl_unmsg_idx_ref.DELETE;
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

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

7196: ,v_database_link
7197: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
7198: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
7199: );
7200: 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);
7201: 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);
7202: delete_from_table('cz_des_chart_features'
7203: ,'rule_id'
7204: ,v_database_link

Line 10859: --------copy data into cz_lce_headers

10855: RAISE;
10856: END insert_lce_load_specs;
10857:
10858: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
10859: --------copy data into cz_lce_headers
10860: PROCEDURE copy_lce_headers
10861: IS
10862: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10863: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;

Line 10864: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;

10860: PROCEDURE copy_lce_headers
10861: IS
10862: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10863: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10864: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10865: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10866: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10867: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10868: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;

Line 10865: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;

10861: IS
10862: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10863: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10864: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10865: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10866: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10867: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10868: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10869: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;

Line 10866: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;

10862: v_cz_lce_comp_id_tbl cz_pb_mgr.t_ref;
10863: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10864: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10865: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10866: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10867: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10868: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10869: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;
10870: v_specs_lce_header_id_tbl cz_pb_mgr.t_ref;

Line 10867: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;

10863: v_cz_lce_expl_id_tbl cz_pb_mgr.t_ref;
10864: v_cz_lce_headers_new_tbl cz_pb_mgr.t_ref;
10865: v_cz_lce_headers_old_tbl cz_pb_mgr.t_ref;
10866: v_cz_lce_headers_comp_tbl cz_pb_mgr.t_ref;
10867: v_cz_lce_headers_expl_tbl cz_pb_mgr.t_ref;
10868: v_cz_lce_devl_id_tbl cz_pb_mgr.t_ref;
10869: v_specs_attach_expl_id_tbl cz_pb_mgr.t_ref;
10870: v_specs_lce_header_id_tbl cz_pb_mgr.t_ref;
10871: v_specs_required_expl_id_tbl cz_pb_mgr.t_ref;

Line 10884: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;

10880: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
10881: THEN
10882: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10883: THEN
10884: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10885: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10886: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10887: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10888: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;

Line 10885: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;

10881: THEN
10882: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10883: THEN
10884: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10885: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10886: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10887: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10888: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
10889: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;

Line 10886: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;

10882: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0)
10883: THEN
10884: cz_pb_mgr.v_cz_lce_headers_new_ref.DELETE;
10885: cz_pb_mgr.v_cz_lce_headers_old_ref.DELETE;
10886: cz_pb_mgr.v_cz_lce_headers_idx_ref.DELETE;
10887: cz_pb_mgr.v_cz_lce_comp_id_ref.DELETE;
10888: cz_pb_mgr.v_cz_lce_expl_id_ref.DELETE;
10889: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;
10890:

Line 10893: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;

10889: cz_pb_mgr.v_cz_lce_devl_id_ref.DELETE;
10890:
10891: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10892: LOOP
10893: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
10894: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
10895: v_cz_lce_comp_id_tbl.DELETE;
10896: v_cz_lce_expl_id_tbl.DELETE;
10897:

Line 10894: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;

10890:
10891: FOR i IN cz_pb_mgr.v_models_to_be_exported.FIRST .. cz_pb_mgr.v_models_to_be_exported.LAST
10892: LOOP
10893: cz_pb_mgr.v_cz_lce_headers_new_tbl.DELETE;
10894: cz_pb_mgr.v_cz_lce_headers_old_tbl.DELETE;
10895: v_cz_lce_comp_id_tbl.DELETE;
10896: v_cz_lce_expl_id_tbl.DELETE;
10897:
10898: BEGIN

Line 10899: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq

10895: v_cz_lce_comp_id_tbl.DELETE;
10896: v_cz_lce_expl_id_tbl.DELETE;
10897:
10898: BEGIN
10899: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq
10900: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10901: ,cz_pb_mgr.v_oraclesequenceincr
10902: )
10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id

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

10896: v_cz_lce_expl_id_tbl.DELETE;
10897:
10898: BEGIN
10899: SELECT cz_pb_mgr.sequence_generate(cz_lce_headers_seq
10900: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10901: ,cz_pb_mgr.v_oraclesequenceincr
10902: )
10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl

Line 10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl

10900: , 'cz_lce_headers_s.nextval' || cz_pb_mgr.v_db_link
10901: ,cz_pb_mgr.v_oraclesequenceincr
10902: )
10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10905: ,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
10906: FROM cz_lce_headers
10907: 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;
10908: EXCEPTION

Line 10905: ,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

10901: ,cz_pb_mgr.v_oraclesequenceincr
10902: )
10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10905: ,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
10906: FROM cz_lce_headers
10907: 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;
10908: EXCEPTION
10909: WHEN NO_DATA_FOUND

Line 10906: FROM cz_lce_headers

10902: )
10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10905: ,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
10906: FROM cz_lce_headers
10907: 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;
10908: EXCEPTION
10909: WHEN NO_DATA_FOUND
10910: THEN

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

10903: ,lce_header_id, component_id, model_ref_expl_id, devl_project_id
10904: BULK COLLECT INTO cz_pb_mgr.v_cz_lce_headers_new_tbl
10905: ,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
10906: FROM cz_lce_headers
10907: 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;
10908: EXCEPTION
10909: WHEN NO_DATA_FOUND
10910: THEN
10911: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

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

10911: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);
10912: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10913: WHEN OTHERS
10914: THEN
10915: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
10916: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10917: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10918: END;
10919:

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

10916: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.LCE', SQLCODE);
10917: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
10918: END;
10919:
10920: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10921:
10922: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10923: THEN
10924: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST

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

10918: END;
10919:
10920: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10921:
10922: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10923: THEN
10924: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10925: LOOP
10926: rec_count := rec_count + 1;

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

10920: rec_count := cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT;
10921:
10922: IF (cz_pb_mgr.v_cz_lce_headers_new_tbl.COUNT > 0)
10923: THEN
10924: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10925: LOOP
10926: rec_count := rec_count + 1;
10927: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10928: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);

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

10923: THEN
10924: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10925: LOOP
10926: rec_count := rec_count + 1;
10927: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10928: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10929: 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);
10930: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10931: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);

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

10924: FOR k IN cz_pb_mgr.v_cz_lce_headers_new_tbl.FIRST .. cz_pb_mgr.v_cz_lce_headers_new_tbl.LAST
10925: LOOP
10926: rec_count := rec_count + 1;
10927: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10928: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10929: 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);
10930: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10931: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);
10932: cz_pb_mgr.v_cz_lce_devl_id_ref(rec_count) := v_cz_lce_devl_id_tbl(k);

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

10925: LOOP
10926: rec_count := rec_count + 1;
10927: cz_pb_mgr.v_cz_lce_headers_new_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_new_tbl(k);
10928: cz_pb_mgr.v_cz_lce_headers_old_ref(rec_count) := cz_pb_mgr.v_cz_lce_headers_old_tbl(k);
10929: 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);
10930: cz_pb_mgr.v_cz_lce_comp_id_ref(rec_count) := v_cz_lce_comp_id_tbl(k);
10931: cz_pb_mgr.v_cz_lce_expl_id_ref(rec_count) := v_cz_lce_expl_id_tbl(k);
10932: cz_pb_mgr.v_cz_lce_devl_id_ref(rec_count) := v_cz_lce_devl_id_tbl(k);
10933: END LOOP;

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

10934: END IF;
10935: END LOOP;
10936: END IF;
10937:
10938: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10939: THEN
10940: ------resolve component ids of cz lce headers
10941: 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');
10942: -------resolve model ref expl id

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

10936: END IF;
10937:
10938: IF (cz_pb_mgr.v_cz_lce_headers_new_ref.COUNT > 0)
10939: THEN
10940: ------resolve component ids of cz lce headers
10941: 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');
10942: -------resolve model ref expl id
10943: 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');
10944: -------resolve model ref expl id

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

10942: -------resolve model ref expl id
10943: 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');
10944: -------resolve model ref expl id
10945: 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');
10946: ------------insert into cz lce headers
10947: plsql_table_list.DELETE;
10948: rec_count := 1;
10949: plsql_table_list(rec_count).col_name := 'lce_header_id';
10950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_headers_new_ref';

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

10946: ------------insert into cz lce headers
10947: plsql_table_list.DELETE;
10948: rec_count := 1;
10949: plsql_table_list(rec_count).col_name := 'lce_header_id';
10950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_headers_new_ref';
10951: rec_count := rec_count + 1;
10952: plsql_table_list(rec_count).col_name := 'component_id';
10953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_comp_id_ref';
10954: rec_count := rec_count + 1;

Line 10960: insert_into_table('cz_lce_headers'

10956: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_expl_id_ref';
10957: rec_count := rec_count + 1;
10958: plsql_table_list(rec_count).col_name := 'devl_project_id';
10959: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_lce_devl_id_ref';
10960: insert_into_table('cz_lce_headers'
10961: ,'lce_header_id'
10962: ,cz_pb_mgr.v_db_link
10963: ,plsql_table_list
10964: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'

Line 10964: ,'cz_pb_mgr.v_cz_lce_headers_old_ref'

10960: insert_into_table('cz_lce_headers'
10961: ,'lce_header_id'
10962: ,cz_pb_mgr.v_db_link
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);

Line 10965: ,cz_pb_mgr.v_cz_lce_headers_old_ref

10961: ,'lce_header_id'
10962: ,cz_pb_mgr.v_db_link
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

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

11049: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11050: RAISE;
11051: WHEN OTHERS
11052: THEN
11053: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERT_ERR', 'TABLENAME', 'cz_lce_headers', 'SQLERRM', SQLERRM);
11054: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.COPYLCEHDRS', SQLCODE);
11055: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
11056: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
11057: RAISE;

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

11113: l_text_id_tbl CZ_PB_MGR.t_ref;
11114: BEGIN
11115: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
11116: THEN
11117: IF (cz_pb_mgr.v_cz_lce_headers_old_ref.COUNT > 0)
11118: THEN
11119: v_text_hdr_ref.DELETE;
11120: v_text_seq_ref.DELETE;
11121: v_lce_text_ref.DELETE;

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

11119: v_text_hdr_ref.DELETE;
11120: v_text_seq_ref.DELETE;
11121: v_lce_text_ref.DELETE;
11122:
11123: FOR i IN cz_pb_mgr.v_cz_lce_headers_old_ref.FIRST .. cz_pb_mgr.v_cz_lce_headers_old_ref.LAST
11124: LOOP
11125: BEGIN
11126: v_text_hdr_tbl.DELETE;
11127: v_text_seq_tbl.DELETE;

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

11129:
11130: SELECT lce_header_id, seq_nbr, lce_text
11131: BULK COLLECT INTO v_text_hdr_tbl, v_text_seq_tbl, v_lce_text_tbl
11132: FROM cz_lce_texts
11133: WHERE cz_lce_texts.lce_header_id = cz_pb_mgr.v_cz_lce_headers_old_ref(i)
11134: ORDER BY lce_header_id, seq_nbr;
11135: EXCEPTION
11136: WHEN NO_DATA_FOUND
11137: THEN

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

11161:
11162: IF (v_text_hdr_ref.COUNT > 0)
11163: THEN
11164: -------------Resolving lce header id
11165: resolve_ids(v_text_hdr_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce header id of cz lce texts');
11166: END IF;
11167:
11168: -------replace reason ids in lce text
11169: IF (v_lce_text_ref.COUNT > 0) THEN

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

13213: clear_tables('cz_expression_nodes', '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

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

17200: v_cz_des_cells_popt_id_tbl.DELETE;
17201: v_cz_des_cells_sexpl_id_tbl.DELETE;
17202:
17203: ELSE
17204: clear_tables('cz_lce_headers', 'ref', cz_pb_mgr.v_status_code);
17205: END IF;
17206: EXCEPTION
17207: WHEN OTHERS
17208: THEN

Line 19684: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;

19680: l_model_name cz_devl_projects.NAME%TYPE;
19681: l_root_model_name cz_devl_projects.NAME%TYPE;
19682: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;
19683: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;
19684: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
19685: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
19686: l_engine_type cz_devl_projects.config_engine_type%TYPE;
19687: l_is_solver_model BOOLEAN;
19688:

Line 19685: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;

19681: l_root_model_name cz_devl_projects.NAME%TYPE;
19682: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;
19683: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;
19684: l_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
19685: l_root_logic_last_update_date cz_lce_headers.last_update_date%TYPE;
19686: l_engine_type cz_devl_projects.config_engine_type%TYPE;
19687: l_is_solver_model BOOLEAN;
19688:
19689: CURSOR model_cur(in_root_model NUMBER) IS

Line 19718: FROM cz_lce_headers

19714: FROM cz_fce_files
19715: WHERE component_id = p_model_id AND deleted_flag = '0';
19716: ELSE
19717: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
19718: FROM cz_lce_headers
19719: WHERE cz_lce_headers.component_id = p_model_id AND cz_lce_headers.deleted_flag = '0';
19720: END IF;
19721:
19722: IF l_root_logic_last_update_date IS NULL OR l_root_logic_last_update_date < l_prj_last_logic_update THEN

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

19715: WHERE component_id = p_model_id AND deleted_flag = '0';
19716: ELSE
19717: SELECT MAX(last_update_date) INTO l_root_logic_last_update_date
19718: FROM cz_lce_headers
19719: WHERE cz_lce_headers.component_id = p_model_id AND cz_lce_headers.deleted_flag = '0';
19720: END IF;
19721:
19722: IF l_root_logic_last_update_date IS NULL OR l_root_logic_last_update_date < l_prj_last_logic_update THEN
19723: x_return_status := 1;

Line 19751: FROM cz_lce_headers

19747: FROM cz_fce_files
19748: WHERE component_id = l_component_id AND deleted_flag = '0';
19749: ELSE
19750: SELECT MAX(last_update_date) INTO l_logic_last_update_date
19751: FROM cz_lce_headers
19752: WHERE cz_lce_headers.component_id = l_component_id AND cz_lce_headers.deleted_flag = '0';
19753: END IF;
19754: END IF;
19755:

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

19748: WHERE component_id = l_component_id AND deleted_flag = '0';
19749: ELSE
19750: SELECT MAX(last_update_date) INTO l_logic_last_update_date
19751: FROM cz_lce_headers
19752: WHERE cz_lce_headers.component_id = l_component_id AND cz_lce_headers.deleted_flag = '0';
19753: END IF;
19754: END IF;
19755:
19756: IF l_prj_last_logic_update IS NULL OR l_logic_last_update_date IS NULL OR