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 50: g_engine_type cz_devl_projects.config_engine_type%TYPE;

46: RULE_TYPE_CONFIG_EXTENSION CONSTANT INTEGER := 300;
47: RULE_TYPE_POPULATOR CONSTANT INTEGER := 502;
48: RULE_TYPE_CAPTION CONSTANT INTEGER := 700;
49:
50: g_engine_type cz_devl_projects.config_engine_type%TYPE;
51:
52: --Bug #5186307 - deferred.
53: --v_item_synched_osr t_item_origsysref_tbl;
54: --v_itemtype_synched_osr t_itemtype_origsysref_tbl;

Line 2615: l_export_model_id cz_devl_projects.devl_project_id%TYPE;

2611: AS
2612: v_ui_def_count NUMBER := 0;
2613: rec_count NUMBER := 0;
2614: v_src_uis_tbl cz_pb_mgr.t_ref;
2615: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
2616: l_menu_caption_rule_tbl cz_pb_mgr.t_ref;
2617: l_page_caption_rule_tbl cz_pb_mgr.t_ref;
2618: l_from_mt_id_tbl cz_pb_mgr.t_ref;
2619: BEGIN

Line 6472: delete_from_table('cz_devl_projects'

6468: END IF;
6469:
6470: 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);
6471: 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);
6472: delete_from_table('cz_devl_projects'
6473: ,'devl_project_id'
6474: ,v_database_link
6475: ,'cz_pb_mgr.v_models_to_be_exported_new'
6476: ,cz_pb_mgr.v_models_to_be_exported_new

Line 6838: FROM cz_devl_projects

6834: FROM cz_model_publications
6835: WHERE cz_model_publications.publication_id = p_publication_id)
6836: AND z.model_last_struct_update =
6837: (SELECT last_struct_update
6838: FROM cz_devl_projects
6839: WHERE cz_devl_projects.devl_project_id =
6840: (SELECT object_id
6841: FROM cz_model_publications
6842: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))

Line 6839: WHERE cz_devl_projects.devl_project_id =

6835: WHERE cz_model_publications.publication_id = p_publication_id)
6836: AND z.model_last_struct_update =
6837: (SELECT last_struct_update
6838: FROM cz_devl_projects
6839: WHERE cz_devl_projects.devl_project_id =
6840: (SELECT object_id
6841: FROM cz_model_publications
6842: WHERE cz_model_publications.publication_id = p_publication_id AND cz_model_publications.deleted_flag = '0'))
6843: AND z.export_status IN('OK', 'PUP')

Line 6949: FROM cz_devl_projects t

6945: AS
6946: BEGIN
6947: SELECT last_struct_update
6948: INTO x_last_struct_date
6949: FROM cz_devl_projects t
6950: WHERE t.deleted_flag = record_not_deleted AND t.devl_project_id = p_model_id;
6951: EXCEPTION
6952: WHEN OTHERS
6953: THEN

Line 6971: l_export_model_id cz_devl_projects.devl_project_id%TYPE;

6967: AS
6968: v_ui_def_count NUMBER := 0;
6969: v_src_uis_tbl cz_pb_mgr.t_ref;
6970: v_cz_ui_defs_old_ref_idx_ref cz_pb_mgr.t_ref_idx_vc2;
6971: l_export_model_id cz_devl_projects.devl_project_id%TYPE;
6972: BEGIN
6973: IF (p_src_models.COUNT > 0)
6974: THEN
6975: x_ui_def_ref.DELETE;

Line 7611: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;

7607: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7608: --------procedure that checks if logic has changed since the model was last published
7609: 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)
7610: AS
7611: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
7612: v_expr_node_date cz_ui_nodes.last_update_date%TYPE;
7613: BEGIN
7614: IF (p_model_array.COUNT > 0)
7615: THEN

Line 7629: FROM cz_devl_projects

7625:
7626: BEGIN
7627: SELECT last_logic_update
7628: INTO v_last_logic_update
7629: FROM cz_devl_projects
7630: WHERE cz_devl_projects.devl_project_id = p_model_array(i) AND cz_devl_projects.deleted_flag = '0';
7631: EXCEPTION
7632: WHEN OTHERS
7633: THEN

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

7626: BEGIN
7627: SELECT last_logic_update
7628: INTO v_last_logic_update
7629: FROM cz_devl_projects
7630: WHERE cz_devl_projects.devl_project_id = p_model_array(i) AND cz_devl_projects.deleted_flag = '0';
7631: EXCEPTION
7632: WHEN OTHERS
7633: THEN
7634: v_last_logic_update := NULL;

Line 7689: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;

7685: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
7686: -------procedure checks if model structure has changed since it was last published
7687: 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)
7688: AS
7689: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
7690: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;
7691: BEGIN
7692: IF (p_model_array.COUNT > 0)
7693: THEN

Line 7690: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;

