APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_CATEGORY_USAGES

Line 95: p_category_usage_id in ota_category_usages.category_usage_id%type) return varchar2;

91:
92: function learner_can_see_category(
93: p_person_id in per_people_f.person_id%type,
94: p_party_id in hz_parties.party_id%type,
95: p_category_usage_id in ota_category_usages.category_usage_id%type) return varchar2;
96:
97:
98: function learner_can_see_course(
99: p_person_id in per_people_f.person_id%type,

Line 114: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

110: p_party_id in hz_parties.party_id%type,
111: p_learning_path_id in ota_learning_paths.learning_path_id%type,
112: p_public_flag ota_learning_paths.public_flag%type,
113: p_start_date_active in ota_learning_paths.start_date_active%type,
114: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
115:
116:
117: function learner_can_enroll_in_path(
118: p_user_id in fnd_user.user_id%type,

Line 122: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

118: p_user_id in fnd_user.user_id%type,
119: p_learning_path_id in ota_learning_paths.learning_path_id%type,
120: p_public_flag ota_learning_paths.public_flag%type,
121: p_start_date_active in ota_learning_paths.start_date_active%type,
122: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
123:
124:
125: function emp_can_enroll_in_path(
126: p_person_id in per_people_f.person_id%type,

Line 130: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

126: p_person_id in per_people_f.person_id%type,
127: p_learning_path_id in ota_learning_paths.learning_path_id%type,
128: p_public_flag ota_learning_paths.public_flag%type,
129: p_start_date_active in ota_learning_paths.start_date_active%type,
130: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
131:
132:
133: function ext_can_enroll_in_path(
134: p_party_id in hz_parties.party_id%type,

Line 138: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

134: p_party_id in hz_parties.party_id%type,
135: p_learning_path_id in ota_learning_paths.learning_path_id%type,
136: p_public_flag ota_learning_paths.public_flag%type,
137: p_start_date_active in ota_learning_paths.start_date_active%type,
138: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
139:
140:
141: function lrn_can_self_enroll_in_path(
142: p_person_id in per_people_f.person_id%type,

Line 147: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

143: p_party_id in hz_parties.party_id%type,
144: p_learning_path_id in ota_learning_paths.learning_path_id%type,
145: p_public_flag ota_learning_paths.public_flag%type,
146: p_start_date_active in ota_learning_paths.start_date_active%type,
147: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
148:
149:
150: function emp_can_self_enroll_in_path(
151: p_person_id in per_people_f.person_id%type,

Line 155: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

151: p_person_id in per_people_f.person_id%type,
152: p_learning_path_id in ota_learning_paths.learning_path_id%type,
153: p_public_flag ota_learning_paths.public_flag%type,
154: p_start_date_active in ota_learning_paths.start_date_active%type,
155: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
156:
157:
158: function ext_can_self_enroll_in_path(
159: p_party_id in hz_parties.party_id%type,

Line 163: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

159: p_party_id in hz_parties.party_id%type,
160: p_learning_path_id in ota_learning_paths.learning_path_id%type,
161: p_public_flag ota_learning_paths.public_flag%type,
162: p_start_date_active in ota_learning_paths.start_date_active%type,
163: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
164:
165: function learner_can_enroll_in_forum(
166: p_person_id in per_people_f.person_id%type,
167: p_party_id in hz_parties.party_id%type,

Line 171: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

167: p_party_id in hz_parties.party_id%type,
168: p_forum_id in ota_forums_b.forum_id%type,
169: p_public_flag ota_forums_b.public_flag%type,
170: p_start_date_active in ota_forums_b.start_date_active%type,
171: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
172:
173:
174: function learner_can_enroll_in_forum(
175: p_user_id in fnd_user.user_id%type,

Line 179: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

175: p_user_id in fnd_user.user_id%type,
176: p_forum_id in ota_forums_b.forum_id%type,
177: p_public_flag ota_forums_b.public_flag%type,
178: p_start_date_active in ota_forums_b.start_date_active%type,
179: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
180:
181:
182: function emp_can_enroll_in_forum(
183: p_person_id in per_people_f.person_id%type,

Line 187: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

183: p_person_id in per_people_f.person_id%type,
184: p_forum_id in ota_forums_b.forum_id%type,
185: p_public_flag ota_forums_b.public_flag%type,
186: p_start_date_active in ota_forums_b.start_date_active%type,
187: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
188:
189:
190: function ext_can_enroll_in_forum(
191: p_party_id in hz_parties.party_id%type,

Line 195: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

191: p_party_id in hz_parties.party_id%type,
192: p_forum_id in ota_forums_b.forum_id%type,
193: p_public_flag ota_forums_b.public_flag%type,
194: p_start_date_active in ota_forums_b.start_date_active%type,
195: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
196:
197:
198: function lrn_can_self_enroll_in_forum(
199: p_person_id in per_people_f.person_id%type,

Line 204: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

200: p_party_id in hz_parties.party_id%type,
201: p_forum_id in ota_forums_b.forum_id%type,
202: p_public_flag ota_forums_b.public_flag%type,
203: p_start_date_active in ota_forums_b.start_date_active%type,
204: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
205:
206:
207: function emp_can_self_enroll_in_forum(
208: p_person_id in per_people_f.person_id%type,

Line 212: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

208: p_person_id in per_people_f.person_id%type,
209: p_forum_id in ota_forums_b.forum_id%type,
210: p_public_flag ota_forums_b.public_flag%type,
211: p_start_date_active in ota_forums_b.start_date_active%type,
212: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
213:
214:
215: function ext_can_self_enroll_in_forum(
216: p_party_id in hz_parties.party_id%type,

Line 220: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

216: p_party_id in hz_parties.party_id%type,
217: p_forum_id in ota_forums_b.forum_id%type,
218: p_public_flag ota_forums_b.public_flag%type,
219: p_start_date_active in ota_forums_b.start_date_active%type,
220: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
221:
222: function learner_can_enroll_in_chat(
223: p_person_id in per_people_f.person_id%type,
224: p_party_id in hz_parties.party_id%type,

Line 228: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

224: p_party_id in hz_parties.party_id%type,
225: p_chat_id in ota_chats_b.chat_id%type,
226: p_public_flag ota_chats_b.public_flag%type,
227: p_start_date_active in ota_chats_b.start_date_active%type,
228: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
229:
230:
231: function learner_can_enroll_in_chat(
232: p_user_id in fnd_user.user_id%type,

Line 236: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

232: p_user_id in fnd_user.user_id%type,
233: p_chat_id in ota_chats_b.chat_id%type,
234: p_public_flag ota_chats_b.public_flag%type,
235: p_start_date_active in ota_chats_b.start_date_active%type,
236: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
237:
238:
239: function emp_can_enroll_in_chat(
240: p_person_id in per_people_f.person_id%type,

Line 244: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

240: p_person_id in per_people_f.person_id%type,
241: p_chat_id in ota_chats_b.chat_id%type,
242: p_public_flag ota_chats_b.public_flag%type,
243: p_start_date_active in ota_chats_b.start_date_active%type,
244: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
245:
246:
247: function ext_can_enroll_in_chat(
248: p_party_id in hz_parties.party_id%type,

Line 252: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

248: p_party_id in hz_parties.party_id%type,
249: p_chat_id in ota_chats_b.chat_id%type,
250: p_public_flag ota_chats_b.public_flag%type,
251: p_start_date_active in ota_chats_b.start_date_active%type,
252: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
253:
254:
255: function lrn_can_self_enroll_in_chat(
256: p_person_id in per_people_f.person_id%type,

Line 261: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

257: p_party_id in hz_parties.party_id%type,
258: p_chat_id in ota_chats_b.chat_id%type,
259: p_public_flag ota_chats_b.public_flag%type,
260: p_start_date_active in ota_chats_b.start_date_active%type,
261: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
262:
263:
264: function emp_can_self_enroll_in_chat(
265: p_person_id in per_people_f.person_id%type,

Line 269: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

265: p_person_id in per_people_f.person_id%type,
266: p_chat_id in ota_chats_b.chat_id%type,
267: p_public_flag ota_chats_b.public_flag%type,
268: p_start_date_active in ota_chats_b.start_date_active%type,
269: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
270:
271:
272: function ext_can_self_enroll_in_chat(
273: p_party_id in hz_parties.party_id%type,

Line 277: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

273: p_party_id in hz_parties.party_id%type,
274: p_chat_id in ota_chats_b.chat_id%type,
275: p_public_flag ota_chats_b.public_flag%type,
276: p_start_date_active in ota_chats_b.start_date_active%type,
277: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
278:
279: function learner_can_enroll_in_cert(
280: p_person_id in per_people_f.person_id%type,
281: p_party_id in hz_parties.party_id%type,

Line 285: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

281: p_party_id in hz_parties.party_id%type,
282: p_certification_id in ota_certifications_b.certification_id%type,
283: p_public_flag ota_certifications_b.public_flag%type,
284: p_start_date_active in ota_certifications_b.start_date_active%type,
285: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
286:
287:
288: function learner_can_enroll_in_cert(
289: p_user_id in fnd_user.user_id%type,

Line 293: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

289: p_user_id in fnd_user.user_id%type,
290: p_certification_id in ota_certifications_b.certification_id%type,
291: p_public_flag ota_certifications_b.public_flag%type,
292: p_start_date_active in ota_certifications_b.start_date_active%type,
293: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
294:
295:
296: function emp_can_enroll_in_cert(
297: p_person_id in per_people_f.person_id%type,

Line 301: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

297: p_person_id in per_people_f.person_id%type,
298: p_certification_id in ota_certifications_b.certification_id%type,
299: p_public_flag ota_certifications_b.public_flag%type,
300: p_start_date_active in ota_certifications_b.start_date_active%type,
301: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
302:
303:
304: function ext_can_enroll_in_cert(
305: p_party_id in hz_parties.party_id%type,

Line 309: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

305: p_party_id in hz_parties.party_id%type,
306: p_certification_id in ota_certifications_b.certification_id%type,
307: p_public_flag ota_certifications_b.public_flag%type,
308: p_start_date_active in ota_certifications_b.start_date_active%type,
309: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
310:
311:
312: function lrn_can_self_enroll_in_cert(
313: p_person_id in per_people_f.person_id%type,

Line 318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

314: p_party_id in hz_parties.party_id%type,
315: p_certification_id in ota_certifications_b.certification_id%type,
316: p_public_flag ota_certifications_b.public_flag%type,
317: p_start_date_active in ota_certifications_b.start_date_active%type,
318: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
319:
320:
321: function emp_can_self_enroll_in_cert(
322: p_person_id in per_people_f.person_id%type,

Line 326: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

322: p_person_id in per_people_f.person_id%type,
323: p_certification_id in ota_certifications_b.certification_id%type,
324: p_public_flag ota_certifications_b.public_flag%type,
325: p_start_date_active in ota_certifications_b.start_date_active%type,
326: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
327:
328:
329: function ext_can_self_enroll_in_cert(
330: p_party_id in hz_parties.party_id%type,

Line 334: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;

330: p_party_id in hz_parties.party_id%type,
331: p_certification_id in ota_certifications_b.certification_id%type,
332: p_public_flag ota_certifications_b.public_flag%type,
333: p_start_date_active in ota_certifications_b.start_date_active%type,
334: p_category_usage_id in ota_category_usages.category_usage_id%type default null) return varchar2;
335:
336: function learner_can_enroll_in_path(
337: p_learning_path_id in ota_learning_paths.learning_path_id%TYPE
338: ,p_person_id in per_all_people_f.person_id%type