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_LP_ENROLLMENTS

Line 29: Function chk_complete_path_ok(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)

25: -- Internal Development Use Only.
26: --
27: -- {End Of Comments}
28: -- ---------------------------------------------------------------------------
29: Function chk_complete_path_ok(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
30: return varchar2;
31:
32: -- ---------------------------------------------------------------------------
33: -- |----------------------< chk_login_person >--------------------------|

Line 59: FUNCTION chk_login_person ( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)

55: --
56: -- {End Of Comments}
57: -- ---------------------------------------------------------------------------
58:
59: FUNCTION chk_login_person ( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
60: RETURN VARCHAR2;
61: -- ----------------------------------------------------------------------------
62: -- |---------------------------------------------------------------|
63: -- ----------------------------------------------------------------------------

Line 91: FUNCTION get_person_id(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)

87: --
88: -- {End Of Comments}
89: -- ----------------------------------------------------------------------------
90:
91: FUNCTION get_person_id(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
92: RETURN number;
93:
94: -- ---------------------------------------------------------------------------
95: -- |----------------------< complete_path >--------------------------|

Line 99: PROCEDURE complete_path(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type);

95: -- |----------------------< complete_path >--------------------------|
96: -- ---------------------------------------------------------------------------
97: --
98:
99: PROCEDURE complete_path(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type);
100:
101: -- ----------------------------------------------------------------------------
102: -- |---------------------- -----------------------|
103: -- ----------------------------------------------------------------------------

Line 167: FUNCTION get_no_of_completed_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,

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

Line 203: Procedure Update_lpe_lpm_changes( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,

199: --
200: -- {End Of Comments}
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);

Line 206: p_completion_target_date IN ota_lp_enrollments.completion_target_date%TYPE,

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: -- ---------------------------------------------------------------------------
210: -- |----------------------< get_lpe_crse_compl_status_msg >--------------------------|

Line 244: FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE

240: -- |----------------------< get_talent_mgmt_lp >--------------------------|
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)

Line 289: Function is_path_successful(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_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;
291:
292: Procedure Start_comp_proc_success_attnd(p_person_id in number ,
293: p_event_id in ota_Events.event_id%type);

Line 296: FUNCTION get_no_of_mand_compl_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)

292: Procedure Start_comp_proc_success_attnd(p_person_id in number ,
293: p_event_id in ota_Events.event_id%type);
294:
295: -- Added this function for Bug# 7430475
296: FUNCTION get_no_of_mand_compl_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
297: RETURN number;
298:
299: function get_lp_current_status(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
300: return varchar2 ;

Line 299: function get_lp_current_status(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)

295: -- Added this function for Bug# 7430475
296: FUNCTION get_no_of_mand_compl_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
297: RETURN number;
298:
299: function get_lp_current_status(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
300: return varchar2 ;
301:
302: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
303: p_person_id IN ota_lp_enrollments.person_id%type,

Line 303: p_person_id IN ota_lp_enrollments.person_id%type,

299: function get_lp_current_status(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
300: return varchar2 ;
301:
302: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
303: p_person_id IN ota_lp_enrollments.person_id%type,
304: p_contact_id ota_lp_enrollments.contact_id%type)
305: return ota_lp_enrollments.lp_enrollment_id%type;
306:
307: END ota_lrng_path_util;

Line 304: p_contact_id ota_lp_enrollments.contact_id%type)

300: return varchar2 ;
301:
302: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
303: p_person_id IN ota_lp_enrollments.person_id%type,
304: p_contact_id ota_lp_enrollments.contact_id%type)
305: return ota_lp_enrollments.lp_enrollment_id%type;
306:
307: END ota_lrng_path_util;
308:

Line 305: return ota_lp_enrollments.lp_enrollment_id%type;

301:
302: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
303: p_person_id IN ota_lp_enrollments.person_id%type,
304: p_contact_id ota_lp_enrollments.contact_id%type)
305: return ota_lp_enrollments.lp_enrollment_id%type;
306:
307: END ota_lrng_path_util;
308: