1 PACKAGE IES_ANSWERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: iesvieas.pls 115.5 2002/12/09 21:13:35 appldev ship $ */
3
4 PROCEDURE Insert_Answer
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_lookup_id IN NUMBER ,
14 p_answer_value IN VARCHAR2 ,
15 p_display_value IN VARCHAR2 ,
16 p_answer_order IN NUMBER ,
17 p_answer_active IN NUMBER ,
18 p_active_status IN NUMBER ,
19 x_answer_id OUT NOCOPY NUMBER
20 ) ;
21
22 PROCEDURE Update_Answer
23 ( p_api_version IN NUMBER := 1 ,
24 p_init_msg_list IN VARCHAR2 := 'DUMMY VAL' ,
25 p_commit IN VARCHAR2 := 'DUMMY VAL' ,
26 p_validation_level IN NUMBER := 1 ,
27 x_return_status OUT NOCOPY VARCHAR2 ,
28 x_msg_count OUT NOCOPY NUMBER ,
29 x_msg_data OUT NOCOPY VARCHAR2 ,
30 p_answer_id IN NUMBER ,
31 p_last_updated_by IN NUMBER ,
32 p_answer_value IN VARCHAR2 ,
33 p_display_value IN VARCHAR2 ,
34 p_answer_order IN NUMBER ,
35 p_answer_active IN NUMBER ,
36 p_active_status IN NUMBER ,
37 x_answer_id OUT NOCOPY NUMBER
38 ) ;
39 END;