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_MANDATORY_ENROLL_UTIL dependencies on OTA_LEARNER_ACCESS_UTIL

Line 988: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));

984: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
985:
986:
987: FOR request IN get_all_mandatory_enr_requests(p_conc_request_id) LOOP
988: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));
989: IF request.usergroup_id IS NULL THEN
990: If request.person_id IS NOT NULL THEN
991: FOR learner IN csr_get_learner (request.person_id,request.event_id, request.enr_prereq_type,l_event_start_date,l_allow_future_end_prof_val,l_per_bg_grp_prof_val,l_ota_global_bg_prof_val) LOOP
992: IF learner_can_enroll_in_class(request.event_id,learner.person_id) = 'Y' THEN

Line 1008: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));

1004: END LOOP;--END FOR learner IN csr_get_learners
1005: END IF;
1006: ELSE
1007: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1008: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1009: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1010: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1011: sql_stmnt :='SELECT * FROM(
1012: SELECT

Line 1009: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);

1005: END IF;
1006: ELSE
1007: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1008: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1009: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1010: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1011: sql_stmnt :='SELECT * FROM(
1012: SELECT
1013: ppf.person_id person_id

Line 1383: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));

1379: FND_FILE.PUT_LINE(FND_FILE.LOG,'Value of profile OTA_HR_GLOBAL_BUSINESS_GROUP_ID : '||l_ota_global_bg_prof_val);
1380:
1381:
1382: FOR request IN get_all_mand_multi_enr_reqs(p_conc_request_id) LOOP
1383: l_event_start_date := trunc(ota_learner_access_util.get_event_start_date(request.event_id,sysdate));
1384: IF request.usergroup_id IS NULL THEN
1385: If request.person_id IS NOT NULL THEN
1386: FOR learner IN csr_get_learner (request.person_id,request.event_id, request.enr_prereq_type,l_event_start_date,l_allow_future_end_prof_val,l_per_bg_grp_prof_val,l_ota_global_bg_prof_val) LOOP
1387: IF learner_can_enroll_in_class(request.event_id,learner.person_id) = 'Y' THEN

Line 1463: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));

1459: END LOOP;--END FOR learner IN csr_get_learners
1460: END IF;
1461: ELSE
1462: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1463: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1464: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1465: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1466: sql_stmnt :='SELECT * FROM(
1467: SELECT

Line 1464: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);

1460: END IF;
1461: ELSE
1462: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
1463: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
1464: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
1465: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
1466: sql_stmnt :='SELECT * FROM(
1467: SELECT
1468: ppf.person_id person_id

Line 2672: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));

2668: END LOOP;--END FOR learner IN csr_get_learners
2669: END IF;
2670: ELSE
2671: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
2672: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
2673: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
2674: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
2675: sql_stmnt :='SELECT * FROM(
2676: SELECT

Line 2673: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);

2669: END IF;
2670: ELSE
2671: --resolve the members FOR the user group AND them to ota_mandatory_enr_request_members
2672: --usergroup_whereclause :=TO_CHAR(ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1));
2673: usergroup_whereclause :=ota_learner_access_util.get_ug_whereclause(request.usergroup_id, -1);
2674: --FND_FILE.PUT_LINE(FND_FILE.LOG,'usergroup_whereclause : '||usergroup_whereclause);
2675: sql_stmnt :='SELECT * FROM(
2676: SELECT
2677: ppf.person_id person_id