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_LEARNING_PATHS

Line 111: p_learning_path_id in ota_learning_paths.learning_path_id%type,

107:
108: function learner_can_enroll_in_path(
109: p_person_id in per_people_f.person_id%type,
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:

Line 112: p_public_flag ota_learning_paths.public_flag%type,

108: function learner_can_enroll_in_path(
109: p_person_id in per_people_f.person_id%type,
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:

Line 113: p_start_date_active in ota_learning_paths.start_date_active%type,

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

Line 119: p_learning_path_id in ota_learning_paths.learning_path_id%type,

115:
116:
117: function learner_can_enroll_in_path(
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:

Line 120: p_public_flag ota_learning_paths.public_flag%type,

116:
117: function learner_can_enroll_in_path(
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:

Line 121: p_start_date_active in ota_learning_paths.start_date_active%type,

117: function learner_can_enroll_in_path(
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(

Line 127: p_learning_path_id in ota_learning_paths.learning_path_id%type,

123:
124:
125: function emp_can_enroll_in_path(
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:

Line 128: p_public_flag ota_learning_paths.public_flag%type,

124:
125: function emp_can_enroll_in_path(
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:

Line 129: p_start_date_active in ota_learning_paths.start_date_active%type,

125: function emp_can_enroll_in_path(
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(

Line 135: p_learning_path_id in ota_learning_paths.learning_path_id%type,

131:
132:
133: function ext_can_enroll_in_path(
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:

Line 136: p_public_flag ota_learning_paths.public_flag%type,

132:
133: function ext_can_enroll_in_path(
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:

Line 137: p_start_date_active in ota_learning_paths.start_date_active%type,

133: function ext_can_enroll_in_path(
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(

Line 144: p_learning_path_id in ota_learning_paths.learning_path_id%type,

140:
141: function lrn_can_self_enroll_in_path(
142: p_person_id in per_people_f.person_id%type,
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:

Line 145: p_public_flag ota_learning_paths.public_flag%type,

141: function lrn_can_self_enroll_in_path(
142: p_person_id in per_people_f.person_id%type,
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:

Line 146: p_start_date_active in ota_learning_paths.start_date_active%type,

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

Line 152: p_learning_path_id in ota_learning_paths.learning_path_id%type,

148:
149:
150: function emp_can_self_enroll_in_path(
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:

Line 153: p_public_flag ota_learning_paths.public_flag%type,

149:
150: function emp_can_self_enroll_in_path(
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:

Line 154: p_start_date_active in ota_learning_paths.start_date_active%type,

150: function emp_can_self_enroll_in_path(
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(

Line 160: p_learning_path_id in ota_learning_paths.learning_path_id%type,

156:
157:
158: function ext_can_self_enroll_in_path(
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:

Line 161: p_public_flag ota_learning_paths.public_flag%type,

157:
158: function ext_can_self_enroll_in_path(
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(

Line 162: p_start_date_active in ota_learning_paths.start_date_active%type,

158: function ext_can_self_enroll_in_path(
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,

Line 337: p_learning_path_id in ota_learning_paths.learning_path_id%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
339: ,p_party_id in hz_parties.party_id%type) return varchar2;
340:
341: function learner_can_enroll_in_cert(