1 PACKAGE EDR_ADHOC_USER_PVT AUTHID CURRENT_USER AS
2 /* $Header: EDRVADHS.pls 120.0.12000000.1 2007/01/18 05:56:04 appldev ship $
3
4 /* Constants declared */
5 -- constants
6 G_ACTION_REQD constant varchar2(1) := 'Y';
7 G_NO_ACTION_REQD constant varchar2(1) := 'N';
8 G_PKG_NAME constant varchar2(30) := 'EDR_ADHOC_USER_PVT';
9
10 -- Start of comments
11 -- API name : UPDATE_SIGNERLIST
12 -- Type : Private
13 -- Function : Update the signer list when new approvers are added.
14 -- Pre-reqs : None.
15 -- Parameters :
16 -- IN : p_event_id IN number
17 -- p_event_name IN VARCHAR2
18 -- p_document_id IN number
19 -- p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255
20 -- p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255
21 -- p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255
22 -- p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255
23 -- p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255
24 -- p_originating_system IN FND_TABLE_OF_VARCHAR2_255
25 -- p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255
26 -- OUT : x_error OUT NUMBER
27 -- x_error_msg OUT VARCHAR2
28 -- End of comments
29
30 -- Bug 2674799: start
31 -- Added signersequence as a new parameter for sequence number use.
32
33 procedure UPDATE_SIGNERLIST (
34 p_event_id IN number,
35 p_event_name IN VARCHAR2 ,
36 p_document_id IN number,
37 p_originalrecipient IN FND_TABLE_OF_VARCHAR2_255,
38 p_finalrecipient IN FND_TABLE_OF_VARCHAR2_255,
39 p_overridingdetails IN FND_TABLE_OF_VARCHAR2_255,
40 p_signaturesequence IN FND_TABLE_OF_VARCHAR2_255,
41 p_recipientdisplayname IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
42 p_originating_system IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
43 p_orignating_system_id IN FND_TABLE_OF_VARCHAR2_255 DEFAULT NULL,
44 x_error OUT NOCOPY NUMBER,
45 x_error_msg OUT NOCOPY VARCHAR2
46 ) ;
47
48 -- Bug 2674799: end
49
50 END EDR_ADHOC_USER_PVT;
[Home] [Help]