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_TRAINING_PLAN_UPGRADE dependencies on OTA_LP_ENROLLMENTS

Line 6: LP_MAP_TABLE_NAME_E constant varchar2(30) := 'OTA_LP_ENROLLMENTS';

2: /* $Header: ottplpupg.pkb 120.0.12000000.2 2007/12/26 16:57:18 pekasi noship $ */
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

Line 968: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_ENROLLMENTS';

964:
965:
966: BEGIN
967: l_add_struct_d.extend(1);
968: l_add_struct_d(l_add_struct_d.count) := 'OTA_LP_ENROLLMENTS';
969: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
970:
971:
972: if not is_lp_enr_migrated(p_training_plan_id

Line 1521: l_status_code ota_lp_enrollments.path_status_code%type;

1517: l_count number;
1518: l_rows_processed number;
1519: l_end_date date;
1520: l_member_status_type_flag boolean;
1521: l_status_code ota_lp_enrollments.path_status_code%type;
1522: l_status_type_id varchar2(30);
1523: l_old_status ota_lp_member_enrollments.member_status_code%type;
1524: l_max_date_status_changed ota_delegate_bookings.date_status_changed%type;
1525: l_date_status_changed ota_delegate_bookings.date_status_changed%type;

Line 1677: --For the first record in this loop, create a learning path and a record in ota_lp_enrollments

1673:
1674:
1675:
1676: --Create learning paths from training plans
1677: --For the first record in this loop, create a learning path and a record in ota_lp_enrollments
1678: if l_flag then
1679: l_status_code := talent_mgmt_rec.plan_status_type_id;
1680: FOR lpm_rec IN csr_member_status(talent_mgmt_comb.source_id
1681: ,talent_mgmt_comb.source_function, talent_mgmt_comb.assignment_id,talent_mgmt_comb.person_id) LOOP

Line 2014: --Create a record in ota_lp_enrollments

2010: l_end_date := null;
2011: else
2012: l_end_date := tp_rec.end_date;
2013: end if;
2014: --Create a record in ota_lp_enrollments
2015:
2016: create_lp_enrollment(p_name => tp_rec.name
2017: ,p_learning_path_id => tp_rec.learning_path_id
2018: ,p_Completion_target_date => l_end_date

Line 2137: -- Updating the status of ota_lp_enrollments and ota_lp_member_enrollments table.

2133:
2134: -- ----------------------------------------------------------------------------
2135: -- |-----------------------< update_enrollment_status >-----------------------|
2136: -- ----------------------------------------------------------------------------
2137: -- Updating the status of ota_lp_enrollments and ota_lp_member_enrollments table.
2138: /*
2139: PROCEDURE update_enrollment_status is
2140: begin
2141: UPDATE ota_lp_enrollments

Line 2141: UPDATE ota_lp_enrollments

2137: -- Updating the status of ota_lp_enrollments and ota_lp_member_enrollments table.
2138: /*
2139: PROCEDURE update_enrollment_status is
2140: begin
2141: UPDATE ota_lp_enrollments
2142: SET path_status_code = 'COMPLETED'
2143: where path_status_code = 'OTA_COMPLETED';
2144:
2145:

Line 2214: FROM ota_lp_enrollments lpe

2210: CURSOR csr_get_lpe(p_path_status_code IN VARCHAR2) is
2211: SELECT lpe.learning_path_id, lpe.lp_enrollment_id, lpe.person_id, lpe.contact_id
2212: ,lpe.completion_date
2213: ,lpe.object_version_number
2214: FROM ota_lp_enrollments lpe
2215: WHERE lpe.path_status_code = p_path_status_code
2216: and lpe.lp_enrollment_id between p_start_pkid and p_end_pkid;
2217: /*
2218: -- Get all the Learning Path Components that are in Active or Planned Status.

Line 2260: ota_lp_enrollments lpe,

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
2264: AND evt.activity_version_id = lpm.activity_version_id

Line 2308: FROM OTA_LEARNING_PATHS LPS, OTA_LP_ENROLLMENTS LPE

2304:
2305: CURSOR GET_SOURCE_FUNCTION_CODE (P_LP_ENROLLMENT_ID IN VARCHAR2)
2306: IS
2307: SELECT LPS.SOURCE_FUNCTION_CODE
2308: FROM OTA_LEARNING_PATHS LPS, OTA_LP_ENROLLMENTS LPE
2309: WHERE LPE.LEARNING_PATH_ID = LPS.LEARNING_PATH_ID
2310: AND LPE.LP_ENROLLMENT_ID = P_LP_ENROLLMENT_ID
2311: AND LPS.SOURCE_FUNCTION_CODE = 'SUITABILITY';
2312:

Line 2316: /* update the enrollment status of ota_lp_enrollments and ota_lp_member_enrollments */

2312:
2313:
2314: BEGIN
2315:
2316: /* update the enrollment status of ota_lp_enrollments and ota_lp_member_enrollments */
2317: --update_enrollment_status;
2318:
2319: update ota_lp_enrollments lpe
2320: set lpe.no_of_mandatory_courses = (select count(lpme.learning_path_member_id)

Line 2319: update ota_lp_enrollments lpe

2315:
2316: /* update the enrollment status of ota_lp_enrollments and ota_lp_member_enrollments */
2317: --update_enrollment_status;
2318:
2319: update ota_lp_enrollments lpe
2320: set lpe.no_of_mandatory_courses = (select count(lpme.learning_path_member_id)
2321: from ota_lp_member_enrollments lpme
2322: where lpme.lp_enrollment_id = lpe.lp_enrollment_id);
2323:

Line 2334: UPDATE ota_lp_enrollments

2330: OPEN GET_SOURCE_FUNCTION_CODE(l_lp_enrollment_id);
2331: FETCH GET_SOURCE_FUNCTION_CODE INTO L_SOURCE_FUNCTION_CODE;
2332: IF GET_SOURCE_FUNCTION_CODE%NOTFOUND THEN
2333: if is_path_complete(p_lp_enrollment_id => l_lp_enrollment_id) = 'S' THEN
2334: UPDATE ota_lp_enrollments
2335: SET path_status_code = 'COMPLETED'
2336: , completion_date = to_date('31/12/4712','DD/MM/RRRR')
2337: WHERE lp_enrollment_id = l_lp_enrollment_id;
2338: end if;

Line 2394: UPDATE ota_lp_enrollments

2390:
2391: end;
2392:
2393: else
2394: UPDATE ota_lp_enrollments
2395: SET completion_date = l_completion_date
2396: ,no_of_completed_courses = nvl(l_completed_courses,0)
2397: WHERE lp_enrollment_id = l_lp_enrollment_id;
2398: end if;

Line 2407: UPDATE ota_lp_enrollments

2403: FOR lpe_rec IN csr_get_lpe('ACTIVE') LOOP
2404: OPEN csr_get_lp_completion_info(lpe_rec.lp_enrollment_id);
2405: FETCH csr_get_lp_completion_info INTO l_completion_date, l_completed_courses;
2406: IF csr_get_lp_completion_info%FOUND THEN
2407: UPDATE ota_lp_enrollments
2408: SET no_of_completed_courses = nvl(l_completed_courses,0)
2409: WHERE lp_enrollment_id = lpe_rec.lp_enrollment_id;
2410: END IF;
2411: CLOSE csr_get_lp_completion_info;

Line 2418: UPDATE ota_lp_enrollments

2414: FOR lpe_rec IN csr_get_lpe('CANCELLED') LOOP
2415: OPEN csr_get_lp_completion_info(lpe_rec.lp_enrollment_id);
2416: FETCH csr_get_lp_completion_info INTO l_completion_date, l_completed_courses;
2417: IF csr_get_lp_completion_info%FOUND THEN
2418: UPDATE ota_lp_enrollments
2419: SET no_of_completed_courses = nvl(l_completed_courses,0)
2420: WHERE lp_enrollment_id = lpe_rec.lp_enrollment_id;
2421: END IF;
2422: CLOSE csr_get_lp_completion_info;

Line 2425: UPDATE OTA_LP_ENROLLMENTS

2421: END IF;
2422: CLOSE csr_get_lp_completion_info;
2423: END LOOP;
2424: /* Path status code for Sutibality matching records should be 'ACTIVE' */
2425: UPDATE OTA_LP_ENROLLMENTS
2426: SET PATH_STATUS_CODE = 'ACTIVE',
2427: COMPLETION_DATE = NULL
2428: WHERE LP_ENROLLMENT_ID IN (SELECT LPE.LP_ENROLLMENT_ID
2429: FROM OTA_LP_ENROLLMENTS LPE, OTA_LEARNING_PATHS LPS

Line 2429: FROM OTA_LP_ENROLLMENTS LPE, OTA_LEARNING_PATHS LPS

2425: UPDATE OTA_LP_ENROLLMENTS
2426: SET PATH_STATUS_CODE = 'ACTIVE',
2427: COMPLETION_DATE = NULL
2428: WHERE LP_ENROLLMENT_ID IN (SELECT LPE.LP_ENROLLMENT_ID
2429: FROM OTA_LP_ENROLLMENTS LPE, OTA_LEARNING_PATHS LPS
2430: WHERE LPE.LEARNING_PATH_ID = LPS.LEARNING_PATH_ID
2431: AND LPS.SOURCE_FUNCTION_CODE = 'SUITABILITY' );
2432:
2433:

Line 2439: migrate_dff_contexts('OTA_TRAINING_PLANS','OTA_LP_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);

2435: /* Create DFF context for LPE from personal TPS */
2436: Open csr_get_attrib_personal_tps;
2437: Fetch csr_get_attrib_personal_tps into l_flex_val;
2438: if l_flex_val is not null then
2439: migrate_dff_contexts('OTA_TRAINING_PLANS','OTA_LP_ENROLLMENTS','ATTRIBUTE','ATTRIBUTE',p_update_id);
2440: end if;
2441: Close csr_get_attrib_personal_tps;
2442: /* Create DFF context for LPME from personal TPM */
2443: Open csr_get_attrib_personal_tpm;

Line 2451: FROM ota_lp_enrollments lpe

2447: end if;
2448: Close csr_get_attrib_personal_tpm;
2449: SELECT nvl(count(1),0)
2450: INTO l_rows_processed
2451: FROM ota_lp_enrollments lpe
2452: WHERE lpe.lp_enrollment_id between p_start_pkid and p_end_pkid;
2453:
2454: p_rows_processed := l_rows_processed;
2455: