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