eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_RULEATTRIBUTE_PVT dependencies on CN_ATTRIBUTE_RULES

Line 5: (ruleset_id cn_attribute_rules.ruleset_id%TYPE,

1: PACKAGE CN_RuleAttribute_PVT AUTHID CURRENT_USER AS
2: --$Header: cnvratrs.pls 120.2 2005/07/04 05:24:30 appldev ship $
3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_id cn_attribute_rules.ruleset_id%TYPE,
6: rule_id cn_attribute_rules.rule_id%TYPE,
7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%TYPE,
9: object_name cn_objects.name%TYPE,

Line 6: rule_id cn_attribute_rules.rule_id%TYPE,

2: --$Header: cnvratrs.pls 120.2 2005/07/04 05:24:30 appldev ship $
3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_id cn_attribute_rules.ruleset_id%TYPE,
6: rule_id cn_attribute_rules.rule_id%TYPE,
7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%TYPE,
9: object_name cn_objects.name%TYPE,
10: not_flag cn_attribute_rules.not_flag%TYPE,

Line 7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,

3:
4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_id cn_attribute_rules.ruleset_id%TYPE,
6: rule_id cn_attribute_rules.rule_id%TYPE,
7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%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: org_id cn_attribute_rules.org_id%TYPE,

4: TYPE RuleAttribute_rec_type IS RECORD
5: (ruleset_id cn_attribute_rules.ruleset_id%TYPE,
6: rule_id cn_attribute_rules.rule_id%TYPE,
7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%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 10: not_flag cn_attribute_rules.not_flag%TYPE,

6: rule_id cn_attribute_rules.rule_id%TYPE,
7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%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,
13: data_flag varchar2(1),
14: object_version_number cn_attribute_rules.object_version_number%TYPE);

Line 11: value_1 cn_attribute_rules.column_value%TYPE,

7: attribute_rule_id cn_attribute_rules.attribute_rule_id%TYPE,
8: org_id cn_attribute_rules.org_id%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,
13: data_flag varchar2(1),
14: object_version_number cn_attribute_rules.object_version_number%TYPE);
15:

Line 12: value_2 cn_attribute_rules.high_value%TYPE,

8: org_id cn_attribute_rules.org_id%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,
13: data_flag varchar2(1),
14: object_version_number cn_attribute_rules.object_version_number%TYPE);
15:
16: -- Start of comments

Line 14: object_version_number cn_attribute_rules.object_version_number%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: object_version_number cn_attribute_rules.object_version_number%TYPE);
15:
16: -- Start of comments
17: -- API name : Create_RuleAttribute
18: -- Type : Private

Line 151: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,

147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: x_loading_status OUT NOCOPY VARCHAR2,
151: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
152: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
153: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
154: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
155: );

Line 152: p_rule_id IN cn_attribute_rules.rule_id%TYPE,

148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2,
150: x_loading_status OUT NOCOPY VARCHAR2,
151: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
152: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
153: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
154: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
155: );
156:

Line 153: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,

149: x_msg_data OUT NOCOPY VARCHAR2,
150: x_loading_status OUT NOCOPY VARCHAR2,
151: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
152: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
153: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
154: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
155: );
156:
157: PROCEDURE Check_Attr_types

Line 154: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE

150: x_loading_status OUT NOCOPY VARCHAR2,
151: p_ruleset_id IN cn_attribute_rules.ruleset_id%TYPE,
152: p_rule_id IN cn_attribute_rules.rule_id%TYPE,
153: p_attribute_rule_id IN cn_attribute_rules.attribute_rule_id%TYPE,
154: p_object_version_number IN cn_attribute_rules.object_version_number%TYPE
155: );
156:
157: PROCEDURE Check_Attr_types
158: (p_value_1 IN VARCHAR2 := NULL,