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_LP_NOTIFY_SS dependencies on OTA_LEARNING_PATHS

Line 94: FROM ota_learning_paths lps,

90: lpe.completion_target_date completion_target,
91: lpe.completion_date,
92: lps.notify_days_before_target,
93: lpe.creator_person_id
94: FROM ota_learning_paths lps,
95: ota_learning_paths_tl lpt,
96: ota_lp_enrollments lpe
97: WHERE lpt.language = USERENV('LANG')
98: AND lps.learning_path_id = lpt.learning_path_id

Line 95: ota_learning_paths_tl lpt,

91: lpe.completion_date,
92: lps.notify_days_before_target,
93: lpe.creator_person_id
94: FROM ota_learning_paths lps,
95: ota_learning_paths_tl lpt,
96: ota_lp_enrollments lpe
97: WHERE lpt.language = USERENV('LANG')
98: AND lps.learning_path_id = lpt.learning_path_id
99: AND lpe.lp_enrollment_id = p_lp_enrollment_id

Line 115: ota_learning_paths lps,

111: FROM ota_lp_member_enrollments lpme,
112: ota_learning_path_members lpm,
113: ota_activity_versions_tl avt,
114: ota_lp_enrollments lpe,
115: ota_learning_paths lps,
116: ota_learning_paths_tl lpt
117: WHERE lpme.lp_member_enrollment_id = p_lp_member_enrollment_id
118: AND lps.learning_path_id = lpt.learning_path_id
119: AND avt.language = USERENV('LANG')

Line 116: ota_learning_paths_tl lpt

112: ota_learning_path_members lpm,
113: ota_activity_versions_tl avt,
114: ota_lp_enrollments lpe,
115: ota_learning_paths lps,
116: ota_learning_paths_tl lpt
117: WHERE lpme.lp_member_enrollment_id = p_lp_member_enrollment_id
118: AND lps.learning_path_id = lpt.learning_path_id
119: AND avt.language = USERENV('LANG')
120: AND avt.activity_version_id = lpm.activity_version_id

Line 410: ota_learning_paths lps,

406:
407: CURSOR csr_get_manager_name IS
408: SELECT ppf.full_name, ppf.person_id
409: FROM ota_lp_enrollments lpe,
410: ota_learning_paths lps,
411: per_all_people_f ppf,
412: per_all_assignments_f paf
413: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
414: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date

Line 478: ota_learning_paths lps,

474:
475: CURSOR csr_get_creator_name IS
476: SELECT ppf.full_name, ppf.person_id
477: FROM ota_lp_enrollments lpe,
478: ota_learning_paths lps,
479: per_all_people_f ppf
480: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
481: AND ppf.person_id = lpe.creator_person_id
482: AND lpe.lp_enrollment_id = l_lp_enrollment_id

Line 563: FROM ota_learning_paths lps,

559: ,lpe.person_id
560: ,lpe.contact_id
561: ,lpe.creator_person_id
562: ,lps.notify_days_before_target
563: FROM ota_learning_paths lps,
564: ota_lp_enrollments lpe
565: WHERE lps.learning_path_id = lpe.learning_path_id
566: AND lpe.path_status_code = 'ACTIVE'
567: AND trunc(sysdate) + lps.notify_days_before_target = trunc(lpe.completion_target_date)

Line 613: ota_learning_paths lps,

609: ,lps.path_source_code
610: ,lpm.notify_days_before_target
611: FROM ota_learning_path_members lpm,
612: ota_lp_member_enrollments lpme,
613: ota_learning_paths lps,
614: ota_lp_enrollments lpe,
615: ota_lp_sections lpc
616: WHERE lpe.learning_path_id = lps.learning_path_id
617: AND lpc.learning_path_id = lps.learning_path_id

Line 638: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;

634: l_lpm_enrollment_id number;
635: failure exception;
636: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';
637: l_lpm_notification_type VARCHAR2(30);
638: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
639: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
640: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
641: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
642: l_key varchar2(80);

Line 639: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;

635: failure exception;
636: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';
637: l_lpm_notification_type VARCHAR2(30);
638: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
639: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
640: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
641: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
642: l_key varchar2(80);
643: BEGIN

Line 641: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;

637: l_lpm_notification_type VARCHAR2(30);
638: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
639: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
640: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
641: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
642: l_key varchar2(80);
643: BEGIN
644:
645: FOR lpm_rec IN csr_get_lp_comps