1 PACKAGE JTF_DAC_ROLE_PERM_CRIT_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfapcs.pls 120.2 2005/10/25 05:14:36 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_crit_id in number,
11 x_role_perm_id in number,
12 x_criteria_id in number,
13 x_jtf_auth_principal_id in number,
14 x_jtf_auth_permission_id in number,
15 x_principal_name in varchar2,
16 x_permission_name in varchar2,
17 x_base_object in varchar2,
18 x_base_object_type in varchar2,
19 x_start_active_date in date,
20 x_end_active_date in date,
21 x_property_name in varchar2,
22 x_operator in varchar2,
23 x_property_value in varchar2,
24 x_property_value_type in varchar2,
25 x_object_version_number in number,
26 X_CREATION_DATE in DATE,
27 X_CREATED_BY in NUMBER,
28 X_LAST_UPDATE_DATE in DATE,
29 X_LAST_UPDATED_BY in NUMBER,
30 X_LAST_UPDATE_LOGIN in NUMBER
31 );
32
33 procedure UPDATE_ROW (
34 x_role_perm_crit_id in number,
35 x_role_perm_id in number,
36 x_criteria_id in number,
37 x_jtf_auth_principal_id in number,
38 x_jtf_auth_permission_id in number,
39 x_principal_name in varchar2,
40 x_permission_name in varchar2,
41 x_base_object in varchar2,
42 x_base_object_type in varchar2,
43 x_start_active_date in date,
44 x_end_active_date in date,
45 x_property_name in varchar2,
46 x_operator in varchar2,
47 x_property_value in varchar2,
48 x_property_value_type in varchar2,
49 x_object_version_number in number,
50 X_LAST_UPDATE_DATE in DATE,
51 X_LAST_UPDATED_BY in NUMBER,
52 X_LAST_UPDATE_LOGIN in NUMBER
53 );
54
55 PROCEDURE TRANSLATE_ROW(
56 x_role_perm_crit_id in number,
57 x_role_perm_id in number,
58 x_criteria_id in number,
59 x_jtf_auth_principal_id in number,
60 x_jtf_auth_permission_id in number,
61 x_principal_name in varchar2,
62 x_permission_name in varchar2,
63 x_base_object in varchar2,
64 x_base_object_type in varchar2,
65 x_start_active_date in date,
66 x_end_active_date in date,
67 x_property_name in varchar2,
68 x_operator in varchar2,
69 x_property_value in varchar2,
70 x_property_value_type in varchar2,
71 x_object_version_number in number,
72 x_owner in varchar2
73 );
74
75 PROCEDURE LOAD_ROW(
76 x_role_perm_crit_id in number,
77 x_role_perm_id in number,
78 x_criteria_id in number,
79 x_jtf_auth_principal_id in number,
80 x_jtf_auth_permission_id in number,
81 x_principal_name in varchar2,
82 x_permission_name in varchar2,
83 x_base_object in varchar2,
84 x_base_object_type in varchar2,
85 x_start_active_date in date,
86 x_end_active_date in date,
87 x_property_name in varchar2,
88 x_operator in varchar2,
89 x_property_value in varchar2,
90 x_property_value_type in varchar2,
91 x_object_version_number in number,
92 x_owner in varchar2
93 );
94
95 end JTF_DAC_ROLE_PERM_CRIT_PKG;