7686: -------procedure checks if model structure has changed since it was last published
7687: 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)
7688: AS
7689: v_last_logic_update cz_devl_projects.last_logic_update%TYPE;
7690: v_last_struct_date cz_devl_projects.last_struct_update%TYPE;
7691: BEGIN
7692: IF (p_model_array.COUNT > 0)
7693: THEN
7694: FOR i IN p_model_array.FIRST .. p_model_array.LAST

Line 8623: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;

8619: ------------procedure checks if the model has been changed since it was last published
8620: FUNCTION has_tobe_published(publicationid IN NUMBER)
8621: RETURN BOOLEAN
8622: IS
8623: v_last_struct_update cz_devl_projects.last_struct_update%TYPE;
8624: v_models_tbl cz_pb_mgr.t_ref;
8625: record_count PLS_INTEGER := 0;
8626: v_last_update_date cz_ui_defs.last_update_date%TYPE;
8627: v_fc_update_date cz_func_comp_specs.last_update_date%TYPE;

Line 8733: FROM cz_devl_projects

8729: LOOP
8730: BEGIN
8731: SELECT last_update_date
8732: INTO l_capt_update_date
8733: FROM cz_devl_projects
8734: WHERE devl_project_id = v_models_tbl(i);
8735: EXCEPTION
8736: WHEN OTHERS
8737: THEN

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

9062: || 'AND cz_pb_model_exports.export_id = '
9063: || ' '
9064: || '(SELECT MIN(export_id)'
9065: || ' '
9066: || 'FROM cz_pb_model_exports x, cz_devl_projects'
9067: || cz_pb_mgr.v_db_link
9068: || ' farprj'
9069: || ' '
9070: || 'WHERE x.server_id = :2'

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

9194: FROM cz_pb_model_exports
9195: WHERE model_id=v_model_id AND status=publication_ok AND server_id=0
9196: AND migration_group_id=g_migration_group_id;
9197: ELSE
9198: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_pb_model_exports x, cz_devl_projects'
9199: || cz_pb_mgr.v_db_link
9200: || ' farprj'
9201: || ' '
9202: || 'WHERE x.model_id = :1'

Line 9296: FROM cz_devl_projects x, cz_pb_model_exports y

9292:
9293: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
9294: IF cz_pb_mgr.v_server_id = 0 THEN
9295: SELECT COUNT(*) INTO v_count
9296: FROM cz_devl_projects x, cz_pb_model_exports y
9297: WHERE x.devl_project_id = y.model_id
9298: AND x.last_update_date < y.last_xfr_activity
9299: AND y.last_xfr_activity > v_expr_last_update
9300: AND y.model_id = v_model_id AND y.server_id = 0

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

9299: AND y.last_xfr_activity > v_expr_last_update
9300: AND y.model_id = v_model_id AND y.server_id = 0
9301: AND y.status = 'OK' AND y.migration_group_id = g_migration_group_id;
9302: ELSE
9303: EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM cz_devl_projects x, cz_pb_model_exports y, cz_devl_projects'
9304: || cz_pb_mgr.v_db_link
9305: || ' farprj'
9306: || ' '
9307: || 'WHERE x.devl_project_id = y.model_id'

Line 9330: FROM cz_devl_projects x, cz_pb_model_exports y

9326: END IF;
9327: ELSE
9328: SELECT COUNT(*)
9329: INTO v_count
9330: FROM cz_devl_projects x, cz_pb_model_exports y
9331: WHERE x.devl_project_id = y.model_id
9332: AND x.last_update_date < y.last_xfr_activity
9333: AND y.last_xfr_activity > v_expr_last_update
9334: AND y.model_id = v_model_id

Line 9365: || 'FROM cz_devl_projects'

9361: || cz_pb_mgr.v_db_link
9362: || ' '
9363: || '(devl_project_id, ''PRJ''), ''/'', ''.'')'
9364: || ' '
9365: || 'FROM cz_devl_projects'
9366: || cz_pb_mgr.v_db_link
9367: || ' t'
9368: || ' '
9369: || 'WHERE t.devl_project_id = :1'

Line 9723: 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)

9719: -----@p_server_id is the target_server_id
9720: -----@p_model_id is the devl_project_id of the model being published
9721: -----@cz_pb_mgr.bom_flag is the out parameter: 'Y' indicates the model is to be
9722: -----synchronized. 'N' indicates that no sync is necessary.
9723: 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)
9724: AS
9725: v_source_server NUMBER;
9726: v_bom_persistent_node_id NUMBER;
9727: v_bom_ps_node_id NUMBER;

Line 9732: v_model_name cz_devl_projects.NAME%TYPE;

9728: v_bom_err_flag VARCHAR2(1);
9729: v_bom_err_msg VARCHAR2(2000);
9730: v_verify_model_run_id NUMBER;
9731: v_bomsynch_err_flag VARCHAR2(2000);
9732: v_model_name cz_devl_projects.NAME%TYPE;
9733:
9734: TYPE verify_model_message_list IS TABLE OF cz_db_logs.MESSAGE%TYPE
9735: INDEX BY BINARY_INTEGER;
9736:

