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_TRNG_PLAN_COMP_SS dependencies on HR_API

Line 207: AND (tpm.target_completion_date

203: -- AND odb.delegate_person_id = tp.person_id
204: AND (odb.delegate_person_id = tp.person_id OR odb.delegate_contact_id = tp.contact_id)
205: AND oe.event_id = p_event_id
206: AND tpm.member_status_type_id NOT IN ('CANCELLED', 'OTA_AWAITING_APPROVAL','OTA_COMPLETED')
207: AND (tpm.target_completion_date 208: or tpm.earliest_start_date > nvl(p_course_end_date, hr_api.g_eot)) ;
209: */
210:
211: l_proc VARCHAR2(72) := g_package|| 'update_tpc_evt_date_change';

Line 208: or tpm.earliest_start_date > nvl(p_course_end_date, hr_api.g_eot)) ;

204: AND (odb.delegate_person_id = tp.person_id OR odb.delegate_contact_id = tp.contact_id)
205: AND oe.event_id = p_event_id
206: AND tpm.member_status_type_id NOT IN ('CANCELLED', 'OTA_AWAITING_APPROVAL','OTA_COMPLETED')
207: AND (tpm.target_completion_date 208: or tpm.earliest_start_date > nvl(p_course_end_date, hr_api.g_eot)) ;
209: */
210:
211: l_proc VARCHAR2(72) := g_package|| 'update_tpc_evt_date_change';
212: l_enroll_status VARCHAR2(30);

Line 250: ,p_validate IN NUMBER DEFAULT hr_api.g_false_num

246: -- |---------------------------< validate_TPC >-------------------------|
247: -- ----------------------------------------------------------------------------
248: Procedure validate_tpc
249: ( p_mode in varchar2
250: ,p_validate IN NUMBER DEFAULT hr_api.g_false_num
251: ,p_effective_date IN date
252: ,p_business_group_id IN number
253: ,p_training_plan_id IN number
254: ,p_activity_version_id IN NUMBER DEFAULT NULL