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_MODEL_REF_EXPLS

Line 307: ELSIF(p_table_name = 'cz_model_ref_expls')

303: cz_pb_mgr.v_ps_item_id_ref.DELETE;
304: cz_pb_mgr.v_ps_type_old_ref.DELETE;
305: cz_pb_mgr.v_ps_src_appl_id_old_ref.DELETE;
306: END IF;
307: ELSIF(p_table_name = 'cz_model_ref_expls')
308: THEN
309: IF (p_table_type = 'tbl')
310: THEN
311: cz_pb_mgr.v_component_id_old_tbl.DELETE;

Line 317: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;

313: cz_pb_mgr.v_child_expl_id_tbl.DELETE;
314: cz_pb_mgr.v_referring_node_id_tbl.DELETE;
315: ELSIF(p_table_type = 'ref')
316: THEN
317: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
318: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
319: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
320: cz_pb_mgr.v_component_id_old_ref.DELETE;
321: cz_pb_mgr.v_parent_expl_id_ref.DELETE;

Line 318: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;

314: cz_pb_mgr.v_referring_node_id_tbl.DELETE;
315: ELSIF(p_table_type = 'ref')
316: THEN
317: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
318: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
319: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
320: cz_pb_mgr.v_component_id_old_ref.DELETE;
321: cz_pb_mgr.v_parent_expl_id_ref.DELETE;
322: cz_pb_mgr.v_child_expl_id_ref.DELETE;

Line 319: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;

315: ELSIF(p_table_type = 'ref')
316: THEN
317: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
318: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
319: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
320: cz_pb_mgr.v_component_id_old_ref.DELETE;
321: cz_pb_mgr.v_parent_expl_id_ref.DELETE;
322: cz_pb_mgr.v_child_expl_id_ref.DELETE;
323: cz_pb_mgr.v_referring_node_id_ref.DELETE;

Line 4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');

4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
4601:
4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4607: plsql_table_list(rec_count).col_name := 'ui_def_id';
4608: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';

Line 4716: resolve_ids(cz_pb_mgr.g_page_sets_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of page sets');

4712: THEN
4713: pbdebug := 22032;
4714: ----resolve ui_def_id of page sets
4715: resolve_ids(cz_pb_mgr.g_page_sets_ui_old_ref,cz_pb_mgr.g_page_sets_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of page sets');
4716: resolve_ids(cz_pb_mgr.g_page_sets_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of page sets');
4717: plsql_table_list.DELETE;
4718: rec_count := 1;
4719: plsql_table_list(rec_count).col_name := 'ui_def_id';
4720: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_ui_ref';

Line 4853: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');

4849: ----caption ids of ui pages
4850: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4851: resolve_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui page refs');
4852: ----resolve expl id
4853: resolve_ids(cz_pb_mgr.g_page_refs_tgt_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4854: plsql_table_list.DELETE;
4855: rec_count := 1;
4856: plsql_table_list(rec_count).col_name := 'ui_def_id';
4857: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_ui_def_new_ref';

Line 4974: resolve_ids(cz_pb_mgr.g_ui_refs_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');

4970: THEN
4971: ----resolve ui_def_id
4972: resolve_ids(cz_pb_mgr.g_ui_refs_old_ui_def_ref,cz_pb_mgr.g_ui_refs_new_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui refs');
4973: ----resolve model ref expl id
4974: resolve_ids(cz_pb_mgr.g_ui_refs_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl ids of page refs');
4975: plsql_table_list.DELETE;
4976: rec_count := 1;
4977: plsql_table_list(rec_count).col_name := 'ui_def_id';
4978: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_new_ui_def_ref';

Line 5115: resolve_ids(cz_pb_mgr.g_ui_ps_maps_expl_id_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of page elements');

5111: resolve_tmpl_ui_defs(cz_pb_mgr.g_ui_ps_maps_templ_ui_tbl, cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref, 'ctrl tmp ui def ids of ui ps maps');
5112: resolve_ids(cz_pb_mgr.g_ui_ps_maps_ctrl_tmp_ref, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'ctrl template id of ui ps maps', ENTITY_TYPE_UCT);
5113: END IF;
5114:
5115: resolve_ids(cz_pb_mgr.g_ui_ps_maps_expl_id_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of page elements');
5116: resolve_ids(cz_pb_mgr.g_ui_ps_maps_elem_sig_tbl, cz_pb_mgr.v_sig_idx_ref, 'element_signature id of page elements', ENTITY_TYPE_SIGNATURE);
5117:
5118: plsql_table_list.DELETE;
5119: rec_count := 1;

Line 6447: resolve_ids(cz_pb_mgr.g_ui_actns_tgtexpl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of ui actions', FLD_IGNORE_NOW);

6443:
6444: ----resolve ui_def_id
6445: resolve_ids(cz_pb_mgr.g_ui_actns_ui_uidef_old_ref,cz_pb_mgr.g_ui_actns_ui_uidef_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui actions');
6446: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
6447: resolve_ids(cz_pb_mgr.g_ui_actns_tgtexpl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of ui actions', FLD_IGNORE_NOW);
6448: -- context_component_id, obsolete
6449: -- resolve_ids(cz_pb_mgr.g_ui_actns_ctx_comp_tbl, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'ctx comp id of ui actions');
6450: resolve_ids(cz_pb_mgr.g_ui_actns_ren_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'render condition id of ui actions');
6451:

Line 7194: delete_from_table('cz_model_ref_expls'

7190: delete_from_table('cz_ui_defs', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7191: delete_from_table('cz_ui_properties', 'ui_def_id', v_database_link, 'cz_pb_mgr.v_cz_ui_defs_new_ref', cz_pb_mgr.v_cz_ui_defs_new_ref);
7192: delete_from_table('cz_ui_nodes', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
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

Line 7197: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'

7193: delete_from_table('cz_ui_node_props', 'ui_node_id', v_database_link, 'cz_pb_mgr.v_cz_ui_nodes_new_ref', cz_pb_mgr.v_cz_ui_nodes_new_ref);
7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
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);

Line 7198: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref

7194: delete_from_table('cz_model_ref_expls'
7195: ,'model_ref_expl_id'
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'

Line 8298: v_component_id cz_model_ref_expls.component_id%TYPE;

8294: -------procedure that retrieves all source models
8295: PROCEDURE get_source_models(p_model_id IN cz_model_publications.model_id%TYPE, x_models_tbl IN OUT NOCOPY cz_pb_mgr.t_ref)
8296: AS
8297: v_count PLS_INTEGER := 0;
8298: v_component_id cz_model_ref_expls.component_id%TYPE;
8299:
8300: CURSOR models_cur(in_root_model NUMBER)
8301: IS
8302: SELECT DISTINCT component_id

Line 8303: FROM cz_model_ref_expls x

8299:
8300: CURSOR models_cur(in_root_model NUMBER)
8301: IS
8302: SELECT DISTINCT component_id
8303: FROM cz_model_ref_expls x
8304: WHERE x.model_id = in_root_model AND x.ps_node_type IN(263, 264) AND x.deleted_flag = '0';
8305: BEGIN
8306: x_models_tbl.DELETE;
8307: v_count := 0;

Line 9643: p_model_id IN cz_model_ref_expls.model_id%TYPE

9639: ----procedure that returns the max node depth for a given child model
9640: ----if max node depth is greater than 1 then we need to determine the
9641: ----parent of this child (p_model_id) is exported or not.
9642: PROCEDURE get_max_node_depth(
9643: p_model_id IN cz_model_ref_expls.model_id%TYPE
9644: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
9645: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
9646: )
9647: IS

Line 9644: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE

9640: ----if max node depth is greater than 1 then we need to determine the
9641: ----parent of this child (p_model_id) is exported or not.
9642: PROCEDURE get_max_node_depth(
9643: p_model_id IN cz_model_ref_expls.model_id%TYPE
9644: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
9645: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
9646: )
9647: IS
9648: BEGIN

Line 9645: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE

9641: ----parent of this child (p_model_id) is exported or not.
9642: PROCEDURE get_max_node_depth(
9643: p_model_id IN cz_model_ref_expls.model_id%TYPE
9644: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
9645: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
9646: )
9647: IS
9648: BEGIN
9649: SELECT MAX(node_depth)

Line 9651: FROM cz_model_ref_expls

9647: IS
9648: BEGIN
9649: SELECT MAX(node_depth)
9650: INTO x_node_depth
9651: FROM cz_model_ref_expls
9652: WHERE cz_model_ref_expls.deleted_flag = '0' AND cz_model_ref_expls.component_id = p_model_id AND cz_model_ref_expls.model_id = p_root_model_id;
9653: END get_max_node_depth;
9654:
9655: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Line 9652: WHERE cz_model_ref_expls.deleted_flag = '0' AND cz_model_ref_expls.component_id = p_model_id AND cz_model_ref_expls.model_id = p_root_model_id;

9648: BEGIN
9649: SELECT MAX(node_depth)
9650: INTO x_node_depth
9651: FROM cz_model_ref_expls
9652: WHERE cz_model_ref_expls.deleted_flag = '0' AND cz_model_ref_expls.component_id = p_model_id AND cz_model_ref_expls.model_id = p_root_model_id;
9653: END get_max_node_depth;
9654:
9655: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
9656: -------procedure that adds a parent of a child that is being exported

Line 9666: p_root_model_id IN cz_model_ref_expls.model_id%TYPE

9662: ------check if the parent is being exported, if not add it to the export array.
9663: ------The root model is not part of any of the arrays here. We check for
9664: ------child models only if greater than one level below.
9665: PROCEDURE add_parent_models(
9666: p_root_model_id IN cz_model_ref_expls.model_id%TYPE
9667: ,p_models_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
9668: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
9669: )
9670: IS

Line 9671: l_component_id cz_model_ref_expls.component_id%TYPE;

9667: ,p_models_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
9668: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
9669: )
9670: IS
9671: l_component_id cz_model_ref_expls.component_id%TYPE;
9672: l_node_depth cz_model_ref_expls.node_depth%TYPE;
9673: rec_count NUMBER := 0;
9674: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
9675: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;

Line 9672: l_node_depth cz_model_ref_expls.node_depth%TYPE;

9668: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
9669: )
9670: IS
9671: l_component_id cz_model_ref_expls.component_id%TYPE;
9672: l_node_depth cz_model_ref_expls.node_depth%TYPE;
9673: rec_count NUMBER := 0;
9674: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
9675: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;
9676: l_all_models_array cz_pb_mgr.t_ref;

Line 9678: CURSOR c_parent_models(p_component_id cz_model_ref_expls.component_id%TYPE, p_top_model_id cz_model_ref_expls.model_id%TYPE)

9674: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
9675: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;
9676: l_all_models_array cz_pb_mgr.t_ref;
9677:
9678: CURSOR c_parent_models(p_component_id cz_model_ref_expls.component_id%TYPE, p_top_model_id cz_model_ref_expls.model_id%TYPE)
9679: IS
9680: SELECT component_id
9681: FROM cz_model_ref_expls
9682: WHERE cz_model_ref_expls.deleted_flag = '0'

Line 9681: FROM cz_model_ref_expls

9677:
9678: CURSOR c_parent_models(p_component_id cz_model_ref_expls.component_id%TYPE, p_top_model_id cz_model_ref_expls.model_id%TYPE)
9679: IS
9680: SELECT component_id
9681: FROM cz_model_ref_expls
9682: WHERE cz_model_ref_expls.deleted_flag = '0'
9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)
9684: AND cz_model_ref_expls.model_ref_expl_id IN(
9685: SELECT parent_expl_node_id

Line 9682: WHERE cz_model_ref_expls.deleted_flag = '0'

9678: CURSOR c_parent_models(p_component_id cz_model_ref_expls.component_id%TYPE, p_top_model_id cz_model_ref_expls.model_id%TYPE)
9679: IS
9680: SELECT component_id
9681: FROM cz_model_ref_expls
9682: WHERE cz_model_ref_expls.deleted_flag = '0'
9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)
9684: AND cz_model_ref_expls.model_ref_expl_id IN(
9685: SELECT parent_expl_node_id
9686: FROM cz_model_ref_expls x

Line 9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)

9679: IS
9680: SELECT component_id
9681: FROM cz_model_ref_expls
9682: WHERE cz_model_ref_expls.deleted_flag = '0'
9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)
9684: AND cz_model_ref_expls.model_ref_expl_id IN(
9685: SELECT parent_expl_node_id
9686: FROM cz_model_ref_expls x
9687: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id

Line 9684: AND cz_model_ref_expls.model_ref_expl_id IN(

9680: SELECT component_id
9681: FROM cz_model_ref_expls
9682: WHERE cz_model_ref_expls.deleted_flag = '0'
9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)
9684: AND cz_model_ref_expls.model_ref_expl_id IN(
9685: SELECT parent_expl_node_id
9686: FROM cz_model_ref_expls x
9687: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id
9688: AND x.model_id = p_top_model_id);

Line 9686: FROM cz_model_ref_expls x

9682: WHERE cz_model_ref_expls.deleted_flag = '0'
9683: AND cz_model_ref_expls.ps_node_type IN(263, 264)
9684: AND cz_model_ref_expls.model_ref_expl_id IN(
9685: SELECT parent_expl_node_id
9686: FROM cz_model_ref_expls x
9687: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id
9688: AND x.model_id = p_top_model_id);
9689: BEGIN
9690: IF (p_models_not_to_be_exported.COUNT > 0)

Line 9698: FROM cz_model_ref_expls x

9694: l_all_models_array.DELETE;
9695:
9696: SELECT x.component_id
9697: BULK COLLECT INTO l_all_models_array
9698: FROM cz_model_ref_expls x
9699: WHERE x.deleted_flag = '0'
9700: AND x.model_id = p_root_model_id
9701: AND (x.ps_node_type = 263 OR x.ps_node_type = 264)
9702: AND x.node_depth = (SELECT MAX(b.node_depth)

Line 9703: FROM cz_model_ref_expls b

9699: WHERE x.deleted_flag = '0'
9700: AND x.model_id = p_root_model_id
9701: AND (x.ps_node_type = 263 OR x.ps_node_type = 264)
9702: AND x.node_depth = (SELECT MAX(b.node_depth)
9703: FROM cz_model_ref_expls b
9704: WHERE x.component_id = b.component_id AND b.model_id = p_root_model_id AND b.deleted_flag = '0')
9705: ORDER BY node_depth DESC;
9706:
9707: IF (p_models_to_be_exported.COUNT > 0)

Line 9724: ---get max node_depth from cz_model_ref_expls for the child model

9720: FOR i IN l_all_models_array.FIRST .. l_all_models_array.LAST
9721: LOOP
9722: IF (l_models_exported.EXISTS(l_all_models_array(i)))
9723: THEN
9724: ---get max node_depth from cz_model_ref_expls for the child model
9725: get_max_node_depth(l_all_models_array(i), p_root_model_id, l_node_depth);
9726:
9727: -----check if node depth > 1, we are interested only if the child model
9728: -----is at a level greater than 1 in the tree.

Line 9887: FROM cz_model_ref_expls x

9883: AS
9884: CURSOR model_cur(in_root_model NUMBER)
9885: IS
9886: SELECT DISTINCT component_id
9887: FROM cz_model_ref_expls x
9888: WHERE x.model_id = in_root_model AND x.deleted_flag = '0' AND(x.ps_node_type = 263 OR x.ps_node_type = 264);
9889:
9890: v_count PLS_INTEGER := 0;
9891: v_models model_id_table;

Line 10204: v_node_depth cz_model_ref_expls.node_depth%TYPE;

10200: ---->>>>>>>>>>>>>>>>>>>>>>>>>
10201: ---------Creates an export request for each model in the PL/SQL table cz_pb_mgr.v_models_to_be_exported
10202: PROCEDURE create_export_request(rootmodelid IN NUMBER, modelid IN NUMBER, publicationid IN NUMBER, serverid IN NUMBER)
10203: AS
10204: v_node_depth cz_model_ref_expls.node_depth%TYPE;
10205: BEGIN
10206: SELECT NVL(MAX(node_depth), 0)
10207: INTO v_node_depth
10208: FROM cz_model_ref_expls

Line 10208: FROM cz_model_ref_expls

10204: v_node_depth cz_model_ref_expls.node_depth%TYPE;
10205: BEGIN
10206: SELECT NVL(MAX(node_depth), 0)
10207: INTO v_node_depth
10208: FROM cz_model_ref_expls
10209: WHERE model_id = rootmodelid AND component_id = modelid AND deleted_flag = '0';
10210:
10211: INSERT INTO cz_pb_model_exports
10212: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq

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

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

Line 11016: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');

11012: END LOOP;
11013: END IF;
11014:
11015: --------resolve attachment expl id
11016: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
11017: --------resolve lce_header id
11018: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
11019: --------resolve required expl id
11020: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');

Line 11020: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');

11016: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
11017: --------resolve lce_header id
11018: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
11019: --------resolve required expl id
11020: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
11021: --------resolve attachment comp id
11022: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
11023: --------resolve model id
11024: resolve_ids(cz_pb_mgr.v_specs_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_lce_load_specs');

Line 11478: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;

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;
11482: v_ref_model_id cz_model_ref_expls.model_id%TYPE;

Line 11480: v_source_child_model cz_model_ref_expls.model_id%TYPE;

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;
11482: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
11483: BEGIN
11484: IF (x_status <> PUBLICATION_ERROR)

Line 11482: v_ref_model_id cz_model_ref_expls.model_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;
11482: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
11483: BEGIN
11484: IF (x_status <> PUBLICATION_ERROR)
11485: THEN
11486: IF (p_master_keys_array.COUNT > 0)

Line 11522: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id FROM cz_model_ref_expls'

11518: get_remote_model_id(cz_pb_mgr.v_server_id, v_ref_project, cz_pb_mgr.v_status_code, v_ref_remote_model);
11519:
11520: IF ((v_ref_project IS NOT NULL) AND(cz_pb_mgr.v_status_code <> PUBLICATION_ERROR))
11521: THEN
11522: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id FROM cz_model_ref_expls'
11523: || cz_pb_mgr.v_db_link
11524: || ' t'
11525: || ' '
11526: || 'WHERE t.model_id = '

Line 11542: || 'FROM cz_model_ref_expls'

11538: CLOSE child_ref_id_cv;
11539:
11540: OPEN child_ref_id_cv FOR 'SELECT model_id'
11541: || ' '
11542: || 'FROM cz_model_ref_expls'
11543: || cz_pb_mgr.v_db_link
11544: || ' t'
11545: || ' '
11546: || 'WHERE t.model_ref_expl_id = '

Line 11589: FROM cz_model_ref_expls

11585: IF cz_pb_mgr.v_session_parameter<>model_copy THEN
11586: BEGIN
11587: SELECT model_id, referring_node_id
11588: INTO v_source_child_model, v_child_ref_node
11589: FROM cz_model_ref_expls
11590: WHERE cz_model_ref_expls.model_ref_expl_id = p_resolved_key_array(i) AND cz_model_ref_expls.deleted_flag = '0';
11591: EXCEPTION
11592: WHEN OTHERS
11593: THEN

Line 11590: WHERE cz_model_ref_expls.model_ref_expl_id = p_resolved_key_array(i) AND cz_model_ref_expls.deleted_flag = '0';

11586: BEGIN
11587: SELECT model_id, referring_node_id
11588: INTO v_source_child_model, v_child_ref_node
11589: FROM cz_model_ref_expls
11590: WHERE cz_model_ref_expls.model_ref_expl_id = p_resolved_key_array(i) AND cz_model_ref_expls.deleted_flag = '0';
11591: EXCEPTION
11592: WHEN OTHERS
11593: THEN
11594: v_child_ref_node := NULL;

Line 11646: || 'FROM cz_model_ref_expls'

11642: THEN
11643: BEGIN
11644: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id'
11645: || ' '
11646: || 'FROM cz_model_ref_expls'
11647: || cz_pb_mgr.v_db_link
11648: || ' t'
11649: || ' '
11650: || 'WHERE t.model_id = '

Line 11673: || 'FROM cz_model_ref_expls'

11669: ELSE
11670: BEGIN
11671: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id'
11672: || ' '
11673: || 'FROM cz_model_ref_expls'
11674: || cz_pb_mgr.v_db_link
11675: || ' t'
11676: || ' '
11677: || 'WHERE t.model_id = '

Line 11870: FROM cz_model_ref_expls

11866:
11867: BEGIN
11868: SELECT component_id
11869: BULK COLLECT INTO v_vrt_comp_id_tbl
11870: FROM cz_model_ref_expls
11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11872: AND cz_model_ref_expls.virtual_flag = 0
11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;

Line 11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)

11867: BEGIN
11868: SELECT component_id
11869: BULK COLLECT INTO v_vrt_comp_id_tbl
11870: FROM cz_model_ref_expls
11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11872: AND cz_model_ref_expls.virtual_flag = 0
11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11875: EXCEPTION

Line 11872: AND cz_model_ref_expls.virtual_flag = 0

11868: SELECT component_id
11869: BULK COLLECT INTO v_vrt_comp_id_tbl
11870: FROM cz_model_ref_expls
11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11872: AND cz_model_ref_expls.virtual_flag = 0
11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11875: EXCEPTION
11876: WHEN NO_DATA_FOUND

Line 11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)

11869: BULK COLLECT INTO v_vrt_comp_id_tbl
11870: FROM cz_model_ref_expls
11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11872: AND cz_model_ref_expls.virtual_flag = 0
11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11875: EXCEPTION
11876: WHEN NO_DATA_FOUND
11877: THEN

Line 11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;

11870: FROM cz_model_ref_expls
11871: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11872: AND cz_model_ref_expls.virtual_flag = 0
11873: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11874: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11875: EXCEPTION
11876: WHEN NO_DATA_FOUND
11877: THEN
11878: cz_pb_mgr.v_err_message := 'No virtual components in the model : ' || TO_CHAR(p_models_not_exported(i));

Line 11968: || 'FROM cz_model_ref_expls'

11964: THEN
11965: BEGIN
11966: OPEN virt_model_id_cv FOR 'SELECT model_ref_expl_id'
11967: || ' '
11968: || 'FROM cz_model_ref_expls'
11969: || cz_pb_mgr.v_db_link
11970: || ' t'
11971: || ' '
11972: || 'WHERE t.model_id = '

Line 12001: || 'UPDATE cz_model_ref_expls'

11997: FOR z IN p_model_ref_expls_ref.FIRST .. p_model_ref_expls_ref.LAST
11998: LOOP
11999: EXECUTE IMMEDIATE 'BEGIN '
12000: || ' '
12001: || 'UPDATE cz_model_ref_expls'
12002: || cz_pb_mgr.v_db_link
12003: || ' t'
12004: || ' '
12005: || 'SET t.component_id = '

Line 12893: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)

12889: END IF;
12890:
12891: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12892:
12893: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
12894: THEN
12895: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST
12896: LOOP
12897: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);

Line 12895: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST

12891: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12892:
12893: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
12894: THEN
12895: FOR i IN cz_pb_mgr.v_cz_model_ref_expls_old_ref.FIRST .. cz_pb_mgr.v_cz_model_ref_expls_old_ref.LAST
12896: LOOP
12897: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12898: v_cz_func_devl_old_tbl.DELETE;
12899: v_cz_func_cid_old_tbl.DELETE;

Line 12915: WHERE t.model_ref_expl_id = cz_pb_mgr.v_cz_model_ref_expls_old_ref(i) AND t.deleted_flag = '0';

12911: BULK COLLECT INTO cz_pb_mgr.v_cz_func_comp_new_tbl
12912: ,cz_pb_mgr.v_cz_func_comp_old_tbl, v_cz_func_devl_old_tbl, v_cz_func_cid_old_tbl, v_cz_func_expl_old_tbl
12913: ,v_cz_func_fld_old_tbl, v_object_type_tbl
12914: FROM cz_func_comp_specs t
12915: WHERE t.model_ref_expl_id = cz_pb_mgr.v_cz_model_ref_expls_old_ref(i) AND t.deleted_flag = '0';
12916: EXCEPTION
12917: WHEN NO_DATA_FOUND
12918: THEN
12919: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

Line 12946: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_model_ref_expls_old_ref */

12942: cz_pb_mgr.v_cz_func_fld_old_ref(rec_count) := v_cz_func_fld_old_tbl(k);
12943: cz_pb_mgr.v_cz_func_obj_ref(rec_count) := v_object_type_tbl(k);
12944: END LOOP;
12945: END IF;
12946: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_model_ref_expls_old_ref */
12947: END IF; /* end if of cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0 */
12948:
12949: IF (cz_pb_mgr.g_log_timing = publication_timing)
12950: THEN

Line 12947: END IF; /* end if of cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0 */

12943: cz_pb_mgr.v_cz_func_obj_ref(rec_count) := v_object_type_tbl(k);
12944: END LOOP;
12945: END IF;
12946: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_model_ref_expls_old_ref */
12947: END IF; /* end if of cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0 */
12948:
12949: IF (cz_pb_mgr.g_log_timing = publication_timing)
12950: THEN
12951: log_timing_message('end bulk collect of func comp specs');

Line 13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);

13195: AS
13196: BEGIN
13197: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);

Line 13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);

13196: BEGIN
13197: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
13198: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
13199: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13200: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13201: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
13202: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
13203: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
13204: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);

Line 14481: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;

14477: )
14478: AS
14479: v_project_count PLS_INTEGER := 0;
14480: rec_count PLS_INTEGER := 0;
14481: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;
14482: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;
14483: plsql_table_list cz_pb_mgr.col_plsql_table_list;
14484: BEGIN
14485: pbdebug := 22037;

Line 14482: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;

14478: AS
14479: v_project_count PLS_INTEGER := 0;
14480: rec_count PLS_INTEGER := 0;
14481: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;
14482: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;
14483: plsql_table_list cz_pb_mgr.col_plsql_table_list;
14484: BEGIN
14485: pbdebug := 22037;
14486:

Line 14732: --------------Populating cz_model_ref_expls table of the target database

14728: THEN
14729: log_timing_message('end update_remote_reference_ids');
14730: END IF;
14731:
14732: --------------Populating cz_model_ref_expls table of the target database
14733: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
14734:
14735: IF (p_models_for_export.COUNT > 0)
14736: THEN

Line 14733: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);

14729: log_timing_message('end update_remote_reference_ids');
14730: END IF;
14731:
14732: --------------Populating cz_model_ref_expls table of the target database
14733: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
14734:
14735: IF (p_models_for_export.COUNT > 0)
14736: THEN
14737: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 14744: v_cz_model_ref_expls_new_tbl.DELETE;

14740: END IF;
14741:
14742: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
14743: LOOP
14744: v_cz_model_ref_expls_new_tbl.DELETE;
14745: v_cz_model_ref_expls_old_tbl.DELETE;
14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
14747:
14748: BEGIN

Line 14745: v_cz_model_ref_expls_old_tbl.DELETE;

14741:
14742: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
14743: LOOP
14744: v_cz_model_ref_expls_new_tbl.DELETE;
14745: v_cz_model_ref_expls_old_tbl.DELETE;
14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
14747:
14748: BEGIN
14749: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq

Line 14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);

14742: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
14743: LOOP
14744: v_cz_model_ref_expls_new_tbl.DELETE;
14745: v_cz_model_ref_expls_old_tbl.DELETE;
14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
14747:
14748: BEGIN
14749: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
14750: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link

Line 14749: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq

14745: v_cz_model_ref_expls_old_tbl.DELETE;
14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
14747:
14748: BEGIN
14749: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
14750: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link
14751: ,cz_pb_mgr.v_oraclesequenceincr
14752: )
14753: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id

Line 14750: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link

14746: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
14747:
14748: BEGIN
14749: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
14750: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link
14751: ,cz_pb_mgr.v_oraclesequenceincr
14752: )
14753: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
14754: ,referring_node_id, model_id

Line 14755: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl

14751: ,cz_pb_mgr.v_oraclesequenceincr
14752: )
14753: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
14754: ,referring_node_id, model_id
14755: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
14756: ,v_cz_model_ref_expls_old_tbl, cz_pb_mgr.v_component_id_old_tbl, cz_pb_mgr.v_parent_expl_id_tbl, cz_pb_mgr.v_child_expl_id_tbl
14757: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
14758: FROM cz_model_ref_expls t
14759: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';

Line 14756: ,v_cz_model_ref_expls_old_tbl, cz_pb_mgr.v_component_id_old_tbl, cz_pb_mgr.v_parent_expl_id_tbl, cz_pb_mgr.v_child_expl_id_tbl

14752: )
14753: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
14754: ,referring_node_id, model_id
14755: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
14756: ,v_cz_model_ref_expls_old_tbl, cz_pb_mgr.v_component_id_old_tbl, cz_pb_mgr.v_parent_expl_id_tbl, cz_pb_mgr.v_child_expl_id_tbl
14757: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
14758: FROM cz_model_ref_expls t
14759: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
14760: EXCEPTION

Line 14758: FROM cz_model_ref_expls t

14754: ,referring_node_id, model_id
14755: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
14756: ,v_cz_model_ref_expls_old_tbl, cz_pb_mgr.v_component_id_old_tbl, cz_pb_mgr.v_parent_expl_id_tbl, cz_pb_mgr.v_child_expl_id_tbl
14757: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
14758: FROM cz_model_ref_expls t
14759: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
14760: EXCEPTION
14761: WHEN OTHERS
14762: THEN

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

14759: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
14760: EXCEPTION
14761: WHEN OTHERS
14762: THEN
14763: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_ref_expls', 'SQLERRM', SQLERRM);
14764: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
14765: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14766: RAISE;
14767: END;

