DBA Data[Home] [Help]

APPS.CN_RULEATTRIBUTE_PUB dependencies on CN_RULES

Line 5: (ruleset_name cn_rulesets.name%TYPE,

1: PACKAGE CN_RuleAttribute_PUB AUTHID CURRENT_USER AS
2: --$Header: cnpratrs.pls 120.1 2005/08/25 23:38:05 rramakri noship $
3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_name cn_rulesets.name%TYPE,
6: start_date cn_rulesets.start_date%TYPE,
7: end_date cn_rulesets.end_date%TYPE,
8: rule_name cn_rules.name%TYPE,
9: object_name cn_objects.name%TYPE,

Line 6: start_date cn_rulesets.start_date%TYPE,

2: --$Header: cnpratrs.pls 120.1 2005/08/25 23:38:05 rramakri noship $
3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_name cn_rulesets.name%TYPE,
6: start_date cn_rulesets.start_date%TYPE,
7: end_date cn_rulesets.end_date%TYPE,
8: rule_name cn_rules.name%TYPE,
9: object_name cn_objects.name%TYPE,
10: not_flag cn_attribute_rules.not_flag%TYPE,

Line 7: end_date cn_rulesets.end_date%TYPE,

3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_name cn_rulesets.name%TYPE,
6: start_date cn_rulesets.start_date%TYPE,
7: end_date cn_rulesets.end_date%TYPE,
8: rule_name cn_rules.name%TYPE,
9: object_name cn_objects.name%TYPE,
10: not_flag cn_attribute_rules.not_flag%TYPE,
11: value_1 cn_attribute_rules.column_value%TYPE,

Line 8: rule_name cn_rules.name%TYPE,

4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_name cn_rulesets.name%TYPE,
6: start_date cn_rulesets.start_date%TYPE,
7: end_date cn_rulesets.end_date%TYPE,
8: rule_name cn_rules.name%TYPE,
9: object_name cn_objects.name%TYPE,
10: not_flag cn_attribute_rules.not_flag%TYPE,
11: value_1 cn_attribute_rules.column_value%TYPE,
12: value_2 cn_attribute_rules.high_value%TYPE,

Line 14: org_id cn_rules.org_id%TYPE

10: not_flag cn_attribute_rules.not_flag%TYPE,
11: value_1 cn_attribute_rules.column_value%TYPE,
12: value_2 cn_attribute_rules.high_value%TYPE,
13: data_flag VARCHAR2(1),
14: org_id cn_rules.org_id%TYPE
15: );
16:
17: -- Start of comments
18: -- API name : Create_RuleAttribute