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