1 PACKAGE AHL_WARRANTY_UTILS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVSWUS.pls 120.2.12020000.2 2012/12/07 14:56:29 sareepar ship $ */
3 ---------------------------------------------------------------------
4 -- Define Record Types for record structures needed by the APIs --
5 ---------------------------------------------------------------------
6
7 -- Declare warranty_contract_id table type for record type NUMBER
8 TYPE warranty_contract_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
9
10 -- Declare warranty_vendor_id table type for record type NUMBER
11 TYPE warranty_vendor_id_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
12
13 --Turnover_Notes_Rec_Type record type to be used for storing turnover notes data
14 TYPE Turnover_Notes_Rec_Type IS RECORD
15
16 (
17
18 jtf_note_id NUMBER,
19
20 source_object_id NUMBER,
21
22 source_object_code VARCHAR2(30),
23
24 notes VARCHAR2(2000),
25
26 user_id NUMBER,--USER_ID in FND_USER
27
28 employee_name VARCHAR2(240),--FULL_NAME in PER_PEOPLE_F
29
30 entered_date DATE
31
32 );
33
34 --Table type for Turnover_Notes_Rec_Type to be used as parameter to Insert_Turnover_Notes procedure
35 TYPE Turnover_Notes_Tbl_Type IS TABLE OF Turnover_Notes_Rec_Type INDEX BY BINARY_INTEGER;
36
37 -----------------------------------------------------------------
38 -- Declare Procedures --
39 -------------------------------------------------------------------
40
41
42 ------------------------------------------------------------------
43 -- Procedure name : Calc_Contract_Exp_Date
44 -- Type : Private
45 --
46 --
47 -- Function :To Calculate Warranty Expiration
48 --
49 --
50 -- Pre-reqs :
51 -- Parameters :
52 --
53 -- Standard IN Parameters :
54 -- p_api_version IN NUMBER Required
55 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
56 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
57 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
58 --
59 -- Standard OUT Parameters :
60 -- x_return_status OUT VARCHAR2 Required
61 -- x_msg_count OUT NUMBER Required
62 -- x_msg_data OUT VARCHAR2 Required
63 --
64 -- Warranty Expiration Calculation Parameters:
65 -- p_warranty_contract_id_tbl IN warranty_contract_id_tbl_type Required if p_module_type is not 'CP'
66 -- cont = contract
67 -- ctl = counter
68 -- Version :
69 -- 24-Sep-2010 JKJain Initial Creation
70 -------------------------------------------------------------------
71 PROCEDURE Calc_Contract_Exp_Date (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
74 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
75 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
76 p_module_type IN VARCHAR2 := NULL,
77 p_warranty_contract_id_tbl IN warranty_contract_id_tbl_type,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2
81 );
82
83
84 --------------------------------------------------------------------
85 -- PROCEDURE
86 -- Calc_Contract_Exp_Date_CP
87 --
88 -- PURPOSE
89 -- Made as an executable for the Warranty Expiration Calculation Concurrent Program
90 -- Calc_Contract_Exp_Date_CP Parameters :
91 --
92 -- errbuf OUT VARCHAR2 Required
93 -- Defines in pl/sql to store procedure to get error messages into log file
94 -- retcode OUT NUMBER Required
95 -- To get the status of the concurrent program
96
97 -- Version :
98 -- 24 Sep, 2010 JKJain, Supplier Warranty ER, Initial Version - 1.0
99 --------------------------------------------------------------------
100 PROCEDURE Calc_Contract_Exp_Date_CP(
101 errbuf OUT NOCOPY VARCHAR2,
102 retcode OUT NOCOPY NUMBER,
103 p_api_version IN NUMBER :=1.0
104 );
105
106 --------------------------------------------------------------------
107 -- PROCEDURE
108 -- Disable_Templates_CP
109 --
110 -- PURPOSE
111 -- Made as an executable for the Disabling Templates Concurrent Program
112 -- Disable_Templates_CP Parameters :
113 --
114 -- errbuf OUT VARCHAR2 Required
115 -- Defines in pl/sql to store procedure to get error messages into log file
116 -- retcode OUT NUMBER Required
117 -- To get the status of the concurrent program
118
119 -- Version :
120 -- 04 Oct, 2010 JKJain, Supplier Warranty ER, Initial Version - 1.0
121 --------------------------------------------------------------------
122 PROCEDURE Disable_Templates_CP(
123 errbuf OUT NOCOPY VARCHAR2,
124 retcode OUT NOCOPY NUMBER,
125 p_api_version IN NUMBER :=1.0
126 );
127
128
129 -------------------------------------------------------------------
130 -- Procedure name : Disable_Templates_For_Vendor
131 -- Type : Private
132 --
133 --
134 -- Function :To Change template's Enabled_Flag to N, given a vendor id.
135 --
136 --
137 -- Pre-reqs :
138 -- Parameters :
139 --
140 -- Standard IN Parameters :
141 -- p_api_version IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
143 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
145 --
146 -- Standard OUT Parameters :
147 -- x_return_status OUT VARCHAR2 Required
148 -- x_msg_count OUT NUMBER Required
149 -- x_msg_data OUT VARCHAR2 Required
150 --
151 -- Warranty Expiration Calculation Parameters:
152 -- p_warranty_vendor_id_tbl IN warranty_vendor_id_tbl_type Required
153 --
154 -- Version :
155 -- 24-Sep-2010 JKJain Initial Creation
156 -- 30-NOV-2010 JKJain Modified for the new requirements.
157 -------------------------------------------------------------------
158 PROCEDURE Disable_Templates_For_Vendor (
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
161 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
162 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
163 p_module_type IN VARCHAR2 := NULL,
164 p_warranty_vendor_id_tbl IN warranty_vendor_id_tbl_type,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2
168 );
169
170 -------------------------------------------------------------------
171 -- Procedure name : Process_Attachments
172 -- Type : Private
173 --
174 --
175 -- Function :To Copy Attachments and Delete Attachements.
176 --
177 --
178 -- Pre-reqs :
179 -- Parameters :
180 --
181 -- Standard IN Parameters :
182 -- p_api_version IN NUMBER Required
183 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
184 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
185 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
186 --
187 -- Standard OUT Parameters :
188 -- x_return_status OUT VARCHAR2 Required
189 -- x_msg_count OUT NUMBER Required
190 -- x_msg_data OUT VARCHAR2 Required
191 --
192 -- Warranty Expiration Calculation Parameters:
193 -- p_entity_name IN VARCHAR2 Required
194 -- p_pk1_value IN NUMBER Required
195 -- p_copy_from_pk IN NUMBER, Required in case of Copy Attachments
196 -- p_copy_from_entity IN VARCHAR2,Required in case of Copy Attachments
197 -- p_dml_operation IN VARCHAR2, D for Delete, C for Copy
198 -- Version :
199 -- 15-Oct-2010 JKJain Initial Creation
200 -------------------------------------------------------------------
201 PROCEDURE Process_Attachments (
202 p_api_version IN NUMBER,
203 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
204 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
205 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
206 p_module_type IN VARCHAR2 := NULL,
207 p_entity_name IN VARCHAR2,
208 p_pk1_value IN NUMBER,
209 p_copy_from_entity IN VARCHAR2,
210 p_copy_from_pk IN NUMBER,
211 p_dml_operation IN VARCHAR2,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2
215 );
216
217 -------------------------------------------------------------------
218 -- Procedure name : Insert_Turnover_Notes
219 -- Type : Private
220 --
221 --
222 -- Function :To Insert Turnover Notes into JTF Notes.
223 --
224 --
225 -- Pre-reqs :
226 -- Parameters :
227 --
228 -- Standard IN Parameters :
229 -- p_api_version IN NUMBER Required
230 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
231 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
232 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
233 -- p_default IN VARCHAR2 Default FND_API.G_FALSE
234 -- p_module_type IN VARCHAR2 Default Null
235 -- Standard OUT Parameters :
236 -- x_return_status OUT VARCHAR2 Required
237 -- x_msg_count OUT NUMBER Required
238 -- x_msg_data OUT VARCHAR2 Required
239 --
240 -- Insert Turnover Notes Parameters:
241 -- p_trunover_notes_tbl IN OUT AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type Required
242 --
243 -- Version :
244 -- 06-Oct-2010 SUKHWSIN Initial Creation
245 -------------------------------------------------------------------
246 PROCEDURE Insert_Turnover_Notes
247 (
248 p_api_version IN NUMBER := 1.0 ,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
250 p_commit IN VARCHAR2 := FND_API.G_FALSE,
251 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
252 p_default IN VARCHAR2 := FND_API.G_FALSE,
253 p_module_type IN VARCHAR2 := Null,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_trunover_notes_tbl IN OUT NOCOPY AHL_WARRANTY_UTILS_PVT.Turnover_Notes_Tbl_Type
258 );
259
260 ------------------------------------------------------------------------------------
261 -- Start of Comments
262 -- Function name : Is_Warranty_Edit_Allowed
263 -- Type : Public
264 -- Function : Checks if the edit warranty security function is allowed for the
265 -- logged in user or not.
266 -- Returns 'Y' is allowed, 'N' otherwsie.
267 --
268 -- Pre-reqs :
269 -- Parameters :
270 --
271 --
272 -- End of Comments
273
274 FUNCTION Is_Warranty_Edit_Allowed
275 RETURN VARCHAR2;
276
277 END AHL_WARRANTY_UTILS_PVT;