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 93: FROM ota_learning_paths lps,

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

Line 94: ota_learning_paths_tl lpt,

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

Line 114: ota_learning_paths lps,

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

Line 115: ota_learning_paths_tl lpt

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

Line 389: ota_learning_paths lps,

385:
386: CURSOR csr_get_manager_name IS
387: SELECT ppf.full_name, ppf.person_id
388: FROM ota_lp_enrollments lpe,
389: ota_learning_paths lps,
390: per_all_people_f ppf,
391: per_all_assignments_f paf
392: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
393: AND trunc(sysdate) between paf.effective_start_date and paf.effective_end_date

Line 457: ota_learning_paths lps,

453:
454: CURSOR csr_get_creator_name IS
455: SELECT ppf.full_name, ppf.person_id
456: FROM ota_lp_enrollments lpe,
457: ota_learning_paths lps,
458: per_all_people_f ppf
459: WHERE trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
460: AND ppf.person_id = lpe.creator_person_id
461: AND lpe.lp_enrollment_id = l_lp_enrollment_id

Line 542: FROM ota_learning_paths lps,

538: ,lpe.person_id
539: ,lpe.contact_id
540: ,lpe.creator_person_id
541: ,lps.notify_days_before_target
542: FROM ota_learning_paths lps,
543: ota_lp_enrollments lpe
544: WHERE lps.learning_path_id = lpe.learning_path_id
545: AND lpe.path_status_code = 'ACTIVE'
546: AND trunc(sysdate) + lps.notify_days_before_target = trunc(lpe.completion_target_date)

Line 592: ota_learning_paths lps,

588: ,lps.path_source_code
589: ,lpm.notify_days_before_target
590: FROM ota_learning_path_members lpm,
591: ota_lp_member_enrollments lpme,
592: ota_learning_paths lps,
593: ota_lp_enrollments lpe,
594: ota_lp_sections lpc
595: WHERE lpe.learning_path_id = lps.learning_path_id
596: AND lpc.learning_path_id = lps.learning_path_id

Line 617: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;

613: l_lpm_enrollment_id number;
614: failure exception;
615: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';
616: l_lpm_notification_type VARCHAR2(30);
617: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
618: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
619: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
620: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
621: l_key varchar2(80);

Line 618: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;

614: failure exception;
615: l_proc varchar2(72) := g_package|| ' send_lpm_ct_notifications';
616: l_lpm_notification_type VARCHAR2(30);
617: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
618: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
619: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
620: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
621: l_key varchar2(80);
622: BEGIN

Line 620: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;

616: l_lpm_notification_type VARCHAR2(30);
617: l_person_id OTA_LEARNING_PATHS.PERSON_ID%TYPE;
618: l_contact_id OTA_LEARNING_PATHS.CONTACT_ID%TYPE;
619: l_creator_person_id OTA_LP_ENROLLMENTS.CREATOR_PERSON_ID%TYPE;
620: l_path_source_code OTA_LEARNING_PATHS.PATH_SOURCE_CODE%TYPE;
621: l_key varchar2(80);
622: BEGIN
623:
624: FOR lpm_rec IN csr_get_lp_comps