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_DEVL_PROJECTS

Line 57: g_engine_type cz_devl_projects.config_engine_type%TYPE;

53: RULE_TYPE_CONFIG_EXTENSION CONSTANT INTEGER := 300;
54: RULE_TYPE_POPULATOR CONSTANT INTEGER := 502;
55: RULE_TYPE_CAPTION CONSTANT INTEGER := 700;
56:
57: g_engine_type cz_devl_projects.config_engine_type%TYPE;
58:
59: --Bug #5186307 - deferred.
60: --v_item_synched_osr t_item_origsysref_tbl;
61: --v_itemtype_synched_osr t_itemtype_origsysref_tbl;

Line 3221: l_export_model_id cz_devl_projects.devl_project_id%TYPE;

3217: AS
3218: v_ui_def_count NUMBER := 0;
3219: rec_count NUMBER := 0;
3220: v_src_uis_tbl cz_pb_mgr.t_ref;
3221: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
3222: l_menu_caption_rule_tbl cz_pb_mgr.t_ref;
3223: l_page_caption_rule_tbl cz_pb_mgr.t_ref;
3224: l_from_mt_id_tbl cz_pb_mgr.t_ref;
3225: BEGIN

Line 6898: log_timing_message('Start of rollback of cz_devl_projects table due to failure ');

6894:
6895: BEGIN
6896:
6897: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
6898: log_timing_message('Start of rollback of cz_devl_projects table due to failure ');
6899: END IF;
6900:
6901: IF ( cz_pb_mgr.v_models_to_be_exported_new.COUNT > 0 ) THEN
6902:

Line 6907: v_DeleteProj := v_DeleteProj||' DELETE FROM cz_devl_projects'||v_db_link||' tgt ';

6903: v_db_link := UPPER(LTRIM(RTRIM(db_link)));
6904:
6905: BEGIN
6906: v_DeleteProj := 'BEGIN FOR i IN cz_pb_mgr.v_models_to_be_exported_new.FIRST..cz_pb_mgr.v_models_to_be_exported_new.LAST LOOP ';
6907: v_DeleteProj := v_DeleteProj||' DELETE FROM cz_devl_projects'||v_db_link||' tgt ';
6908: v_DeleteProj := v_DeleteProj||' WHERE tgt.devl_project_id = cz_pb_mgr.v_models_to_be_exported_new(i) ';
6909: v_DeleteProj := v_DeleteProj||' AND NOT EXISTS( SELECT null FROM cz_rp_entries'||v_db_link;
6910: v_DeleteProj := v_DeleteProj||' WHERE object_type=''PRJ'' AND seeded_flag=''1'' AND object_id=tgt.devl_project_id)';
6911: v_DeleteProj := v_DeleteProj||' ; END LOOP; COMMIT; END; ';

Line 6925: log_timing_message('End of rollback of cz_devl_projects table due to failure ');

6921:
6922: COMMIT;
6923:
6924: IF (cz_pb_mgr.g_log_timing = publication_timing) THEN
6925: log_timing_message('End of rollback of cz_devl_projects table due to failure ');
6926: END IF;
6927:
6928: EXCEPTION
6929: WHEN OTHERS THEN

Line 6930: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', 'cz_devl_projects');

6926: END IF;
6927:
6928: EXCEPTION
6929: WHEN OTHERS THEN
6930: cz_pb_mgr.v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_TABLE_ROLLBACK_ERR', 'TABLENAME', 'cz_devl_projects');
6931: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message ,'cz_pb_mgr.ROLLBACK',SQLCODE);
6932:
6933: END DeleteFromDevlProjects;
6934:

Line 7180: --SKM:Bug-13437555 Caling own procedure for deleting from cz_devl_projects table.

7176: END IF;
7177:
7178: delete_from_table('cz_ps_nodes', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
7179: delete_from_table('cz_ps_prop_vals', 'ps_node_id', v_database_link, 'cz_pb_mgr.v_cz_ps_nodes_new_tbl', cz_pb_mgr.v_cz_ps_nodes_new_tbl);
7180: --SKM:Bug-13437555 Caling own procedure for deleting from cz_devl_projects table.
7181:
7182: DeleteFromDevlProjects(v_database_link);
7183:
7184: -- delete_from_table('cz_devl_projects'

Line 7184: -- delete_from_table('cz_devl_projects'

7180: --SKM:Bug-13437555 Caling own procedure for deleting from cz_devl_projects table.
7181:
7182: DeleteFromDevlProjects(v_database_link);
7183:
7184: -- delete_from_table('cz_devl_projects'
7185: -- ,'devl_project_id'
7186: -- ,v_database_link
7187: -- ,'cz_pb_mgr.v_models_to_be_exported_new'
7188: -- ,cz_pb_mgr.v_models_to_be_exported_new

Line 7559: FROM cz_devl_projects

7555: FROM cz_model_publications
7556: WHERE cz_model_publications.publication_id = p_publication_id)
7557: AND z.model_last_struct_update =
7558: (SELECT last_struct_update
7559: FROM cz_devl_projects
7560: WHERE cz_devl_projects.devl_project_id =
7561: (SELECT object_id
7562: FROM cz_model_publications
7563: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))

Line 7560: WHERE cz_devl_projects.devl_project_id =

7556: WHERE cz_model_publications.publication_id = p_publication_id)
7557: AND z.model_last_struct_update =
7558: (SELECT last_struct_update
7559: FROM cz_devl_projects
7560: WHERE cz_devl_projects.devl_project_id =
7561: (SELECT object_id
7562: FROM cz_model_publications
7563: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
7564: AND z.export_status IN('OK', 'PUP')

Line 7672: FROM cz_devl_projects t

7668: AS
7669: BEGIN
7670: SELECT last_struct_update
7671: INTO x_last_struct_date
7672: FROM cz_devl_projects t
7673: WHERE t.deleted_flag = record_not_deleted AND t.devl_project_id = p_model_id;
7674: EXCEPTION
7675: WHEN OTHERS
7676: THEN

Line 7694: l_export_model_id cz_devl_projects.devl_project_id%TYPE;

7690: AS
7691: v_ui_def_count NUMBER := 0;
7692: v_src_uis_tbl cz_pb_mgr.t_ref;
7693: v_cz_ui_defs_old_ref_idx_ref cz_pb_mgr.t_ref_idx_vc2;
7694: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
7695: BEGIN
7696: IF (p_src_models.COUNT > 0)
7697: THEN
7698: x_ui_def_ref.DELETE;

Line 8334: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;

8330: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8331: --------procedure that checks if logic has changed since the model was last published
8332: PROCEDURE chk_if_logic_changed(p_model_array IN cz_pb_mgr.t_ref, p_last_xfr_date IN DATE, x_record_count IN OUT NOCOPY NUMBER)
8333: AS
8334: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
8335: v_expr_node_date cz_ui_nodes.last_update_date%TYPE;
8336: BEGIN
8337: IF (p_model_array.COUNT > 0)
8338: THEN

Line 8352: FROM cz_devl_projects

8348:
8349: BEGIN
8350: SELECT last_logic_update
8351: INTO v_last_logic_update
8352: FROM cz_devl_projects
8353: WHERE cz_devl_projects.devl_project_id = p_model_array(i) AND cz_devl_projects.deleted_flag = '0';
8354: EXCEPTION
8355: WHEN OTHERS
8356: THEN

Line 8353: WHERE cz_devl_projects.devl_project_id = p_model_array(i) AND cz_devl_projects.deleted_flag = '0';

8349: BEGIN
8350: SELECT last_logic_update
8351: INTO v_last_logic_update
8352: FROM cz_devl_projects
8353: WHERE cz_devl_projects.devl_project_id = p_model_array(i) AND cz_devl_projects.deleted_flag = '0';
8354: EXCEPTION
8355: WHEN OTHERS
8356: THEN
8357: v_last_logic_update := NULL;

Line 8412: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;

8408: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8409: -------procedure checks if model structure has changed since it was last published
8410: PROCEDURE chk_if_struct_changed(p_model_array IN cz_pb_mgr.t_ref, p_last_xfr_date IN DATE, x_record_count IN OUT NOCOPY NUMBER)
8411: AS
8412: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
8413: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;
8414: BEGIN
8415: IF (p_model_array.COUNT > 0)
8416: THEN

Line 8413: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;

8409: -------procedure checks if model structure has changed since it was last published
8410: PROCEDURE chk_if_struct_changed(p_model_array IN cz_pb_mgr.t_ref, p_last_xfr_date IN DATE, x_record_count IN OUT NOCOPY NUMBER)
8411: AS
8412: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
8413: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;
8414: BEGIN
8415: IF (p_model_array.COUNT > 0)
8416: THEN
8417: FOR i IN p_model_array.FIRST .. p_model_array.LAST

Line 9379: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;

9375: ------------procedure checks if the model has been changed since it was last published
9376: FUNCTION has_tobe_published(publicationid IN NUMBER)
9377: RETURN BOOLEAN
9378: IS
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;

Line 9489: FROM cz_devl_projects

9485: LOOP
9486: BEGIN
9487: SELECT last_update_date
9488: INTO l_capt_update_date
9489: FROM cz_devl_projects
9490: WHERE devl_project_id = v_models_tbl(i);
9491: EXCEPTION
9492: WHEN OTHERS
9493: THEN

Line 9822: || 'FROM cz_pb_model_exports x, cz_devl_projects'

9818: || 'AND cz_pb_model_exports.export_id = '
9819: || ' '
9820: || '(SELECT MIN(export_id)'
9821: || ' '
9822: || 'FROM cz_pb_model_exports x, cz_devl_projects'
9823: || cz_pb_mgr.v_db_link
9824: || ' farprj'
9825: || ' '
9826: || 'WHERE x.server_id = :2'

Line 9954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'

9950: FROM cz_pb_model_exports
9951: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9952: AND migration_group_id=g_migration_group_id;
9953: ELSE
9954: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'
9955: || cz_pb_mgr.v_db_link
9956: || ' farprj'
9957: || ' '
9958: || 'WHERE x.model_id = :1'

Line 10052: FROM cz_devl_projects x, cz_pb_model_exports y

10048:
10049: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
10050: IF cz_pb_mgr.v_server_id = 0 THEN
10051: SELECT COUNT(*) INTO v_count
10052: FROM cz_devl_projects x, cz_pb_model_exports y
10053: WHERE x.devl_project_id = y.model_id
10054: AND x.last_update_date < y.last_xfr_activity
10055: AND y.last_xfr_activity > v_expr_last_update
10056: AND y.model_id = v_model_id AND y.server_id = 0

Line 10059: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_devl_projects x, cz_pb_model_exports y, cz_devl_projects'

10055: AND y.last_xfr_activity > v_expr_last_update
10056: AND y.model_id = v_model_id AND y.server_id = 0
10057: AND y.status = 'OK' AND y.migration_group_id = g_migration_group_id;
10058: ELSE
10059: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_devl_projects x, cz_pb_model_exports y, cz_devl_projects'
10060: || cz_pb_mgr.v_db_link
10061: || ' farprj'
10062: || ' '
10063: || 'WHERE x.devl_project_id = y.model_id'

Line 10086: FROM cz_devl_projects x, cz_pb_model_exports y

10082: END IF;
10083: ELSE
10084: SELECT COUNT(*)
10085: INTO v_count
10086: FROM cz_devl_projects x, cz_pb_model_exports y
10087: WHERE x.devl_project_id = y.model_id
10088: AND x.last_update_date < y.last_xfr_activity
10089: AND y.last_xfr_activity > v_expr_last_update
10090: AND y.model_id = v_model_id

Line 10121: || 'FROM cz_devl_projects'

10117: || cz_pb_mgr.v_db_link
10118: || ' '
10119: || '(devl_project_id, ''PRJ''), ''/'', ''.'')'
10120: || ' '
10121: || 'FROM cz_devl_projects'
10122: || cz_pb_mgr.v_db_link
10123: || ' t'
10124: || ' '
10125: || 'WHERE t.devl_project_id = :1'

Line 10479: PROCEDURE verify_model_for_sync(p_server_id IN cz_servers.server_local_id%TYPE, p_model_id IN cz_devl_projects.devl_project_id%TYPE)

10475: -----@p_server_id is the target_server_id
10476: -----@p_model_id is the devl_project_id of the model being published
10477: -----@cz_pb_mgr.bom_flag is the out parameter: 'Y' indicates the model is to be
10478: -----synchronized. 'N' indicates that no sync is necessary.
10479: PROCEDURE verify_model_for_sync(p_server_id IN cz_servers.server_local_id%TYPE, p_model_id IN cz_devl_projects.devl_project_id%TYPE)
10480: AS
10481: v_source_server NUMBER;
10482: v_bom_persistent_node_id NUMBER;
10483: v_bom_ps_node_id NUMBER;

Line 10488: v_model_name cz_devl_projects.NAME%TYPE;

10484: v_bom_err_flag VARCHAR2(1);
10485: v_bom_err_msg VARCHAR2(2000);
10486: v_verify_model_run_id NUMBER;
10487: v_bomsynch_err_flag VARCHAR2(2000);
10488: v_model_name cz_devl_projects.NAME%TYPE;
10489:
10490: TYPE verify_model_message_list IS TABLE OF cz_db_logs.MESSAGE%TYPE
10491: INDEX BY BINARY_INTEGER;
10492:

Line 10548: FROM cz_devl_projects

10544:
10545: BEGIN
10546: SELECT NAME
10547: INTO v_model_name
10548: FROM cz_devl_projects
10549: WHERE devl_project_id = cz_pb_mgr.v_root_model_id AND deleted_flag = '0';
10550: EXCEPTION
10551: WHEN OTHERS
10552: THEN

Line 11476: v_ref_project cz_devl_projects.devl_project_id%TYPE;

11472: AS
11473: ref_node_found BOOLEAN := FALSE;
11474: v_node_id NUMBER := 0.0;
11475: child_ref_id_cv ref_cursor;
11476: v_ref_project cz_devl_projects.devl_project_id%TYPE;
11477: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
11478: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11479: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
11480: v_source_child_model cz_model_ref_expls.model_id%TYPE;

Line 11477: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;

11473: ref_node_found BOOLEAN := FALSE;
11474: v_node_id NUMBER := 0.0;
11475: child_ref_id_cv ref_cursor;
11476: v_ref_project cz_devl_projects.devl_project_id%TYPE;
11477: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
11478: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
11479: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
11480: v_source_child_model cz_model_ref_expls.model_id%TYPE;
11481: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;

Line 11855: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;

11851: v_vir_devl_id NUMBER := 0.0;
11852: v_remote_comp_id NUMBER := 0.0;
11853: v_child_expl_id NUMBER := 0.0;
11854: v_vir_persistent_id cz_ps_nodes.persistent_node_id%TYPE;
11855: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;
11856: BEGIN
11857: IF (x_status <> PUBLICATION_ERROR)
11858: THEN
11859: IF (p_models_not_exported.COUNT > 0)

Line 12061: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;

12057:
12058: v_ui_defs_tbl cz_pb_mgr.t_ref;
12059:
12060: ui_ref_id_cv REF_CURSOR;
12061: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12062: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12063: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
12064: v_name cz_ui_defs.name%TYPE;
12065: CANNOT_FIND_REMOTE_UI EXCEPTION;

Line 12062: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;

12058: v_ui_defs_tbl cz_pb_mgr.t_ref;
12059:
12060: ui_ref_id_cv REF_CURSOR;
12061: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12062: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
12063: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
12064: v_name cz_ui_defs.name%TYPE;
12065: CANNOT_FIND_REMOTE_UI EXCEPTION;
12066:

Line 12169: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;

12165: v_remote_ui_nod_ui_def_tbl cz_pb_mgr.t_ref;
12166: v_remote_pers_ui_node_tbl cz_pb_mgr.t_ref;
12167: v_remote_pers_ui_node_ref cz_pb_mgr.t_ref;
12168: ui_def_ref_id_cv ref_cursor;
12169: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;
12170: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
12171: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
12172: rec_count NUMBER;
12173:

Line 13342: FROM cz_model_publications, cz_devl_projects

13338: IF (x_status <> PUBLICATION_ERROR)
13339: THEN
13340: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';

Line 13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id

13341: INTO x_model_id, x_ui_def_id, x_server_id, x_export_status, x_remote_publication_id, x_object_type, x_pb_mode, g_engine_type
13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13348: -- AND cz_model_publications.disabled_flag = '0';
13349:

Line 13346: AND cz_devl_projects.deleted_flag = '0';

13342: FROM cz_model_publications, cz_devl_projects
13343: WHERE cz_model_publications.publication_id = p_publication_id
13344: AND cz_model_publications.deleted_flag = record_not_deleted
13345: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
13346: AND cz_devl_projects.deleted_flag = '0';
13347: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
13348: -- AND cz_model_publications.disabled_flag = '0';
13349:
13350: ----if x_ui_def_id is null

Line 13456: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE

13452: ----------@p_server_id : server_id of the publication request
13453: ----------@x_publication_id : retrieved max publication id
13454: ----------@x_status: publication status parameter
13455: PROCEDURE get_max_pub_id(
13456: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13457: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
13458: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
13459: ,x_status IN OUT NOCOPY VARCHAR2
13460: )

Line 13469: FROM cz_devl_projects

13465: FROM cz_model_publications t
13466: WHERE t.model_id = p_model_id
13467: AND t.server_id = p_server_id
13468: AND t.model_last_struct_update = (SELECT last_struct_update
13469: FROM cz_devl_projects
13470: WHERE cz_devl_projects.devl_project_id = p_model_id)
13471: AND t.export_status IN('PUP', 'OK')
13472: AND t.source_target_flag = g_source_flag
13473: AND t.publication_id <> cz_pb_mgr.v_publication_id

Line 13470: WHERE cz_devl_projects.devl_project_id = p_model_id)

13466: WHERE t.model_id = p_model_id
13467: AND t.server_id = p_server_id
13468: AND t.model_last_struct_update = (SELECT last_struct_update
13469: FROM cz_devl_projects
13470: WHERE cz_devl_projects.devl_project_id = p_model_id)
13471: AND t.export_status IN('PUP', 'OK')
13472: AND t.source_target_flag = g_source_flag
13473: AND t.publication_id <> cz_pb_mgr.v_publication_id
13474: AND t.deleted_flag = record_not_deleted;

Line 13732: --Bug#12653412: SKM**SUN PURGE (Update all the models in cz_devl_projects.published to NULL

13728: SET remote_publication_id = p_new_publication_id
13729: WHERE publication_id = p_old_publication_id;
13730: END IF;
13731:
13732: --Bug#12653412: SKM**SUN PURGE (Update all the models in cz_devl_projects.published to NULL
13733: --based on the list of models exported (from cz_model_exports.remote_model_id) based on p_new/old_publication_id
13734: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects SET published = NULL ' || ' ' ||
13735: 'WHERE devl_project_id IN (SELECT remote_model_id '|| ' '||
13736: 'FROM cz_pb_model_exports WHERE publication_id = ' ||p_old_publication_id|| ')';

Line 13734: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects SET published = NULL ' || ' ' ||

13730: END IF;
13731:
13732: --Bug#12653412: SKM**SUN PURGE (Update all the models in cz_devl_projects.published to NULL
13733: --based on the list of models exported (from cz_model_exports.remote_model_id) based on p_new/old_publication_id
13734: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects SET published = NULL ' || ' ' ||
13735: 'WHERE devl_project_id IN (SELECT remote_model_id '|| ' '||
13736: 'FROM cz_pb_model_exports WHERE publication_id = ' ||p_old_publication_id|| ')';
13737:
13738: ------update for republish_model api

Line 13753: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects set checkout_user = NULL ' || ' ' || 'WHERE devl_project_id = ' || NVL(p_model_id, 0);

13749: || 'WHERE t.publication_id = :3 '
13750: USING v_repub_appl_from, v_repub_appl_until, v_repub_remote_pb_id;
13751: END IF;
13752:
13753: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects set checkout_user = NULL ' || ' ' || 'WHERE devl_project_id = ' || NVL(p_model_id, 0);
13754: END IF;
13755:
13756: COMMIT;
13757: EXCEPTION

Line 13840: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE

13836: END insert_pb_parameters;
13837:
13838: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13839: PROCEDURE insert_devl_projects(
13840: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13841: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13842: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
13843: ,x_status IN OUT NOCOPY VARCHAR2
13844: )

Line 13841: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE

13837:
13838: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13839: PROCEDURE insert_devl_projects(
13840: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13841: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13842: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
13843: ,x_status IN OUT NOCOPY VARCHAR2
13844: )
13845: AS

Line 13842: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE

13838: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13839: PROCEDURE insert_devl_projects(
13840: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13841: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
13842: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
13843: ,x_status IN OUT NOCOPY VARCHAR2
13844: )
13845: AS
13846: l_sql_query VARCHAR2(32000);

Line 13872: FROM cz_devl_projects

13868: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id
13869: ,cz_pb_mgr.l_devl_proj_org_id
13870: ,cz_pb_mgr.l_devl_proj_product_key, cz_pb_mgr.l_bom_caption_text_id
13871: ,cz_pb_mgr.l_nonbom_caption_text_id
13872: FROM cz_devl_projects
13873: WHERE cz_devl_projects.devl_project_id = p_old_model_id;
13874:
13875: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
13876: THEN

Line 13873: WHERE cz_devl_projects.devl_project_id = p_old_model_id;

13869: ,cz_pb_mgr.l_devl_proj_org_id
13870: ,cz_pb_mgr.l_devl_proj_product_key, cz_pb_mgr.l_bom_caption_text_id
13871: ,cz_pb_mgr.l_nonbom_caption_text_id
13872: FROM cz_devl_projects
13873: WHERE cz_devl_projects.devl_project_id = p_old_model_id;
13874:
13875: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
13876: THEN
13877: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;

Line 13878: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'bom capt text of cz_devl_projects');

13874:
13875: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
13876: THEN
13877: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;
13878: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'bom capt text of cz_devl_projects');
13879: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'bom capt text of cz_devl_projects');
13880: cz_pb_mgr.l_bom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
13881: ELSE
13882: cz_pb_mgr.l_bom_caption_text_id := NULL;

Line 13879: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'bom capt text of cz_devl_projects');

13875: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
13876: THEN
13877: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;
13878: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'bom capt text of cz_devl_projects');
13879: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'bom capt text of cz_devl_projects');
13880: cz_pb_mgr.l_bom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
13881: ELSE
13882: cz_pb_mgr.l_bom_caption_text_id := NULL;
13883: END IF;

Line 13888: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'non bom capt text of cz_devl_projects');

13884:
13885: IF (cz_pb_mgr.l_nonbom_caption_text_id <> 0)
13886: THEN
13887: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_nonbom_caption_text_id;
13888: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'non bom capt text of cz_devl_projects');
13889: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'non bom capt text of cz_devl_projects');
13890: cz_pb_mgr.l_nonbom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
13891: ELSE
13892: cz_pb_mgr.l_nonbom_caption_text_id := NULL;

Line 13889: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'non bom capt text of cz_devl_projects');

13885: IF (cz_pb_mgr.l_nonbom_caption_text_id <> 0)
13886: THEN
13887: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_nonbom_caption_text_id;
13888: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'non bom capt text of cz_devl_projects');
13889: resolve_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, cz_pb_mgr.v_cz_intl_text_idx_ref, 'non bom capt text of cz_devl_projects');
13890: cz_pb_mgr.l_nonbom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
13891: ELSE
13892: cz_pb_mgr.l_nonbom_caption_text_id := NULL;
13893: END IF;

Line 13913: 'BEGIN INSERT INTO cz_devl_projects'

13909: --Bug#12653412: SKM**SUN PURGE
13910: --Populate sysdate for the published column here
13911:
13912: l_sql_query :=
13913: 'BEGIN INSERT INTO cz_devl_projects'
13914: || cz_pb_mgr.v_db_link
13915: || '(DEVL_PROJECT_ID'
13916: || ' '
13917: || ',NAME,VERSION,DESC_TEXT,ORIG_SYS_REF,PUBLISHED,LAST_STRUCT_UPDATE'

Line 13943: || 'FROM cz_devl_projects'

13939: || ',:5,:6,:7'
13940: || ' '
13941: || ',:8,:9,POST_MIGR_CHANGE_FLAG,config_engine_type'
13942: || ' '
13943: || 'FROM cz_devl_projects'
13944: || ' '
13945: || 'WHERE cz_devl_projects.devl_project_id = '
13946: || TO_CHAR(p_old_model_id)
13947: || '; END; ';

Line 13945: || 'WHERE cz_devl_projects.devl_project_id = '

13941: || ',:8,:9,POST_MIGR_CHANGE_FLAG,config_engine_type'
13942: || ' '
13943: || 'FROM cz_devl_projects'
13944: || ' '
13945: || 'WHERE cz_devl_projects.devl_project_id = '
13946: || TO_CHAR(p_old_model_id)
13947: || '; END; ';
13948:
13949: EXECUTE IMMEDIATE l_sql_query

