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 OTA_TRAINING_PLAN_MEMBERS

Line 32: FROM ota_training_plan_members otpm,

28: CURSOR csr_tpm_info(csr_activity_version_id number, csr_evt_start_date date,csr_evt_end_date date,csr_evt_type varchar2) IS
29: SELECT otpm.training_plan_member_id,
30: otpm.object_version_number,otpm.earliest_start_date, otpm.target_completion_date
31: -- otpm.member_status_type_id
32: FROM ota_training_plan_members otpm,
33: ota_training_plans otp
34: WHERE otp.training_plan_id = otpm.training_plan_id
35: -- AND otp.person_id = p_person_id
36: AND (( p_person_id IS NOT NULL AND otp.person_id = p_person_id)

Line 64: l_member_status_type ota_training_plan_members.member_status_type_id%TYPE;

60: l_evt_end_date DATE;
61: l_activity_version_id NUMBER(9);
62: l_evt_type VARCHAR2(30);
63: l_enroll_type varchar2(30);
64: l_member_status_type ota_training_plan_members.member_status_type_id%TYPE;
65: /* l_exists ota_training_plan_members.training_plan_member_id%TYPE;
66: l_name ota_training_plans.name%type;
67: l_object_version_number ota_training_plans.object_version_number%type;
68: l_time_period_id ota_training_plans.time_period_id%type;

Line 65: /* l_exists ota_training_plan_members.training_plan_member_id%TYPE;

61: l_activity_version_id NUMBER(9);
62: l_evt_type VARCHAR2(30);
63: l_enroll_type varchar2(30);
64: l_member_status_type ota_training_plan_members.member_status_type_id%TYPE;
65: /* l_exists ota_training_plan_members.training_plan_member_id%TYPE;
66: l_name ota_training_plans.name%type;
67: l_object_version_number ota_training_plans.object_version_number%type;
68: l_time_period_id ota_training_plans.time_period_id%type;
69: l_budget_currency ota_training_plans.budget_currency%type;

Line 192: ota_training_plan_members tpm,

188: -- Modified for Bug#3479186
189: tp.contact_id,
190: tpm.object_version_number
191: FROM ota_training_plans tp,
192: ota_training_plan_members tpm,
193: ota_events oe,
194: ota_delegate_bookings odb,
195: ota_booking_status_types bst
196: WHERE oe.event_id = odb.event_id

Line 428: p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type,

424: -- ---------------------------------------------------------------------------
425: --
426:
427: Procedure Update_tpc_sshr_change(
428: p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type,
429: p_person_id ota_training_plans.person_id%type,
430: p_mode varchar2)
431: is
432:

Line 436: ota_training_plan_members

432:
433: Cursor get_tpc_detail
434: is
435: Select object_version_number from
436: ota_training_plan_members
437: where training_plan_member_id=p_training_plan_member_id;
438:
439: l_enroll_type varchar2(30);
440: l_object_version_number Number(9);

Line 495: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type)

491: --
492: -- This procedure will get called only when a tpc is Cancelled
493: /*
494: Procedure Update_tp_tpc_change
495: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type)
496: is
497:
498: --get all the TP corresponding to a particular TP member
499: CURSOR csr_tp_with_tpc

Line 504: ota_training_plan_members otpm

500: IS
501: SELECT otp.training_plan_id
502: , otp.plan_status_type_id
503: FROM ota_training_plans otp,
504: ota_training_plan_members otpm
505: WHERE otp.training_plan_id=otpm.training_plan_id
506: and otp.plan_status_type_id <> 'CANCELLED'
507: --and otp.plan_status_type_id <> 'COMPLETED'
508: -- Modified from COMPLETED to OTA_COMPLETED

Line 516: FROM ota_training_plan_members otpm

512: --check if selected TP has any component not in Cancelled or completed status
513: CURSOR csr_tp_with_valid_tpc(csr_training_plan_id number)
514: IS
515: SELECT otpm.training_plan_member_id
516: FROM ota_training_plan_members otpm
517: WHERE otpm.member_status_type_id <>'CANCELLED'
518: and otpm.member_status_type_id <>'OTA_COMPLETED'
519: and otpm.training_plan_id=csr_training_plan_id
520: and rownum=1;

Line 530: ota_training_plan_members otpm

526: otp.object_version_number,
527: otp.time_period_id,
528: otp.budget_currency
529: FROM ota_training_plans otp,
530: ota_training_plan_members otpm
531: WHERE otp.training_plan_id = csr_training_plan_id
532: AND otp.training_plan_id = otpm.training_plan_id
533: AND otpm.member_status_type_id = 'OTA_COMPLETED'
534: AND additional_member_flag = 'N';

Line 536: l_exists ota_training_plan_members.training_plan_member_id%TYPE;

532: AND otp.training_plan_id = otpm.training_plan_id
533: AND otpm.member_status_type_id = 'OTA_COMPLETED'
534: AND additional_member_flag = 'N';
535:
536: l_exists ota_training_plan_members.training_plan_member_id%TYPE;
537: l_name ota_training_plans.name%type;
538: l_object_version_number ota_training_plans.object_version_number%type;
539: l_time_period_id ota_training_plans.time_period_id%type;
540: l_budget_currency ota_training_plans.budget_currency%type;

Line 595: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type)

591:
592: end Update_tp_tpc_change;
593: */
594: Procedure Update_tp_tpc_change
595: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type)
596: is
597:
598: CURSOR csr_tp_with_tpc
599: IS

