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_UTIL_SS dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 20: ota_Training_plan_members tpm

16: is
17:
18: Cursor any_child is
19: Select tpm.training_plan_member_id from
20: ota_Training_plan_members tpm
21: where member_status_type_id<>'CANCELLED'
22: and training_plan_id=p_training_plan_id and rownum=1;
23:
24: l_proc VARCHAR2(72) := g_package ||'chk_cancel_plan_ok';

Line 54: ota_Training_plan_members tpm

50: IS
51:
52: Cursor any_child is
53: Select tpm.training_plan_member_id from
54: ota_Training_plan_members tpm
55: where member_status_type_id<>'CANCELLED'
56: and member_status_type_id<>'OTA_COMPLETED'
57: and training_plan_id=p_training_plan_id and rownum=1;
58:

Line 61: ota_training_plan_members tpm

57: and training_plan_id=p_training_plan_id and rownum=1;
58:
59: Cursor one_child_completed is
60: Select tpm.training_plan_member_id from
61: ota_training_plan_members tpm
62: where member_status_type_id='OTA_COMPLETED'
63: and training_plan_id=p_training_plan_id and rownum=1;
64:
65: l_proc VARCHAR2(72) := g_package ||'chk_complete_plan_ok';

Line 97: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)

93: -- ---------------------------------------------------------------------------
94: --
95: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
96: p_contact_id IN ota_training_plans.contact_id%TYPE,
97: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)
98: RETURN VARCHAR2 IS
99:
100:
101: CURSOR enroll_status IS

Line 103: FROM ota_training_plan_members tpm,

99:
100:
101: CURSOR enroll_status IS
102: SELECT DECODE(bst.type,'C','Z',bst.type) status
103: FROM ota_training_plan_members tpm,
104: ota_events evt,
105: ota_delegate_bookings tdb,
106: ota_booking_status_types bst,
107: ota_training_plans tps

Line 205: -- ,p_source_function in ota_training_plan_members.source_function%type

201: -- ---------------------------------------------------------------------------
202: --
203:
204: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE
205: -- ,p_source_function in ota_training_plan_members.source_function%type
206: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
207: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
208: -- Added for Bug#3108246
209: ,p_business_group_id IN number)

Line 206: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE

202: --
203:
204: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE
205: -- ,p_source_function in ota_training_plan_members.source_function%type
206: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
207: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
208: -- Added for Bug#3108246
209: ,p_business_group_id IN number)
210: RETURN number

Line 207: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE

203:
204: FUNCTION chk_src_func_tlntmgt(p_person_id IN ota_training_plans.person_id%TYPE
205: -- ,p_source_function in ota_training_plan_members.source_function%type
206: ,p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE
207: ,p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE
208: -- Added for Bug#3108246
209: ,p_business_group_id IN number)
210: RETURN number
211: IS

Line 262: FROM ota_training_plan_members tpm

258:
259: CURSOR csr_attached_TPC
260: IS
261: SELECT tpm.training_plan_member_id
262: FROM ota_training_plan_members tpm
263: WHERE tpm.activity_version_id = p_activity_version_id
264: AND (tpm.earliest_start_date < p_start_date
265: or (p_end_date IS NOT NULL AND tpm.target_completion_date > p_end_date))
266: and tpm.member_status_type_id <> 'CANCELLED'

Line 296: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)

292: -- ---------------------------------------------------------------------------
293:
294: FUNCTION chk_enrollment_exist ( p_person_id IN ota_training_plans.person_id%TYPE,
295: p_contact_id IN ota_training_plans.contact_id%TYPE,
296: p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE)
297: RETURN boolean
298: IS
299: CURSOR chk_enr IS
300: SELECT NULL

Line 305: ota_training_plan_members tpm

301: FROM ota_events e,
302: ota_activity_versions a,
303: ota_delegate_bookings b,
304: ota_booking_status_types s,
305: ota_training_plan_members tpm
306: WHERE e.event_id = b.event_id
307: AND tpm.activity_version_id = a.activity_version_id
308: AND ((e.course_start_date >= tpm.earliest_start_date
309: AND e.course_end_date <= tpm.target_completion_date )

Line 356: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

352: -- overrules 'C'.
353:
354: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
355: p_contact_id IN ota_training_plans.contact_id%TYPE,
356: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
357: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
358: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
359: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
360: p_action IN VARCHAR2)

Line 357: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

353:
354: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
355: p_contact_id IN ota_training_plans.contact_id%TYPE,
356: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
357: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
358: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
359: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
360: p_action IN VARCHAR2)
361: RETURN VARCHAR2 IS

Line 358: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,

354: FUNCTION get_enroll_status(p_person_id IN ota_training_plans.person_id%TYPE,
355: p_contact_id IN ota_training_plans.contact_id%TYPE,
356: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
357: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
358: p_activity_version_id IN ota_training_plan_members.activity_version_id%TYPE,
359: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
360: p_action IN VARCHAR2)
361: RETURN VARCHAR2 IS
362:

Line 454: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

450: --
451:
452: PROCEDURE modify_tpc_status_on_create(--p_person_id IN ota_training_plans.person_id%TYPE,
453: -- p_contact_id IN ota_training_plans.contact_id%TYPE,
454: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
455: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
456: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
457: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
458: p_member_status_id OUT nocopy VARCHAR2)

Line 455: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

451:
452: PROCEDURE modify_tpc_status_on_create(--p_person_id IN ota_training_plans.person_id%TYPE,
453: -- p_contact_id IN ota_training_plans.contact_id%TYPE,
454: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
455: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
456: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
457: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
458: p_member_status_id OUT nocopy VARCHAR2)
459: IS

Line 517: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,

513: -- ---------------------------------------------------------------------------
514: --
515:
516: PROCEDURE modify_tpc_status_on_update(--p_person_id IN ota_training_plans.person_id%TYPE,
517: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
518: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
519: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
520: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
521: p_member_status_id OUT nocopy VARCHAR2)

Line 518: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,

514: --
515:
516: PROCEDURE modify_tpc_status_on_update(--p_person_id IN ota_training_plans.person_id%TYPE,
517: p_earliest_start_date IN ota_training_plan_members.earliest_start_date%TYPE,
518: p_target_completion_date IN ota_training_plan_members.target_completion_date%TYPE,
519: p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
520: p_training_plan_id IN ota_training_plans.training_plan_id%TYPE,
521: p_member_status_id OUT nocopy VARCHAR2)
522: IS

Line 608: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE

604: -- |---------------------------< get_valid_enroll >-------------------------|
605: -- ----------------------------------------------------------------------------
606: PROCEDURE get_valid_enroll (p_person_id IN ota_training_plans.person_id%TYPE
607: , p_contact_id IN ota_training_plans.contact_id%TYPE
608: ,p_training_plan_member_id IN ota_training_plan_members.training_plan_member_id%TYPE
609: ,p_return_status OUT nocopy VARCHAR2)
610: IS
611: l_evt_type VARCHAR2(30);
612: l_proc VARCHAR2(72) := g_package|| 'get_valid_enroll';