[Home] [Help]
PACKAGE: APPS.CSC_CHECK_RATINGS_PUB
Source
4 -- Package name : CSC_CHECK_RATINGS_PUB
1 PACKAGE CSC_CHECK_RATINGS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppras.pls 115.10 2002/11/29 04:05:02 bhroy ship $ */
3 -- Start of Comments
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:CHK_RATING_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CHECK_ID
19 -- CHECK_RATING_GRADE
20 -- RATING_COLOR_ID
21 -- RATING_CODE
22 -- COLOR_CODE
23 -- RANGE_LOW_VALUE
24 -- RANGE_HIGH_VALUE
25 -- LAST_UPDATE_DATE
26 -- LAST_UPDATED_BY
27 -- CREATION_DATE
28 -- CREATED_BY
29 -- LAST_UPDATE_LOGIN
30 -- SEEDED_FLAG
31 --
32 -- Required:
33 -- Defaults:
34 --
35 -- End of Comments
36
37 TYPE CHK_RATING_Rec_Type IS RECORD
38 (
39 CHECK_RATING_ID NUMBER,
40 CHECK_ID NUMBER,
41 CHECK_RATING_GRADE VARCHAR2(9),
42 RATING_COLOR_ID NUMBER,
43 RATING_CODE VARCHAR2(30),
44 COLOR_CODE VARCHAR2(30),
45 RANGE_LOW_VALUE VARCHAR2(240),
46 RANGE_HIGH_VALUE VARCHAR2(240),
47 LAST_UPDATE_DATE DATE,
48 LAST_UPDATED_BY NUMBER,
49 CREATION_DATE DATE,
50 CREATED_BY NUMBER,
54
51 LAST_UPDATE_LOGIN NUMBER,
52 SEEDED_FLAG VARCHAR2(3)
53 );
55 G_MISS_CHK_RATING_REC CHK_RATING_Rec_Type;
56 TYPE CHK_RATING_Tbl_Type IS TABLE OF CHK_RATING_Rec_Type
57 INDEX BY BINARY_INTEGER;
58 G_MISS_CHK_RATING_TBL CSC_CHECK_RATINGS_PVT.CHK_RATING_Tbl_Type;
59
60
61 -- *******************************************************
62 -- Start of Comments
63 -- *******************************************************
64 -- API Name: Create_check_ratings
65 -- Type : Public
66 -- Pre-Req :
67 -- Parameters:
68 -- IN
69 -- p_api_version_number IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
71 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
72 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
73 --
74 -- OUT :
75 -- x_return_status OUT NOCOPY VARCHAR2
76 -- x_msg_count OUT NOCOPY NUMBER
77 -- x_msg_data OUT NOCOPY VARCHAR2
78 -- Version : Current version 1.0
79 --
80 -- End of Comments
81 --
82 PROCEDURE Create_check_ratings(
83 P_Api_Version_Number IN NUMBER,
84 P_Init_Msg_List IN VARCHAR2,
85 P_Commit IN VARCHAR2,
86 p_validation_level IN NUMBER ,
87 px_CHECK_RATING_ID IN OUT NOCOPY NUMBER,
88 p_CHECK_ID IN NUMBER,
89 p_CHECK_RATING_GRADE IN VARCHAR2,
90 p_RATING_COLOR_ID IN NUMBER,
91 p_RATING_CODE IN VARCHAR2,
92 p_COLOR_CODE IN VARCHAR2,
93 p_RANGE_LOW_VALUE IN VARCHAR2,
94 p_RANGE_HIGH_VALUE IN VARCHAR2,
95 p_LAST_UPDATE_DATE IN DATE,
96 p_LAST_UPDATED_BY IN NUMBER,
97 p_CREATION_DATE IN DATE,
98 p_CREATED_BY IN NUMBER,
99 p_LAST_UPDATE_LOGIN IN NUMBER,
100 p_SEEDED_FLAG IN VARCHAR2,
101 X_Return_Status OUT NOCOPY VARCHAR2,
102 X_Msg_Count OUT NOCOPY NUMBER,
103 X_Msg_Data OUT NOCOPY VARCHAR2
104 );
105
106
107
108 PROCEDURE Create_check_ratings(
109 P_Api_Version_Number IN NUMBER,
110 P_Init_Msg_List IN VARCHAR2,
111 P_Commit IN VARCHAR2,
112 p_validation_level IN NUMBER ,
113 px_Check_Rating_ID IN OUT NOCOPY NUMBER,
114 P_CHK_RATING_Rec IN CHK_RATING_Rec_Type,
115 X_Return_Status OUT NOCOPY VARCHAR2,
116 X_Msg_Count OUT NOCOPY NUMBER,
117 X_Msg_Data OUT NOCOPY VARCHAR2
118 );
119
120 -- *******************************************************
121 -- Start of Comments
122 -- *******************************************************
123 -- API Name: Update_check_ratings
124 -- Type : Public
125 -- Pre-Req :
126 -- Parameters:
127 -- IN
128 -- p_api_version_number IN NUMBER Required
129 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
131 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
132 --
133 -- OUT :
134 -- x_return_status OUT NOCOPY VARCHAR2
135 -- x_msg_count OUT NOCOPY NUMBER
136 -- x_msg_data OUT NOCOPY VARCHAR2
137 -- Version : Current version 1.0
138 --
139 -- End of Comments
140 --
141
142 PROCEDURE Update_check_ratings(
143 P_Api_Version_Number IN NUMBER,
144 P_Init_Msg_List IN VARCHAR2,
145 P_Commit IN VARCHAR2,
146 p_validation_level IN NUMBER DEFAULT NULL,
147 p_CHECK_RATING_ID IN NUMBER DEFAULT NULL,
148 p_CHECK_ID IN NUMBER DEFAULT NULL,
149 p_CHECK_RATING_GRADE IN VARCHAR2 DEFAULT NULL,
150 p_RATING_COLOR_ID IN NUMBER DEFAULT NULL,
151 p_RATING_CODE IN VARCHAR2 DEFAULT NULL,
152 p_COLOR_CODE IN VARCHAR2 DEFAULT NULL,
153 p_RANGE_LOW_VALUE IN VARCHAR2 DEFAULT NULL,
154 p_RANGE_HIGH_VALUE IN VARCHAR2 DEFAULT NULL,
155 p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
156 p_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
157 p_CREATION_DATE IN DATE DEFAULT NULL,
158 p_CREATED_BY IN NUMBER DEFAULT NULL,
159 p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
160 p_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
161 X_Return_Status OUT NOCOPY VARCHAR2,
162 X_Msg_Count OUT NOCOPY NUMBER,
163 X_Msg_Data OUT NOCOPY VARCHAR2
164 );
165
166 PROCEDURE Update_check_ratings(
167 P_Api_Version_Number IN NUMBER,
168 P_Init_Msg_List IN VARCHAR2,
169 P_Commit IN VARCHAR2,
170 p_validation_level IN NUMBER DEFAULT NULL,
171 P_CHK_RATING_Rec IN CHK_RATING_Rec_Type,
172 X_Return_Status OUT NOCOPY VARCHAR2,
173 X_Msg_Count OUT NOCOPY NUMBER,
174 X_Msg_Data OUT NOCOPY VARCHAR2
175 );
176
180 -- API Name: Delete_check_ratings
177 -- *******************************************************
178 -- Start of Comments
179 -- *******************************************************
181 -- Type : Public
182 -- Pre-Req :
183 -- Parameters:
184 -- IN
185 -- p_api_version_number IN NUMBER Required
186 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
188 -- P_CHK_RATING_Rec IN CHK_RATING_Rec_Type Required
189 --
190 -- OUT :
191 -- x_return_status OUT NOCOPY VARCHAR2
192 -- x_msg_count OUT NOCOPY NUMBER
193 -- x_msg_data OUT NOCOPY VARCHAR2
194 -- Version : Current version 1.0
195 --
196 -- End of Comments
197 --
198 PROCEDURE Delete_check_ratings(
199 P_Api_Version_Number IN NUMBER,
200 P_Init_Msg_List IN VARCHAR2,
201 P_Commit IN VARCHAR2,
202 p_validation_level IN NUMBER,
203 P_CHECK_RATING_ID IN NUMBER,
204 X_Return_Status OUT NOCOPY VARCHAR2,
205 X_Msg_Count OUT NOCOPY NUMBER,
206 X_Msg_Data OUT NOCOPY VARCHAR2
207 );
208 END;