1 PACKAGE IEM_ARCH_DTLS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemardvs.pls 115.0 2003/08/20 21:38:31 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_source_message_id IN jtf_varchar2_Table_100,
30 p_CREATED_BY IN NUMBER,
31 p_CREATION_DATE IN DATE,
32 p_LAST_UPDATED_BY IN NUMBER ,
33 p_LAST_UPDATE_DATE IN DATE,
34 p_LAST_UPDATE_LOGIN IN NUMBER ,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2
38 );
39
40 END IEM_ARCH_DTLS_PVT;