[Home] [Help]
PACKAGE: APPS.IEX_CASE_CONTACTS_PVT
Source
1 PACKAGE IEX_CASE_CONTACTS_PVT AUTHID CURRENT_USER as
2 /* $Header: iexvcons.pls 120.0 2004/01/24 03:25:04 appldev noship $ */
3 -- Start of Comments
4 -- Package name : IEX_CASE_CONTACTS_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_contact_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CAS_CONTACT_ID
19 -- CAS_ID
20 -- CONTACT_PARTY_ID
21 -- OBJECT_VERSION_NUMBER
22 -- ACTIVE_FLAG
23 -- ADDRESS_ID
24 -- PHONE_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 -- PRIMARY_FLAG
51 -- Required:
52 -- Defaults:
53 -- Note: This is automatic generated record definition, it includes all columns
54 -- defined in the table, developer must manually add or delete some of the attributes.
55 --
56 -- End of Comments
57
58 TYPE case_contact_Rec_Type IS RECORD
59 (
60 CAS_CONTACT_ID NUMBER := FND_API.G_MISS_NUM,
61 CAS_ID NUMBER := FND_API.G_MISS_NUM,
62 CONTACT_PARTY_ID NUMBER := FND_API.G_MISS_NUM,
63 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
64 ACTIVE_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 ADDRESS_ID NUMBER := FND_API.G_MISS_NUM,
66 PHONE_ID NUMBER := FND_API.G_MISS_NUM,
67 REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
68 PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
69 PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
70 PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71 ATTRIBUTE_CATEGORY VARCHAR2(240) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE1 VARCHAR2(240) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE2 VARCHAR2(240) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE3 VARCHAR2(240) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE4 VARCHAR2(240) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE5 VARCHAR2(240) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE6 VARCHAR2(240) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE7 VARCHAR2(240) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE8 VARCHAR2(240) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE9 VARCHAR2(240) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE10 VARCHAR2(240) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE11 VARCHAR2(240) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE12 VARCHAR2(240) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE13 VARCHAR2(240) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE14 VARCHAR2(240) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE15 VARCHAR2(240) := FND_API.G_MISS_CHAR,
87 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
88 CREATION_DATE DATE := FND_API.G_MISS_DATE,
89 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
90 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
91 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92 PRIMARY_FLAG VARCHAR2(240) := FND_API.G_MISS_CHAR
93 );
94
95 G_MISS_case_contact_REC case_contact_Rec_Type;
96 TYPE case_contact_Tbl_Type IS TABLE OF case_contact_Rec_Type
97 INDEX BY BINARY_INTEGER;
98 G_MISS_case_contact_TBL case_contact_Tbl_Type;
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- API Name: Create_case_contact
104 -- Type : Private
105 -- Pre-Req :
106 -- Parameters:
107 -- IN
108 -- p_api_version_number IN NUMBER Required
109 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112 -- P_case_contact_Rec IN case_contact_Rec_Type Required
113 --
114 -- OUT:
115 -- x_return_status OUT NOCOPY VARCHAR2
116 -- x_msg_count OUT NOCOPY NUMBER
117 -- x_msg_data OUT NOCOPY VARCHAR2
118 -- Version : Current version 2.0
119 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
120 -- and basic operation, developer must manually add parameters and business logic as necessary.
121 --
122 -- End of Comments
123 --
124 PROCEDURE Create_case_contact(
125 P_Api_Version_Number IN NUMBER,
126 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129 P_case_contact_Rec IN case_contact_Rec_Type := G_MISS_case_contact_REC,
130 X_CAS_CONTACT_ID OUT NOCOPY NUMBER,
131 X_Return_Status OUT NOCOPY VARCHAR2,
132 X_Msg_Count OUT NOCOPY NUMBER,
133 X_Msg_Data OUT NOCOPY VARCHAR2
134 );
135
136 -- *******************************************************
137 -- Start of Comments
138 -- *******************************************************
139 -- API Name: Update_case_contact
140 -- Type : Private
141 -- Pre-Req :
142 -- Parameters:
143 -- IN
144 -- p_api_version_number IN NUMBER Required
145 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
146 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
147 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
148 -- P_case_contact_Rec IN case_contact_Rec_Type Required
149 --
150 -- OUT:
151 -- x_return_status OUT NOCOPY VARCHAR2
152 -- x_msg_count OUT NOCOPY NUMBER
153 -- x_msg_data OUT NOCOPY VARCHAR2
154 -- Version : Current version 2.0
155 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
156 -- and basic operation, developer must manually add parameters and business logic as necessary.
157 --
158 -- End of Comments
159 --
160 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
161 PROCEDURE Update_case_contact(
162 P_Api_Version_Number IN NUMBER,
163 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
166 P_case_contact_Rec IN case_contact_Rec_Type,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2,
170 xo_object_version_number OUT NOCOPY NUMBER
171 );
172
173 -- *******************************************************
174 -- Start of Comments
175 -- *******************************************************
176 -- API Name: Delete_case_contact
177 -- Type : Private
178 -- Pre-Req :
179 -- Parameters:
180 -- IN
181 -- p_api_version_number IN NUMBER Required
182 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
183 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
184 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
185 -- P_case_contact_Rec IN case_contact_Rec_Type Required
186 --
187 -- OUT:
188 -- x_return_status OUT NOCOPY VARCHAR2
189 -- x_msg_count OUT NOCOPY NUMBER
190 -- x_msg_data OUT NOCOPY VARCHAR2
191 -- Version : Current version 2.0
192 --
193 -- End of Comments
194 --
195 PROCEDURE Delete_case_contact(
196 P_Api_Version_Number IN NUMBER,
197 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
198 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
199 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
200 P_cas_contact_id IN NUMBER,
201 X_Return_Status OUT NOCOPY VARCHAR2,
202 X_Msg_Count OUT NOCOPY NUMBER,
203 X_Msg_Data OUT NOCOPY VARCHAR2
204 );
205
206 End IEX_CASE_CONTACTS_PVT;