Line 14769: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;

14765: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
14766: RAISE;
14767: END;
14768:
14769: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
14770:
14771: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
14772: THEN
14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST

Line 14771: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)

14767: END;
14768:
14769: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
14770:
14771: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
14772: THEN
14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
14774: LOOP
14775: rec_count := rec_count + 1;

Line 14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST

14769: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
14770:
14771: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
14772: THEN
14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
14774: LOOP
14775: rec_count := rec_count + 1;
14776: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
14777: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);

Line 14776: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);

14772: THEN
14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
14774: LOOP
14775: rec_count := rec_count + 1;
14776: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
14777: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
14778: cz_pb_mgr.v_cz_model_ref_expls_idx_ref(v_cz_model_ref_expls_old_tbl(k)):=v_cz_model_ref_expls_new_tbl(k);
14779: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
14780: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);

Line 14777: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);

14773: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
14774: LOOP
14775: rec_count := rec_count + 1;
14776: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
14777: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
14778: cz_pb_mgr.v_cz_model_ref_expls_idx_ref(v_cz_model_ref_expls_old_tbl(k)):=v_cz_model_ref_expls_new_tbl(k);
14779: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
14780: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);
14781: cz_pb_mgr.v_child_expl_id_ref(rec_count) := cz_pb_mgr.v_child_expl_id_tbl(k);

Line 14778: cz_pb_mgr.v_cz_model_ref_expls_idx_ref(v_cz_model_ref_expls_old_tbl(k)):=v_cz_model_ref_expls_new_tbl(k);

14774: LOOP
14775: rec_count := rec_count + 1;
14776: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
14777: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
14778: cz_pb_mgr.v_cz_model_ref_expls_idx_ref(v_cz_model_ref_expls_old_tbl(k)):=v_cz_model_ref_expls_new_tbl(k);
14779: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
14780: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);
14781: cz_pb_mgr.v_child_expl_id_ref(rec_count) := cz_pb_mgr.v_child_expl_id_tbl(k);
14782: cz_pb_mgr.v_referring_node_id_ref(rec_count) := cz_pb_mgr.v_referring_node_id_tbl(k);

Line 14797: log_timing_message('start resolve_ids parent ids of cz_model_ref_expls');

14793:
14794: ------------Resolve parent expl ids of model_ref_expls
14795: IF (cz_pb_mgr.g_log_timing = publication_timing)
14796: THEN
14797: log_timing_message('start resolve_ids parent ids of cz_model_ref_expls');
14798: END IF;
14799:
14800: resolve_ids(cz_pb_mgr.v_parent_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'parent ids of cz_model_ref_expls');
14801:

Line 14800: resolve_ids(cz_pb_mgr.v_parent_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'parent ids of cz_model_ref_expls');

14796: THEN
14797: log_timing_message('start resolve_ids parent ids of cz_model_ref_expls');
14798: END IF;
14799:
14800: resolve_ids(cz_pb_mgr.v_parent_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'parent ids of cz_model_ref_expls');
14801:
14802: IF (cz_pb_mgr.g_log_timing = publication_timing)
14803: THEN
14804: log_timing_message('end resolve_ids parent ids of cz_model_ref_expls');

Line 14804: log_timing_message('end resolve_ids parent ids of cz_model_ref_expls');

14800: resolve_ids(cz_pb_mgr.v_parent_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'parent ids of cz_model_ref_expls');
14801:
14802: IF (cz_pb_mgr.g_log_timing = publication_timing)
14803: THEN
14804: log_timing_message('end resolve_ids parent ids of cz_model_ref_expls');
14805: END IF;
14806:
14807: -------------resolve model id of model_ref_expls
14808: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 14810: log_timing_message('start resolve_ids model id of cz_model_ref_expls');

14806:
14807: -------------resolve model id of model_ref_expls
14808: IF (cz_pb_mgr.g_log_timing = publication_timing)
14809: THEN
14810: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
14811: END IF;
14812:
14813: resolve_ids(cz_pb_mgr.v_ref_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_model_ref_expls');
14814:

Line 14813: resolve_ids(cz_pb_mgr.v_ref_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_model_ref_expls');

14809: THEN
14810: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
14811: END IF;
14812:
14813: resolve_ids(cz_pb_mgr.v_ref_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_model_ref_expls');
14814:
14815: IF (cz_pb_mgr.g_log_timing = publication_timing)
14816: THEN
14817: log_timing_message('end resolve_ids model id of cz_model_ref_expls');

Line 14817: log_timing_message('end resolve_ids model id of cz_model_ref_expls');

14813: resolve_ids(cz_pb_mgr.v_ref_model_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'model id of cz_model_ref_expls');
14814:
14815: IF (cz_pb_mgr.g_log_timing = publication_timing)
14816: THEN
14817: log_timing_message('end resolve_ids model id of cz_model_ref_expls');
14818: END IF;
14819:
14820: ----------resolving referring node ids of model ref expls
14821: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 14826: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

14822: THEN
14823: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.referring_node_id');
14824: END IF;
14825:
14826: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14827: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14828: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14829: ,cz_pb_mgr.v_referring_node_id_ref
14830: ,'cz_model_ref_expl.referring_node_id'

Line 14845: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

14841: THEN
14842: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.child_expl_id');
14843: END IF;
14844:
14845: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14846: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
14847: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
14848: ,cz_pb_mgr.v_child_expl_id_ref
14849: ,'cz_model_ref_expl.child_expl_id'

Line 14846: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref

14842: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.child_expl_id');
14843: END IF;
14844:
14845: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14846: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
14847: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
14848: ,cz_pb_mgr.v_child_expl_id_ref
14849: ,'cz_model_ref_expl.child_expl_id'
14850: ,cz_pb_mgr.v_status_code

Line 14847: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref

14843: END IF;
14844:
14845: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14846: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
14847: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
14848: ,cz_pb_mgr.v_child_expl_id_ref
14849: ,'cz_model_ref_expl.child_expl_id'
14850: ,cz_pb_mgr.v_status_code
14851: );

Line 14864: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

14860: THEN
14861: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.component_id');
14862: END IF;
14863:
14864: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14865: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
14866: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
14867: ,cz_pb_mgr.v_component_id_old_ref
14868: ,'cz_model_ref_expl.component_id'

Line 14894: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_model_ref_expls_new_ref';

14890: --------populate plsql_table_list for model_ref_expls
14891: plsql_table_list.DELETE;
14892: rec_count := 1;
14893: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
14894: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_model_ref_expls_new_ref';
14895: rec_count := rec_count + 1;
14896: plsql_table_list(rec_count).col_name := 'parent_expl_node_id';
14897: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_parent_expl_id_ref';
14898: rec_count := rec_count + 1;

Line 14913: log_timing_message('start insert_into_table cz_model_ref_expls');

14909: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_child_expl_id_ref';
14910:
14911: IF (cz_pb_mgr.g_log_timing = publication_timing)
14912: THEN
14913: log_timing_message('start insert_into_table cz_model_ref_expls');
14914: END IF;
14915:
14916: insert_into_table('cz_model_ref_expls'
14917: ,'model_ref_expl_id'

Line 14916: insert_into_table('cz_model_ref_expls'

14912: THEN
14913: log_timing_message('start insert_into_table cz_model_ref_expls');
14914: END IF;
14915:
14916: insert_into_table('cz_model_ref_expls'
14917: ,'model_ref_expl_id'
14918: ,cz_pb_mgr.v_db_link
14919: ,plsql_table_list
14920: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'

Line 14920: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'

14916: insert_into_table('cz_model_ref_expls'
14917: ,'model_ref_expl_id'
14918: ,cz_pb_mgr.v_db_link
14919: ,plsql_table_list
14920: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'
14921: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
14922: );
14923:
14924: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 14921: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref

14917: ,'model_ref_expl_id'
14918: ,cz_pb_mgr.v_db_link
14919: ,plsql_table_list
14920: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'
14921: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
14922: );
14923:
14924: IF (cz_pb_mgr.g_log_timing = publication_timing)
14925: THEN

Line 14926: log_timing_message('end insert_into_table cz_model_ref_expls');

14922: );
14923:
14924: IF (cz_pb_mgr.g_log_timing = publication_timing)
14925: THEN
14926: log_timing_message('end insert_into_table cz_model_ref_expls');
14927: END IF;
14928:
14929: -----------------------resolution of non virtual components
14930: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 14935: resolve_virtual_components(cz_pb_mgr.v_cz_model_ref_expls_new_ref

14931: THEN
14932: log_timing_message('start resolve_virtual_components');
14933: END IF;
14934:
14935: resolve_virtual_components(cz_pb_mgr.v_cz_model_ref_expls_new_ref
14936: ,cz_pb_mgr.v_models_not_to_be_exported
14937: ,cz_pb_mgr.v_server_id
14938: ,cz_pb_mgr.v_status_code
14939: );

Line 14959: v_cz_model_ref_expls_new_tbl.DELETE;

14955: END IF;
14956: END IF;
14957:
14958: ---------release local pl/sql tables
14959: v_cz_model_ref_expls_new_tbl.DELETE;
14960: v_cz_model_ref_expls_old_tbl.DELETE;
14961: EXCEPTION
14962: WHEN OTHERS
14963: THEN

Line 14960: v_cz_model_ref_expls_old_tbl.DELETE;

14956: END IF;
14957:
14958: ---------release local pl/sql tables
14959: v_cz_model_ref_expls_new_tbl.DELETE;
14960: v_cz_model_ref_expls_old_tbl.DELETE;
14961: EXCEPTION
14962: WHEN OTHERS
14963: THEN
14964: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);

Line 15679: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_ui nodes');

15675: log_timing_message('end resolve_ids component ids of ui nodes');
15676: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
15677: END IF;
15678:
15679: resolve_ids(cz_pb_mgr.v_cz_ui_nodes_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_ui nodes');
15680:
15681: IF (cz_pb_mgr.g_log_timing = publication_timing)
15682: THEN
15683: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');

Line 16123: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');

16119: -------------Resolve component_id of cz_rules
16120: resolve_ids(cz_pb_mgr.v_cz_rules_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component_id of cz rules', FLD_RULE_COMPONENT_ID);
16121:
16122: -------------Resolve expl id of cz_rules
16123: resolve_ids(cz_pb_mgr.v_cz_rules_expl_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl id of cz rules');
16124: resolve_ids(cz_pb_mgr.v_cz_rules_ui_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def id of cz rules');
16125: -------------populate plsql_table_list for cz rules
16126: plsql_table_list.DELETE;
16127: rec_count := 1;

Line 16795: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');

16791: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
16792: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
16793: END IF;
16794:
16795: resolve_ids(cz_pb_mgr.v_cz_func_expl_old_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of cz_func_comp_specs');
16796:
16797: IF (cz_pb_mgr.g_log_timing = publication_timing)
16798: THEN
16799: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');

Line 16992: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');

16988: resolve_ids(cz_pb_mgr.v_cz_enodes_par_sig_id_ref, cz_pb_mgr.v_sig_idx_ref, 'param sig ids cz expr nodes', ENTITY_TYPE_SIGNATURE);
16989:
16990: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16991: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
16992: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
16993: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
16994: ELSE
16995: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
16996: resolve_ids(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'ps node ids of expression nodes',FLD_IGNORE_NOW);

Line 16995: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);

16991: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.ps_node_id');
16992: mm_resolve_rule_fks(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_enodes_rule_id_ref,'cz_expression_nodes.model_ref_expl_id');
16993: resolve_ids(cz_pb_mgr.v_cz_enodes_prop_id_ref, cz_pb_mgr.mm_v_ht_sync_all_prop, 'property id of cz expr nodes', ENTITY_TYPE_PROPERTY);
16994: ELSE
16995: resolve_ids(cz_pb_mgr.v_cz_enodes_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of expression nodes',FLD_IGNORE_NOW);
16996: resolve_ids(cz_pb_mgr.v_cz_enodes_psnode_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'ps node ids of expression nodes',FLD_IGNORE_NOW);
16997: END IF;
16998:
16999: resolve_ids(cz_pb_mgr.v_cz_enodes_rule_id_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of expression nodes');

Line 17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');

17095: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
17096:
17097: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17098: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
17100: ELSE
17101: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
17102: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
17103: END IF;

Line 17102: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);

17098: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.feature_id');
17099: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_feature_rid_new_ref,'cz_des_chart_features.model_ref_expl_id');
17100: ELSE
17101: resolve_ids(cz_pb_mgr.v_cz_des_feature_id_old_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'feature id of cz_des_features',FLD_IGNORE_NOW);
17102: resolve_ids(cz_pb_mgr.v_cz_des_feature_mrefl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'model ref expl id of cz_des_features',FLD_IGNORE_NOW);
17103: END IF;
17104:
17105: resolve_ids(cz_pb_mgr.v_cz_des_feature_rid_new_ref, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'rule id of des chart features');
17106:

Line 17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');

17170:
17171: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
17172: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feature_id');
17173: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_opt_id');
17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
17175: ELSE
17176: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
17177: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
17178: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);

Line 17178: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);

17174: mm_resolve_rule_fks(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,cz_pb_mgr.v_cz_des_cells_rule_id_old_ref,'cz_des_chart_cells.secondary_feat_expl_id');
17175: ELSE
17176: resolve_ids(cz_pb_mgr.v_cz_des_cells_sf_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary feature id of cz_des_cells',FLD_IGNORE_NOW);
17177: resolve_ids(cz_pb_mgr.v_cz_des_cells_sopt_id_ref,cz_pb_mgr.v_cz_ps_nodes_idx_tbl,'secondary opt id of cz_des_cells',FLD_IGNORE_NOW);
17178: resolve_ids(cz_pb_mgr.v_cz_des_cells_sexpl_id_ref,cz_pb_mgr.v_cz_model_ref_expls_idx_ref,'secondary feat expl id of cz_des_cells',FLD_IGNORE_NOW);
17179: END IF;
17180:
17181: ------insert new records into cz_des_chart_cells
17182: insert_des_chart_cells(cz_pb_mgr.v_status_code);

Line 18791: (SELECT component_id FROM cz_model_ref_expls

18787: ELSE
18788: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
18789: FROM cz_ui_defs
18790: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
18791: (SELECT component_id FROM cz_model_ref_expls
18792: WHERE deleted_flag='0' AND model_id=p_model_id);
18793: END IF;
18794:
18795: IF l_ui_tbl.COUNT>0 THEN

Line 19679: l_component_id cz_model_ref_expls.component_id%TYPE;

19675: -- return status: 0 yes, 1 no
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;

Line 19691: FROM cz_model_ref_expls

19687: l_is_solver_model BOOLEAN;
19688:
19689: CURSOR model_cur(in_root_model NUMBER) IS
19690: SELECT DISTINCT component_id
19691: FROM cz_model_ref_expls
19692: WHERE deleted_flag = '0' AND model_id = in_root_model AND ps_node_type = 263;
19693: BEGIN
19694: fnd_msg_pub.initialize;
19695:

Line 19804: (SELECT component_id FROM cz_model_ref_expls

19800: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
19801: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19802: FROM cz_ui_defs
19803: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
19804: (SELECT component_id FROM cz_model_ref_expls
19805: WHERE deleted_flag='0' AND model_id=modelid);
19806: ELSE
19807: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19808: FROM cz_ui_defs

Line 19810: (SELECT component_id FROM cz_model_ref_expls

19806: ELSE
19807: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
19808: FROM cz_ui_defs
19809: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
19810: (SELECT component_id FROM cz_model_ref_expls
19811: WHERE deleted_flag='0' AND model_id=modelid);
19812: END IF;
19813:
19814: IF l_uidef_tbl.COUNT > 0 THEN