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