Line 9792: FROM cz_devl_projects

9788:
9789: BEGIN
9790: SELECT NAME
9791: INTO v_model_name
9792: FROM cz_devl_projects
9793: WHERE devl_project_id = cz_pb_mgr.v_root_model_id AND deleted_flag = '0';
9794: EXCEPTION
9795: WHEN OTHERS
9796: THEN

Line 10720: v_ref_project cz_devl_projects.devl_project_id%TYPE;

10716: AS
10717: ref_node_found BOOLEAN := FALSE;
10718: v_node_id NUMBER := 0.0;
10719: child_ref_id_cv ref_cursor;
10720: v_ref_project cz_devl_projects.devl_project_id%TYPE;
10721: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
10722: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
10723: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
10724: v_source_child_model cz_model_ref_expls.model_id%TYPE;

Line 10721: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;

10717: ref_node_found BOOLEAN := FALSE;
10718: v_node_id NUMBER := 0.0;
10719: child_ref_id_cv ref_cursor;
10720: v_ref_project cz_devl_projects.devl_project_id%TYPE;
10721: v_ref_remote_model cz_devl_projects.devl_project_id%TYPE;
10722: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;
10723: v_persistent_node_id cz_ps_nodes.persistent_node_id%TYPE;
10724: v_source_child_model cz_model_ref_expls.model_id%TYPE;
10725: v_child_ref_node cz_ps_nodes.ps_node_id%TYPE;

Line 11099: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;

11095: v_vir_devl_id NUMBER := 0.0;
11096: v_remote_comp_id NUMBER := 0.0;
11097: v_child_expl_id NUMBER := 0.0;
11098: v_vir_persistent_id cz_ps_nodes.persistent_node_id%TYPE;
11099: v_errored_model_id cz_devl_projects.devl_project_id%TYPE;
11100: BEGIN
11101: IF (x_status <> PUBLICATION_ERROR)
11102: THEN
11103: IF (p_models_not_exported.COUNT > 0)

Line 11305: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;

11301:
11302: v_ui_defs_tbl cz_pb_mgr.t_ref;
11303:
11304: ui_ref_id_cv REF_CURSOR;
11305: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11306: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11307: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
11308: v_name cz_ui_defs.name%TYPE;
11309: CANNOT_FIND_REMOTE_UI EXCEPTION;

Line 11306: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;

11302: v_ui_defs_tbl cz_pb_mgr.t_ref;
11303:
11304: ui_ref_id_cv REF_CURSOR;
11305: v_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11306: v_remote_devl_project_id cz_devl_projects.devl_project_id%TYPE;
11307: v_remote_ui_def_id cz_ui_defs.ui_def_id%TYPE;
11308: v_name cz_ui_defs.name%TYPE;
11309: CANNOT_FIND_REMOTE_UI EXCEPTION;
11310:

Line 11413: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;

11409: v_remote_ui_nod_ui_def_tbl cz_pb_mgr.t_ref;
11410: v_remote_pers_ui_node_tbl cz_pb_mgr.t_ref;
11411: v_remote_pers_ui_node_ref cz_pb_mgr.t_ref;
11412: ui_def_ref_id_cv ref_cursor;
11413: v_node_ref_proj_id cz_devl_projects.devl_project_id%TYPE;
11414: v_node_ref_export_id cz_pb_model_exports.export_id%TYPE;
11415: v_node_ref_remote_model cz_pb_model_exports.remote_model_id%TYPE;
11416: rec_count NUMBER;
11417:

Line 12350: FROM cz_model_publications, cz_devl_projects

12346: IF (x_status <> PUBLICATION_ERROR)
12347: THEN
12348: SELECT object_id, ui_def_id, server_id, export_status, remote_publication_id, object_type, publication_mode, NVL(config_engine_type, 'L')
12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';

Line 12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id

12349: 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
12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12356: -- AND cz_model_publications.disabled_flag = '0';
12357:

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

12350: FROM cz_model_publications, cz_devl_projects
12351: WHERE cz_model_publications.publication_id = p_publication_id
12352: AND cz_model_publications.deleted_flag = record_not_deleted
12353: AND cz_model_publications.object_id = cz_devl_projects.devl_project_id
12354: AND cz_devl_projects.deleted_flag = '0';
12355: -- Bug 5507300; 06-Sep-2006; kdande; Removed the following condition as user should be able to Republish disabled publications.
12356: -- AND cz_model_publications.disabled_flag = '0';
12357:
12358: ----if x_ui_def_id is null

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

12460: ----------@p_server_id : server_id of the publication request
12461: ----------@x_publication_id : retrieved max publication id
12462: ----------@x_status: publication status parameter
12463: PROCEDURE get_max_pub_id(
12464: p_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12465: ,p_server_id IN OUT NOCOPY cz_model_publications.server_id%TYPE
12466: ,x_publication_id IN OUT NOCOPY cz_model_publications.publication_id%TYPE
12467: ,x_status IN OUT NOCOPY VARCHAR2
12468: )

