1 PACKAGE IEM_ARCH_REQUESTS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemarqvs.pls 115.0 2003/08/20 21:37:27 sboorela noship $ */
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table IEM_ARCH_REQUESTS
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2
12 -- p_commit IN VARCHAR2
13 --
14 -- OUT
15 -- x_return_status OUT VARCHAR2
16 -- x_msg_count OUT NUMBER
17 -- x_msg_data OUT VARCHAR2
18 --
19 -- Version : 1.0
20 -- Notes :
21 --
22 -- End of comments
23 -- **********************************************************
24
25 PROCEDURE create_item (p_api_version_number IN NUMBER,
26 p_init_msg_list IN VARCHAR2 ,
27 p_commit IN VARCHAR2 ,
28 p_request_id in number,
29 p_arch_criteria IN VARCHAR2,
30 p_email_account_id IN NUMBER,
31 p_folder_name IN VARCHAR2,
32 p_request IN VARCHAR2,
33 p_arch_folder_id IN NUMBER,
34 p_arch_count IN NUMBER,
35 p_CREATED_BY IN NUMBER,
36 p_CREATION_DATE IN DATE,
37 p_LAST_UPDATED_BY IN NUMBER ,
38 p_LAST_UPDATE_DATE IN DATE,
39 p_LAST_UPDATE_LOGIN IN NUMBER ,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2
43 );
44
45 -- Start of Comments
46 -- API name : update_item
47 -- Type : Private
48 -- Function : This procedure updates a record in the table IEM_ARCH_REQUESTS
49 -- Pre-reqs : None.
50 -- Parameters :
51 -- IN
52 -- p_api_version_number IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2
54 -- p_commit IN VARCHAR2
55 -- p_request_id in number,
56 -- p_arch_folder_id in number,
57 -- p_arch_count in number,
58 -- p_arch_size in number,
59 -- p_status in varchar2,
60 -- p_comment in varchar2,
61
62 -- OUT
63 -- x_return_status OUT VARCHAR2
64 -- x_msg_count OUT NUMBER
65 -- x_msg_data OUT VARCHAR2
66 --
67 -- Version : 1.0
68 -- Notes :
69 --
70 -- End of comments
71 -- **********************************************************
72
73 PROCEDURE update_item(p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2 ,
75 p_commit IN VARCHAR2 ,
76 p_request_id in number,
77 p_arch_folder_id in number,
78 p_arch_count in number,
79 p_arch_size in number,
80 p_status in varchar2,
81 p_comment in varchar2,
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2
85 );
86
87 END IEM_ARCH_REQUESTS_PVT;