1 PACKAGE Jtf_Msite_Resp_Pkg AUTHID CURRENT_USER AS
2 /* $Header: JTFTMRSS.pls 115.4 2004/07/09 18:51:25 applrt ship $ */
3
4 PROCEDURE insert_row
5 (
6 p_msite_resp_id IN NUMBER,
7 p_object_version_number IN NUMBER,
8 p_msite_id IN NUMBER,
9 p_responsibility_id IN NUMBER,
10 p_application_id IN NUMBER,
11 p_start_date_active IN DATE,
12 p_end_date_active IN DATE,
13 p_sort_order IN NUMBER,
14 p_security_group_id IN NUMBER,
15 p_display_name IN VARCHAR2,
16 p_creation_date IN DATE,
17 p_created_by IN NUMBER,
18 p_last_update_date IN DATE,
19 p_last_updated_by IN NUMBER,
20 p_last_update_login IN NUMBER,
21 x_rowid OUT VARCHAR2,
22 x_msite_resp_id OUT NUMBER
23 );
24
25 PROCEDURE update_row
26 (
27 p_msite_resp_id IN NUMBER,
28 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
29 p_start_date_active IN DATE,
30 p_end_date_active IN DATE,
31 p_sort_order IN NUMBER,
32 p_security_group_id IN NUMBER,
33 p_display_name IN VARCHAR2,
34 p_last_update_date IN DATE,
35 p_last_updated_by IN NUMBER,
36 p_last_update_login IN NUMBER
37 );
38
39 PROCEDURE delete_row
40 (
41 p_msite_resp_id IN NUMBER
42 ) ;
43
44 PROCEDURE add_language;
45
46 END Jtf_Msite_Resp_Pkg;