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_PLANS

Line 17: p_person_id IN ota_training_plans.person_id%TYPE,

13: -- ---------------------------------------------------------------------------
14: --
15:
16: PROCEDURE update_tpc_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
17: p_person_id IN ota_training_plans.person_id%TYPE,
18: -- Modified for Bug#3479186
19: p_contact_id IN ota_training_plans.contact_id%TYPE,
20: p_learning_path_ids OUT NOCOPY varchar2)
21: --p_status_id in ota_booking_status_types.booking_status_type_id%type)

Line 19: p_contact_id IN ota_training_plans.contact_id%TYPE,

15:
16: PROCEDURE update_tpc_enroll_status_chg (p_event_id IN ota_events.event_id%TYPE,
17: p_person_id IN ota_training_plans.person_id%TYPE,
18: -- Modified for Bug#3479186
19: p_contact_id IN ota_training_plans.contact_id%TYPE,
20: p_learning_path_ids OUT NOCOPY varchar2)
21: --p_status_id in ota_booking_status_types.booking_status_type_id%type)
22: IS
23:

Line 33: ota_training_plans otp

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)
37: OR (p_contact_id IS NOT NULL AND otp.contact_id = p_contact_id))

Line 66: l_name ota_training_plans.name%type;

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;
70: */

Line 67: l_object_version_number ota_training_plans.object_version_number%type;

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;
70: */
71:

Line 68: l_time_period_id ota_training_plans.time_period_id%type;

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;
70: */
71:
72: BEGIN

Line 69: l_budget_currency ota_training_plans.budget_currency%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;
70: */
71:
72: BEGIN
73:

Line 191: FROM ota_training_plans tp,

187: tp.person_id,
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

Line 429: p_person_id ota_training_plans.person_id%type,

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:
433: Cursor get_tpc_detail

Line 503: FROM ota_training_plans otp,

499: CURSOR csr_tp_with_tpc
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'

Line 529: FROM ota_training_plans otp,

525: SELECT otp.name,
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'

Line 537: l_name ota_training_plans.name%type;

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;
541: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;

Line 538: l_object_version_number ota_training_plans.object_version_number%type;

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;
541: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
542:

Line 539: l_time_period_id ota_training_plans.time_period_id%type;

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;
541: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
542:
543: begin

Line 540: l_budget_currency ota_training_plans.budget_currency%type;

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;
541: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
542:
543: begin
544:

Line 541: l_plan_status_type_id ota_training_plans.plan_status_type_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;
541: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
542:
543: begin
544:
545: FOR rec1 in csr_tp_with_tpc

Line 603: FROM ota_training_plans otp,

599: IS
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;

Line 616: FROM ota_training_plans otp

612: SELECT otp.name,
613: otp.object_version_number,
614: otp.time_period_id,
615: otp.budget_currency
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;

Line 621: l_name ota_training_plans.name%type;

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;
625: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;

Line 622: l_object_version_number ota_training_plans.object_version_number%type;

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;
625: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
626: l_complete_ok varchar2(1);

Line 623: l_time_period_id ota_training_plans.time_period_id%type;

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;
625: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
626: l_complete_ok varchar2(1);
627:

Line 624: l_budget_currency ota_training_plans.budget_currency%type;

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;
625: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
626: l_complete_ok varchar2(1);
627:
628: BEGIN

Line 625: l_plan_status_type_id ota_training_plans.plan_status_type_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;
625: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
626: l_complete_ok varchar2(1);
627:
628: BEGIN
629: FOR rec1 in csr_tp_with_tpc LOOP

Line 675: FROM ota_training_plans otp,

671: SELECT otp.training_plan_id
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;

Line 688: FROM ota_training_plans otp

684: SELECT otp.name,
685: otp.object_version_number,
686: otp.time_period_id,
687: otp.budget_currency
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;

Line 693: l_name ota_training_plans.name%type;

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;
697: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;

Line 694: l_object_version_number ota_training_plans.object_version_number%type;

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;
697: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
698: l_complete_ok varchar2(1);

Line 695: l_time_period_id ota_training_plans.time_period_id%type;

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;
697: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
698: l_complete_ok varchar2(1);
699: l_learning_path_ids varchar2(4000) := '';

Line 696: l_budget_currency ota_training_plans.budget_currency%type;

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;
697: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
698: l_complete_ok varchar2(1);
699: l_learning_path_ids varchar2(4000) := '';
700:

Line 697: l_plan_status_type_id ota_training_plans.plan_status_type_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;
697: l_plan_status_type_id ota_training_plans.plan_status_type_id%type;
698: l_complete_ok varchar2(1);
699: l_learning_path_ids varchar2(4000) := '';
700:
701: BEGIN