Line 12477: FROM cz_devl_projects

12473: FROM cz_model_publications t
12474: WHERE t.model_id = p_model_id
12475: AND t.server_id = p_server_id
12476: AND t.model_last_struct_update = (SELECT last_struct_update
12477: FROM cz_devl_projects
12478: WHERE cz_devl_projects.devl_project_id = p_model_id)
12479: AND t.export_status IN('PUP', 'OK')
12480: AND t.source_target_flag = g_source_flag
12481: AND t.publication_id <> cz_pb_mgr.v_publication_id

Line 12478: WHERE cz_devl_projects.devl_project_id = p_model_id)

12474: WHERE t.model_id = p_model_id
12475: AND t.server_id = p_server_id
12476: AND t.model_last_struct_update = (SELECT last_struct_update
12477: FROM cz_devl_projects
12478: WHERE cz_devl_projects.devl_project_id = p_model_id)
12479: AND t.export_status IN('PUP', 'OK')
12480: AND t.source_target_flag = g_source_flag
12481: AND t.publication_id <> cz_pb_mgr.v_publication_id
12482: AND t.deleted_flag = record_not_deleted;

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

12751: || 'WHERE t.publication_id = :3 '
12752: USING v_repub_appl_from, v_repub_appl_until, v_repub_remote_pb_id;
12753: END IF;
12754:
12755: EXECUTE IMMEDIATE 'UPDATE cz_devl_projects set checkout_user = NULL ' || ' ' || 'WHERE devl_project_id = ' || NVL(p_model_id, 0);
12756: END IF;
12757:
12758: COMMIT;
12759: EXCEPTION

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

12838: END insert_pb_parameters;
12839:
12840: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12841: PROCEDURE insert_devl_projects(
12842: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12843: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12844: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
12845: ,x_status IN OUT NOCOPY VARCHAR2
12846: )

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

12839:
12840: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12841: PROCEDURE insert_devl_projects(
12842: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12843: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12844: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
12845: ,x_status IN OUT NOCOPY VARCHAR2
12846: )
12847: AS

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

12840: ------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12841: PROCEDURE insert_devl_projects(
12842: p_new_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12843: ,p_old_model_id IN OUT NOCOPY cz_devl_projects.devl_project_id%TYPE
12844: ,p_orig_sys_ref IN OUT NOCOPY cz_devl_projects.orig_sys_ref%TYPE
12845: ,x_status IN OUT NOCOPY VARCHAR2
12846: )
12847: AS
12848: l_sql_query VARCHAR2(32000);

Line 12874: FROM cz_devl_projects

12870: ,cz_pb_mgr.l_nonbom_capt_rule_id, cz_pb_mgr.l_devl_proj_inv_id
12871: ,cz_pb_mgr.l_devl_proj_org_id
12872: ,cz_pb_mgr.l_devl_proj_product_key, cz_pb_mgr.l_bom_caption_text_id
12873: ,cz_pb_mgr.l_nonbom_caption_text_id
12874: FROM cz_devl_projects
12875: WHERE cz_devl_projects.devl_project_id = p_old_model_id;
12876:
12877: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
12878: THEN

Line 12875: WHERE cz_devl_projects.devl_project_id = p_old_model_id;

12871: ,cz_pb_mgr.l_devl_proj_org_id
12872: ,cz_pb_mgr.l_devl_proj_product_key, cz_pb_mgr.l_bom_caption_text_id
12873: ,cz_pb_mgr.l_nonbom_caption_text_id
12874: FROM cz_devl_projects
12875: WHERE cz_devl_projects.devl_project_id = p_old_model_id;
12876:
12877: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
12878: THEN
12879: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;

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

12876:
12877: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
12878: THEN
12879: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;
12880: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'bom capt text of cz_devl_projects');
12881: 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');
12882: cz_pb_mgr.l_bom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
12883: ELSE
12884: cz_pb_mgr.l_bom_caption_text_id := NULL;

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

12877: IF (cz_pb_mgr.l_bom_caption_text_id <> 0)
12878: THEN
12879: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_bom_caption_text_id;
12880: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'bom capt text of cz_devl_projects');
12881: 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');
12882: cz_pb_mgr.l_bom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
12883: ELSE
12884: cz_pb_mgr.l_bom_caption_text_id := NULL;
12885: END IF;

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

12886:
12887: IF (cz_pb_mgr.l_nonbom_caption_text_id <> 0)
12888: THEN
12889: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_nonbom_caption_text_id;
12890: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'non bom capt text of cz_devl_projects');
12891: 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');
12892: cz_pb_mgr.l_nonbom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
12893: ELSE
12894: cz_pb_mgr.l_nonbom_caption_text_id := NULL;

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

12887: IF (cz_pb_mgr.l_nonbom_caption_text_id <> 0)
12888: THEN
12889: cz_pb_mgr.l_intl_text_id_tbl(1) := cz_pb_mgr.l_nonbom_caption_text_id;
12890: insert_intl_texts(cz_pb_mgr.l_intl_text_id_tbl, 'non bom capt text of cz_devl_projects');
12891: 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');
12892: cz_pb_mgr.l_nonbom_caption_text_id := cz_pb_mgr.l_intl_text_id_tbl(1);
12893: ELSE
12894: cz_pb_mgr.l_nonbom_caption_text_id := NULL;
12895: END IF;

Line 12912: 'BEGIN INSERT INTO cz_devl_projects'

12908: cz_pb_mgr.l_nonbom_capt_rule_id := NULL;
12909: END IF;
12910:
12911: l_sql_query :=
12912: 'BEGIN INSERT INTO cz_devl_projects'
12913: || cz_pb_mgr.v_db_link
12914: || '(DEVL_PROJECT_ID'
12915: || ' '
12916: || ',NAME,VERSION,DESC_TEXT,ORIG_SYS_REF,PUBLISHED,LAST_STRUCT_UPDATE'

Line 12942: || 'FROM cz_devl_projects'

12938: || ',:5,:6,:7'
12939: || ' '
12940: || ',:8,:9,POST_MIGR_CHANGE_FLAG,config_engine_type'
12941: || ' '
12942: || 'FROM cz_devl_projects'
12943: || ' '
12944: || 'WHERE cz_devl_projects.devl_project_id = '
12945: || TO_CHAR(p_old_model_id)
12946: || '; END; ';

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

12940: || ',:8,:9,POST_MIGR_CHANGE_FLAG,config_engine_type'
12941: || ' '
12942: || 'FROM cz_devl_projects'
12943: || ' '
12944: || 'WHERE cz_devl_projects.devl_project_id = '
12945: || TO_CHAR(p_old_model_id)
12946: || '; END; ';
12947:
12948: EXECUTE IMMEDIATE l_sql_query

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

12960: COMMIT;
12961: EXCEPTION
12962: WHEN OTHERS
12963: THEN
12964: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_devl_projects', 'SQLERRM', SQLERRM);
12965: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
12966: x_status := PUBLICATION_ERROR;
12967: RAISE;
12968: END insert_devl_projects;

Line 15462: FROM cz_rules rule, cz_devl_projects prj

15458: EXCEPTION
15459: WHEN NO_DATA_FOUND THEN
15460: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
15461: FOR j IN (SELECT rule.name rulename, prj.name prjname
15462: FROM cz_rules rule, cz_devl_projects prj
15463: WHERE rule.rule_id=p_ruleid_tbl(i) AND rule.devl_project_id=prj.devl_project_id) LOOP
15464: 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);
15465: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'upload_rule_schema.mm_resolve_rule_fks', SQLCODE);
15466: END LOOP;

Line 17335: l_model_name cz_devl_projects.NAME%TYPE;

17331: l_ui_name cz_ui_defs.NAME%TYPE;
17332: l_root_model_id NUMBER;
17333: l_root_ui_last_update_date DATE;
17334: l_model_id NUMBER;
17335: l_model_name cz_devl_projects.NAME%TYPE;
17336: l_last_update_date DATE;
17337: l_last_struct_update DATE;
17338: l_suppress_refresh_flag cz_ui_defs.suppress_refresh_flag%TYPE;
17339: BEGIN

Line 17354: FROM cz_devl_projects

17350: x_msg_data := l_ui_name;
17351:
17352: IF p_report_model_info = 1 THEN
17353: SELECT NAME INTO x_model_name
17354: FROM cz_devl_projects
17355: WHERE devl_project_id = l_root_model_id;
17356: END IF;
17357:
17358: RETURN;

Line 17417: FROM cz_devl_projects

17413: x_msg_data := l_ui_name;
17414:
17415: IF p_report_model_info = 1 THEN
17416: SELECT NAME INTO x_model_name
17417: FROM cz_devl_projects
17418: WHERE devl_project_id = l_model_id;
17419: END IF;
17420:
17421: EXIT;

Line 17428: FROM cz_devl_projects

17424:
17425: BEGIN
17426: SELECT DECODE(l_ui_style, g_ui_style_jrad, NVL(ui_timestamp_struct_update, last_struct_update), last_struct_update), NAME
17427: INTO l_last_struct_update, l_model_name
17428: FROM cz_devl_projects
17429: WHERE cz_devl_projects.devl_project_id = l_model_id;
17430: EXCEPTION
17431: WHEN OTHERS THEN
17432: l_last_struct_update := NULL;

Line 17429: WHERE cz_devl_projects.devl_project_id = l_model_id;

17425: BEGIN
17426: SELECT DECODE(l_ui_style, g_ui_style_jrad, NVL(ui_timestamp_struct_update, last_struct_update), last_struct_update), NAME
17427: INTO l_last_struct_update, l_model_name
17428: FROM cz_devl_projects
17429: WHERE cz_devl_projects.devl_project_id = l_model_id;
17430: EXCEPTION
17431: WHEN OTHERS THEN
17432: l_last_struct_update := NULL;
17433: l_model_name := NULL;

Line 17608: FROM cz_devl_projects

17604:
17605: BEGIN
17606: SELECT 1, NVL(config_engine_type, 'L')
17607: INTO v_model_chk_count, g_engine_type
17608: FROM cz_devl_projects
17609: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
17610: EXCEPTION
17611: WHEN OTHERS
17612: THEN

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

17605: BEGIN
17606: SELECT 1, NVL(config_engine_type, 'L')
17607: INTO v_model_chk_count, g_engine_type
17608: FROM cz_devl_projects
17609: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_root_model_id AND cz_devl_projects.deleted_flag = '0';
17610: EXCEPTION
17611: WHEN OTHERS
17612: THEN
17613: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL');

Line 17797: FROM cz_devl_projects

17793:
17794: BEGIN
17795: SELECT desc_text, orig_sys_ref
17796: INTO v_rp_entries_desc, v_rp_orig_sys_ref
17797: FROM cz_devl_projects
17798: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
17799: EXCEPTION
17800: WHEN NO_DATA_FOUND
17801: THEN

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

17794: BEGIN
17795: SELECT desc_text, orig_sys_ref
17796: INTO v_rp_entries_desc, v_rp_orig_sys_ref
17797: FROM cz_devl_projects
17798: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
17799: EXCEPTION
17800: WHEN NO_DATA_FOUND
17801: THEN
17802: v_rp_orig_sys_ref := NULL;

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

17804: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17805: WHEN OTHERS
17806: THEN
17807: v_rp_orig_sys_ref := NULL;
17808: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;
17809: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17810: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17811: END;
17812:

Line 17887: || 'UPDATE cz_devl_projects'

17883: IF ((l_model_upto_date_status = 0) AND(l_ui_upto_date_status = 0))
17884: THEN
17885: EXECUTE IMMEDIATE 'BEGIN'
17886: || ' '
17887: || 'UPDATE cz_devl_projects'
17888: || cz_pb_mgr.v_db_link
17889: || ' t'
17890: || ' '
17891: || 'SET t.name = cz_pb_mgr.v_rp_name'

Line 17902: || 'UPDATE cz_devl_projects'

17898: ELSIF((l_model_upto_date_status = logic_gen_required) AND(l_ui_upto_date_status = ui_refresh_required))
17899: THEN
17900: EXECUTE IMMEDIATE 'BEGIN'
17901: || ' '
17902: || 'UPDATE cz_devl_projects'
17903: || cz_pb_mgr.v_db_link
17904: || ' t'
17905: || ' '
17906: || 'SET t.name = cz_pb_mgr.v_rp_name,'

Line 17921: || 'UPDATE cz_devl_projects'

17917: ELSIF((l_model_upto_date_status = logic_gen_required) AND(l_ui_upto_date_status = 0))
17918: THEN
17919: EXECUTE IMMEDIATE 'BEGIN'
17920: || ' '
17921: || 'UPDATE cz_devl_projects'
17922: || cz_pb_mgr.v_db_link
17923: || ' t'
17924: || ' '
17925: || 'SET t.name = cz_pb_mgr.v_rp_name,'

Line 17937: || 'UPDATE cz_devl_projects'

17933: || 'END;';
17934: ELSE
17935: EXECUTE IMMEDIATE 'BEGIN'
17936: || ' '
17937: || 'UPDATE cz_devl_projects'
17938: || cz_pb_mgr.v_db_link
17939: || ' t'
17940: || ' '
17941: || 'SET t.name = cz_pb_mgr.v_rp_name,'

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

17953: COMMIT;
17954: EXCEPTION
17955: WHEN OTHERS
17956: THEN
17957: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;
17958: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODELCOPY', SQLCODE);
17959: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17960: END;
17961:

Line 17968: ||' cz_devl_projects p,'

17964: EXECUTE IMMEDIATE ' INSERT INTO CZ_PERSISTENT_REC_IDS'
17965: ||' (devl_project_id,MAX_PERSISTENT_REC_ID,'
17966: ||' deleted_flag) '
17967: ||' SELECT :1,m.max_persistent_rec_id,0 from '
17968: ||' cz_devl_projects p,'
17969: ||' CZ_PERSISTENT_REC_IDS m '
17970: ||' where p.devl_project_id=:2'
17971: ||' and m.devl_project_id=p.devl_project_id '
17972: ||' and p.deleted_flag=0 '

Line 18177: l_model_id cz_devl_projects.devl_project_id%TYPE;

18173: IS
18174: TYPE message_tbl_type IS TABLE OF VARCHAR2(2000)
18175: INDEX BY BINARY_INTEGER;
18176:
18177: l_model_id cz_devl_projects.devl_project_id%TYPE;
18178: l_run_id NUMBER;
18179: l_status VARCHAR2(2000);
18180: l_message_tbl message_tbl_type;
18181: l_instr NUMBER := 0;

Line 18365: FROM cz_devl_projects

18361: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)
18362: THEN
18363: SELECT COUNT(*)
18364: INTO v_model_chk_count
18365: FROM cz_devl_projects
18366: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
18367:
18368: IF (v_model_chk_count = 0)
18369: THEN

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

18362: THEN
18363: SELECT COUNT(*)
18364: INTO v_model_chk_count
18365: FROM cz_devl_projects
18366: WHERE cz_devl_projects.devl_project_id = p_model_id AND cz_devl_projects.deleted_flag = record_not_deleted;
18367:
18368: IF (v_model_chk_count = 0)
18369: THEN
18370: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_NO_MODEL', 'PUBID', p_publication_id);

Line 18513: l_model_name cz_devl_projects.NAME%TYPE;

18509:
18510: -------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18511: PROCEDURE is_ui_upto_date(p_ui_def_id IN NUMBER, x_return_status OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2)
18512: IS
18513: l_model_name cz_devl_projects.NAME%TYPE;
18514: BEGIN
18515: IF p_ui_def_id IS NOT NULL
18516: THEN
18517: is_ui_upto_date(p_ui_def_id, 0, x_return_status, x_msg_data, l_model_name);

Line 18543: l_model_name cz_devl_projects.NAME%TYPE;

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

Line 18544: l_root_model_name cz_devl_projects.NAME%TYPE;

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

Line 18545: l_prj_last_logic_update cz_devl_projects.last_logic_update%TYPE;

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

Line 18546: l_prj_last_struct_update cz_devl_projects.last_struct_update%TYPE;

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

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

Line 18566: FROM cz_devl_projects

18562:
18563: BEGIN
18564: SELECT last_logic_update, config_engine_type, NAME
18565: INTO l_prj_last_logic_update, l_engine_type, l_root_model_name
18566: FROM cz_devl_projects
18567: WHERE devl_project_id = p_model_id AND deleted_flag = '0';
18568: EXCEPTION
18569: WHEN NO_DATA_FOUND THEN
18570: RAISE;

Line 18600: FROM cz_devl_projects

18596: --bug6348111
18597: BEGIN
18598: SELECT last_logic_update, NAME, last_struct_update
18599: INTO l_prj_last_logic_update, l_model_name, l_prj_last_struct_update
18600: FROM cz_devl_projects
18601: WHERE cz_devl_projects.devl_project_id = l_component_id AND deleted_flag = '0';
18602: EXCEPTION
18603: WHEN OTHERS THEN
18604: l_prj_last_logic_update := NULL;

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

18597: BEGIN
18598: SELECT last_logic_update, NAME, last_struct_update
18599: INTO l_prj_last_logic_update, l_model_name, l_prj_last_struct_update
18600: FROM cz_devl_projects
18601: WHERE cz_devl_projects.devl_project_id = l_component_id AND deleted_flag = '0';
18602: EXCEPTION
18603: WHEN OTHERS THEN
18604: l_prj_last_logic_update := NULL;
18605: END;

Line 18756: original_name cz_devl_projects.NAME%TYPE;

18752: ----------------------------------------------------------------------------------
18753: FUNCTION migrate_name(p_devl_project_id IN NUMBER)
18754: RETURN VARCHAR2
18755: IS
18756: original_name cz_devl_projects.NAME%TYPE;
18757: v_name cz_devl_projects.NAME%TYPE;
18758: v_instance_name cz_servers.instance_name%TYPE;
18759: v_null PLS_INTEGER;
18760: l_endBr varchar2(3):=NULL;

Line 18757: v_name cz_devl_projects.NAME%TYPE;

18753: FUNCTION migrate_name(p_devl_project_id IN NUMBER)
18754: RETURN VARCHAR2
18755: IS
18756: original_name cz_devl_projects.NAME%TYPE;
18757: v_name cz_devl_projects.NAME%TYPE;
18758: v_instance_name cz_servers.instance_name%TYPE;
18759: v_null PLS_INTEGER;
18760: l_endBr varchar2(3):=NULL;
18761: BEGIN

Line 19134: FROM cz_devl_projects

19130:
19131: BEGIN
19132: SELECT desc_text, orig_sys_ref
19133: INTO v_rp_entries_desc, v_rp_orig_sys_ref
19134: FROM cz_devl_projects
19135: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
19136: EXCEPTION
19137: WHEN NO_DATA_FOUND THEN
19138: v_rp_orig_sys_ref := NULL;

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

19131: BEGIN
19132: SELECT desc_text, orig_sys_ref
19133: INTO v_rp_entries_desc, v_rp_orig_sys_ref
19134: FROM cz_devl_projects
19135: WHERE cz_devl_projects.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) AND cz_devl_projects.deleted_flag = '0';
19136: EXCEPTION
19137: WHEN NO_DATA_FOUND THEN
19138: v_rp_orig_sys_ref := NULL;
19139: cz_pb_mgr.v_err_message := 'No desc exists for devl_project_id : ' || SQLERRM;

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

19139: cz_pb_mgr.v_err_message := 'No desc exists for devl_project_id : ' || SQLERRM;
19140: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
19141: WHEN OTHERS THEN
19142: v_rp_orig_sys_ref := NULL;
19143: cz_pb_mgr.v_err_message := 'Error in retrieving desc from cz_devl_projects for devl_project_id: ' || SQLERRM;
19144: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
19145: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19146: END;
19147:

Line 19211: || 'UPDATE cz_devl_projects'

19207: IF (cz_pb_mgr.v_rp_name IS NOT NULL) THEN
19208:
19209: EXECUTE IMMEDIATE 'BEGIN'
19210: || ' '
19211: || 'UPDATE cz_devl_projects'
19212: || cz_pb_mgr.v_db_link
19213: || ' t'
19214: || ' '
19215: || 'SET t.name = cz_pb_mgr.v_rp_name'

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

19226:
19227: COMMIT;
19228: EXCEPTION
19229: WHEN OTHERS THEN
19230: cz_pb_mgr.v_err_message := 'Error in updating cz_devl_projects with the new project name: ' || SQLERRM;
19231: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MIGRATEMODEL', SQLCODE);
19232: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
19233: END;
19234:

Line 21809: original_name cz_devl_projects.name%TYPE;

21805: RETURN VARCHAR2
21806:
21807: AS
21808:
21809: original_name cz_devl_projects.name%TYPE;
21810: copy_name cz_devl_projects.name%TYPE;
21811: L PLS_INTEGER := 0;
21812: x_error BOOLEAN := FALSE;
21813:

Line 21810: copy_name cz_devl_projects.name%TYPE;

21806:
21807: AS
21808:
21809: original_name cz_devl_projects.name%TYPE;
21810: copy_name cz_devl_projects.name%TYPE;
21811: L PLS_INTEGER := 0;
21812: x_error BOOLEAN := FALSE;
21813:
21814: BEGIN

Line 21886: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;

21882: l_end_date DATE;
21883: l_last_struct_update DATE;
21884: l_last_logic_update DATE;
21885: l_last_updated DATE;
21886: l_persistent_project_id cz_devl_projects.persistent_project_id%TYPE;
21887: v_publicationidstring VARCHAR2(2000);
21888: v_upto_date_status VARCHAR2(2000);
21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;

Line 21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;

21887: v_publicationidstring VARCHAR2(2000);
21888: v_upto_date_status VARCHAR2(2000);
21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21894: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21895: l_short_name cz_pb_client_apps.application_short_name%TYPE;

Line 21892: l_organization_id cz_devl_projects.organization_id%TYPE;

21888: v_upto_date_status VARCHAR2(2000);
21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21894: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21895: l_short_name cz_pb_client_apps.application_short_name%TYPE;
21896: pub_overlap EXCEPTION;

Line 21893: l_product_key cz_devl_projects.product_key%TYPE;

21889: l_ui_style cz_ui_defs.ui_style%TYPE;
21890: v_new_publication_id cz_model_publications.publication_id%TYPE;
21891: l_inventory_item_id cz_devl_projects.inventory_item_id%TYPE;
21892: l_organization_id cz_devl_projects.organization_id%TYPE;
21893: l_product_key cz_devl_projects.product_key%TYPE;
21894: l_ui_def_id cz_ui_defs.ui_def_id%TYPE;
21895: l_short_name cz_pb_client_apps.application_short_name%TYPE;
21896: pub_overlap EXCEPTION;
21897: no_model_id EXCEPTION;

Line 21922: FROM cz_devl_projects

21918: SELECT devl_project_id, product_key, inventory_item_id, organization_id, last_struct_update, last_logic_update, last_update_date
21919: ,persistent_project_id
21920: 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
21921: ,l_persistent_project_id
21922: FROM cz_devl_projects
21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries

Line 21923: WHERE cz_devl_projects.devl_project_id = p_model_id

21919: ,persistent_project_id
21920: 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
21921: ,l_persistent_project_id
21922: FROM cz_devl_projects
21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries
21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');

Line 21924: AND cz_devl_projects.deleted_flag = '0'

21920: 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
21921: ,l_persistent_project_id
21922: FROM cz_devl_projects
21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries
21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
21928: EXCEPTION

Line 21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id

21921: ,l_persistent_project_id
21922: FROM cz_devl_projects
21923: WHERE cz_devl_projects.devl_project_id = p_model_id
21924: AND cz_devl_projects.deleted_flag = '0'
21925: AND cz_devl_projects.devl_project_id IN(SELECT object_id
21926: FROM cz_rp_entries
21927: WHERE cz_rp_entries.object_type = 'PRJ' AND cz_rp_entries.deleted_flag = '0');
21928: EXCEPTION
21929: WHEN NO_DATA_FOUND