1 package PV_BENFT_USER_ROLE_MAPS_PKG as
2 /* $Header: pvxtulms.pls 120.0 2005/07/11 23:13:10 appldev noship $ */
3
4 procedure INSERT_ROW (
5 px_user_role_map_id IN OUT NOCOPY NUMBER,
6 px_object_version_number IN OUT NOCOPY NUMBER,
7 p_benefit_type in VARCHAR2,
8 p_user_role_code in VARCHAR2,
9 p_external_flag in VARCHAR2,
10 p_creation_date in DATE,
11 p_created_by in NUMBER,
12 p_last_update_date in DATE,
13 p_last_updated_by in NUMBER,
14 p_last_update_login in NUMBER);
15
16 procedure LOCK_ROW (
17 p_user_role_map_id in NUMBER,
18 p_object_version_number in NUMBER,
19 p_benefit_type in VARCHAR2,
20 p_user_role_code in VARCHAR2,
21 p_external_flag in VARCHAR2
22 );
23
24 procedure UPDATE_ROW (
25 p_user_role_map_id in NUMBER,
26 p_object_version_number in NUMBER,
27 p_benefit_type in VARCHAR2,
28 p_user_role_code in VARCHAR2,
29 p_external_flag in VARCHAR2,
30 p_last_update_date in DATE,
31 p_last_updated_by in NUMBER,
32 p_last_update_login in NUMBER
33 );
34
35 procedure DELETE_ROW (
36 p_user_role_map_id in NUMBER
37 );
38
39 procedure LOAD_ROW (
40 p_upload_mode IN VARCHAR2,
41 p_user_role_map_id IN NUMBER,
42 p_object_version_number IN NUMBER,
43 p_benefit_type IN VARCHAR2,
44 p_user_role_code IN VARCHAR2,
45 p_external_flag IN VARCHAR2,
46 p_owner IN VARCHAR2
47 );
48 end PV_BENFT_USER_ROLE_MAPS_PKG;