[Home] [Help]
49:
50: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;
51: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;
52: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;
53: TYPE tPsNodeName IS TABLE OF cz_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
54: TYPE tPropertyName IS TABLE OF cz_properties.name%TYPE INDEX BY BINARY_INTEGER;
55: TYPE tNodeId IS TABLE OF cz_model_ref_expls.model_ref_expl_id%TYPE INDEX BY BINARY_INTEGER;
56: TYPE tParentId IS TABLE OF cz_model_ref_expls.parent_expl_node_id%TYPE INDEX BY BINARY_INTEGER;
57: TYPE tComponentId IS TABLE OF cz_model_ref_expls.component_id%TYPE INDEX BY BINARY_INTEGER;
141: BEGIN
142:
143: IF(h_ModelPath.EXISTS(p_ps_node_id))THEN RETURN h_ModelPath(p_ps_node_id); END IF;
144:
145: FOR c_name IN (SELECT name, parent_id FROM cz_ps_nodes
146: START WITH ps_node_id = p_ps_node_id
147: CONNECT BY PRIOR parent_id = ps_node_id) LOOP
148:
149: IF(v_Name IS NULL)THEN
150:
151: v_Name := '''' || c_name.name || '''';
152: h_NodeName(p_ps_node_id) := v_Name;
153:
154: FOR c_node IN (SELECT NULL FROM cz_ps_nodes WHERE deleted_flag = '0'
155: AND devl_project_id = p_devl_project_id
156: AND name = c_name.name
157: AND ps_node_id <> p_ps_node_id)LOOP
158: h_FullName(p_ps_node_id) := 1;
157: AND ps_node_id <> p_ps_node_id)LOOP
158: h_FullName(p_ps_node_id) := 1;
159: EXIT;
160: END LOOP;
161: FOR c_node IN (SELECT NULL FROM cz_ps_nodes WHERE deleted_flag = '0'
162: AND devl_project_id IN
163: (SELECT component_id FROM cz_model_ref_expls
164: WHERE deleted_flag = '0'
165: AND model_id = p_devl_project_id
204: h_ComponentId(v_Node) <> v_ExprPsNodeId(j))THEN
205:
206: BEGIN
207:
208: SELECT name INTO v_ModelName FROM cz_ps_nodes
209: WHERE ps_node_id = h_ComponentId(v_Node);
210: EXCEPTION
211: WHEN OTHERS THEN
212: NULL;