APPS.CZ_MODEL_UTIL_PVT dependencies on CZ_MODEL_REF_EXPLS

Line 235: , CZ_MODEL_REF_EXPLS ROOTEXPL

231: 99),
232: 999
233: ) as NEAR_ROOT_MARKER
234: FROM CZ_EXPLMODEL_NODES_V XPLNODE
235: , CZ_MODEL_REF_EXPLS ROOTEXPL
236: WHERE XPLNODE.model_id = p_model_to_search
237: AND ROOTEXPL.MODEL_ID = P_MODEL_TO_SEARCH
238: AND ROOTEXPL.parent_expl_node_id IS NULL
239: AND ROOTEXPL.DELETED_FLAG = '0'

Line 445: cz_model_ref_expls xpl,

441: xpl.model_ref_expl_id as leaf_expl_node_id,
442: rootn.persistent_node_id as leaf_persistent_node_id
443: from
444: cz_ui_defs udf,
445: cz_model_ref_expls xpl,
446: cz_ps_nodes rootn
447: where
448: rootn.deleted_flag = '0' and
449: rootn.ps_node_id = xpl.component_id and

Line 520: cz_model_ref_expls rootxp,

516: enclexpl.child_model_expl_id as leaf_expl_node_id,
517: comp.persistent_node_id as leaf_persistent_node_id
518: from
519: cz_ps_nodes comp,
520: cz_model_ref_expls rootxp,
521: cz_model_ref_expls enclexpl,
522: table (cast (listsofar as "SYSTEM".cz_uirefs_inmodel_tbl_type)) extlist
523: where
524: comp.ps_node_id = rootxp.component_id and

Line 521: cz_model_ref_expls enclexpl,

517: comp.persistent_node_id as leaf_persistent_node_id
518: from
519: cz_ps_nodes comp,
520: cz_model_ref_expls rootxp,
521: cz_model_ref_expls enclexpl,
522: table (cast (listsofar as "SYSTEM".cz_uirefs_inmodel_tbl_type)) extlist
523: where
524: comp.ps_node_id = rootxp.component_id and
525: comp.deleted_flag = '0' and

Line 628: from cz_model_ref_expls

624: -- first -- verify that p_desc_expl_id really is a child model expl ID of p_encl_expl_id
625: -- we can also use this to calculate MODEL_REFERENCE_DEPTH
626: begin
627: select (level - 1) into desc_ref_depth
628: from cz_model_ref_expls
629: where model_ref_expl_id = p_desc_expl_id and deleted_flag = '0'
630: start with model_ref_expl_id = p_encl_expl_id and deleted_flag = '0'
631: connect by model_ref_expl_id = prior child_model_expl_id and deleted_flag = '0' and
632: prior model_ref_expl_id <> p_desc_expl_id;

Line 646: from cz_model_ref_expls

642:
643: -- to honor the "limiter", we get the original explosion depth. This will be used to determine
644: -- if we have exceeded the depth limit specified by the P_MAX_EXPL_DEPTH parameter
645: select node_depth into start_encl_depth
646: from cz_model_ref_expls
647: where model_ref_expl_id = p_encl_expl_id;
648:
649: -- get some room
650: pairs.extend ();

Line 683: cz_model_ref_expls r_xp,

679: r_xp.model_ref_expl_id as encl_expl,
680: r_xp.node_depth as encl_depth,
681: c_xp.model_ref_expl_id as desc_expl
682: from
683: cz_model_ref_expls r_xp,
684: cz_model_ref_expls c_xp
685: where
686: -- retrieve the child expl nodes of both the ENCL and DESC nodes in the current pair
687: r_xp.parent_expl_node_id = pairs (cur_pair_index).enclosing_expl_id and

Line 684: cz_model_ref_expls c_xp

680: r_xp.node_depth as encl_depth,
681: c_xp.model_ref_expl_id as desc_expl
682: from
683: cz_model_ref_expls r_xp,
684: cz_model_ref_expls c_xp
685: where
686: -- retrieve the child expl nodes of both the ENCL and DESC nodes in the current pair
687: r_xp.parent_expl_node_id = pairs (cur_pair_index).enclosing_expl_id and
688: c_xp.parent_expl_node_id = pairs (cur_pair_index).descendant_expl_id and