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_SCA_CRRULEATTR_PVT dependencies on CN_SCA_RULE_ATTRIBUTES

Line 4: Sca_Rule_Attribute_Id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE,

1: PACKAGE CN_SCA_CRRULEATTR_PVT as
2: -- $Header: cnvscrrs.pls 120.1 2005/08/07 21:32:22 vensrini noship $ --+
3: TYPE credit_rule_attr_rec is RECORD (
4: Sca_Rule_Attribute_Id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE,
5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,
6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,

Line 5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,

1: PACKAGE CN_SCA_CRRULEATTR_PVT as
2: -- $Header: cnvscrrs.pls 120.1 2005/08/07 21:32:22 vensrini noship $ --+
3: TYPE credit_rule_attr_rec is RECORD (
4: Sca_Rule_Attribute_Id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE,
5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,
6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,

Line 6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,

2: -- $Header: cnvscrrs.pls 120.1 2005/08/07 21:32:22 vensrini noship $ --+
3: TYPE credit_rule_attr_rec is RECORD (
4: Sca_Rule_Attribute_Id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE,
5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,
6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,

Line 7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,

3: TYPE credit_rule_attr_rec is RECORD (
4: Sca_Rule_Attribute_Id cn_sca_rule_attributes.sca_rule_attribute_id%TYPE,
5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,
6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,

Line 9: Data_Type cn_sca_rule_attributes.datatype%TYPE,

5: Transaction_source cn_sca_rule_attributes.transaction_source%TYPE,
6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,

Line 10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,

6: Destination_column cn_sca_rule_attributes.src_column_name%TYPE,
7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,

Line 11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,

7: User_Name cn_sca_rule_attributes.user_column_name%TYPE,
8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,

Line 12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,

8: Value_Set_Id fnd_flex_value_sets.flex_value_set_id%TYPE,
9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,

Line 13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,

9: Data_Type cn_sca_rule_attributes.datatype%TYPE,
10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,

Line 14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,

10: Source_Column cn_sca_rule_attributes.trx_src_column_name%TYPE ,
11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,

Line 15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,

11: Enable_Flag cn_sca_rule_attributes.enabled_flag%TYPE ,
12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,

Line 16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,

12: Attribute_Category cn_sca_rule_attributes.attribute_category%TYPE := NULL,
13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,

Line 17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,

13: Attribute1 cn_sca_rule_attributes.attribute1%TYPE := NULL,
14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,

Line 18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,

14: Attribute2 cn_sca_rule_attributes.attribute2%TYPE := NULL,
15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,

Line 19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,

15: Attribute3 cn_sca_rule_attributes.attribute3%TYPE := NULL,
16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,

Line 20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,

16: Attribute4 cn_sca_rule_attributes.attribute4%TYPE := NULL,
17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,

Line 21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,

17: Attribute5 cn_sca_rule_attributes.attribute5%TYPE := NULL,
18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,

Line 22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,

18: Attribute6 cn_sca_rule_attributes.attribute6%TYPE := NULL,
19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,

Line 23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,

19: Attribute7 cn_sca_rule_attributes.attribute7%TYPE := NULL,
20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,

Line 24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,

20: Attribute8 cn_sca_rule_attributes.attribute8%TYPE := NULL,
21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,
28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE

Line 25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,

21: Attribute9 cn_sca_rule_attributes.attribute9%TYPE := NULL,
22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,
28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE
29: );

Line 26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,

22: Attribute10 cn_sca_rule_attributes.attribute10%TYPE := NULL,
23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,
28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE
29: );
30:

Line 27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,

23: Attribute11 cn_sca_rule_attributes.attribute11%TYPE := NULL,
24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,
28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE
29: );
30:
31: TYPE credit_rule_attr_tbl_type IS

Line 28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE

24: Attribute12 cn_sca_rule_attributes.attribute12%TYPE := NULL,
25: Attribute13 cn_sca_rule_attributes.attribute13%TYPE := NULL,
26: Attribute14 cn_sca_rule_attributes.attribute14%TYPE := NULL,
27: Attribute15 cn_sca_rule_attributes.attribute15%TYPE := NULL,
28: Object_Version_Number cn_sca_rule_attributes.object_version_number%TYPE
29: );
30:
31: TYPE credit_rule_attr_tbl_type IS
32: TABLE OF credit_rule_attr_rec INDEX BY BINARY_INTEGER ;

Line 42: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change

38: ( p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_commit IN VARCHAR2 := FND_API.G_FALSE,
41: p_valdiation_level IN VARCHAR2 := FND_API.G_FALSE,
42: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
43: p_credit_rule_attr_rec IN credit_rule_attr_rec,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2

Line 56: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change

52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54: p_commit IN VARCHAR2,
55: p_valdiation_level IN VARCHAR2,
56: p_org_id IN cn_sca_rule_attributes.org_id%TYPE, -- MOAC Change
57: p_credit_rule_attr_rec IN credit_rule_attr_rec,
58: -- p_old_credit_rule_attr_rec IN credit_rule_attr_rec,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

Line 73: p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%' ,

69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: p_start_record IN NUMBER := -1,
72: p_fetch_size IN NUMBER := -1,
73: p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%' ,
74: p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,
75: x_credit_rule_attr OUT NOCOPY credit_rule_attr_tbl_type,
76: x_total_record OUT NOCOPY NUMBER,
77: x_return_status OUT NOCOPY VARCHAR2,

Line 74: p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,

70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: p_start_record IN NUMBER := -1,
72: p_fetch_size IN NUMBER := -1,
73: p_search_uname IN cn_sca_rule_attributes.user_column_name%TYPE := '%' ,
74: p_search_trx_source IN cn_sca_rule_attributes.transaction_source%TYPE,
75: x_credit_rule_attr OUT NOCOPY credit_rule_attr_tbl_type,
76: x_total_record OUT NOCOPY NUMBER,
77: x_return_status OUT NOCOPY VARCHAR2,
78: x_msg_count OUT NOCOPY NUMBER,