1 PACKAGE edr_Standard_pub AS
2 /* $Header: EDRPSTDS.pls 120.0.12000000.1 2007/01/18 05:54:52 appldev ship $ */
3 /*#
4 * This package contains all general Oracle E-Records utilities.
5 * @rep:scope public
6 * @rep:metalink 268669.1 Oracle E-Records API User's Guide
7 * @rep:product EDR
8 * @rep:displayname Oracle E-Records Utility
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY EDR_EVIDENCE_STORE
11 */
12
13 -- Public Record Type Decleration
14
15 TYPE EventDetail_tbl_type IS TABLE of edr_standard.eventDetails INDEX by binary_integer;
16
17 TYPE InputVar_Values_tbl_type IS TABLE of edr_standard.RuleInputValues index by binary_integer;
18
19 -- Global Variables
20
21 G_SIGNATURE_STATUS varchar2(80) := NULL; -- hold the status of workflow ('APPROVED','REJECTED')
22
23
24 Type Flex_ColnName_Rec_Type is record (
25 P_COLUMN1_NAME VARCHAR2(30),
26 P_COLUMN2_NAME VARCHAR2(30),
27 P_COLUMN3_NAME VARCHAR2(30),
28 P_COLUMN4_NAME VARCHAR2(30),
29 P_COLUMN5_NAME VARCHAR2(30),
30 P_COLUMN6_NAME VARCHAR2(30),
31 P_COLUMN7_NAME VARCHAR2(30),
32 P_COLUMN8_NAME VARCHAR2(30),
33 P_COLUMN9_NAME VARCHAR2(30),
34 P_COLUMN10_NAME VARCHAR2(30),
35 P_COLUMN11_NAME VARCHAR2(30),
36 P_COLUMN12_NAME VARCHAR2(30),
37 P_COLUMN13_NAME VARCHAR2(30),
38 P_COLUMN14_NAME VARCHAR2(30),
39 P_COLUMN15_NAME VARCHAR2(30),
40 P_COLUMN16_NAME VARCHAR2(30),
41 P_COLUMN17_NAME VARCHAR2(30),
42 P_COLUMN18_NAME VARCHAR2(30),
43 P_COLUMN19_NAME VARCHAR2(30),
44 P_COLUMN20_NAME VARCHAR2(30),
45 P_COLUMN21_NAME VARCHAR2(30),
46 P_COLUMN22_NAME VARCHAR2(30),
47 P_COLUMN23_NAME VARCHAR2(30),
48 P_COLUMN24_NAME VARCHAR2(30),
49 P_COLUMN25_NAME VARCHAR2(30),
50 P_COLUMN26_NAME VARCHAR2(30),
51 P_COLUMN27_NAME VARCHAR2(30),
52 P_COLUMN28_NAME VARCHAR2(30),
53 P_COLUMN29_NAME VARCHAR2(30),
54 P_COLUMN30_NAME VARCHAR2(30) );
55
56 Type Flex_ColnPrompt_Rec_Type is record (
57 P_COLUMN1_PROMPT VARCHAR2(80),
58 P_COLUMN2_PROMPT VARCHAR2(80),
59 P_COLUMN3_PROMPT VARCHAR2(80),
60 P_COLUMN4_PROMPT VARCHAR2(80),
61 P_COLUMN5_PROMPT VARCHAR2(80),
62 P_COLUMN6_PROMPT VARCHAR2(80),
63 P_COLUMN7_PROMPT VARCHAR2(80),
64 P_COLUMN8_PROMPT VARCHAR2(80),
65 P_COLUMN9_PROMPT VARCHAR2(80),
66 P_COLUMN10_PROMPT VARCHAR2(80),
67 P_COLUMN11_PROMPT VARCHAR2(80),
68 P_COLUMN12_PROMPT VARCHAR2(80),
69 P_COLUMN13_PROMPT VARCHAR2(80),
70 P_COLUMN14_PROMPT VARCHAR2(80),
71 P_COLUMN15_PROMPT VARCHAR2(80),
72 P_COLUMN16_PROMPT VARCHAR2(80),
73 P_COLUMN17_PROMPT VARCHAR2(80),
74 P_COLUMN18_PROMPT VARCHAR2(80),
75 P_COLUMN19_PROMPT VARCHAR2(80),
76 P_COLUMN20_PROMPT VARCHAR2(80),
77 P_COLUMN21_PROMPT VARCHAR2(80),
78 P_COLUMN22_PROMPT VARCHAR2(80),
79 P_COLUMN23_PROMPT VARCHAR2(80),
80 P_COLUMN24_PROMPT VARCHAR2(80),
81 P_COLUMN25_PROMPT VARCHAR2(80),
82 P_COLUMN26_PROMPT VARCHAR2(80),
83 P_COLUMN27_PROMPT VARCHAR2(80),
84 P_COLUMN28_PROMPT VARCHAR2(80),
85 P_COLUMN29_PROMPT VARCHAR2(80),
86 P_COLUMN30_PROMPT VARCHAR2(80) );
87
88
89
90
91 -- --------------------------------------
92 -- API name : Get_PsigStatus
93 -- Type : Public
94 -- Pre-reqs : None
95 -- Function : Obtains signature status ('PENDING','COMPLETE','ERROR') for a given event
96 -- Parameters
97 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
98 -- p_event_key VARCHAR2 event key, eg ItemNo3125
99 -- OUT : x_psig_status VARCHAR2 event psig status
100 -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status
101 -- ---------------------------------------
102 /*#
103 * This API obtains current e-signature status for an event.
104 * @rep:scope public
105 * @rep:lifecycle active
106 * @rep:displayname Get current e-signature status
107 */
108
109 PROCEDURE Get_PsigStatus (
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 default NULL,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_event_name in varchar2,
116 p_event_key in varchar2,
117 x_psig_status out NOCOPY varchar2 ) ;
118
119
120 -- --------------------------------------
121 -- API name : Is_Psig_Required
122 -- Type : Public
123 -- Pre-reqs : None
124 -- Function : return True/False on signature requirement for a given event
125 -- Parameters
126 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
127 -- p_event_key VARCHAR2 event key, eg ItemNo3125
128 -- OUT : x_psig_required VARCHAR2 event psig status
129 -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_REQUIRED
130 -- ---------------------------------------
131 /*#
132 * This API checks if a signature is required for an event.
133 * @rep:scope public
134 * @rep:lifecycle active
135 * @rep:displayname Determine if the e-signature is required
136 */
137
138 PROCEDURE Is_eSig_Required (
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 default NULL,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_event_name IN varchar2,
145 p_event_key IN varchar2,
146 x_isRequired_eSig OUT NOCOPY VARCHAR2 ) ;
147
148
149 -- --------------------------------------
150 -- API name : Is_eRec_Required
151 -- Type : Public
152 -- Pre-reqs : None
153 -- Function : return True/False on eRecord Requirement for a given event
154 -- Parameters
155 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
156 -- p_event_key VARCHAR2 event key, eg ItemNo3125
157 -- OUT : x_erec_required VARCHAR2 event psig status
158 -- Versions : 1.0 17-Jul-03 created from edr_standard.EREC_REQUIRED
159 -- ---------------------------------------
160 /*#
161 * This API checks if an e-record is required for an event.
162 * @rep:scope public
163 * @rep:lifecycle active
164 * @rep:displayname Determine if the e-record is required
165 */
166
167 PROCEDURE Is_eRec_Required (
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 default NULL,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_event_name IN varchar2,
174 p_event_key IN varchar2,
175 x_isRequired_eRec OUT NOCOPY VARCHAR2 ) ;
176
177
178 -- --------------------------------------
179 -- API name : Get_PsigQuery_Id
180 -- Type : Public
181 -- Pre-reqs : None
182 -- Function : obtain a query id for events based on records of event informations
183 -- Parameters
184 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
185 -- p_event_key VARCHAR2 event key, eg ItemNo3125
186 -- OUT : x_psig_status VARCHAR2 event psig status
187 -- Versions : 1.0 17-Jul-03 created from edr_standard.PSIG_QUERY
188 -- ---------------------------------------
189 /*#
190 * This API obtains a query ID for a list of events passed to the API as p_eventQuery_recTbl.
191 * This API is used in the context of querying the e-record repository.
192 * @rep:scope public
193 * @rep:lifecycle active
194 * @rep:displayname Get query ID
195 */
196
197 Procedure Get_QueryId_OnEvents (
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 default NULL,
200 p_commit IN VARCHAR2 default NULL,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_eventQuery_recTbl IN EventDetail_tbl_type,
205 x_query_id OUT NOCOPY NUMBER );
206
207
208 -- --------------------------------------
209 -- API name : DISPLAY_DATE
210 -- Type : Public
211 -- Pre-reqs : None
212 -- Function : convert a date to string
213 -- Parameters
214 -- IN : p_api_version NUMBER 1.0
215 -- p_init_msg_list VARCHAR2
216 -- p_date_in DATE date that need to be converted
217 -- OUT : x_return_status VARCHAR2
218 -- x_msg_count NUMBER
219 -- x_msg_data VARCHAR2
220 -- x_date_out VARCHAR2 converted date
221 -- Versions : 1.0 17-Jul-03 created from edr_standard.DISPLAY_DATE
222 -- ---------------------------------------
223
224 PROCEDURE DISPLAY_DATE (
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 default NULL,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 P_DATE_IN IN DATE ,
231 x_date_out OUT NOCOPY Varchar2 ) ;
232
233 -- --------------------------------------
234 -- API name : DISPLAY_DATE_ONLY
235 -- Type : Public
236 -- Pre-reqs : None
237 -- Function : convert a date to string
238 -- Parameters
239 -- IN : p_api_version NUMBER 1.0
240 -- p_init_msg_list VARCHAR2
241 -- p_date_in DATE date that need to be converted
242 -- OUT : x_return_status VARCHAR2
243 -- x_msg_count NUMBER
244 -- x_msg_data VARCHAR2
245 -- x_date_out VARCHAR2 converted date
246 -- Versions : 1.0 7-Nov-03 created from edr_standard.DISPLAY_DATE_ONLY
247 -- ---------------------------------------
248
249 PROCEDURE DISPLAY_DATE_ONLY (
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 default NULL,
252 x_return_status OUT NOCOPY VARCHAR2,
253 x_msg_count OUT NOCOPY NUMBER,
254 x_msg_data OUT NOCOPY VARCHAR2,
255 P_DATE_IN IN DATE ,
256 x_date_out OUT NOCOPY Varchar2 ) ;
257 -- --------------------------------------
258 -- API name : DISPLAY_TIME_ONLY
259 -- Type : Public
260 -- Pre-reqs : None
261 -- Function : convert a date to string
262 -- Parameters
263 -- IN : p_api_version NUMBER 1.0
264 -- p_init_msg_list VARCHAR2
265 -- p_date_in DATE date that need to be converted
266 -- OUT : x_return_status VARCHAR2
267 -- x_msg_count NUMBER
268 -- x_msg_data VARCHAR2
269 -- x_date_out VARCHAR2 converted time
270 -- Versions : 1.0 12-Nov-03 created from edr_standard.DISPLAY_TIME_ONLY
271 -- ---------------------------------------
272
273 PROCEDURE DISPLAY_TIME_ONLY (
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 default NULL,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 P_DATE_IN IN DATE ,
280 x_date_out OUT NOCOPY Varchar2 ) ;
281
282
283 -- Bug 3214495 : Start
284
285 -- --------------------------------------
286 -- API name : Get_AmeRule_VarValues
287 -- Type : Public
288 -- Pre-reqs : None
289 -- Function : check if the table column has been audited with a different old value
290 -- Parameters
291 -- IN : p_transaction_name VARCHAR2 transaction name, eg GMI ERES Item Creation
292 -- p_ameRule_id NUMBER AME rule id, eg 11400
293 -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
294 -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
295 -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_AMERULE_INPUT_VALUES
296 -- ---------------------------------------
297
298
299 /*#
300 * This API returns the table of configuration variables for an AME Transaction and Rule.
301 * This API has been deprecated and replaced by GET_AMERULE_VARIABLEVALUES.
302 * @rep:scope public
303 * @rep:lifecycle deprecated
304 * @rep:displayname Get AME rule level configuration values
305 */
306
307
308 PROCEDURE Get_AmeRule_VarValues (
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 default NULL,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_transaction_name IN VARCHAR2,
315 p_ameRule_id IN NUMBER,
316 p_ameRule_name IN VARCHAR2,
317 x_inputVar_values_tbl OUT NOCOPY InputVar_Values_tbl_type ) ;
318
319
320
321 -- --------------------------------------
322 -- API name : Get_AmeRule_VariableValues
323 -- Type : Public
324 -- Pre-reqs : None
325 -- Function : check if the table column has been audited with a different old value
326 -- Parameters
327 -- IN : p_transaction_id VARCHAR2 transaction id, eg oracle.apps.gme.batch.create
328 -- p_ameRule_id NUMBER AME rule id, eg 11400
329 -- p_ameRule_name VARCHAR2 AME rule name, eg Item Creation Rule
330 -- OUT : x_inputVar_values_tbl inputvar_values_tbl_type table of inputVar values
331 -- Versions : 1.0 19-Feb-05 created from edr_standard.GET_AMERULE_INPUT_VALUES
332 -- ---------------------------------------
333
334 /*#
335 * This API returns the table of configuration variables for an AME Transaction and Rule.
336 * @rep:scope public
337 * @rep:lifecycle active
338 * @rep:displayname Get AME rule level configuration values
339 */
340
341 PROCEDURE Get_AmeRule_VariableValues (
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2 default NULL,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_transaction_id IN VARCHAR2,
348 p_ameRule_id IN NUMBER,
349 p_ameRule_name IN VARCHAR2,
350 x_inputVar_values_tbl OUT NOCOPY InputVar_Values_tbl_type ) ;
351
352 -- Bug 3214495 : End
353
354 -- --------------------------------------
355 -- API name : Is_AuditValue_Old
356 -- Type : Public
357 -- Pre-reqs : None
358 -- Function : check if the table column has been audited with a different old value
359 -- Parameters
360 -- IN : p_table_name VARCHAR2 table being audited, eg oracle.apps.gmi.item.create
361 -- p_column_name VARCHAR2 column to be checked, eg ItemNo3125
362 -- p_primKey_name VARCHAR2 name of primary key, eg ItemNo3125
363 -- p_primKey_value VARCHAR2 value of primary key, eg ItemNo3125
364 -- OUT : x_auditValue_old VARCHAR2 indicate if the audited value is updated
365 -- Versions : 1.0 17-Jul-03 created from edr_standard.COMPARE_AUDITVALUES
366 -- ---------------------------------------
367
368 Procedure Is_AuditValue_Old (
369 p_api_version IN NUMBER,
370 p_init_msg_list IN VARCHAR2 default NULL,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2,
374 p_table_name IN VARCHAR2,
375 p_column_name IN VARCHAR2,
376 p_primKey_name IN VARCHAR2,
377 p_primKey_value IN VARCHAR2,
378 x_isOld_auditValue OUT NOCOPY VARCHAR2 );
379
380
381 -- --------------------------------------
382 -- API name : Get_Notif_Routing_Info
383 -- Type : Public
384 -- Pre-reqs : None
385 -- Function : Obtain the overriding recipient and routing comment for a routed notification
386 -- Parameters
387 -- IN : p_original_recipient VARCHAR2 original recipient
388 -- p_message_type VARCHAR2 message type
389 -- p_message_name VARCHAR2 message name
390 -- OUT : x_final_recipient VARCHAR2 final recipient
391 -- x_allrout_comments VARCHAR2 all routing comments
392 -- Versions : 1.0 17-Jul-03 created from edr_standard.FIND_WF_NTF_RECIPIENT
393 -- ---------------------------------------
394
395 PROCEDURE Get_Notif_Routing_Info (
396 p_api_version IN NUMBER,
397 p_init_msg_list IN VARCHAR2 default NULL,
398 x_return_status OUT NOCOPY VARCHAR2,
399 x_msg_count OUT NOCOPY NUMBER,
400 x_msg_data OUT NOCOPY VARCHAR2,
401 p_original_recipient IN VARCHAR2,
402 p_message_type IN VARCHAR2,
403 p_message_name IN VARCHAR2,
404 x_final_recipient OUT NOCOPY VARCHAR2,
405 x_allrout_comments OUT NOCOPY VARCHAR2 );
406
407
408
409 -- --------------------------------------
410 -- API name : Get_DescFlex_OnePrompt
411 -- Type : Public
412 -- Pre-reqs : None
413 -- Function : Obtains a single descriptive flexfield prompt for designated column
414 -- Parameters
415 -- IN : p_application_id NUMBER descriptive flexfield owner application id
416 -- p_descFlex_defName VARCHAR2 name of flexfield definiation
417 -- p_descFlex_context VARCHAR2 flex definition context (ATTRIBUTE_CATEGORY)
418 -- p_column_name VARCHAR2 name of the column corresponding to a flex segment
419 -- p_prompt_type VARCHAR2 indicate the field from which to return values
420 -- 'LEFT' --> FORM_LEFT_PROMPT; 'ABOVE' --> FORM_ABOVE_PROMPT
421 -- OUT : x_column_prompt VARCHAR2 the prompt values for the columns
422 -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_SINGLE_PROMPT
423 -- ---------------------------------------
424
425 PROCEDURE Get_DescFlex_OnePrompt (
426 p_api_version IN NUMBER,
427 p_init_msg_list IN VARCHAR2 default NULL,
428 x_return_status OUT NOCOPY VARCHAR2,
429 x_msg_count OUT NOCOPY NUMBER,
430 x_msg_data OUT NOCOPY VARCHAR2,
431 p_application_id IN NUMBER,
432 p_descFlex_defName IN VARCHAR2,
433 p_descFlex_context IN VARCHAR2,
434 P_COLUMN_NAME IN VARCHAR2,
435 P_PROMPT_TYPE IN VARCHAR2 DEFAULT NULL,
436 x_column_prompt OUT NOCOPY VARCHAR2 );
437
438
439
440 -- --------------------------------------
441 -- API name : Get_DescFlex_AllPrompts
442 -- Type : Public
443 -- Pre-reqs : None
444 -- Function : Obtains all 30 descriptive flexfield prompts
445 -- Parameters
446 -- IN : p_application_id NUMBER descriptive flexfield owner application id
447 -- p_descFlex_defName VARCHAR2 name of flexfield definiation
448 -- p_descFlex_context VARCHAR2 flex definition context (ATTRIBUTE_CATEGORY)
449 -- p_colnNames_rec Flex_ColnName_Rec_Type
450 -- names of the columns corresponding to a flex segment
451 -- p_prompt_type VARCHAR2 indicate the field from which to return values
452 -- 'LEFT': FORM_LEFT_PROMPT; 'ABOVE': FORM_ABOVE_PROMPT
453 -- OUT : x_colnPrompts_rec Flex_ColnPrompt_Rec_Type
454 -- the prompt values for the columns
455 -- Versions : 1.0 17-Jul-03 created from edr_standard.GET_DESC_FLEX_ALL_PROMPTS
456 -- ---------------------------------------
457
458
459 PROCEDURE Get_DescFlex_AllPrompts (
460 p_api_version IN NUMBER,
461 p_init_msg_list IN VARCHAR2 default NULL,
462 x_return_status OUT NOCOPY VARCHAR2,
463 x_msg_count OUT NOCOPY NUMBER,
464 x_msg_data OUT NOCOPY VARCHAR2,
465 p_application_id IN NUMBER,
466 p_descFlex_defName IN VARCHAR2,
467 p_descFlex_context IN VARCHAR2,
468 p_colnNames_rec IN edr_standard_pub.Flex_ColnName_Rec_Type,
469 p_prompt_type IN VARCHAR2 DEFAULT NULL,
470 x_colnPrompts_rec OUT NOCOPY edr_standard_pub.Flex_ColnPrompt_Rec_Type );
471
472
473
474 -- --------------------------------------
475 -- API name : Get_Lookup_Meaning
476 -- Type : Public
477 -- Pre-reqs : None
478 -- Function : Obtains lookup code meaning using fnd_lookups view
479 -- Parameters
480 -- IN : p_lookup_type VARCHAR2 event name, eg oracle.apps.gmi.item.create
481 -- p_lookup_code VARCHAR2 event key, eg ItemNo3125
482 -- OUT : x_psig_status VARCHAR2 event psig status
483 -- Versions : 1.0 17-Jul-03 created from edr_standard.Get_Meaning
484 -- ---------------------------------------
485
486 PROCEDURE Get_Lookup_Meaning (
487 p_api_version IN NUMBER,
488 p_init_msg_list IN VARCHAR2 default NULL,
489 x_return_status OUT NOCOPY VARCHAR2,
490 x_msg_count OUT NOCOPY NUMBER,
491 x_msg_data OUT NOCOPY VARCHAR2,
492 p_lookup_type IN VARCHAR2,
493 p_lookup_code IN VARCHAR2,
494 x_lkup_meaning OUT NOCOPY VARCHAR2 );
495
496
497 -- --------------------------------------
498 -- API name : Get_QueryId_OnParams
499 -- Type : Public
500 -- Pre-reqs : None
501 -- Function : obtain a query id for events based on arrays of event parameters (name, key)
502 -- Parameters
503 -- IN : p_event_name VARCHAR2 event name, eg oracle.apps.gmi.item.create
504 -- p_event_key VARCHAR2 event key, eg ItemNo3125
505 -- OUT : x_query_id NUMBER one query id for all events details
506 -- Versions : 1.0 17-Jul-03 created from edr_standard.Psig_Status
507 -- ---------------------------------------
508
509 PROCEDURE Get_QueryId_OnParams (
510 p_api_version IN NUMBER,
511 p_init_msg_list IN VARCHAR2 default NULL,
512 p_commit IN VARCHAR2 default NULL,
513 x_return_status OUT NOCOPY VARCHAR2,
514 x_msg_count OUT NOCOPY NUMBER,
515 x_msg_data OUT NOCOPY VARCHAR2,
516 p_eventNames_tbl IN FND_TABLE_OF_VARCHAR2_255,
517 p_eventKeys_tbl IN FND_TABLE_OF_VARCHAR2_255,
518 x_query_id OUT NOCOPY NUMBER );
519
520 -- Start of comments
521 -- API name : GET_ERECORD_ID
522 -- Type : public
523 -- Function : accepts event name and event key and returns Latest eRecord ID
524 --
525 -- Pre-reqs : None.
526 -- Parameters :
527 -- IN :p_api_version IN NUMBER Required
528 -- p_init_msg_list IN VARCHAR2 Optional
529 -- Default = FND_API.G_FALSE
530 -- p_event_name IN VARCHAR2 Required
531 -- p_event_key IN VARCHAR2 Required
532 --
533 -- OUT :x_return_status OUT VARCHAR2(1)
534 -- x_msg_count OUT NUMBER
535 -- x_msg_data OUT VARCHAR2(2000)
536 -- x_erecord_id OUT NUMBER
537 --
538 -- Version :Current version 1.0
539 -- Initial version 1.0
540 --
541 -- Notes :
542 --
543 --
544 -- End of comments
545 /*#
546 * This API retreives the latest e-record ID.
547 * @rep:scope public
548 * @rep:lifecycle active
549 * @rep:displayname Retreive the latest e-record ID
550 */
551
552 PROCEDURE GET_ERECORD_ID ( p_api_version IN NUMBER ,
553 p_init_msg_list IN VARCHAR2 default NULL ,
554 x_return_status OUT NOCOPY VARCHAR2 ,
555 x_msg_count OUT NOCOPY NUMBER ,
556 x_msg_data OUT NOCOPY VARCHAR2 ,
557 p_event_name IN VARCHAR2 ,
558 p_event_key IN VARCHAR2 ,
559 x_erecord_id OUT NOCOPY NUMBER );
560
561 --Bug 3437422: Start
562 -- Start of comments
563 -- API name : USER_DATA_XML
564 -- Type : public
565 -- Function : Returns the value of the USER_DATA node in the
566 -- XML payload of any ERES Event
567 --
568 -- Pre-reqs : None.
569 -- Parameters :
570 -- OUT :x_user_data OUT VARCHAR2(2000)
571 --
572 -- Version :Current version 1.0
573 -- Initial version 1.0
574 --
575 -- Notes :
576 --
577 --
578 -- End of comments
579 PROCEDURE USER_DATA_XML (X_USER_DATA OUT NOCOPY VARCHAR2);
580 --Bug 3437422: End
581
582 -- Bug 3848049 : Start
583
584 -- API name : GET_ERECORD_ID
585 -- Type : public
586 -- Function : Accepts event name and event key and returns Latest
587 -- eRecord ID
588 --
589 -- Pre-reqs : None.
590 -- Parameters :
591 -- IN : p_event_name IN VARCHAR2 Required
592 -- p_event_key IN VARCHAR2 Required
593 --
594 -- Return Paramter
595 -- erecord_id Return Number
596 --
597 -- Version :Current version 1.0
598 -- Initial version 1.0
599 --
600 -- Notes :
601 --
602 --
603 -- End of comments
604
605
606
607 FUNCTION GET_ERECORD_ID ( p_event_name IN VARCHAR2,
608 p_event_key IN VARCHAR2) return NUMBER;
609 -- Bug 3848049 : End
610
611
612
613 END EDR_STANDARD_PUB;