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 258: ELSIF(p_table_name = 'cz_model_ref_expls')

254: cz_pb_mgr.v_cz_ps_nodes_comp_ref.DELETE;
255: cz_pb_mgr.v_ps_item_id_ref.DELETE;
256: cz_pb_mgr.v_ps_type_old_ref.DELETE;
257: END IF;
258: ELSIF(p_table_name = 'cz_model_ref_expls')
259: THEN
260: IF (p_table_type = 'tbl')
261: THEN
262: cz_pb_mgr.v_component_id_old_tbl.DELETE;

Line 268: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;

264: cz_pb_mgr.v_child_expl_id_tbl.DELETE;
265: cz_pb_mgr.v_referring_node_id_tbl.DELETE;
266: ELSIF(p_table_type = 'ref')
267: THEN
268: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
269: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
270: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
271: cz_pb_mgr.v_component_id_old_ref.DELETE;
272: cz_pb_mgr.v_parent_expl_id_ref.DELETE;

Line 269: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;

265: cz_pb_mgr.v_referring_node_id_tbl.DELETE;
266: ELSIF(p_table_type = 'ref')
267: THEN
268: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
269: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
270: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
271: cz_pb_mgr.v_component_id_old_ref.DELETE;
272: cz_pb_mgr.v_parent_expl_id_ref.DELETE;
273: cz_pb_mgr.v_child_expl_id_ref.DELETE;

Line 270: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;

266: ELSIF(p_table_type = 'ref')
267: THEN
268: cz_pb_mgr.v_cz_model_ref_expls_idx_ref.DELETE;
269: cz_pb_mgr.v_cz_model_ref_expls_old_ref.DELETE;
270: cz_pb_mgr.v_cz_model_ref_expls_new_ref.DELETE;
271: cz_pb_mgr.v_component_id_old_ref.DELETE;
272: cz_pb_mgr.v_parent_expl_id_ref.DELETE;
273: cz_pb_mgr.v_child_expl_id_ref.DELETE;
274: cz_pb_mgr.v_referring_node_id_ref.DELETE;

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

3942: 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');
3943:
3944: 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');
3945: 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');
3946: 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');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3949: plsql_table_list(rec_count).col_name := 'ui_def_id';
3950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';

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

4054: THEN
4055: pbdebug := 22032;
4056: ----resolve ui_def_id of page sets
4057: 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');
4058: 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');
4059: plsql_table_list.DELETE;
4060: rec_count := 1;
4061: plsql_table_list(rec_count).col_name := 'ui_def_id';
4062: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_sets_ui_ref';

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

4188: ----caption ids of ui pages
4189: -----insert_intl_texts(cz_pb_mgr.g_page_refs_capt_id_ref,'caption ids of cz ui page refs');
4190: 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');
4191: ----resolve expl id
4192: 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');
4193: plsql_table_list.DELETE;
4194: rec_count := 1;
4195: plsql_table_list(rec_count).col_name := 'ui_def_id';
4196: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_page_refs_ui_def_new_ref';

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

4309: THEN
4310: ----resolve ui_def_id
4311: 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');
4312: ----resolve model ref expl id
4313: 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');
4314: plsql_table_list.DELETE;
4315: rec_count := 1;
4316: plsql_table_list(rec_count).col_name := 'ui_def_id';
4317: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_ui_refs_new_ui_def_ref';

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

4450: 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');
4451: 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);
4452: END IF;
4453:
4454: 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');
4455: 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);
4456:
4457: plsql_table_list.DELETE;
4458: rec_count := 1;

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

5689:
5690: ----resolve ui_def_id
5691: 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');
5692: -- ignore expl id resolution failure because of a ui refresh issue (see 6817586)
5693: 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);
5694: -- context_component_id, obsolete
5695: -- 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');
5696: 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');
5697:

Line 6482: delete_from_table('cz_model_ref_expls'

6478: 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);
6479: 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);
6480: 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);
6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6484: ,v_database_link
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref

Line 6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'

6481: 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);
6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6484: ,v_database_link
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
6487: );
6488: delete_from_table('cz_lce_headers', 'lce_header_id', v_database_link, 'cz_pb_mgr.v_cz_lce_headers_new_ref', cz_pb_mgr.v_cz_lce_headers_new_ref);
6489: delete_from_table('cz_rules', 'rule_id', v_database_link, 'cz_pb_mgr.v_cz_rules_rule_id_new_ref', cz_pb_mgr.v_cz_rules_rule_id_new_ref);

Line 6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref

6482: delete_from_table('cz_model_ref_expls'
6483: ,'model_ref_expl_id'
6484: ,v_database_link
6485: ,'cz_pb_mgr.v_cz_model_ref_expls_new_ref'
6486: ,cz_pb_mgr.v_cz_model_ref_expls_new_ref
6487: );
6488: delete_from_table('cz_lce_headers', 'lce_header_id', v_database_link, 'cz_pb_mgr.v_cz_lce_headers_new_ref', cz_pb_mgr.v_cz_lce_headers_new_ref);
6489: delete_from_table('cz_rules', 'rule_id', v_database_link, 'cz_pb_mgr.v_cz_rules_rule_id_new_ref', cz_pb_mgr.v_cz_rules_rule_id_new_ref);
6490: delete_from_table('cz_des_chart_features'

Line 7575: v_component_id cz_model_ref_expls.component_id%TYPE;

7571: -------procedure that retrieves all source models
7572: 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)
7573: AS
7574: v_count PLS_INTEGER := 0;
7575: v_component_id cz_model_ref_expls.component_id%TYPE;
7576:
7577: CURSOR models_cur(in_root_model NUMBER)
7578: IS
7579: SELECT DISTINCT component_id

Line 7580: FROM cz_model_ref_expls x

7576:
7577: CURSOR models_cur(in_root_model NUMBER)
7578: IS
7579: SELECT DISTINCT component_id
7580: FROM cz_model_ref_expls x
7581: WHERE x.model_id = in_root_model AND x.ps_node_type IN(263, 264) AND x.deleted_flag = '0';
7582: BEGIN
7583: x_models_tbl.DELETE;
7584: v_count := 0;

Line 8887: p_model_id IN cz_model_ref_expls.model_id%TYPE

8883: ----procedure that returns the max node depth for a given child model
8884: ----if max node depth is greater than 1 then we need to determine the
8885: ----parent of this child (p_model_id) is exported or not.
8886: PROCEDURE get_max_node_depth(
8887: p_model_id IN cz_model_ref_expls.model_id%TYPE
8888: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
8889: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
8890: )
8891: IS

Line 8888: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE

8884: ----if max node depth is greater than 1 then we need to determine the
8885: ----parent of this child (p_model_id) is exported or not.
8886: PROCEDURE get_max_node_depth(
8887: p_model_id IN cz_model_ref_expls.model_id%TYPE
8888: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
8889: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
8890: )
8891: IS
8892: BEGIN

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

8885: ----parent of this child (p_model_id) is exported or not.
8886: PROCEDURE get_max_node_depth(
8887: p_model_id IN cz_model_ref_expls.model_id%TYPE
8888: ,p_root_model_id IN cz_model_ref_expls.model_id%TYPE
8889: ,x_node_depth OUT NOCOPY cz_model_ref_expls.node_depth%TYPE
8890: )
8891: IS
8892: BEGIN
8893: SELECT MAX(node_depth)

Line 8895: FROM cz_model_ref_expls

8891: IS
8892: BEGIN
8893: SELECT MAX(node_depth)
8894: INTO x_node_depth
8895: FROM cz_model_ref_expls
8896: 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;
8897: END get_max_node_depth;
8898:
8899: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

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

8892: BEGIN
8893: SELECT MAX(node_depth)
8894: INTO x_node_depth
8895: FROM cz_model_ref_expls
8896: 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;
8897: END get_max_node_depth;
8898:
8899: -------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
8900: -------procedure that adds a parent of a child that is being exported

Line 8910: p_root_model_id IN cz_model_ref_expls.model_id%TYPE

8906: ------check if the parent is being exported, if not add it to the export array.
8907: ------The root model is not part of any of the arrays here. We check for
8908: ------child models only if greater than one level below.
8909: PROCEDURE add_parent_models(
8910: p_root_model_id IN cz_model_ref_expls.model_id%TYPE
8911: ,p_models_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
8912: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
8913: )
8914: IS

Line 8915: l_component_id cz_model_ref_expls.component_id%TYPE;

8911: ,p_models_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
8912: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
8913: )
8914: IS
8915: l_component_id cz_model_ref_expls.component_id%TYPE;
8916: l_node_depth cz_model_ref_expls.node_depth%TYPE;
8917: rec_count NUMBER := 0;
8918: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
8919: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;

Line 8916: l_node_depth cz_model_ref_expls.node_depth%TYPE;

8912: ,p_models_not_to_be_exported IN OUT NOCOPY cz_pb_mgr.t_ref
8913: )
8914: IS
8915: l_component_id cz_model_ref_expls.component_id%TYPE;
8916: l_node_depth cz_model_ref_expls.node_depth%TYPE;
8917: rec_count NUMBER := 0;
8918: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
8919: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;
8920: l_all_models_array cz_pb_mgr.t_ref;

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

8918: l_models_exported cz_pb_mgr.t_ref_idx_vc2;
8919: l_models_not_exported cz_pb_mgr.t_ref_idx_vc2;
8920: l_all_models_array cz_pb_mgr.t_ref;
8921:
8922: 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)
8923: IS
8924: SELECT component_id
8925: FROM cz_model_ref_expls
8926: WHERE cz_model_ref_expls.deleted_flag = '0'

Line 8925: FROM cz_model_ref_expls

8921:
8922: 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)
8923: IS
8924: SELECT component_id
8925: FROM cz_model_ref_expls
8926: WHERE cz_model_ref_expls.deleted_flag = '0'
8927: AND cz_model_ref_expls.ps_node_type IN(263, 264)
8928: AND cz_model_ref_expls.model_ref_expl_id IN(
8929: SELECT parent_expl_node_id

Line 8926: WHERE cz_model_ref_expls.deleted_flag = '0'

8922: 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)
8923: IS
8924: SELECT component_id
8925: FROM cz_model_ref_expls
8926: WHERE cz_model_ref_expls.deleted_flag = '0'
8927: AND cz_model_ref_expls.ps_node_type IN(263, 264)
8928: AND cz_model_ref_expls.model_ref_expl_id IN(
8929: SELECT parent_expl_node_id
8930: FROM cz_model_ref_expls x

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

8923: IS
8924: SELECT component_id
8925: FROM cz_model_ref_expls
8926: WHERE cz_model_ref_expls.deleted_flag = '0'
8927: AND cz_model_ref_expls.ps_node_type IN(263, 264)
8928: AND cz_model_ref_expls.model_ref_expl_id IN(
8929: SELECT parent_expl_node_id
8930: FROM cz_model_ref_expls x
8931: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id

Line 8928: AND cz_model_ref_expls.model_ref_expl_id IN(

8924: SELECT component_id
8925: FROM cz_model_ref_expls
8926: WHERE cz_model_ref_expls.deleted_flag = '0'
8927: AND cz_model_ref_expls.ps_node_type IN(263, 264)
8928: AND cz_model_ref_expls.model_ref_expl_id IN(
8929: SELECT parent_expl_node_id
8930: FROM cz_model_ref_expls x
8931: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id
8932: AND x.model_id = p_top_model_id);

Line 8930: FROM cz_model_ref_expls x

8926: WHERE cz_model_ref_expls.deleted_flag = '0'
8927: AND cz_model_ref_expls.ps_node_type IN(263, 264)
8928: AND cz_model_ref_expls.model_ref_expl_id IN(
8929: SELECT parent_expl_node_id
8930: FROM cz_model_ref_expls x
8931: WHERE x.deleted_flag = '0' AND x.component_id = p_component_id
8932: AND x.model_id = p_top_model_id);
8933: BEGIN
8934: IF (p_models_not_to_be_exported.COUNT > 0)

Line 8942: FROM cz_model_ref_expls x

8938: l_all_models_array.DELETE;
8939:
8940: SELECT x.component_id
8941: BULK COLLECT INTO l_all_models_array
8942: FROM cz_model_ref_expls x
8943: WHERE x.deleted_flag = '0'
8944: AND x.model_id = p_root_model_id
8945: AND (x.ps_node_type = 263 OR x.ps_node_type = 264)
8946: AND x.node_depth = (SELECT MAX(b.node_depth)

Line 8947: FROM cz_model_ref_expls b

8943: WHERE x.deleted_flag = '0'
8944: AND x.model_id = p_root_model_id
8945: AND (x.ps_node_type = 263 OR x.ps_node_type = 264)
8946: AND x.node_depth = (SELECT MAX(b.node_depth)
8947: FROM cz_model_ref_expls b
8948: WHERE x.component_id = b.component_id AND b.model_id = p_root_model_id AND b.deleted_flag = '0')
8949: ORDER BY node_depth DESC;
8950:
8951: IF (p_models_to_be_exported.COUNT > 0)

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

8964: FOR i IN l_all_models_array.FIRST .. l_all_models_array.LAST
8965: LOOP
8966: IF (l_models_exported.EXISTS(l_all_models_array(i)))
8967: THEN
8968: ---get max node_depth from cz_model_ref_expls for the child model
8969: get_max_node_depth(l_all_models_array(i), p_root_model_id, l_node_depth);
8970:
8971: -----check if node depth > 1, we are interested only if the child model
8972: -----is at a level greater than 1 in the tree.

Line 9131: FROM cz_model_ref_expls x

9127: AS
9128: CURSOR model_cur(in_root_model NUMBER)
9129: IS
9130: SELECT DISTINCT component_id
9131: FROM cz_model_ref_expls x
9132: WHERE x.model_id = in_root_model AND x.deleted_flag = '0' AND(x.ps_node_type = 263 OR x.ps_node_type = 264);
9133:
9134: v_count PLS_INTEGER := 0;
9135: v_models model_id_table;

Line 9448: v_node_depth cz_model_ref_expls.node_depth%TYPE;

9444: ---->>>>>>>>>>>>>>>>>>>>>>>>>
9445: ---------Creates an export request for each model in the PL/SQL table cz_pb_mgr.v_models_to_be_exported
9446: PROCEDURE create_export_request(rootmodelid IN NUMBER, modelid IN NUMBER, publicationid IN NUMBER, serverid IN NUMBER)
9447: AS
9448: v_node_depth cz_model_ref_expls.node_depth%TYPE;
9449: BEGIN
9450: SELECT NVL(MAX(node_depth), 0)
9451: INTO v_node_depth
9452: FROM cz_model_ref_expls

Line 9452: FROM cz_model_ref_expls

9448: v_node_depth cz_model_ref_expls.node_depth%TYPE;
9449: BEGIN
9450: SELECT NVL(MAX(node_depth), 0)
9451: INTO v_node_depth
9452: FROM cz_model_ref_expls
9453: WHERE model_id = rootmodelid AND component_id = modelid AND deleted_flag = '0';
9454:
9455: INSERT INTO cz_pb_model_exports
9456: (export_id, export_seq, model_id, root_model_id, server_id, publication_id, export_reverse_seq

Line 10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');

10183: THEN
10184: ------resolve component ids of cz lce headers
10185: resolve_ids(cz_pb_mgr.v_cz_lce_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'component ids of lce headers');
10186: -------resolve model ref expl id
10187: resolve_ids(cz_pb_mgr.v_cz_lce_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'model ref expl id of lce headers');
10188: -------resolve model ref expl id
10189: resolve_ids(cz_pb_mgr.v_cz_lce_devl_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'devl proj id of lce headers');
10190: ------------insert into cz lce headers
10191: plsql_table_list.DELETE;

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

10256: END LOOP;
10257: END IF;
10258:
10259: --------resolve attachment expl id
10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
10261: --------resolve lce_header id
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');

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

10260: resolve_ids(cz_pb_mgr.v_specs_attach_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'attachment expl id of cz_lce_load_specs');
10261: --------resolve lce_header id
10262: resolve_ids(cz_pb_mgr.v_specs_lce_header_id_ref, cz_pb_mgr.v_cz_lce_headers_idx_ref, 'lce_header_id of cz_lce_load_specs');
10263: --------resolve required expl id
10264: resolve_ids(cz_pb_mgr.v_specs_required_expl_id_ref, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'required expl id of cz_lce_load_specs');
10265: --------resolve attachment comp id
10266: resolve_ids(cz_pb_mgr.v_specs_attach_comp_id_ref, cz_pb_mgr.v_cz_ps_nodes_idx_tbl, 'attachment comp id of cz_lce_load_specs');
10267: --------resolve model id
10268: 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 10722: v_child_expl_id cz_model_ref_expls.model_ref_expl_id%TYPE;

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

Line 10724: v_source_child_model cz_model_ref_expls.model_id%TYPE;

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;
10726: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
10727: BEGIN
10728: IF (x_status <> PUBLICATION_ERROR)

Line 10726: v_ref_model_id cz_model_ref_expls.model_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;
10726: v_ref_model_id cz_model_ref_expls.model_id%TYPE;
10727: BEGIN
10728: IF (x_status <> PUBLICATION_ERROR)
10729: THEN
10730: IF (p_master_keys_array.COUNT > 0)

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

10762: get_remote_model_id(cz_pb_mgr.v_server_id, v_ref_project, cz_pb_mgr.v_status_code, v_ref_remote_model);
10763:
10764: IF ((v_ref_project IS NOT NULL) AND(cz_pb_mgr.v_status_code <> PUBLICATION_ERROR))
10765: THEN
10766: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id FROM cz_model_ref_expls'
10767: || cz_pb_mgr.v_db_link
10768: || ' t'
10769: || ' '
10770: || 'WHERE t.model_id = '

Line 10786: || 'FROM cz_model_ref_expls'

10782: CLOSE child_ref_id_cv;
10783:
10784: OPEN child_ref_id_cv FOR 'SELECT model_id'
10785: || ' '
10786: || 'FROM cz_model_ref_expls'
10787: || cz_pb_mgr.v_db_link
10788: || ' t'
10789: || ' '
10790: || 'WHERE t.model_ref_expl_id = '

Line 10833: FROM cz_model_ref_expls

10829: IF cz_pb_mgr.v_session_parameter<>model_copy THEN
10830: BEGIN
10831: SELECT model_id, referring_node_id
10832: INTO v_source_child_model, v_child_ref_node
10833: FROM cz_model_ref_expls
10834: WHERE cz_model_ref_expls.model_ref_expl_id = p_resolved_key_array(i) AND cz_model_ref_expls.deleted_flag = '0';
10835: EXCEPTION
10836: WHEN OTHERS
10837: THEN

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

10830: BEGIN
10831: SELECT model_id, referring_node_id
10832: INTO v_source_child_model, v_child_ref_node
10833: FROM cz_model_ref_expls
10834: WHERE cz_model_ref_expls.model_ref_expl_id = p_resolved_key_array(i) AND cz_model_ref_expls.deleted_flag = '0';
10835: EXCEPTION
10836: WHEN OTHERS
10837: THEN
10838: v_child_ref_node := NULL;

Line 10890: || 'FROM cz_model_ref_expls'

10886: THEN
10887: BEGIN
10888: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id'
10889: || ' '
10890: || 'FROM cz_model_ref_expls'
10891: || cz_pb_mgr.v_db_link
10892: || ' t'
10893: || ' '
10894: || 'WHERE t.model_id = '

Line 10917: || 'FROM cz_model_ref_expls'

10913: ELSE
10914: BEGIN
10915: OPEN child_ref_id_cv FOR 'SELECT model_ref_expl_id'
10916: || ' '
10917: || 'FROM cz_model_ref_expls'
10918: || cz_pb_mgr.v_db_link
10919: || ' t'
10920: || ' '
10921: || 'WHERE t.model_id = '

Line 11114: FROM cz_model_ref_expls

11110:
11111: BEGIN
11112: SELECT component_id
11113: BULK COLLECT INTO v_vrt_comp_id_tbl
11114: FROM cz_model_ref_expls
11115: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11116: AND cz_model_ref_expls.virtual_flag = 0
11117: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;

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

11111: BEGIN
11112: SELECT component_id
11113: BULK COLLECT INTO v_vrt_comp_id_tbl
11114: FROM cz_model_ref_expls
11115: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11116: AND cz_model_ref_expls.virtual_flag = 0
11117: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11119: EXCEPTION

Line 11116: AND cz_model_ref_expls.virtual_flag = 0

11112: SELECT component_id
11113: BULK COLLECT INTO v_vrt_comp_id_tbl
11114: FROM cz_model_ref_expls
11115: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11116: AND cz_model_ref_expls.virtual_flag = 0
11117: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11119: EXCEPTION
11120: WHEN NO_DATA_FOUND

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

11113: BULK COLLECT INTO v_vrt_comp_id_tbl
11114: FROM cz_model_ref_expls
11115: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11116: AND cz_model_ref_expls.virtual_flag = 0
11117: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11119: EXCEPTION
11120: WHEN NO_DATA_FOUND
11121: THEN

Line 11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;

11114: FROM cz_model_ref_expls
11115: WHERE cz_model_ref_expls.model_id = p_models_not_exported(i)
11116: AND cz_model_ref_expls.virtual_flag = 0
11117: AND (cz_model_ref_expls.ps_node_type = non_virtual_component OR cz_model_ref_expls.ps_node_type = model_connector)
11118: AND cz_model_ref_expls.deleted_flag = record_not_deleted;
11119: EXCEPTION
11120: WHEN NO_DATA_FOUND
11121: THEN
11122: cz_pb_mgr.v_err_message := 'No virtual components in the model : ' || TO_CHAR(p_models_not_exported(i));

Line 11212: || 'FROM cz_model_ref_expls'

11208: THEN
11209: BEGIN
11210: OPEN virt_model_id_cv FOR 'SELECT model_ref_expl_id'
11211: || ' '
11212: || 'FROM cz_model_ref_expls'
11213: || cz_pb_mgr.v_db_link
11214: || ' t'
11215: || ' '
11216: || 'WHERE t.model_id = '

Line 11245: || 'UPDATE cz_model_ref_expls'

11241: FOR z IN p_model_ref_expls_ref.FIRST .. p_model_ref_expls_ref.LAST
11242: LOOP
11243: EXECUTE IMMEDIATE 'BEGIN '
11244: || ' '
11245: || 'UPDATE cz_model_ref_expls'
11246: || cz_pb_mgr.v_db_link
11247: || ' t'
11248: || ' '
11249: || 'SET t.component_id = '

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

11925: END IF;
11926:
11927: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
11928:
11929: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
11930: THEN
11931: 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
11932: LOOP
11933: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);

Line 11931: 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

11927: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
11928:
11929: IF (cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0)
11930: THEN
11931: 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
11932: LOOP
11933: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
11934: v_cz_func_devl_old_tbl.DELETE;
11935: v_cz_func_cid_old_tbl.DELETE;

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

11947: BULK COLLECT INTO cz_pb_mgr.v_cz_func_comp_new_tbl
11948: ,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
11949: ,v_cz_func_fld_old_tbl, v_object_type_tbl
11950: FROM cz_func_comp_specs t
11951: WHERE t.model_ref_expl_id = cz_pb_mgr.v_cz_model_ref_expls_old_ref(i) AND t.deleted_flag = '0';
11952: EXCEPTION
11953: WHEN NO_DATA_FOUND
11954: THEN
11955: cz_pb_mgr.v_err_message := SUBSTR(SQLERRM, 1, 2000);

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

11978: cz_pb_mgr.v_cz_func_fld_old_ref(rec_count) := v_cz_func_fld_old_tbl(k);
11979: cz_pb_mgr.v_cz_func_obj_ref(rec_count) := v_object_type_tbl(k);
11980: END LOOP;
11981: END IF;
11982: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_model_ref_expls_old_ref */
11983: END IF; /* end if of cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0 */
11984:
11985: IF (cz_pb_mgr.g_log_timing = publication_timing)
11986: THEN

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

11979: cz_pb_mgr.v_cz_func_obj_ref(rec_count) := v_object_type_tbl(k);
11980: END LOOP;
11981: END IF;
11982: END LOOP; /* end loop of FOR I IN cz_pb_mgr.v_cz_model_ref_expls_old_ref */
11983: END IF; /* end if of cz_pb_mgr.v_cz_model_ref_expls_old_ref.COUNT > 0 */
11984:
11985: IF (cz_pb_mgr.g_log_timing = publication_timing)
11986: THEN
11987: log_timing_message('end bulk collect of func comp specs');

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

12203: AS
12204: BEGIN
12205: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
12207: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);

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

12204: BEGIN
12205: clear_tables('cz_ps_nodes', 'tbl', cz_pb_mgr.v_status_code);
12206: clear_tables('cz_ps_nodes', 'ref', cz_pb_mgr.v_status_code);
12207: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
12208: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
12209: clear_tables('cz_func_comp_specs', 'tbl', cz_pb_mgr.v_status_code);
12210: clear_tables('cz_func_comp_specs', 'ref', cz_pb_mgr.v_status_code);
12211: clear_tables('cz_ui_defs', 'ref', cz_pb_mgr.v_status_code);
12212: clear_tables('cz_ui_defs', 'tbl', cz_pb_mgr.v_status_code);

Line 13426: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;

13422: )
13423: AS
13424: v_project_count PLS_INTEGER := 0;
13425: rec_count PLS_INTEGER := 0;
13426: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;
13427: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;
13428: plsql_table_list cz_pb_mgr.col_plsql_table_list;
13429: BEGIN
13430: pbdebug := 22037;

Line 13427: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;

13423: AS
13424: v_project_count PLS_INTEGER := 0;
13425: rec_count PLS_INTEGER := 0;
13426: v_cz_model_ref_expls_new_tbl cz_pb_mgr.t_ref;
13427: v_cz_model_ref_expls_old_tbl cz_pb_mgr.t_ref;
13428: plsql_table_list cz_pb_mgr.col_plsql_table_list;
13429: BEGIN
13430: pbdebug := 22037;
13431:

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

13668: THEN
13669: log_timing_message('end update_remote_reference_ids');
13670: END IF;
13671:
13672: --------------Populating cz_model_ref_expls table of the target database
13673: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13674:
13675: IF (p_models_for_export.COUNT > 0)
13676: THEN

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

13669: log_timing_message('end update_remote_reference_ids');
13670: END IF;
13671:
13672: --------------Populating cz_model_ref_expls table of the target database
13673: clear_tables('cz_model_ref_expls', 'ref', cz_pb_mgr.v_status_code);
13674:
13675: IF (p_models_for_export.COUNT > 0)
13676: THEN
13677: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 13684: v_cz_model_ref_expls_new_tbl.DELETE;

13680: END IF;
13681:
13682: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
13683: LOOP
13684: v_cz_model_ref_expls_new_tbl.DELETE;
13685: v_cz_model_ref_expls_old_tbl.DELETE;
13686: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13687:
13688: BEGIN

Line 13685: v_cz_model_ref_expls_old_tbl.DELETE;

13681:
13682: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
13683: LOOP
13684: v_cz_model_ref_expls_new_tbl.DELETE;
13685: v_cz_model_ref_expls_old_tbl.DELETE;
13686: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13687:
13688: BEGIN
13689: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq

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

13682: FOR i IN p_models_for_export.FIRST .. p_models_for_export.LAST
13683: LOOP
13684: v_cz_model_ref_expls_new_tbl.DELETE;
13685: v_cz_model_ref_expls_old_tbl.DELETE;
13686: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13687:
13688: BEGIN
13689: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
13690: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link

Line 13689: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq

13685: v_cz_model_ref_expls_old_tbl.DELETE;
13686: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13687:
13688: BEGIN
13689: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
13690: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link
13691: ,cz_pb_mgr.v_oraclesequenceincr
13692: )
13693: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id

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

13686: clear_tables('cz_model_ref_expls', 'tbl', cz_pb_mgr.v_status_code);
13687:
13688: BEGIN
13689: SELECT cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_ref_expls_seq
13690: , 'cz_model_ref_expls_s.nextval' || cz_pb_mgr.v_db_link
13691: ,cz_pb_mgr.v_oraclesequenceincr
13692: )
13693: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
13694: ,referring_node_id, model_id

Line 13695: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl

13691: ,cz_pb_mgr.v_oraclesequenceincr
13692: )
13693: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
13694: ,referring_node_id, model_id
13695: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
13696: ,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
13697: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
13698: FROM cz_model_ref_expls t
13699: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';

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

13692: )
13693: ,model_ref_expl_id, component_id, parent_expl_node_id, child_model_expl_id
13694: ,referring_node_id, model_id
13695: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
13696: ,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
13697: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
13698: FROM cz_model_ref_expls t
13699: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
13700: EXCEPTION

Line 13698: FROM cz_model_ref_expls t

13694: ,referring_node_id, model_id
13695: BULK COLLECT INTO v_cz_model_ref_expls_new_tbl
13696: ,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
13697: ,cz_pb_mgr.v_referring_node_id_tbl, cz_pb_mgr.v_ref_model_id_tbl
13698: FROM cz_model_ref_expls t
13699: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
13700: EXCEPTION
13701: WHEN OTHERS
13702: THEN

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

13699: WHERE t.model_id = p_models_for_export(i) AND t.deleted_flag = '0';
13700: EXCEPTION
13701: WHEN OTHERS
13702: THEN
13703: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_ref_expls', 'SQLERRM', SQLERRM);
13704: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.MODEL', SQLCODE);
13705: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
13706: RAISE;
13707: END;

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

13705: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
13706: RAISE;
13707: END;
13708:
13709: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
13710:
13711: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
13712: THEN
13713: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST

Line 13711: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)

13707: END;
13708:
13709: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
13710:
13711: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
13712: THEN
13713: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
13714: LOOP
13715: rec_count := rec_count + 1;

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

13709: rec_count := cz_pb_mgr.v_cz_model_ref_expls_new_ref.COUNT;
13710:
13711: IF (v_cz_model_ref_expls_new_tbl.COUNT > 0)
13712: THEN
13713: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
13714: LOOP
13715: rec_count := rec_count + 1;
13716: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
13717: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);

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

13712: THEN
13713: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
13714: LOOP
13715: rec_count := rec_count + 1;
13716: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
13717: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
13718: 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);
13719: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
13720: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);

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

13713: FOR k IN v_cz_model_ref_expls_new_tbl.FIRST .. v_cz_model_ref_expls_new_tbl.LAST
13714: LOOP
13715: rec_count := rec_count + 1;
13716: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
13717: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
13718: 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);
13719: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
13720: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);
13721: cz_pb_mgr.v_child_expl_id_ref(rec_count) := cz_pb_mgr.v_child_expl_id_tbl(k);

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

13714: LOOP
13715: rec_count := rec_count + 1;
13716: cz_pb_mgr.v_cz_model_ref_expls_new_ref(rec_count) := v_cz_model_ref_expls_new_tbl(k);
13717: cz_pb_mgr.v_cz_model_ref_expls_old_ref(rec_count) := v_cz_model_ref_expls_old_tbl(k);
13718: 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);
13719: cz_pb_mgr.v_component_id_old_ref(rec_count) := cz_pb_mgr.v_component_id_old_tbl(k);
13720: cz_pb_mgr.v_parent_expl_id_ref(rec_count) := cz_pb_mgr.v_parent_expl_id_tbl(k);
13721: cz_pb_mgr.v_child_expl_id_ref(rec_count) := cz_pb_mgr.v_child_expl_id_tbl(k);
13722: cz_pb_mgr.v_referring_node_id_ref(rec_count) := cz_pb_mgr.v_referring_node_id_tbl(k);

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

13733:
13734: ------------Resolve parent expl ids of model_ref_expls
13735: IF (cz_pb_mgr.g_log_timing = publication_timing)
13736: THEN
13737: log_timing_message('start resolve_ids parent ids of cz_model_ref_expls');
13738: END IF;
13739:
13740: 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');
13741:

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

13736: THEN
13737: log_timing_message('start resolve_ids parent ids of cz_model_ref_expls');
13738: END IF;
13739:
13740: 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');
13741:
13742: IF (cz_pb_mgr.g_log_timing = publication_timing)
13743: THEN
13744: log_timing_message('end resolve_ids parent ids of cz_model_ref_expls');

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

13740: 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');
13741:
13742: IF (cz_pb_mgr.g_log_timing = publication_timing)
13743: THEN
13744: log_timing_message('end resolve_ids parent ids of cz_model_ref_expls');
13745: END IF;
13746:
13747: -------------resolve model id of model_ref_expls
13748: IF (cz_pb_mgr.g_log_timing = publication_timing)

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

13746:
13747: -------------resolve model id of model_ref_expls
13748: IF (cz_pb_mgr.g_log_timing = publication_timing)
13749: THEN
13750: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
13751: END IF;
13752:
13753: 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');
13754:

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

13749: THEN
13750: log_timing_message('start resolve_ids model id of cz_model_ref_expls');
13751: END IF;
13752:
13753: 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');
13754:
13755: IF (cz_pb_mgr.g_log_timing = publication_timing)
13756: THEN
13757: log_timing_message('end resolve_ids model id of cz_model_ref_expls');

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

13753: 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');
13754:
13755: IF (cz_pb_mgr.g_log_timing = publication_timing)
13756: THEN
13757: log_timing_message('end resolve_ids model id of cz_model_ref_expls');
13758: END IF;
13759:
13760: ----------resolving referring node ids of model ref expls
13761: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 13766: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

13762: THEN
13763: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.referring_node_id');
13764: END IF;
13765:
13766: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13767: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13768: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13769: ,cz_pb_mgr.v_referring_node_id_ref
13770: ,'cz_model_ref_expl.referring_node_id'

Line 13785: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

13781: THEN
13782: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.child_expl_id');
13783: END IF;
13784:
13785: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13786: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
13787: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
13788: ,cz_pb_mgr.v_child_expl_id_ref
13789: ,'cz_model_ref_expl.child_expl_id'

Line 13786: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref

13782: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.child_expl_id');
13783: END IF;
13784:
13785: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13786: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
13787: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
13788: ,cz_pb_mgr.v_child_expl_id_ref
13789: ,'cz_model_ref_expl.child_expl_id'
13790: ,cz_pb_mgr.v_status_code

Line 13787: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref

13783: END IF;
13784:
13785: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13786: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
13787: ,cz_pb_mgr.v_cz_model_ref_expls_idx_ref
13788: ,cz_pb_mgr.v_child_expl_id_ref
13789: ,'cz_model_ref_expl.child_expl_id'
13790: ,cz_pb_mgr.v_status_code
13791: );

Line 13804: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref

13800: THEN
13801: log_timing_message('start resolve_ref_ids_not_found cz_model_ref_expl.component_id');
13802: END IF;
13803:
13804: resolve_ref_ids_not_found(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13805: ,cz_pb_mgr.v_cz_ps_nodes_old_tbl
13806: ,cz_pb_mgr.v_cz_ps_nodes_idx_tbl
13807: ,cz_pb_mgr.v_component_id_old_ref
13808: ,'cz_model_ref_expl.component_id'

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

13830: --------populate plsql_table_list for model_ref_expls
13831: plsql_table_list.DELETE;
13832: rec_count := 1;
13833: plsql_table_list(rec_count).col_name := 'model_ref_expl_id';
13834: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_cz_model_ref_expls_new_ref';
13835: rec_count := rec_count + 1;
13836: plsql_table_list(rec_count).col_name := 'parent_expl_node_id';
13837: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_parent_expl_id_ref';
13838: rec_count := rec_count + 1;

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

13849: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.v_child_expl_id_ref';
13850:
13851: IF (cz_pb_mgr.g_log_timing = publication_timing)
13852: THEN
13853: log_timing_message('start insert_into_table cz_model_ref_expls');
13854: END IF;
13855:
13856: insert_into_table('cz_model_ref_expls'
13857: ,'model_ref_expl_id'

Line 13856: insert_into_table('cz_model_ref_expls'

13852: THEN
13853: log_timing_message('start insert_into_table cz_model_ref_expls');
13854: END IF;
13855:
13856: insert_into_table('cz_model_ref_expls'
13857: ,'model_ref_expl_id'
13858: ,cz_pb_mgr.v_db_link
13859: ,plsql_table_list
13860: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'

Line 13860: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'

13856: insert_into_table('cz_model_ref_expls'
13857: ,'model_ref_expl_id'
13858: ,cz_pb_mgr.v_db_link
13859: ,plsql_table_list
13860: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'
13861: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
13862: );
13863:
13864: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 13861: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref

13857: ,'model_ref_expl_id'
13858: ,cz_pb_mgr.v_db_link
13859: ,plsql_table_list
13860: ,'cz_pb_mgr.v_cz_model_ref_expls_old_ref'
13861: ,cz_pb_mgr.v_cz_model_ref_expls_old_ref
13862: );
13863:
13864: IF (cz_pb_mgr.g_log_timing = publication_timing)
13865: THEN

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

13862: );
13863:
13864: IF (cz_pb_mgr.g_log_timing = publication_timing)
13865: THEN
13866: log_timing_message('end insert_into_table cz_model_ref_expls');
13867: END IF;
13868:
13869: -----------------------resolution of non virtual components
13870: IF (cz_pb_mgr.g_log_timing = publication_timing)

Line 13875: resolve_virtual_components(cz_pb_mgr.v_cz_model_ref_expls_new_ref

13871: THEN
13872: log_timing_message('start resolve_virtual_components');
13873: END IF;
13874:
13875: resolve_virtual_components(cz_pb_mgr.v_cz_model_ref_expls_new_ref
13876: ,cz_pb_mgr.v_models_not_to_be_exported
13877: ,cz_pb_mgr.v_server_id
13878: ,cz_pb_mgr.v_status_code
13879: );

Line 13899: v_cz_model_ref_expls_new_tbl.DELETE;

13895: END IF;
13896: END IF;
13897:
13898: ---------release local pl/sql tables
13899: v_cz_model_ref_expls_new_tbl.DELETE;
13900: v_cz_model_ref_expls_old_tbl.DELETE;
13901: EXCEPTION
13902: WHEN OTHERS
13903: THEN

Line 13900: v_cz_model_ref_expls_old_tbl.DELETE;

13896: END IF;
13897:
13898: ---------release local pl/sql tables
13899: v_cz_model_ref_expls_new_tbl.DELETE;
13900: v_cz_model_ref_expls_old_tbl.DELETE;
13901: EXCEPTION
13902: WHEN OTHERS
13903: THEN
13904: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);

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

14615: log_timing_message('end resolve_ids component ids of ui nodes');
14616: log_timing_message('start resolve_ids model ref expl id of cz_ui nodes');
14617: END IF;
14618:
14619: 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');
14620:
14621: IF (cz_pb_mgr.g_log_timing = publication_timing)
14622: THEN
14623: log_timing_message('end resolve_ids model ref expl id of cz_ui nodes');

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

15005: -------------Resolve component_id of cz_rules
15006: 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);
15007:
15008: -------------Resolve expl id of cz_rules
15009: 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');
15010: 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');
15011: -------------populate plsql_table_list for cz rules
15012: plsql_table_list.DELETE;
15013: rec_count := 1;

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

15677: log_timing_message('end resolve_ids component id of cz_func_comp_specs');
15678: log_timing_message('start resolve_ids model ref expl id of cz_funce_comp_specs');
15679: END IF;
15680:
15681: 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');
15682:
15683: IF (cz_pb_mgr.g_log_timing = publication_timing)
15684: THEN
15685: log_timing_message('end resolve_ids model ref expl id of cz_funce_comp_specs');

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

15874: 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);
15875:
15876: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15877: 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');
15878: 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');
15879: 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);
15880: ELSE
15881: 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);
15882: 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 15881: 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);

