1: PACKAGE CN_Rule_PUB AUTHID CURRENT_USER AS
2: --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $
3: TYPE rule_rec_type IS RECORD
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
1: PACKAGE CN_Rule_PUB AUTHID CURRENT_USER AS
2: --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $
3: TYPE rule_rec_type IS RECORD
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
1: PACKAGE CN_Rule_PUB AUTHID CURRENT_USER AS
2: --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $
3: TYPE rule_rec_type IS RECORD
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
2: --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $
3: TYPE rule_rec_type IS RECORD
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
3: TYPE rule_rec_type IS RECORD
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
11: liability_ccid cn_rules.liability_ccid%TYPE,
4: (ruleset_name cn_rulesets.name%TYPE,
5: start_date cn_rulesets.start_date%TYPE,
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
11: liability_ccid cn_rules.liability_ccid%TYPE,
12: org_id cn_rules.org_id%TYPE
6: end_date cn_rulesets.end_date%TYPE,
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
11: liability_ccid cn_rules.liability_ccid%TYPE,
12: org_id cn_rules.org_id%TYPE
13: );
14:
7: rule_name cn_rules.name%TYPE,
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
11: liability_ccid cn_rules.liability_ccid%TYPE,
12: org_id cn_rules.org_id%TYPE
13: );
14:
15: -- Start of comments
8: parent_rule_name cn_rules.name%TYPE,
9: revenue_class_name cn_revenue_classes.name%TYPE,
10: expense_ccid cn_rules.expense_ccid%TYPE,
11: liability_ccid cn_rules.liability_ccid%TYPE,
12: org_id cn_rules.org_id%TYPE
13: );
14:
15: -- Start of comments
16: -- API name : Create_Rule
139: x_return_status OUT NOCOPY VARCHAR2,
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: x_loading_status OUT NOCOPY VARCHAR2,
143: p_rule_name IN cn_rules.name%TYPE,
144: p_ruleset_name IN cn_rulesets.name%TYPE,
145: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
146: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
147: ) ;
140: x_msg_count OUT NOCOPY NUMBER,
141: x_msg_data OUT NOCOPY VARCHAR2,
142: x_loading_status OUT NOCOPY VARCHAR2,
143: p_rule_name IN cn_rules.name%TYPE,
144: p_ruleset_name IN cn_rulesets.name%TYPE,
145: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
146: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
147: ) ;
148:
141: x_msg_data OUT NOCOPY VARCHAR2,
142: x_loading_status OUT NOCOPY VARCHAR2,
143: p_rule_name IN cn_rules.name%TYPE,
144: p_ruleset_name IN cn_rulesets.name%TYPE,
145: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
146: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
147: ) ;
148:
149: ---------------------------+
142: x_loading_status OUT NOCOPY VARCHAR2,
143: p_rule_name IN cn_rules.name%TYPE,
144: p_ruleset_name IN cn_rulesets.name%TYPE,
145: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,
146: p_ruleset_end_date IN cn_rulesets.end_date%TYPE
147: ) ;
148:
149: ---------------------------+
150: --