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_LEARNING_PATHS

Line 480: UPDATE ota_learning_paths

476:
477: begin
478:
479:
480: UPDATE ota_learning_paths
481: SET path_source_code ='CATALOG'
482: ,display_to_learner_flag = 'Y'
483: WHERE path_source_code IS null;
484:

Line 485: UPDATE ota_learning_paths lps

481: SET path_source_code ='CATALOG'
482: ,display_to_learner_flag = 'Y'
483: WHERE path_source_code IS null;
484:
485: UPDATE ota_learning_paths lps
486: SET public_flag = (SELECT decode(count(tea.learning_path_id),0,'Y','N')
487: FROM ota_event_associations tea
488: WHERE lps.learning_path_id = tea.learning_path_id)
489: WHERE lps.public_flag IS NULL

Line 525: FROM ota_learning_paths lps, ota_learning_paths_tl lpst

521:
522: cursor csr_get_dup_lps_rec(p_name in varchar2, p_business_group_id in number
523: , p_person_id in number, p_contact_id in number) IS
524: SELECT lps.learning_path_id
525: FROM ota_learning_paths lps, ota_learning_paths_tl lpst
526: where lps.learning_path_id = lpst.learning_path_id
527: and lpst.language = userenv('LANG')
528: and lpst.name = p_name
529: and lps.business_group_id = p_business_group_id

Line 538: l_add_struct_d(l_add_struct_d.count) := 'OTA_LEARNING_PATHS';

534:
535:
536: BEGIN
537: l_add_struct_d.extend(1);
538: l_add_struct_d(l_add_struct_d.count) := 'OTA_LEARNING_PATHS';
539: hr_dflex_utility.create_ignore_df_validation(p_rec => l_add_struct_d);
540:
541: open csr_get_dup_lps_rec(p_name,p_business_group_id, p_person_id, p_contact_id);
542: fetch csr_get_dup_lps_rec into l_learning_path_id;

Line 1074: FROM ota_learning_paths lps, ota_learning_paths_tl lpst

1070:
1071:
1072: CURSOR csr_get_lp IS
1073: SELECT lps.learning_path_id, lpst.name , lps.business_group_id
1074: FROM ota_learning_paths lps, ota_learning_paths_tl lpst
1075: WHERE lpst.learning_path_id = lps.learning_path_id
1076: AND lpst.language = USERENV('LANG')
1077: AND lps.path_source_code = 'CATALOG'
1078: AND lps.learning_path_id between p_start_pkid and p_end_pkid;

Line 1099: -- for existing data in ota_learning_paths

1095: BEGIN
1096:
1097:
1098: -- Update path_source_code_code_code to CATALOG and display_to_learner_flag to 'Y'
1099: -- for existing data in ota_learning_paths
1100: l_upgrade_id := null;
1101:
1102: select max(upgrade_id) INTO l_upgrade_id
1103: from ota_upgrade_log

Line 1163: From Ota_learning_paths_tl M

1159: M.Creation_date,
1160: M.Last_Updated_By,
1161: M.Last_Update_Date,
1162: M.Last_Update_Login
1163: From Ota_learning_paths_tl M
1164: Where M.learning_path_id = l_learning_path_id;
1165:
1166: Exception
1167: when others then

Line 1202: from ota_learning_paths

1198:
1199:
1200: Select nvl(count(1),0)
1201: into l_rows_processed
1202: from ota_learning_paths
1203: where learning_path_id between p_start_pkid and p_end_pkid;
1204:
1205: p_rows_processed := l_rows_processed;
1206: END upg_cat_lp_to_section;

Line 1530: l_display_to_learner_flag ota_learning_paths.display_to_learner_flag%type;

1526: l_name varchar2(80);
1527: l_lang_len number;
1528: MAX_NAME_LEN constant number := 80;
1529: MAX_DATA_TRUNC_LEN constant number := 10;
1530: l_display_to_learner_flag ota_learning_paths.display_to_learner_flag%type;
1531: l_member_status_code ota_lp_member_enrollments.member_status_code%type;
1532: --
1533:
1534:

Line 1995: ota_learning_paths lps

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')
1999: AND lps.learning_path_id = lpm.learning_path_id

Line 2206: l_source_function_code ota_learning_paths.source_function_code%type;

2202: l_lp_object_version_number number;
2203: l_lp_completion_date_old date;
2204: l_err_code varchar2(72);
2205: l_err_msg varchar2(2000);
2206: l_source_function_code ota_learning_paths.source_function_code%type;
2207:
2208:
2209:
2210: CURSOR csr_get_lpe(p_path_status_code IN VARCHAR2) is

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 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: