[Home] [Help]
PACKAGE: APPS.CN_SCA_CRRULEATTR_PVT
Source
1 PACKAGE CN_SCA_CRRULEATTR_PVT AUTHID CURRENT_USER 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,
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,
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,
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 ;
33
34 G_MISS_SCACRRR_REC credit_rule_attr_rec;
35 G_MISS_SCACRRR_REC_TB credit_rule_attr_tbl_type;
36
37 PROCEDURE Create_Credit_RuleAttr
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
47 );
48
49
50 PROCEDURE Update_Credit_RuleAttr
51 (
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,
61 x_msg_data OUT NOCOPY VARCHAR2
62 );
63
64
65
66 /*PROCEDURE Get_Credit_Rule_Attr
67 (p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
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,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2
80 );*/
81
82 PROCEDURE Generate_Package
83 ( p_api_version IN NUMBER,
84 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
85 p_commit IN VARCHAR2 := FND_API.G_FALSE,
86 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
87 p_org_id IN NUMBER, -- MOAC Change
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2
91 );
92
93
94
95 END CN_SCA_CRRULEATTR_PVT;