1 package jumf_lct_pkg as
2 /* $Header: JTFUMLSS.pls 120.0 2005/09/26 14:04:58 vimohan noship $ */
3 procedure LOAD_SEED_TEMPLATES(
4 x_upload_mode in varchar2,
5 x_template_name in varchar2,
6 x_description in varchar2,
7 x_owner in varchar2,
8 x_template_key in varchar2,
9 x_page_name in varchar2,
10 x_template_handler in varchar2,
11 x_template_type_code in varchar2,
12 x_enabled_flag in varchar2,
13 x_application_id in varchar2,
14 x_effective_start_date in varchar2,
15 x_effective_end_date in varchar2,
16 x_last_update_date in varchar2,
17 x_custom_mode in varchar2
18 );
19
20
21
22 procedure LOAD_SEED_APPROVALS(
23 x_upload_mode in varchar2,
24 x_approval_key in varchar2,
25 x_approval_key_start_date in varchar2,
26 x_approval_name in varchar2,
27 x_description in varchar2,
28 x_owner in varchar2,
29 x_enabled_flag in varchar2,
30 x_application_id in varchar2,
31 x_wf_item_type in varchar2,
32 x_use_pending_req_flag in varchar2,
33 x_effective_end_date in varchar2,
34 x_last_update_date in varchar2,
35 x_custom_mode in varchar2 );
36
37 procedure LOAD_SEED_APPROVERS(
38 x_upload_mode in varchar2,
39 x_effective_start_date in varchar2,
40 x_approval_key_start_date in varchar2,
41 x_user_name in varchar2,
42 x_approval_key in varchar2,
43 x_approver_seq in varchar2,
44 x_effective_end_date in varchar2,
45 x_owner in varchar2,
46 x_last_update_date in varchar2,
47 x_custom_mode in varchar2
48 );
49
50
51 procedure LOAD_SEED_USERTYPES(
52 x_upload_mode in varchar2,
53 x_usertype_key in varchar2,
54 x_usertype_key_start_date in varchar2,
55 x_usertype_name in varchar2,
56 x_usertype_shortname in varchar2,
57 x_description in varchar2,
58 x_owner in varchar2,
59 x_is_self_service_flag in varchar2,
60 x_email_notification_flag in varchar2,
61 x_enabled_flag in varchar2,
62 x_approval_key in varchar2,
63 x_approval_key_start_date in varchar2,
64 x_application_id in varchar2,
65 x_effective_end_date in varchar2,
66 x_display_order in varchar2,
67 x_last_update_date in varchar2,
68 x_custom_mode in varchar2
69 );
70
71
72 procedure LOAD_SEED_USERTYPE_TMPL(
73 x_upload_mode in varchar2,
74 x_usertype_key in varchar2,
75 x_usertype_key_start_date in varchar2,
76 x_template_key in varchar2,
77 x_template_key_start_date in varchar2,
78 x_effective_start_date in varchar2,
79 x_effective_end_date in varchar2,
80 x_owner in varchar2,
81 x_last_update_date in varchar2,
82 x_custom_mode in varchar2
83 );
84
85 procedure LOAD_SEED_USERTYPE_ROLE(
86 x_upload_mode in varchar2,
87 x_usertype_key in varchar2,
88 x_usertype_key_start_date in varchar2,
89 x_principal_name in varchar2,
90 x_effective_start_date in varchar2,
91 x_effective_end_date in varchar2,
92 x_owner in varchar2,
93 x_last_update_date in varchar2,
94 x_custom_mode in varchar2
95 );
96
97
98 procedure LOAD_SEED_USERTYPE_RESP(
99 x_upload_mode in varchar2,
100 x_usertype_key in varchar2,
101 x_usertype_key_start_date in varchar2,
102 x_responsibility_key in varchar2,
103 x_effective_start_date in varchar2,
104 x_is_default_flag in varchar2,
105 x_effective_end_date in varchar2,
106 x_owner in varchar2,
107 x_application_id in varchar2,
108 x_last_update_date in varchar2,
109 x_custom_mode in varchar2
110 );
111
112
113 procedure LOAD_SEED_SUBSCRIPTIONS(
114 x_upload_mode in varchar2,
115 x_subscription_key in varchar2,
116 x_subscription_key_start_date in varchar2,
117 x_subscription_name in varchar2,
118 x_description in varchar2,
119 x_owner in varchar2,
120 x_availability_code in varchar2,
121 x_logon_display_frequency in varchar2,
122 x_parent_subscription_key in varchar2,
123 x_parent_key_start_date in varchar2,
124 x_application_id in varchar2,
125 x_enabled_flag in varchar2,
126 x_approval_key in varchar2,
127 x_approval_key_start_date in varchar2,
128 x_auth_delegation_role_id in varchar2,
129 x_effective_end_date in varchar2,
130 x_last_update_date in varchar2,
131 x_custom_mode in varchar2
132 );
133
134
135 procedure LOAD_SEED_SUBSCRIPTION_TMPL(
136 x_upload_mode in varchar2,
137 x_subscription_key in varchar2,
138 x_subscription_key_start_date in varchar2,
139 x_template_key in varchar2,
140 x_template_key_start_date in varchar2,
141 x_effective_start_date in varchar2,
142 x_effective_end_date in varchar2,
143 x_owner in varchar2,
144 x_last_update_date in varchar2,
145 x_custom_mode in varchar2
146 );
147
148
149 procedure LOAD_SEED_SUBSCR_USERTYPE(
150 x_upload_mode in varchar2,
151 x_subscription_key in varchar2,
152 x_subscription_key_start_date in varchar2,
153 x_usertype_key in varchar2,
154 x_usertype_key_start_date in varchar2,
155 x_effective_start_date in varchar2,
156 x_subscription_flag in varchar2,
157 x_subscription_display_order in varchar2,
158 x_effective_end_date in varchar2,
159 x_owner in varchar2,
160 x_last_update_date in varchar2,
161 x_custom_mode in varchar2
162 );
163
164
165
166 procedure LOAD_SEED_SUBSCRIPTION_ROLE(
167 x_upload_mode in varchar2,
168 x_subscription_key in varchar2,
169 x_subscription_key_start_date in varchar2,
170 x_principal_name in varchar2,
171 x_effective_start_date in varchar2,
172 x_effective_end_date in varchar2,
173 x_owner in varchar2,
174 x_last_update_date in varchar2,
175 x_custom_mode in varchar2
176 );
177
178
179
180 procedure LOAD_SEED_SUBSCRIPTION_RESP(
181 x_upload_mode in varchar2,
182 x_subscription_key in varchar2,
183 x_subscription_key_start_date in varchar2,
184 x_responsibility_key in varchar2,
185 x_effective_start_date in varchar2,
186 x_effective_end_date in varchar2,
187 x_owner in varchar2,
188 x_application_id in varchar2,
189 x_last_update_date in varchar2,
190 x_custom_mode in varchar2
191 );
192 end jumf_lct_pkg;