APPS.CZ_RULE_TEXT_GEN dependencies on CZ_RULES

Line 50: TYPE tRuleId IS TABLE OF cz_rules.rule_id%TYPE INDEX BY BINARY_INTEGER;

46: TYPE tIntegerTable IS TABLE OF PLS_INTEGER INDEX BY VARCHAR2(15);
47: TYPE tIntegerTableIBI IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
48: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
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;

Line 51: TYPE tRuleName IS TABLE OF cz_rules.name%TYPE INDEX BY BINARY_INTEGER;

47: TYPE tIntegerTableIBI IS TABLE OF PLS_INTEGER INDEX BY BINARY_INTEGER;
48: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
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;

Line 52: TYPE tTemplateToken IS TABLE OF cz_rules.template_token%TYPE INDEX BY BINARY_INTEGER;

48: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
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;

Line 137: v_token cz_rules.template_token%TYPE;

133: v_RuleText VARCHAR2(32767);
134: v_Name VARCHAR2(2000);
135: v_Index PLS_INTEGER;
136: v_aux PLS_INTEGER;
137: v_token cz_rules.template_token%TYPE;
138: ---------------------------------------------------------------------------------------
139: FUNCTION generate_model_path(p_ps_node_id IN NUMBER) RETURN VARCHAR2 IS
140: v_Name VARCHAR2(32767);
141: BEGIN

Line 665: FROM cz_rules ru

661: v_pres_flag:=1;
662:
663: SELECT presentation_flag
664: INTO v_pres_flag
665: FROM cz_rules ru
666: WHERE rule_id = p_rule_id
667: AND(rule_text IS NULL
668: OR EXISTS
669: (SELECT 1

Line 758: UPDATE cz_rules SET rule_text = v_RuleText WHERE rule_id = p_rule_id;

754: data_type = v_ExprDataType(i),
755: data_num_value = v_ExprDataNumValue(i)
756: WHERE expr_node_id = v_ExprId(i);
757:
758: UPDATE cz_rules SET rule_text = v_RuleText WHERE rule_id = p_rule_id;
759:
760: EXCEPTION
761: WHEN CZ_UPRT_MULTIPLE_ROOTS THEN
762: xError := cz_utils.report('rule_id = ' || p_rule_id || ': more than one record with null expr_parent_id', 1, 'CDL Rule Upgrade', 13000);

Line 798: FROM cz_rules

794:
795: --Initialize the rule data for resolving token names.
796:
797: SELECT rule_id, name, template_token BULK COLLECT INTO v_RuleId, v_RuleName, v_TemplateToken
798: FROM cz_rules
799: WHERE deleted_flag = '0'
800: AND disabled_flag = '0'
801: AND rule_id < 1000;
802:

Line 830: FOR c_rule IN (SELECT rule_id FROM cz_rules

826:
827: populate_rule_text(p_rule_id);
828: ELSE
829:
830: FOR c_rule IN (SELECT rule_id FROM cz_rules
831: WHERE deleted_flag = '0'
832: AND devl_project_id = p_devl_project_id
833: AND rule_type IN (100, 200)) LOOP
834: populate_rule_text(c_rule.rule_id);