Line 13965: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_devl_projects', 'SQLERRM', SQLERRM);

13961: COMMIT;
13962: EXCEPTION
13963: WHEN OTHERS
13964: THEN
13965: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_devl_projects', 'SQLERRM', SQLERRM);
13966: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
13967: x_status := PUBLICATION_ERROR;
13968: RAISE;
13969: END insert_devl_projects;

Line 16576: FROM cz_rules rule, cz_devl_projects prj

16572: EXCEPTION
16573: WHEN NO_DATA_FOUND THEN
16574: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
16575: FOR j IN (SELECT rule.name rulename, prj.name prjname
16576: FROM cz_rules rule, cz_devl_projects prj
16577: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
16578: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_MIGR_RULE_ERR', 'FK_COL', p_colname, 'RULE_NAME', j.rulename, 'MODEL_NAME', j.prjname);
16579: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
16580: END LOOP;

Line 18478: l_model_name cz_devl_projects.NAME%TYPE;

18474: l_ui_name cz_ui_defs.NAME%TYPE;
18475: l_root_model_id NUMBER;
18476: l_root_ui_last_update_date DATE;
18477: l_model_id NUMBER;
18478: l_model_name cz_devl_projects.NAME%TYPE;
18479: l_last_update_date DATE;
18480: l_last_struct_update DATE;
18481: l_suppress_refresh_flag cz_ui_defs.suppress_refresh_flag%TYPE;
18482: BEGIN

Line 18497: FROM cz_devl_projects

18493: x_msg_data := l_ui_name;
18494:
18495: IF p_report_model_info = 1 THEN
18496: SELECT NAME INTO x_model_name
18497: FROM cz_devl_projects
18498: WHERE devl_project_id = l_root_model_id;
18499: END IF;
18500:
18501: RETURN;

Line 18560: FROM cz_devl_projects

18556: x_msg_data := l_ui_name;
18557:
18558: IF p_report_model_info = 1 THEN
18559: SELECT NAME INTO x_model_name
18560: FROM cz_devl_projects
18561: WHERE devl_project_id = l_model_id;
18562: END IF;
18563:
18564: EXIT;

Line 18571: FROM cz_devl_projects

18567:
18568: BEGIN
18569: SELECT DECODE(l_ui_style, g_ui_style_jrad, NVL(ui_timestamp_struct_update, last_struct_update), last_struct_update), NAME
18570: INTO l_last_struct_update, l_model_name
18571: FROM cz_devl_projects
18572: WHERE cz_devl_projects.devl_project_id = l_model_id;
18573: EXCEPTION
18574: WHEN OTHERS THEN
18575: l_last_struct_update := NULL;

Line 18572: WHERE cz_devl_projects.devl_project_id = l_model_id;

18568: BEGIN
18569: SELECT DECODE(l_ui_style, g_ui_style_jrad, NVL(ui_timestamp_struct_update, last_struct_update), last_struct_update), NAME
18570: INTO l_last_struct_update, l_model_name
18571: FROM cz_devl_projects
18572: WHERE cz_devl_projects.devl_project_id = l_model_id;
18573: EXCEPTION
18574: WHEN OTHERS THEN
18575: l_last_struct_update := NULL;
18576: l_model_name := NULL;

Line 18751: FROM cz_devl_projects

18747:
18748: BEGIN
18749: SELECT 1, NVL(config_engine_type, 'L')
18750: INTO v_model_chk_count, g_engine_type
18751: FROM cz_devl_projects
18752: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
18753: EXCEPTION
18754: WHEN OTHERS
18755: THEN

Line 18752: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';

18748: BEGIN
18749: SELECT 1, NVL(config_engine_type, 'L')
18750: INTO v_model_chk_count, g_engine_type
18751: FROM cz_devl_projects
18752: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
18753: EXCEPTION
18754: WHEN OTHERS
18755: THEN
18756: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');

Line 18940: FROM cz_devl_projects

18936:
18937: BEGIN
18938: SELECT desc_text, orig_sys_ref
18939: INTO v_rp_entries_desc, v_rp_orig_sys_ref
18940: FROM cz_devl_projects
18941: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
18942: EXCEPTION
18943: WHEN NO_DATA_FOUND
18944: THEN

Line 18941: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';

18937: BEGIN
18938: SELECT desc_text, orig_sys_ref
18939: INTO v_rp_entries_desc, v_rp_orig_sys_ref
18940: FROM cz_devl_projects
18941: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
18942: EXCEPTION
18943: WHEN NO_DATA_FOUND
18944: THEN
18945: v_rp_orig_sys_ref := NULL;

Line 18951: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;

18947: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18948: WHEN OTHERS
18949: THEN
18950: v_rp_orig_sys_ref := NULL;
18951: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;
18952: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
18953: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
18954: END;
18955:

Line 19030: || 'UPDATE cz_devl_projects'

19026: IF ((l_model_upto_date_status = 0) AND(l_ui_upto_date_status = 0))
19027: THEN
19028: EXECUTE IMMEDIATE 'BEGIN'
19029: || ' '
19030: || 'UPDATE cz_devl_projects'
19031: || cz_pb_mgr.v_db_link
19032: || ' t'
19033: || ' '
19034: || 'SET t.name = cz_pb_mgr.v_rp_name'

Line 19045: || 'UPDATE cz_devl_projects'

19041: ELSIF((l_model_upto_date_status = logic_gen_required) AND(l_ui_upto_date_status = ui_refresh_required))
19042: THEN
19043: EXECUTE IMMEDIATE 'BEGIN'
19044: || ' '
19045: || 'UPDATE cz_devl_projects'
19046: || cz_pb_mgr.v_db_link
19047: || ' t'
19048: || ' '
19049: || 'SET t.name = cz_pb_mgr.v_rp_name,'

Line 19064: || 'UPDATE cz_devl_projects'

19060: ELSIF((l_model_upto_date_status = logic_gen_required) AND(l_ui_upto_date_status = 0))
19061: THEN
19062: EXECUTE IMMEDIATE 'BEGIN'
19063: || ' '
19064: || 'UPDATE cz_devl_projects'
19065: || cz_pb_mgr.v_db_link
19066: || ' t'
19067: || ' '
19068: || 'SET t.name = cz_pb_mgr.v_rp_name,'

Line 19080: || 'UPDATE cz_devl_projects'

19076: || 'END;';
19077: ELSE
19078: EXECUTE IMMEDIATE 'BEGIN'
19079: || ' '
19080: || 'UPDATE cz_devl_projects'
19081: || cz_pb_mgr.v_db_link
19082: || ' t'
19083: || ' '
19084: || 'SET t.name = cz_pb_mgr.v_rp_name,'

Line 19100: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;

19096: COMMIT;
19097: EXCEPTION
19098: WHEN OTHERS
19099: THEN
19100: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;
19101: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
19102: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19103: END;
19104:

Line 19111: ||' cz_devl_projects p,'

19107: EXECUTE IMMEDIATE ' INSERT INTO CZ_PERSISTENT_REC_IDS'
19108: ||' (devl_project_id,MAX_PERSISTENT_REC_ID,'
19109: ||' deleted_flag) '
19110: ||' SELECT :1,m.max_persistent_rec_id,0 from '
19111: ||' cz_devl_projects p,'
19112: ||' CZ_PERSISTENT_REC_IDS m '
19113: ||' where p.devl_project_id=:2'
19114: ||' and m.devl_project_id=p.devl_project_id '
19115: ||' and p.deleted_flag=0 '

Line 19320: l_model_id cz_devl_projects.devl_project_id%TYPE;

19316: IS
19317: TYPE message_tbl_type IS TABLE OF VARCHAR2(2000)
19318: INDEX BY BINARY_INTEGER;
19319:
19320: l_model_id cz_devl_projects.devl_project_id%TYPE;
19321: l_run_id NUMBER;
19322: l_status VARCHAR2(2000);
19323: l_message_tbl message_tbl_type;
19324: l_instr NUMBER := 0;

Line 19502: FROM cz_devl_projects

19498: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
19499: THEN
19500: SELECT COUNT(*)
19501: INTO v_model_chk_count
19502: FROM cz_devl_projects
19503: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
19504:
19505: IF (v_model_chk_count = 0)
19506: THEN

Line 19503: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;

19499: THEN
19500: SELECT COUNT(*)
19501: INTO v_model_chk_count
19502: FROM cz_devl_projects
19503: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
19504:
19505: IF (v_model_chk_count = 0)
19506: THEN
19507: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL', 'PUBID', p_publication_id);

Line 19650: l_model_name cz_devl_projects.NAME%TYPE;

19646:
19647: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19648: PROCEDURE is_ui_upto_date(p_ui_def_id IN NUMBER, x_return_status OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2)
19649: IS
19650: l_model_name cz_devl_projects.NAME%TYPE;
19651: BEGIN
19652: IF p_ui_def_id IS NOT NULL
19653: THEN
19654: is_ui_upto_date(p_ui_def_id, 0, x_return_status, x_msg_data, l_model_name);

Line 19680: l_model_name cz_devl_projects.NAME%TYPE;

19676: -- directly called by developer
19677: PROCEDURE is_model_upto_date(p_model_id IN NUMBER, x_return_status IN OUT NOCOPY NUMBER, x_msg_data IN OUT NOCOPY VARCHAR2)
19678: IS
19679: l_component_id cz_model_ref_expls.component_id%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;

Line 19681: l_root_model_name cz_devl_projects.NAME%TYPE;

19677: PROCEDURE is_model_upto_date(p_model_id IN NUMBER, x_return_status IN OUT NOCOPY NUMBER, x_msg_data IN OUT NOCOPY VARCHAR2)
19678: IS
19679: l_component_id cz_model_ref_expls.component_id%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;

Line 19682: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;

19678: IS
19679: l_component_id cz_model_ref_expls.component_id%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;

Line 19683: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;

19679: l_component_id cz_model_ref_expls.component_id%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;

Line 19686: l_engine_type cz_devl_projects.config_engine_type%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
19690: SELECT DISTINCT component_id

Line 19703: FROM cz_devl_projects

19699:
19700: BEGIN
19701: SELECT last_logic_update, config_engine_type, NAME
19702: INTO l_prj_last_logic_update, l_engine_type, l_root_model_name
19703: FROM cz_devl_projects
19704: WHERE devl_project_id = p_model_id AND deleted_flag = '0';
19705: EXCEPTION
19706: WHEN NO_DATA_FOUND THEN
19707: RAISE;

Line 19737: FROM cz_devl_projects

19733: --bug6348111
19734: BEGIN
19735: SELECT last_logic_update, NAME, last_struct_update
19736: INTO l_prj_last_logic_update, l_model_name, l_prj_last_struct_update
19737: FROM cz_devl_projects
19738: WHERE cz_devl_projects.devl_project_id = l_component_id AND deleted_flag = '0';
19739: EXCEPTION
19740: WHEN OTHERS THEN
19741: l_prj_last_logic_update := NULL;

Line 19738: WHERE cz_devl_projects.devl_project_id = l_component_id AND deleted_flag = '0';

19734: BEGIN
19735: SELECT last_logic_update, NAME, last_struct_update
19736: INTO l_prj_last_logic_update, l_model_name, l_prj_last_struct_update
19737: FROM cz_devl_projects
19738: WHERE cz_devl_projects.devl_project_id = l_component_id AND deleted_flag = '0';
19739: EXCEPTION
19740: WHEN OTHERS THEN
19741: l_prj_last_logic_update := NULL;
19742: END;

Line 19893: original_name cz_devl_projects.NAME%TYPE;

19889: ----------------------------------------------------------------------------------
19890: FUNCTION migrate_name(p_devl_project_id IN NUMBER)
19891: RETURN VARCHAR2
19892: IS
19893: original_name cz_devl_projects.NAME%TYPE;
19894: v_name cz_devl_projects.NAME%TYPE;
19895: v_instance_name cz_servers.instance_name%TYPE;
19896: v_null PLS_INTEGER;
19897: l_endBr varchar2(3):=NULL;

Line 19894: v_name cz_devl_projects.NAME%TYPE;

19890: FUNCTION migrate_name(p_devl_project_id IN NUMBER)
19891: RETURN VARCHAR2
19892: IS
19893: original_name cz_devl_projects.NAME%TYPE;
19894: v_name cz_devl_projects.NAME%TYPE;
19895: v_instance_name cz_servers.instance_name%TYPE;
19896: v_null PLS_INTEGER;
19897: l_endBr varchar2(3):=NULL;
19898: BEGIN

Line 20319: FROM cz_devl_projects

20315:
20316: BEGIN
20317: SELECT desc_text, orig_sys_ref
20318: INTO v_rp_entries_desc, v_rp_orig_sys_ref
20319: FROM cz_devl_projects
20320: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
20321: EXCEPTION
20322: WHEN NO_DATA_FOUND THEN
20323: v_rp_orig_sys_ref := NULL;

Line 20320: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';

20316: BEGIN
20317: SELECT desc_text, orig_sys_ref
20318: INTO v_rp_entries_desc, v_rp_orig_sys_ref
20319: FROM cz_devl_projects
20320: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
20321: EXCEPTION
20322: WHEN NO_DATA_FOUND THEN
20323: v_rp_orig_sys_ref := NULL;
20324: cz_pb_mgr.v_err_message := 'No desc exists for devl_project_id : ' || SQLERRM;

Line 20328: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;

20324: cz_pb_mgr.v_err_message := 'No desc exists for devl_project_id : ' || SQLERRM;
20325: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
20326: WHEN OTHERS THEN
20327: v_rp_orig_sys_ref := NULL;
20328: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;
20329: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
20330: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20331: END;
20332:

Line 20396: || 'UPDATE cz_devl_projects'

20392: IF (cz_pb_mgr.v_rp_name IS NOT NULL) THEN
20393:
20394: EXECUTE IMMEDIATE 'BEGIN'
20395: || ' '
20396: || 'UPDATE cz_devl_projects'
20397: || cz_pb_mgr.v_db_link
20398: || ' t'
20399: || ' '
20400: || 'SET t.name = cz_pb_mgr.v_rp_name'

Line 20415: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;

20411:
20412: COMMIT;
20413: EXCEPTION
20414: WHEN OTHERS THEN
20415: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;
20416: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
20417: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
20418: END;
20419:

Line 23018: original_name cz_devl_projects.name%TYPE;

23014: RETURN VARCHAR2
23015:
23016: AS
23017:
23018: original_name cz_devl_projects.name%TYPE;
23019: copy_name cz_devl_projects.name%TYPE;
23020: L PLS_INTEGER := 0;
23021: x_error BOOLEAN := FALSE;
23022:

Line 23019: copy_name cz_devl_projects.name%TYPE;

23015:
23016: AS
23017:
23018: original_name cz_devl_projects.name%TYPE;
23019: copy_name cz_devl_projects.name%TYPE;
23020: L PLS_INTEGER := 0;
23021: x_error BOOLEAN := FALSE;
23022:
23023: BEGIN

Line 23095: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;

23091: l_end_date DATE;
23092: l_last_struct_update DATE;
23093: l_last_logic_update DATE;
23094: l_last_updated DATE;
23095: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
23096: v_publicationidstring VARCHAR2(2000);
23097: v_upto_date_status VARCHAR2(2000);
23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;

Line 23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;

23096: v_publicationidstring VARCHAR2(2000);
23097: v_upto_date_status VARCHAR2(2000);
23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;

Line 23101: l_organization_id cz_devl_projects.organization_id%TYPE;

23097: v_upto_date_status VARCHAR2(2000);
23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;
23105: pub_overlap EXCEPTION;

Line 23102: l_product_key cz_devl_projects.product_key%TYPE;

23098: l_ui_style cz_ui_defs.ui_style%TYPE;
23099: v_new_publication_id cz_model_publications.publication_id%TYPE;
23100: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
23101: l_organization_id cz_devl_projects.organization_id%TYPE;
23102: l_product_key cz_devl_projects.product_key%TYPE;
23103: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
23104: l_short_name cz_pb_client_apps.application_short_name%TYPE;
23105: pub_overlap EXCEPTION;
23106: no_model_id EXCEPTION;

Line 23131: FROM cz_devl_projects

23127: SELECT devl_project_id, product_key, inventory_item_id, organization_id, last_struct_update, last_logic_update, last_update_date
23128: ,persistent_project_id
23129: INTO l_model_id, l_product_key, l_inventory_item_id, l_organization_id, l_last_struct_update, l_last_logic_update, l_last_updated
23130: ,l_persistent_project_id
23131: FROM cz_devl_projects
23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries

Line 23132: WHERE cz_devl_projects.devl_project_id = p_model_id

23128: ,persistent_project_id
23129: INTO l_model_id, l_product_key, l_inventory_item_id, l_organization_id, l_last_struct_update, l_last_logic_update, l_last_updated
23130: ,l_persistent_project_id
23131: FROM cz_devl_projects
23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries
23136: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');

Line 23133: AND cz_devl_projects.deleted_flag = '0'

23129: INTO l_model_id, l_product_key, l_inventory_item_id, l_organization_id, l_last_struct_update, l_last_logic_update, l_last_updated
23130: ,l_persistent_project_id
23131: FROM cz_devl_projects
23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries
23136: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
23137: EXCEPTION

Line 23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id

23130: ,l_persistent_project_id
23131: FROM cz_devl_projects
23132: WHERE cz_devl_projects.devl_project_id = p_model_id
23133: AND cz_devl_projects.deleted_flag = '0'
23134: AND cz_devl_projects.devl_project_id IN(SELECT object_id
23135: FROM cz_rp_entries
23136: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
23137: EXCEPTION
23138: WHEN NO_DATA_FOUND