Line 604: ota_training_plan_members otpm

600: SELECT otp.training_plan_id
601: , otp.plan_status_type_id
602: , otp.additional_member_flag
603: FROM ota_training_plans otp,
604: ota_training_plan_members otpm
605: WHERE otp.training_plan_id=otpm.training_plan_id
606: and otp.plan_status_type_id <> 'CANCELLED'
607: and otpm.training_plan_member_id=p_training_plan_member_id;
608:

Line 620: l_exists ota_training_plan_members.training_plan_member_id%TYPE;

616: FROM ota_training_plans otp
617: WHERE otp.training_plan_id = csr_training_plan_id;
618:
619:
620: l_exists ota_training_plan_members.training_plan_member_id%TYPE;
621: l_name ota_training_plans.name%type;
622: l_object_version_number ota_training_plans.object_version_number%type;
623: l_time_period_id ota_training_plans.time_period_id%type;
624: l_budget_currency ota_training_plans.budget_currency%type;

Line 665: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type

661: END Update_tp_tpc_change;
662:
663:
664: Procedure Update_tp_tpc_change
665: (p_training_plan_member_id ota_training_plan_members.training_plan_member_id%type
666: ,p_learning_path_ids OUT NOCOPY varchar2)
667: is
668:
669: CURSOR csr_tp_with_tpc

Line 676: ota_training_plan_members otpm

672: , otp.plan_status_type_id
673: , otp.additional_member_flag
674: , otp.learning_path_id
675: FROM ota_training_plans otp,
676: ota_training_plan_members otpm
677: WHERE otp.training_plan_id=otpm.training_plan_id
678: and otp.plan_status_type_id <> 'CANCELLED'
679: and otpm.training_plan_member_id=p_training_plan_member_id;
680:

Line 692: l_exists ota_training_plan_members.training_plan_member_id%TYPE;

688: FROM ota_training_plans otp
689: WHERE otp.training_plan_id = csr_training_plan_id;
690:
691:
692: l_exists ota_training_plan_members.training_plan_member_id%TYPE;
693: l_name ota_training_plans.name%type;
694: l_object_version_number ota_training_plans.object_version_number%type;
695: l_time_period_id ota_training_plans.time_period_id%type;
696: l_budget_currency ota_training_plans.budget_currency%type;