[Home] [Help]
PACKAGE: APPS.IBE_MSITE_RESP_PKG
Source
1 PACKAGE Ibe_Msite_Resp_Pkg AUTHID CURRENT_USER AS
2 /* $Header: IBETMRSS.pls 115.4 2003/09/02 21:35:07 jqu ship $ */
3
4 -- HISTORY
5 -- 12/13/02 SCHAK Modified for NOCOPY (Bug # 2691704) Changes.
6 -- 07/28/03 JQU
7 -- Modified procedures for addition of group_code column
8 -- *********************************************************************************
9
10 PROCEDURE insert_row
11 (
12 p_msite_resp_id IN NUMBER,
13 p_object_version_number IN NUMBER,
14 p_msite_id IN NUMBER,
15 p_responsibility_id IN NUMBER,
16 p_application_id IN NUMBER,
17 p_start_date_active IN DATE,
18 p_end_date_active IN DATE,
19 p_sort_order IN NUMBER,
20 p_display_name IN VARCHAR2,
21 p_group_code IN VARCHAR2 default null,
22 p_creation_date IN DATE,
23 p_created_by IN NUMBER,
24 p_last_update_date IN DATE,
25 p_last_updated_by IN NUMBER,
26 p_last_update_login IN NUMBER,
27 x_rowid OUT NOCOPY VARCHAR2,
28 x_msite_resp_id OUT NOCOPY NUMBER
29 );
30
31 PROCEDURE update_row
32 (
33 p_msite_resp_id IN NUMBER,
34 p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
35 p_start_date_active IN DATE,
36 p_end_date_active IN DATE,
37 p_sort_order IN NUMBER,
38 p_display_name IN VARCHAR2,
39 p_group_code IN VARCHAR2 default null,
40 p_last_update_date IN DATE,
41 p_last_updated_by IN NUMBER,
42 p_last_update_login IN NUMBER
43 );
44
45 PROCEDURE delete_row
46 (
47 p_msite_resp_id IN NUMBER
48 ) ;
49
50 PROCEDURE add_language;
51
52 END Ibe_Msite_Resp_Pkg;