[Home] [Help]
301: -- end fix 1560336
302:
303: begin
304: --
305: hr_utility.set_location('Entering :'||l_proc,10);
306: --
307: -- Default return values for nulls
308: --
309: fnd_message.set_name('BEN','BEN_91792_ALL_PROMPT');
366: p_status;
367: --
368: close c_benefit_actions;
369: --
370: hr_utility.set_location('Leaving :'||l_proc,10);
371: --
372: end standard_header;
373: -----------------------------------------------------------------------
374: procedure temporal_life_events
481: l_c1 c1%rowtype;
482: --
483: begin
484: --
485: hr_utility.set_location('Entering :'||l_proc,10);
486: --
487: open c0;
488: fetch c0 into l_c0 ;
489: close c0 ;
589: l_period_enroll_changed +
590: l_voulntary_end_cvg +
591: l_waiting_satisfied ;
592: --
593: hr_utility.set_location('Leaving :'||l_proc,10);
594: --
595: end temporal_life_events;
596: -----------------------------------------------------------------------
597: procedure process_information
629: l_proc_info c_proc_info%rowtype;
630: --
631: begin
632: --
633: hr_utility.set_location('Entering :'||l_proc,10);
634: --
635: -- Get execution control data
636: --
637: open c_proc_info;
647: p_persons_processed_succ,
648: p_persons_errored;
649: close c_proc_info;
650: --
651: hr_utility.set_location('Leaving :'||l_proc,10);
652: --
653: end process_information;
654: -----------------------------------------------------------------------
655: procedure activity_summary_by_action
748: l_dummy varchar2(30);
749: --
750: begin
751: --
752: hr_utility.set_location('Entering :'||l_proc,10);
753: --
754: open c0 ;
755: fetch c0 into l_c0;
756: close c0;
836: p_life_event_choices := l_life_event_choices;
837: p_life_event_no_effect := l_life_event_no_effect;
838: p_life_event_rt_pr_chg := l_life_event_rt_pr_chg;
839: --
840: hr_utility.set_location('Leaving :'||l_proc,10);
841: --
842: end activity_summary_by_action;
843: -----------------------------------------------------------------------
844: -- Procedure activity_summary_by_action is overloaded as two more parameters for life
943: l_life_event_collision number :=0;
944: --
945: begin
946: --
947: hr_utility.set_location('Entering :'||l_proc,10);
948: --
949: -- Get execution control data
950: --
951: open c_ler_info;
1037: p_life_event_rt_pr_chg := l_life_event_rt_pr_chg;
1038: p_life_event_collapsed := l_life_event_collapsed;
1039: p_life_event_collision := l_life_event_collision;
1040: --
1041: hr_utility.set_location('Leaving :'||l_proc,10);
1042: --
1043:
1044: end activity_summary_by_action;
1045: -------------------------------------------------------------------------------------------
1054: l_errbuf varchar2(2000);
1055: --
1056: begin
1057: --
1058: hr_utility.set_location('Entering :'||l_proc,10);
1059: --
1060: -- Reports are not relevant in collective agreement mode
1061: --
1062: if p_mode = 'A'
1124: retcode => l_retcode,
1125: p_program_name => l_program_name,
1126: p_concurrent_request_id => p_concurrent_request_id);
1127: --
1128: hr_utility.set_location('Leaving :'||l_proc,10);
1129: --
1130: end batch_reports;
1131: -----------------------------------------------------------------------
1132: procedure submit_request(errbuf out nocopy varchar2,
1138: l_request_id number;
1139: --
1140: begin
1141: --
1142: hr_utility.set_location('Entering :'||l_proc,10);
1143: --
1144: l_request_id := fnd_request.submit_request
1145: (application => 'BEN',
1146: program => p_program_name,
1155: fnd_message.raise_error;
1156: --
1157: end if;
1158: --
1159: hr_utility.set_location('Leaving :'||l_proc,10);
1160: --
1161: end submit_request;
1162: -----------------------------------------------------------------------
1163: procedure event_summary(