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_ELIG_PROFILE_UTIL dependencies on OTA_GENERAL

Line 321: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;

317: and trunc(sysdate) between trunc(ug.start_date_active) and nvl(ug.end_date_active,trunc(sysdate+1))
318: and uge.elig_prfl_id is not null
319: and uge.person_id is null
320: and nvl(uge.processing_status,''A'') <> ''P''
321: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;
322:
323:
324: if p_enable_logging = 'Y' then
325: FND_FILE.PUT_LINE(FND_FILE.LOG,'OTA_HR_GLOBAL_BUSINESS_GROUP_ID :' ||fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID'));

Line 536: l_general_bg number := ota_general.get_business_group_id;

532: csr_get_ug_to_be_processed learner_assign_details;
533:
534: get_ug_to_be_processed varchar2(4000);
535: l_pre_ug_id ota_user_group_elements.user_group_id%TYPE := -1;
536: l_general_bg number := ota_general.get_business_group_id;
537: l_proc varchar2(200) := 'resolve_eligibility_profile';
538: OTA_NO_PERSON_LG_TO_PROCESS exception;
539:
540: begin

Line 562: ,p_business_group_id => ota_general.get_business_group_id

558: ota_batch_action_api.create_bulk_enr_request
559: (p_bulk_enr_request_id => l_action_id
560: ,p_requestor_id => fnd_global.conc_login_id
561: ,p_object_type => 'EP'
562: ,p_business_group_id => ota_general.get_business_group_id
563: ,p_conc_program_request_id => fnd_global.conc_request_id);
564:
565: if p_enable_logging = 'Y' then
566: FND_FILE.PUT_LINE(FND_FILE.LOG,'l_action_id:'||l_action_id);

Line 603: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_whereclause ||

599: and trunc(sysdate) between trunc(ug.start_date_active) and nvl(ug.end_date_active,trunc(sysdate+1))
600: and uge.elig_prfl_id is not null
601: and uge.person_id is null
602: and nvl(uge.processing_status,''A'') in (''A'',''E'')
603: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_whereclause ||
604: ' order by user_group_id';
605:
606: OPEN csr_get_ug_to_be_processed for get_ug_to_be_processed;
607: FETCH csr_get_ug_to_be_processed BULK COLLECT into user_elig_pro_rec;

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);

608: CLOSE csr_get_ug_to_be_processed;
609:
610: if p_enable_logging = 'Y' then
611: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);
612: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' ota_general.get_business_group_id:'||ota_general.get_business_group_id);
613: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' user_elig_pro_rec.count:'||user_elig_pro_rec.count);
614: end if;
615: if user_elig_pro_rec.count > 0 then -- check whether there is any ug to process
616:

Line 768: p_business_group_id => ota_general.get_business_group_id,

764:
765:
766: process_elig_profile_multi( p_validate =>l_validate ,
767: p_action_id =>l_action_id,
768: p_business_group_id => ota_general.get_business_group_id,
769: p_learner_group_id => p_learner_group_id,
770: p_elig_prof_id => p_elig_prof_id,
771: p_enable_logging => p_enable_logging,
772: p_chunk_size => p_chunk_size,

Line 954: l_ota_general_bg number := ota_general.get_business_group_id;

950: ug_whereclause varchar2(200);
951: get_ug_to_be_processed varchar2(4000);
952: l_pre_ug_id ota_user_group_elements.user_group_id%TYPE := -1;
953: l_proc varchar2(200) := 'resolve_eligibility_profile_m';
954: l_ota_general_bg number := ota_general.get_business_group_id;
955: l_is_eligible boolean := false;
956:
957: BEGIN
958:

Line 1000: || ''' and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '

996: and trunc(sysdate) between bep.effective_start_date AND bep.effective_end_date
997: and bep.stat_cd IN (''A'',''P'')
998: and nvl(uge.processing_status,''A'') = '''
999: || to_char (conc_parent_request_id(fnd_global.conc_request_id))
1000: || ''' and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '
1001: || ug_whereclause
1002: || ' order by user_group_id';
1003: if p_enable_logging = 'Y' then
1004: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' get_ug_to_be_processed:'||get_ug_to_be_processed);

Line 1168: and BUSINESS_GROUP_ID = l_ota_general_bg;

1164: update ota_user_group_elements set processing_status = 'E' --Parent record to Error
1165: where user_group_id = user_elig_pro_rec(ug_print_count).user_group_id
1166: and elig_prfl_id is not null
1167: and person_id is null
1168: and BUSINESS_GROUP_ID = l_ota_general_bg;
1169:
1170: l_pre_ug_id := user_elig_pro_rec(ug_print_count).user_group_id;
1171: end if;
1172: end loop;

Line 1247: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;

1243: and trunc(sysdate) between trunc(ug.start_date_active) and nvl(ug.end_date_active,trunc(sysdate+1))
1244: and uge.elig_prfl_id is not null
1245: and uge.person_id is null
1246: and nvl(uge.processing_status,''A'') <> ''P''
1247: and ug.business_group_id = ota_general.get_business_group_id) QRSLT WHERE '|| ug_ep_whereclause ;
1248:
1249: OPEN csr_get_ug_to_be_processed for get_ug_to_be_processed;
1250: LOOP
1251: FETCH csr_get_ug_to_be_processed into user_group_rec;