15877: 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');
15878: 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');
15879: 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);
15880: ELSE
15881: 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);
15882: 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);
15883: END IF;
15884:
15885: 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 15985: 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');

15981: END IF; /* cz_pb_mgr.v_models_to_be_exported.COUNT > 0 */
15982:
15983: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
15984: 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');
15985: 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');
15986: ELSE
15987: 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);
15988: 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);
15989: END IF;

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

15984: 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');
15985: 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');
15986: ELSE
15987: 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);
15988: 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);
15989: END IF;
15990:
15991: 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');
15992:

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

16056:
16057: IF (cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id<>0) THEN
16058: 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');
16059: 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');
16060: 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');
16061: ELSE
16062: 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);
16063: 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);
16064: 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 16064: 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);

16060: 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');
16061: ELSE
16062: 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);
16063: 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);
16064: 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);
16065: END IF;
16066:
16067: ------insert new records into cz_des_chart_cells
16068: insert_des_chart_cells(cz_pb_mgr.v_status_code);

Line 17648: (SELECT component_id FROM cz_model_ref_expls

17644: ELSE
17645: SELECT ui_def_id, ui_style BULK COLLECT INTO l_ui_tbl, l_ui_style_tbl
17646: FROM cz_ui_defs
17647: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
17648: (SELECT component_id FROM cz_model_ref_expls
17649: WHERE deleted_flag='0' AND model_id=p_model_id);
17650: END IF;
17651:
17652: IF l_ui_tbl.COUNT>0 THEN

Line 18542: l_component_id cz_model_ref_expls.component_id%TYPE;

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

Line 18554: FROM cz_model_ref_expls

18550: l_is_solver_model BOOLEAN;
18551:
18552: CURSOR model_cur(in_root_model NUMBER) IS
18553: SELECT DISTINCT component_id
18554: FROM cz_model_ref_expls
18555: WHERE deleted_flag = '0' AND model_id = in_root_model AND ps_node_type = 263;
18556: BEGIN
18557: fnd_msg_pub.initialize;
18558:

Line 18667: (SELECT component_id FROM cz_model_ref_expls

18663: IF cz_pb_mgr.v_session_parameter=cz_model_migration_pvt.migrate_model AND cz_pb_mgr.v_server_id=0 THEN
18664: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18665: FROM cz_ui_defs
18666: WHERE deleted_flag='0' AND ui_style=g_ui_style_jrad AND devl_project_id IN
18667: (SELECT component_id FROM cz_model_ref_expls
18668: WHERE deleted_flag='0' AND model_id=modelid);
18669: ELSE
18670: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18671: FROM cz_ui_defs

Line 18673: (SELECT component_id FROM cz_model_ref_expls

18669: ELSE
18670: SELECT ui_def_id BULK COLLECT INTO l_uidef_tbl
18671: FROM cz_ui_defs
18672: WHERE deleted_flag='0' AND ui_style<>-1 AND devl_project_id IN
18673: (SELECT component_id FROM cz_model_ref_expls
18674: WHERE deleted_flag='0' AND model_id=modelid);
18675: END IF;
18676:
18677: IF l_uidef_tbl.COUNT > 0 THEN