1 PACKAGE IES_LOOKUPS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesviels.pls 115.6 2002/12/09 21:13:42 appldev ship $ */
3
4 PROCEDURE Insert_Lookup
5 ( p_api_version IN NUMBER := 1 ,
6 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
7 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
8 p_validation_level IN NUMBER := 1 ,
9 x_return_status OUT NOCOPY VARCHAR2 ,
10 x_msg_count OUT NOCOPY NUMBER ,
11 x_msg_data OUT NOCOPY VARCHAR2 ,
12 p_created_by IN NUMBER ,
13 p_dscript_id IN NUMBER ,
14 p_lookup_table_id IN NUMBER ,
15 p_lookup_name IN VARCHAR2 ,
16 p_active_status IN NUMBER ,
17 x_lookup_id OUT NOCOPY NUMBER
18 );
19
20 PROCEDURE Update_Lookup
21 ( p_api_version IN NUMBER := 1 ,
22 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
23 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
24 p_validation_level IN NUMBER := 1 ,
25 x_return_status OUT NOCOPY VARCHAR2 ,
26 x_msg_count OUT NOCOPY NUMBER ,
27 x_msg_data OUT NOCOPY VARCHAR2 ,
28 p_lookup_id IN NUMBER ,
29 p_lookup_table_id IN NUMBER ,
30 p_last_updated_by IN NUMBER ,
31 p_lookup_name IN VARCHAR2 ,
32 p_active_status IN NUMBER ,
33 x_lookup_id OUT NOCOPY NUMBER
34 );
35 END;