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_FORUMS_B

Line 168: p_forum_id in ota_forums_b.forum_id%type,

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

Line 169: p_public_flag ota_forums_b.public_flag%type,

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

Line 170: p_start_date_active in ota_forums_b.start_date_active%type,

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

Line 176: p_forum_id in ota_forums_b.forum_id%type,

172:
173:
174: function learner_can_enroll_in_forum(
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:

Line 177: p_public_flag ota_forums_b.public_flag%type,

173:
174: function learner_can_enroll_in_forum(
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:

Line 178: p_start_date_active in ota_forums_b.start_date_active%type,

174: function learner_can_enroll_in_forum(
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(

Line 184: p_forum_id in ota_forums_b.forum_id%type,

180:
181:
182: function emp_can_enroll_in_forum(
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:

Line 185: p_public_flag ota_forums_b.public_flag%type,

181:
182: function emp_can_enroll_in_forum(
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:

Line 186: p_start_date_active in ota_forums_b.start_date_active%type,

182: function emp_can_enroll_in_forum(
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(

Line 192: p_forum_id in ota_forums_b.forum_id%type,

188:
189:
190: function ext_can_enroll_in_forum(
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:

Line 193: p_public_flag ota_forums_b.public_flag%type,

189:
190: function ext_can_enroll_in_forum(
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:

Line 194: p_start_date_active in ota_forums_b.start_date_active%type,

190: function ext_can_enroll_in_forum(
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(

Line 201: p_forum_id in ota_forums_b.forum_id%type,

197:
198: function lrn_can_self_enroll_in_forum(
199: p_person_id in per_people_f.person_id%type,
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:

Line 202: p_public_flag ota_forums_b.public_flag%type,

198: function lrn_can_self_enroll_in_forum(
199: p_person_id in per_people_f.person_id%type,
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:

Line 203: p_start_date_active in ota_forums_b.start_date_active%type,

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

Line 209: p_forum_id in ota_forums_b.forum_id%type,

205:
206:
207: function emp_can_self_enroll_in_forum(
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:

Line 210: p_public_flag ota_forums_b.public_flag%type,

206:
207: function emp_can_self_enroll_in_forum(
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:

Line 211: p_start_date_active in ota_forums_b.start_date_active%type,

207: function emp_can_self_enroll_in_forum(
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(

Line 217: p_forum_id in ota_forums_b.forum_id%type,

213:
214:
215: function ext_can_self_enroll_in_forum(
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:

Line 218: p_public_flag ota_forums_b.public_flag%type,

214:
215: function ext_can_self_enroll_in_forum(
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(

Line 219: p_start_date_active in ota_forums_b.start_date_active%type,

215: function ext_can_self_enroll_in_forum(
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,