DBA Data[Home] [Help]

APPS.CN_RULE_PUB dependencies on CN_RULES

Line 2: --$Header: cnprules.pls 120.2 2005/08/25 23:37:34 rramakri noship $

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,

Line 4: (ruleset_name cn_rulesets.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,

Line 5: start_date cn_rulesets.start_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,
9: revenue_class_name cn_revenue_classes.name%TYPE,

Line 6: end_date cn_rulesets.end_date%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,

Line 7: rule_name cn_rules.name%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,

Line 8: parent_rule_name cn_rules.name%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

Line 10: expense_ccid cn_rules.expense_ccid%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:

Line 11: liability_ccid cn_rules.liability_ccid%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:
15: -- Start of comments

Line 12: org_id cn_rules.org_id%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
16: -- API name : Create_Rule

Line 143: p_rule_name IN cn_rules.name%TYPE,

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: ) ;

Line 144: p_ruleset_name IN cn_rulesets.name%TYPE,

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:

Line 145: p_ruleset_start_date IN cn_rulesets.start_date%TYPE,

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: ---------------------------+

Line 146: p_ruleset_end_date IN cn_rulesets.end_date%TYPE

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: --