[Home] [Help]
556: end if;
557:
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:
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);
567: end if;
616:
617: for ug_print_count in user_elig_pro_rec.first..user_elig_pro_rec.last --{ ug_ep loop
618: loop
619: if l_pre_ug_id <> user_elig_pro_rec(ug_print_count).user_group_id then
620: update ota_user_group_elements set processing_status = fnd_global.conc_request_id --Parent record to Processing
621: where user_group_id = user_elig_pro_rec(ug_print_count).user_group_id
622: and elig_prfl_id is not null
623: and person_id is null
624: and BUSINESS_GROUP_ID = l_general_bg;
995: and bep.eligy_prfl_id = uge.elig_prfl_id
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
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);
1005: end if;
1006:
1007: FND_FILE.PUT_LINE(FND_FILE.LOG,l_proc || ' conc_parent_request_id:'||conc_parent_request_id(fnd_global.conc_request_id));
1008:
1009: OPEN csr_get_ug_to_be_processed
1010: FOR get_ug_to_be_processed;
1011: