1 PACKAGE JTF_DAC_ROLE_PERMS_PKG AS
2 /* $Header: jtfarps.pls 120.2 2005/10/25 05:15:39 psanyal ship $ */
3
4 /* for return status */
5 ERROR_STATUS CONSTANT NUMBER := -1;
6 OKAY_STATUS CONSTANT NUMBER := 0;
7
8 procedure INSERT_ROW(
9 X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10 x_role_perm_id in number,
11 x_role_id in number,
12 x_permission_id in number,
13 x_base_object in varchar2,
14 x_base_object_type in varchar2,
15 x_start_active_date in date,
16 x_end_active_date in date,
17 x_object_version_number in number,
18 X_CREATION_DATE in DATE,
19 X_CREATED_BY in NUMBER,
20 X_LAST_UPDATE_DATE in DATE,
21 X_LAST_UPDATED_BY in NUMBER,
22 X_LAST_UPDATE_LOGIN in NUMBER
23 );
24
25 procedure UPDATE_ROW (
26 x_role_perm_id in number,
27 x_role_id in number,
28 x_permission_id in number,
29 x_base_object in varchar2,
30 x_base_object_type in varchar2,
31 x_start_active_date in date,
32 x_end_active_date in date,
33 x_object_version_number in number,
34 X_LAST_UPDATE_DATE in DATE,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_LOGIN in NUMBER
37 );
38
39 PROCEDURE TRANSLATE_ROW(
40 x_role_perm_id in number,
41 x_role_id in number,
42 x_permission_id in number,
43 x_base_object in varchar2,
44 x_base_object_type in varchar2,
45 x_start_active_date in date,
46 x_end_active_date in date,
47 x_object_version_number in number,
48 x_owner in varchar2
49 );
50
51 PROCEDURE LOAD_ROW(
52 x_role_perm_id in number,
53 x_role_id in number,
54 x_permission_id in number,
55 x_base_object in varchar2,
56 x_base_object_type in varchar2,
57 x_start_active_date in date,
58 x_end_active_date in date,
59 x_object_version_number in number,
60 x_owner in varchar2
61 );
62
63 end JTF_DAC_ROLE_PERMS_PKG;