DBA Data[Home] [Help]

APPS.CN_RULE_PUB dependencies on CN_RULESETS

Line 4: (ruleset_name cn_rulesets.name%TYPE,

1: PACKAGE CN_Rule_PUB 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 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 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: --