1 package JTF_UM_ROLE_RESP_PKG as
2 /* $Header: JTFUMRRS.pls 120.3 2005/11/28 08:50:54 vimohan ship $ */
3
4 procedure INSERT_USERTYPE_ROLE_ROW (
5 x_usertype_id IN NUMBER,
6 x_principal_name IN VARCHAR2,
7 x_effective_start_date IN DATE,
8 x_effective_end_date IN DATE,
9 x_creation_date IN DATE,
10 x_created_by IN NUMBER,
11 x_last_update_date IN DATE,
12 x_last_updated_by IN NUMBER,
13 x_last_update_login IN NUMBER);
14
15 procedure UPDATE_USERTYPE_ROLE_ROW (
16 x_usertype_id IN NUMBER,
17 x_principal_name IN VARCHAR2,
18 x_effective_end_date IN DATE,
19 x_last_update_date IN DATE,
20 x_last_updated_by IN NUMBER,
21 x_last_update_login IN NUMBER);
22
23 procedure LOAD_USERTYPE_ROLE_ROW (
24 x_usertype_id IN NUMBER,
25 x_principal_name IN VARCHAR2,
26 x_effective_start_date IN DATE,
27 x_effective_end_date IN DATE,
28 x_owner IN VARCHAR2,
29 x_last_update_date in varchar2 default NULL,
30 X_CUSTOM_MODE in varchar2 default NULL
31 );
32
33 procedure INSERT_USERTYPE_RESP_ROW (
34 x_usertype_id IN NUMBER,
35 x_responsibility_key IN VARCHAR2,
36 x_is_default_flag IN VARCHAR2,
37 x_effective_start_date IN DATE,
38 x_effective_end_date IN DATE,
39 x_creation_date IN DATE,
40 x_created_by IN NUMBER,
41 x_last_update_date IN DATE,
42 x_last_updated_by IN NUMBER,
43 x_last_update_login IN NUMBER,
44 x_application_id IN NUMBER);
45
46 procedure UPDATE_USERTYPE_RESP_ROW (
47 x_usertype_id IN NUMBER,
48 x_responsibility_key IN VARCHAR2,
49 x_is_default_flag IN VARCHAR2,
50 x_effective_end_date IN DATE,
51 x_last_update_date IN DATE,
52 x_last_updated_by IN NUMBER,
53 x_last_update_login IN NUMBER,
54 x_application_id IN NUMBER);
55
56 procedure LOAD_USERTYPE_RESP_ROW (
57 x_usertype_id IN NUMBER,
58 x_responsibility_key IN VARCHAR2,
59 x_is_default_flag IN VARCHAR2,
60 x_effective_start_date IN DATE,
61 x_effective_end_date IN DATE,
62 x_owner IN VARCHAR2,
63 x_application_id IN NUMBER,
64 x_last_update_date in varchar2 default NULL,
65 x_custom_mode in varchar2 default NULL
66 );
67
68 procedure INSERT_SUBSCRIPTION_ROLE_ROW (
69 x_subscription_id IN NUMBER,
70 x_principal_name IN VARCHAR2,
71 x_effective_start_date IN DATE,
72 x_effective_end_date IN DATE,
73 x_creation_date IN DATE,
74 x_created_by IN NUMBER,
75 x_last_update_date IN DATE,
76 x_last_updated_by IN NUMBER,
77 x_last_update_login IN NUMBER);
78
79 procedure UPDATE_SUBSCRIPTION_ROLE_ROW (
80 x_subscription_id IN NUMBER,
81 x_principal_name IN VARCHAR2,
82 x_effective_end_date IN DATE,
83 x_last_update_date IN DATE,
84 x_last_updated_by IN NUMBER,
85 x_last_update_login IN NUMBER);
86
87 procedure LOAD_SUBSCRIPTION_ROLE_ROW (
88 x_subscription_id IN NUMBER,
89 x_principal_name IN VARCHAR2,
90 x_effective_start_date IN DATE,
91 x_effective_end_date IN DATE,
92 x_owner IN VARCHAR2,
93 x_last_update_date in varchar2 default NULL,
94 x_custom_mode in varchar2 default NULL
95 );
96
97 procedure INSERT_SUBSCRIPTION_RESP_ROW (
98 x_subscription_id IN NUMBER,
99 x_responsibility_key IN VARCHAR2,
100 x_effective_start_date IN DATE,
101 x_effective_end_date IN DATE,
102 x_creation_date IN DATE,
103 x_created_by IN NUMBER,
104 x_last_update_date IN DATE,
105 x_last_updated_by IN NUMBER,
106 x_last_update_login IN NUMBER,
107 x_application_id IN NUMBER);
108
109 procedure UPDATE_SUBSCRIPTION_RESP_ROW (
110 x_subscription_id IN NUMBER,
111 x_responsibility_key IN VARCHAR2,
112 x_effective_end_date IN DATE,
113 x_last_update_date IN DATE,
114 x_last_updated_by IN NUMBER,
115 x_last_update_login IN NUMBER,
116 x_application_id IN NUMBER);
117
118 procedure LOAD_SUBSCRIPTION_RESP_ROW (
119 x_subscription_id IN NUMBER,
120 x_responsibility_key IN VARCHAR2,
121 x_effective_start_date IN DATE,
122 x_effective_end_date IN DATE,
123 x_owner IN VARCHAR2,
124 x_application_id IN NUMBER,
125 x_last_update_date in varchar2 default NULL,
126 X_CUSTOM_MODE in varchar2 default NULL
127 );
128
129 end JTF_UM_ROLE_RESP_PKG;