eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_CHATS_B

Line 225: p_chat_id in ota_chats_b.chat_id%type,

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,
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:

Line 226: p_public_flag ota_chats_b.public_flag%type,

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,
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:

Line 227: p_start_date_active in ota_chats_b.start_date_active%type,

223: p_person_id in per_people_f.person_id%type,
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(

Line 233: p_chat_id in ota_chats_b.chat_id%type,

229:
230:
231: function learner_can_enroll_in_chat(
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:

Line 234: p_public_flag ota_chats_b.public_flag%type,

230:
231: function learner_can_enroll_in_chat(
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:

Line 235: p_start_date_active in ota_chats_b.start_date_active%type,

231: function learner_can_enroll_in_chat(
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(

Line 241: p_chat_id in ota_chats_b.chat_id%type,

237:
238:
239: function emp_can_enroll_in_chat(
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:

Line 242: p_public_flag ota_chats_b.public_flag%type,

238:
239: function emp_can_enroll_in_chat(
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:

Line 243: p_start_date_active in ota_chats_b.start_date_active%type,

239: function emp_can_enroll_in_chat(
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(

Line 249: p_chat_id in ota_chats_b.chat_id%type,

245:
246:
247: function ext_can_enroll_in_chat(
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:

Line 250: p_public_flag ota_chats_b.public_flag%type,

246:
247: function ext_can_enroll_in_chat(
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:

Line 251: p_start_date_active in ota_chats_b.start_date_active%type,

247: function ext_can_enroll_in_chat(
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(

Line 258: p_chat_id in ota_chats_b.chat_id%type,

254:
255: function lrn_can_self_enroll_in_chat(
256: p_person_id in per_people_f.person_id%type,
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:

Line 259: p_public_flag ota_chats_b.public_flag%type,

255: function lrn_can_self_enroll_in_chat(
256: p_person_id in per_people_f.person_id%type,
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:

Line 260: p_start_date_active in ota_chats_b.start_date_active%type,

256: p_person_id in per_people_f.person_id%type,
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(

Line 266: p_chat_id in ota_chats_b.chat_id%type,

262:
263:
264: function emp_can_self_enroll_in_chat(
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:

Line 267: p_public_flag ota_chats_b.public_flag%type,

263:
264: function emp_can_self_enroll_in_chat(
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:

Line 268: p_start_date_active in ota_chats_b.start_date_active%type,

264: function emp_can_self_enroll_in_chat(
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(

Line 274: p_chat_id in ota_chats_b.chat_id%type,

270:
271:
272: function ext_can_self_enroll_in_chat(
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:

Line 275: p_public_flag ota_chats_b.public_flag%type,

271:
272: function ext_can_self_enroll_in_chat(
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(

Line 276: p_start_date_active in ota_chats_b.start_date_active%type,

272: function ext_can_self_enroll_in_chat(
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,