[Home] [Help]
1: package body ota_elig_profile_util as
2: /* $Header: oteligprfl.pkb 120.4.12020000.5 2013/02/08 04:17:48 jaysridh ship $ */
3:
4: g_package varchar2(33) := 'ota_elig_profile_util'; -- Global package name
5:
1: package body ota_elig_profile_util as
2: /* $Header: oteligprfl.pkb 120.4.12020000.5 2013/02/08 04:17:48 jaysridh ship $ */
3:
4: g_package varchar2(33) := 'ota_elig_profile_util'; -- Global package name
5:
6: CURSOR csr_get_learner(
7: p_per_bg_grp_prof_val number,
8: p_ota_global_bg_prof_val number
730:
731: --
732: -- Store the request id of the concurrent request
733: --
734: ota_elig_profile_util.g_num_processes := ota_elig_profile_util.g_num_processes + 1;
735: ota_elig_profile_util.g_processes_tbl(ota_elig_profile_util.g_num_processes) := l_request_id;
736:
737: --
738: end loop;
731: --
732: -- Store the request id of the concurrent request
733: --
734: ota_elig_profile_util.g_num_processes := ota_elig_profile_util.g_num_processes + 1;
735: ota_elig_profile_util.g_processes_tbl(ota_elig_profile_util.g_num_processes) := l_request_id;
736:
737: --
738: end loop;
739: --
1137: user_elig_pro_rec.delete;
1138: l_eligprof_tab.delete;
1139:
1140:
1141: ota_elig_profile_util.check_all_slaves_finished
1142: (p_rpt_flag => TRUE);
1143:
1144: IF l_counter = 0 THEN
1145: fnd_file.put_line (fnd_file.log
1609: rpt_error(p_proc =>l_proc,p_last_actn=>l_actn,p_rpt_flag=>p_rpt_flag);
1610: raise;
1611: End check_all_slaves_finished;
1612:
1613: end ota_elig_profile_util;
1614: