[Home] [Help]
3:
4: -- LP_MAP_UPGRADE_ID constant number(2) := -2;
5: OTA_MIG_FAIL_ID constant number(2) := -1;
6: LP_MAP_TABLE_NAME_E constant varchar2(30) := 'OTA_LP_ENROLLMENTS';
7: LP_MAP_TABLE_NAME_M constant varchar2(30) := 'OTA_LEARNING_PATH_MEMBERS';
8: LP_MAP_TABLE_NAME_M_E constant varchar2(30) := 'OTA_LP_MEMBER_ENROLLMENTS';
9: LP_UPGRADE_NAME constant varchar2(30) := 'OTLPUPG';
10: LP_LOG_TYPE_I constant varchar2(30) := 'I'; -- log type is Infornation
11: LP_LOG_TYPE_N constant varchar2(30) := 'N'; -- log type is Internal
696:
697:
698: BEGIN
699: l_add_struct_d.extend(1);
700: l_add_struct_d(l_add_struct_d.count) := 'OTA_LEARNING_PATH_MEMBERS';
701: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
702:
703:
704:
1186:
1187:
1188:
1189: if l_learning_path_section_id is not null then
1190: UPDATE ota_learning_path_members
1191: SET learning_path_section_id = l_learning_path_section_id --//Section_id returned from create call
1192: where learning_path_id = l_learning_path_id;
1193: end if;
1194:
1990: ,tpm.ATTRIBUTE28 ,tpm.ATTRIBUTE29
1991: ,tpm.ATTRIBUTE30
1992: FROM ota_training_plan_members tpm,
1993: ota_training_plans tp,
1994: ota_learning_path_members lpm,
1995: ota_learning_paths lps
1996: WHERE tp.training_plan_id = p_training_plan_id
1997: AND lpm.activity_version_id = tpm.activity_version_id
1998: AND lps.path_source_code in ('CATALOG','MANAGER')
2218: -- Get all the Learning Path Components that are in Active or Planned Status.
2219: CURSOR csr_get_lpme(p_lp_enrollment_id in number) IS
2220: SELECT lpm.activity_version_id, lpme.lp_member_enrollment_id, lpme.member_status_code,
2221: lpme.object_version_number
2222: FROM ota_lp_member_enrollments lpme,ota_learning_path_members lpm
2223: WHERE lpme.learning_path_member_id = lpm.learning_path_member_id
2224: AND lpme.lp_enrollment_id = p_lp_enrollment_id
2225: -- AND lpm.learning_path_id = p_learning_path_id
2226: AND lpme.member_status_code IN ('PLANNED','ACTIVE');
2255: cursor csr_get_lpm_completion_date(p_lpm_enrollment_id IN NUMBER) IS
2256: SELECT trunc(min(nvl(tdb.date_status_changed,tdb.date_booking_placed))) completion_date
2257: FROM ota_delegate_bookings tdb,
2258: ota_lp_member_enrollments lpme,
2259: ota_learning_path_members lpm,
2260: ota_lp_enrollments lpe,
2261: ota_events evt,
2262: ota_booking_status_types bst
2263: WHERE tdb.event_id = evt.event_id