APPS.CZ_RULE_TEXT_GEN dependencies on CZ_RULES

Line 51: TYPE tRuleId IS TABLE OF cz_rules.rule_id%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: TYPE tNumberTable_idx_vc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15); -- New Array defined.
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;

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

48: TYPE tNumberTable IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
49: TYPE tNumberTable_idx_vc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15); -- New Array defined.
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;

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

49: TYPE tNumberTable_idx_vc2 IS TABLE OF NUMBER INDEX BY VARCHAR2(15); -- New Array defined.
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;

Line 141: v_token cz_rules.template_token%TYPE;

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

Line 669: FROM cz_rules ru

665: v_pres_flag:=1;
666:
667: SELECT presentation_flag
668: INTO v_pres_flag
669: FROM cz_rules ru
670: WHERE rule_id = p_rule_id
671: AND(rule_text IS NULL
672: OR EXISTS
673: (SELECT 1

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

771: data_type = v_ExprDataType(i),
772: data_num_value = v_ExprDataNumValue(i)
773: WHERE expr_node_id = v_ExprId(i);
774:
775: UPDATE cz_rules SET rule_text = v_RuleText WHERE rule_id = p_rule_id;
776:
777: EXCEPTION
778: WHEN CZ_UPRT_MULTIPLE_ROOTS THEN
779: xError := cz_utils.report('rule_id = ' || p_rule_id || ': more than one record with null expr_parent_id', 1, 'CDL Rule Upgrade', 13000);

Line 815: FROM cz_rules

811:
812: --Initialize the rule data for resolving token names.
813:
814: SELECT rule_id, name, template_token BULK COLLECT INTO v_RuleId, v_RuleName, v_TemplateToken
815: FROM cz_rules
816: WHERE deleted_flag = '0'
817: AND disabled_flag = '0'
818: AND rule_id < 1000;
819:

Line 847: FOR c_rule IN (SELECT rule_id FROM cz_rules

843:
844: populate_rule_text(p_rule_id);
845: ELSE
846:
847: FOR c_rule IN (SELECT rule_id FROM cz_rules
848: WHERE deleted_flag = '0'
849: AND devl_project_id = p_devl_project_id
850: AND rule_type IN (100, 200)) LOOP
851: populate_rule_text(c_rule.rule_id);