1 PACKAGE AS_SCORECARD_RULES_PUB AS
2 /* $Header: asxpscos.pls 120.1 2005/06/24 16:56:03 appldev ship $ */
3
4 TYPE CARDRULE_QUAL_REC_TYPE IS RECORD (
5 QUAL_VALUE_ID NUMBER ,
6 LAST_UPDATE_DATE DATE ,
7 LAST_UPDATED_BY NUMBER ,
8 CREATION_DATE DATE ,
9 CREATED_BY NUMBER ,
10 LAST_UPDATE_LOGIN NUMBER ,
11 SCORECARD_ID NUMBER ,
12 SCORE NUMBER ,
13 CARD_RULE_ID NUMBER ,
14 SEED_QUAL_ID NUMBER ,
15 HIGH_VALUE_NUMBER NUMBER ,
16 LOW_VALUE_NUMBER NUMBER ,
17 HIGH_VALUE_CHAR VARCHAR2(60),
18 LOW_VALUE_CHAR VARCHAR2(60),
19 CURRENCY_CODE VARCHAR2(15),
20 LOW_VALUE_DATE DATE ,
21 HIGH_VALUE_DATE DATE ,
22 START_DATE_ACTIVE DATE ,
23 END_DATE_ACTIVE DATE);
24
25 G_MISS_CARDRULE_QUAL_REC AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE ;
26 TYPE CARDRULE_QUAL_Tbl_Type IS TABLE OF AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE
27 INDEX BY BINARY_INTEGER;
28 G_MISS_CARDRULE_QUAL_TBL AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_Type;
29
30 TYPE SCORECARD_REC_TYPE IS RECORD (
31 SCORECARD_ID NUMBER ,
32 LAST_UPDATE_DATE DATE ,
33 LAST_UPDATED_BY NUMBER ,
34 CREATION_DATE DATE ,
35 CREATED_BY NUMBER ,
36 LAST_UPDATE_LOGIN NUMBER ,
37 DESCRIPTION VARCHAR2(240) ,
38 ENABLED_FLAG VARCHAR2(1) ,
39 START_DATE_ACTIVE DATE ,
40 END_DATE_ACTIVE DATE);
41 G_MISS_SCORECARD_REC AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
42
43 -- Start of comments
44 -- API name : Init_AS_SCORECARD_Rec
45 -- Type : Private
46 -- Pre-reqs : None.
47 -- Function : Initializes and returns a new raw SQL query record type
48 -- as required by AS_SCORECARD_RULES_PUB
49 -- Parameters : None
50 -- Returns : AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
51 -- Version : Current version 1.0
52 -- Initial version 1.0
53 -- End of comments
54 FUNCTION Init_AS_SCORECARD_Rec RETURN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE;
55
56 -- Start of comments
57 -- API name : Init_AS_CARDRULE_QUAL_Rec
58 -- Type : Private
59 -- Pre-reqs : None.
60 -- Function : Initializes and returns a new raw SQL query record type
61 -- as required by AS_SCORECARD_RULES_PUB
62 -- Parameters : None
63 -- Returns : AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE
64 -- Version : Current version 1.0
65 -- Initial version 1.0
66 -- End of comments
67 FUNCTION Init_AS_CARDRULE_QUAL_Rec RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE;
68
69 -- Start of comments
70 -- API name : Init_AS_CARDRULE_QUAL_Tbl
71 -- Type : Private
72 -- Pre-reqs : None.
73 -- Function : Initializes and returns a new raw SQL query record type
74 -- as required by AS_SCORECARD_RULES_PUB
75 -- Parameters : None
76 -- Returns : AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE
77 -- Version : Current version 1.0
78 -- Initial version 1.0
79 -- End of comments
80 FUNCTION Init_AS_CARDRULE_QUAL_Tbl RETURN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_Tbl_TYPE;
81
82 Procedure Create_ScoreCard (
83 p_api_version IN NUMBER := 2.0,
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 := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
91 := G_MISS_SCORECARD_REC,
92 X_SCORECARD_ID OUT NOCOPY NUMBER);
93
94 Procedure Update_ScoreCard (
95 p_api_version IN NUMBER := 2.0,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE,
98 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
99 x_return_status OUT NOCOPY VARCHAR2,
100 x_msg_count OUT NOCOPY NUMBER,
101 x_msg_data OUT NOCOPY VARCHAR2,
102 P_SCORECARD_REC IN AS_SCORECARD_RULES_PUB.SCORECARD_REC_TYPE
103 := G_MISS_SCORECARD_REC);
104
105 Procedure Delete_ScoreCard (
106 p_api_version IN NUMBER := 2.0,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 P_SCORECARD_ID IN NUMBER);
114
115 Procedure Create_CardRule_QUAL (
116 p_api_version IN NUMBER := 2.0,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE,
124 x_qual_value_id OUT NOCOPY NUMBER);
125
126 Procedure Update_CardRule_QUAL (
127 p_api_version IN NUMBER := 2.0,
128 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
129 p_commit IN VARCHAR2 := FND_API.G_FALSE,
130 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_CardRule_Qual_rec IN AS_SCORECARD_RULES_PUB.CARDRULE_QUAL_REC_TYPE);
135
136 -- pass in the qual value Id
137 Procedure Delete_CardRule_QUAL (
138 p_api_version IN NUMBER := 2.0,
139 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
140 p_commit IN VARCHAR2 := FND_API.G_FALSE,
141 p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_qual_value_id IN NUMBER);
146
147
148
149 END AS_SCORECARD_RULES_PUB;