[Home] [Help]
PACKAGE: APPS.IEX_CASES_PVT
Source
1 PACKAGE IEX_CASES_PVT as
2 /* $Header: iexvcass.pls 120.0 2004/01/24 03:24:49 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_CASES_PVT
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:cas_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CAS_ID
19 -- CASE_NUMBER
20 -- ORIG_CAS_ID
21 -- CASE_STATE
22 -- STATUS_CODE
23 -- OBJECT_VERSION_NUMBER
24 -- CASE_ESTABLISHED_DATE
25 -- CASE_CLOSING_DATE
26 -- OWNER_RESOURCE_ID
27 -- ACCESS_RESOURCE_ID
28 -- REQUEST_ID
29 -- PROGRAM_APPLICATION_ID
30 -- PROGRAM_ID
31 -- PROGRAM_UPDATE_DATE
32 -- ATTRIBUTE_CATEGORY
33 -- ATTRIBUTE1
34 -- ATTRIBUTE2
35 -- ATTRIBUTE3
36 -- ATTRIBUTE4
37 -- ATTRIBUTE5
38 -- ATTRIBUTE6
39 -- ATTRIBUTE7
40 -- ATTRIBUTE8
41 -- ATTRIBUTE9
42 -- ATTRIBUTE10
43 -- ATTRIBUTE11
44 -- ATTRIBUTE12
45 -- ATTRIBUTE13
46 -- ATTRIBUTE14
47 -- ATTRIBUTE15
48 -- CREATED_BY
49 -- CREATION_DATE
50 -- LAST_UPDATED_BY
51 -- LAST_UPDATE_DATE
52 -- LAST_UPDATE_LOGIN
53 -- ORG_ID
54 -- CLOSE_REASON
55 -- COMMENTS
56 -- Required:
57 -- Defaults:
58 --
59 -- End of Comments
60
61 TYPE cas_Rec_Type IS RECORD
62 (
63 CAS_ID NUMBER := FND_API.G_MISS_NUM,
64 CASE_NUMBER VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
66 PARTY_ID NUMBER := FND_API.G_MISS_NUM,
67 ORIG_CAS_ID NUMBER := FND_API.G_MISS_NUM,
68 CASE_STATE VARCHAR2(240) := FND_API.G_MISS_CHAR,
69 STATUS_CODE VARCHAR2(240) := FND_API.G_MISS_CHAR,
70 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
71 CASE_ESTABLISHED_DATE DATE := FND_API.G_MISS_DATE,
72 CASE_CLOSING_DATE DATE := FND_API.G_MISS_DATE,
73 OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
74 ACCESS_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
75 PREDICTED_RECOVERY_AMOUNT NUMBER := FND_API.G_MISS_NUM,
76 PREDICTED_CHANCE NUMBER := FND_API.G_MISS_NUM,
77 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
78 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
79 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
80 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
81 ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
88 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
89 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
90 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
91 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
92 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
93 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
94 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
95 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
96 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
98 CREATION_DATE DATE := FND_API.G_MISS_DATE,
99 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
100 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
101 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
102 ORG_ID NUMBER := FND_API.G_MISS_NUM,
103 CLOSE_REASON VARCHAR2(240) := FND_API.G_MISS_CHAR,
104 COMMENTS VARCHAR2(240) := FND_API.G_MISS_CHAR
105 );
106
107 G_MISS_cas_REC cas_Rec_Type;
108 TYPE cas_Tbl_Type IS TABLE OF cas_Rec_Type
109 INDEX BY BINARY_INTEGER;
110 G_MISS_cas_TBL cas_Tbl_Type;
111
112
113
114 -- *******************************************************
115 -- Start of Comments
116 -- *******************************************************
117 -- API Name: Create_CAS
118 -- Type : private
119 -- Pre-Req :
120 -- Parameters:
121 -- IN
122 -- p_api_version_number IN NUMBER Required
123 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125 -- P_cas_Rec IN case_object_Rec_Type Required
126 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127 --
128 -- OUT:
129 -- x_case_id OUT NOCOPY NUMBER
130 -- x_return_status OUT NOCOPY VARCHAR2
131 -- x_msg_count OUT NOCOPY NUMBER
132 -- x_msg_data OUT NOCOPY VARCHAR2
133 -- Version : Current version 2.0
134 --
135 -- End of Comments
136 --
137 PROCEDURE Create_CAS(
138 P_Api_Version_Number IN NUMBER,
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 := FND_API.G_VALID_LEVEL_FULL,
142 P_CAS_Rec IN CAS_Rec_Type := G_MISS_CAS_REC,
143 X_CASE_ID OUT NOCOPY NUMBER,
144 X_Return_Status OUT NOCOPY VARCHAR2,
145 X_Msg_Count OUT NOCOPY NUMBER,
146 X_Msg_Data OUT NOCOPY VARCHAR2
147 );
148
149 -- *******************************************************
150 -- Start of Comments
151 -- *******************************************************
152 -- API Name: Update_CAS
153 -- Type : private
154 -- Pre-Req :
155 -- Parameters:
156 -- IN
157 -- p_api_version_number IN NUMBER Required
158 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
159 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
160 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
161 -- P_CAS_Rec IN CAS_Rec_Type Required
162 -- OUT:
163 -- x_return_status OUT NOCOPY VARCHAR2
164 -- x_msg_count OUT NOCOPY NUMBER
165 -- x_msg_data OUT NOCOPY VARCHAR2
166 -- Version : Current version 2.0
167 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
168 -- and basic operation, developer must manually add parameters and business logic as necessary.
169 --
170 -- End of Comments
171 --
172 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
173 PROCEDURE Update_CAS(
174 P_Api_Version_Number IN NUMBER,
175 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
176 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
177 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178 P_CAS_Rec IN CAS_Rec_Type,
179 X_Return_Status OUT NOCOPY VARCHAR2,
180 X_Msg_Count OUT NOCOPY NUMBER,
181 X_Msg_Data OUT NOCOPY VARCHAR2,
182 XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
183
184 );
185
186 -- *******************************************************
187 -- Start of Comments
188 -- *******************************************************
189 -- API Name: Delete_CAS
190 -- Type : private
191 -- Pre-Req :
192 -- Parameters:
193 -- IN
194 -- p_api_version_number IN NUMBER Required
195 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
197 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
198 -- OUT:
199 -- x_return_status OUT NOCOPY VARCHAR2
200 -- x_msg_count OUT NOCOPY NUMBER
201 -- x_msg_data OUT NOCOPY VARCHAR2
202 -- Version : Current version 2.0
203 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
204 -- and basic operation, developer must manually add parameters and business logic as necessary.
205 --
206 -- End of Comments
207 --
208 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
209 -- The Master delete procedure may not be needed depends on different business requirements.
210 PROCEDURE Delete_CAS(
211 P_Api_Version_Number IN NUMBER,
212 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
213 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 p_cas_id IN NUMBER ,
216 X_Return_Status OUT NOCOPY VARCHAR2,
217 X_Msg_Count OUT NOCOPY NUMBER,
218 X_Msg_Data OUT NOCOPY VARCHAR2
219 );
220
221
222 End IEX_CASES_PVT;