2: --$Header: cnvrules.pls 120.3 2006/03/07 04:57:59 hanaraya ship $
3:
4: TYPE rule_rec_type IS RECORD
5: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
4: TYPE rule_rec_type IS RECORD
5: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
6: rule_id cn_rules_all_b.rule_id%TYPE,
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
7: rule_name VARCHAR2(80),
8: parent_rule_id cn_rules_all_b.rule_id%TYPE,
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );
9: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );
16:
17: TYPE rule_out_rec_type IS RECORD
10: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
11: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
12: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
13: org_id cn_rules_all_b.org_id%TYPE,
14: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
15: );
16:
17: TYPE rule_out_rec_type IS RECORD
18: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
16:
17: TYPE rule_out_rec_type IS RECORD
18: (ruleset_id cn_rulesets_all_b.ruleset_id%TYPE,
19: ruleset_name cn_rulesets_all_tl.name%TYPE,
20: rule_id cn_rules_all_b.rule_id%TYPE,
21: rule_name cn_rules_all_tl.name%TYPE,
22: expense_desc Varchar2(2000),
23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,
21: rule_name cn_rules_all_tl.name%TYPE,
22: expense_desc Varchar2(2000),
23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
23: liability_desc Varchar2(2000),
24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
24: revenue_class_name cn_revenue_classes.name%TYPE,
25: parent_rule_id cn_rules_all_b.rule_id%TYPE,
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );
26: revenue_class_id cn_revenue_classes.revenue_class_id%TYPE,
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );
33:
34: TYPE rule_tbl_type IS TABLE OF rule_out_rec_type
27: expense_ccid cn_rules_all_b.expense_ccid%TYPE,
28: liability_ccid cn_rules_all_b.liability_ccid%TYPE,
29: sequence_number cn_rules_hierarchy.sequence_number%TYPE,
30: org_id cn_rules_all_b.org_id%TYPE,
31: object_version_no cn_rules_all_b.OBJECT_VERSION_NUMBER%TYPE
32: );
33:
34: TYPE rule_tbl_type IS TABLE OF rule_out_rec_type
35: INDEX BY BINARY_INTEGER;
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:
172: --============================================================================
165: x_msg_data OUT NOCOPY VARCHAR2,
166: x_loading_status OUT NOCOPY VARCHAR2,
167: p_rule_id IN cn_rules_all_b.rule_id%TYPE,
168: p_ruleset_id IN cn_rules_all_b.ruleset_id%TYPE,
169: p_org_id IN cn_rules_all_b.org_id%TYPE
170: );
171:
172: --============================================================================
173: -- Start of Comments