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_LRNG_PATH_UTIL dependencies on OTA_LEARNING_PATHS

Line 131: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,

127: --
128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130:
131: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
132: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
133: RETURN number;
134:
135:

Line 132: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130:
131: FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
132: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
133: RETURN number;
134:
135:
136: -- ----------------------------------------------------------------------------

Line 168: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)

164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166:
167: FUNCTION get_no_of_completed_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
168: p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
169: RETURN number;
170:
171: -- ---------------------------------------------------------------------------
172: -- |----------------------< Update_lpe_lpm_changes >--------------------------|

Line 205: --p_path_source_code IN ota_learning_paths.path_source_code%TYPE,

201: -- ---------------------------------------------------------------------------
202:
203: Procedure Update_lpe_lpm_changes( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
204: --Modified for Bug#3891087
205: --p_path_source_code IN ota_learning_paths.path_source_code%TYPE,
206: p_completion_target_date IN ota_lp_enrollments.completion_target_date%TYPE,
207: p_return_status OUT NOCOPY VARCHAR2);
208:
209: -- ---------------------------------------------------------------------------

Line 245: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE

241: -- ---------------------------------------------------------------------------
242: --
243:
244: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
245: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
246: ,p_source_id IN ota_learning_paths.source_id%TYPE
247: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
248: ,p_business_group_id IN NUMBER)
249: RETURN NUMBER;

Line 246: ,p_source_id IN ota_learning_paths.source_id%TYPE

242: --
243:
244: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
245: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
246: ,p_source_id IN ota_learning_paths.source_id%TYPE
247: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
248: ,p_business_group_id IN NUMBER)
249: RETURN NUMBER;
250:

Line 247: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE

243:
244: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
245: ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
246: ,p_source_id IN ota_learning_paths.source_id%TYPE
247: ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
248: ,p_business_group_id IN NUMBER)
249: RETURN NUMBER;
250:
251:

Line 285: p_person_id IN ota_learning_paths.person_id%TYPE,

281: -- {End Of Comments}
282: -- ----------------------------------------------------------------------------
283:
284: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
285: p_person_id IN ota_learning_paths.person_id%TYPE,
286: p_contact_id IN ota_learning_paths.contact_id%TYPE)
287: RETURN number;
288:
289: Function is_path_successful(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)

Line 286: p_contact_id IN ota_learning_paths.contact_id%TYPE)

282: -- ----------------------------------------------------------------------------
283:
284: FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
285: p_person_id IN ota_learning_paths.person_id%TYPE,
286: p_contact_id IN ota_learning_paths.contact_id%TYPE)
287: RETURN number;
288:
289: Function is_path_successful(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
290: return varchar2;