1 PACKAGE Jtf_Msite_Prty_Accss_Pkg AUTHID CURRENT_USER AS
2 /* $Header: JTFTMPRS.pls 115.1 2001/03/02 19:07:34 pkm ship $ */
3
4 PROCEDURE insert_row
5 (
6 p_msite_prty_accss_id IN NUMBER,
7 p_object_version_number IN NUMBER,
8 p_msite_id IN NUMBER,
9 p_party_id IN NUMBER,
10 p_start_date_active IN DATE,
11 p_end_date_active IN DATE,
12 p_security_group_id IN NUMBER,
13 p_creation_date IN DATE,
14 p_created_by IN NUMBER,
15 p_last_update_date IN DATE,
16 p_last_updated_by IN NUMBER,
17 p_last_update_login IN NUMBER,
18 x_rowid OUT VARCHAR2,
19 x_msite_prty_accss_id OUT NUMBER
20 );
21
22 PROCEDURE update_row
23 (
24 p_msite_prty_accss_id IN NUMBER,
25 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
26 p_start_date_active IN DATE,
27 p_end_date_active IN DATE,
28 p_security_group_id IN NUMBER,
29 p_last_update_date IN DATE,
30 p_last_updated_by IN NUMBER,
31 p_last_update_login IN NUMBER
32 );
33
34 PROCEDURE delete_row
35 (
36 p_msite_prty_accss_id IN NUMBER
37 ) ;
38
39 END Jtf_Msite_Prty_Accss_Pkg;