1 package ota_elig_profile_util AUTHID CURRENT_USER as
2 /* $Header: oteligprfl.pkh 120.4.12020000.2 2013/02/07 20:56:09 jaysridh ship $ */
3
4 cursor get_elig_prof_details(p_elig_prof_id in number) is
5 select
6 eligy_prfl_id,
7 name,
8 asmt_to_use_cd,
9 business_group_id
10 from ben_eligy_prfl_f
11 where
12 eligy_prfl_id = p_elig_prof_id
13 and trunc(sysdate) between effective_start_date and effective_end_date
14 and stat_cd in ('A','P');
15
16 cursor get_elig_obj_elig_prf_id(p_elig_obj_id in number,p_eligibility_profile_id in number) is
17 select
18 elig_obj_elig_prfl_id,
19 elig_prfl_id,
20 object_version_number
21 from
22 ben_elig_obj_elig_profl_f
23 where
24 trunc(sysdate) between effective_start_date and effective_end_date
25 and elig_obj_id = p_elig_obj_id
26 and elig_prfl_id = p_eligibility_profile_id;
27
28 Type g_processes_table is table of number index by binary_integer;
29
30 g_num_processes number := 0;
31 g_processes_tbl g_processes_table;
32
33 function check_processing_status(p_user_group_id in number,p_eligibility_profile_id in number default null )
34 return varchar2;
35
36 function get_learner_group_name(p_ug_id in number)
37 return varchar2;
38
39 function is_learner_in_resolved_ug_data(p_user_group_id in number,
40 p_person_id in number,
41 p_processing_status in varchar2 default null) return varchar2;
42
43 procedure process_eligible_lrnr_record(p_person_id per_all_assignments_f.person_id%type,
44 p_user_group_id ota_user_group_elements.user_group_id%type,
45 p_eligibility_profile_id ota_user_group_elements.elig_prfl_id%type,
46 p_business_group_id ota_user_group_elements.business_group_id%type,
47 p_enable_logging in varchar2 default 'N');
48
49
50 procedure resolve_eligibility_profile(errbuf out nocopy varchar2,
51 retcode out nocopy varchar2,
52 p_learner_group_id in number,
53 p_elig_prof_id in number,
54 p_enable_logging in varchar2 default 'N');
55
56 procedure resolve_elig_profile_multi(errbuf out nocopy varchar2,
57 retcode out nocopy varchar2,
58 p_action_id in number default null,
59 p_chunk_size in number default 1000,
60 p_thread_count in number default 3,
61 p_learner_group_id in number,
62 p_elig_prof_id in number,
63 p_enable_logging in varchar2 default 'N');
64
65 procedure delete_ineligible_records(errbuf out nocopy varchar2,
66 retcode out nocopy varchar2,
67 p_learner_group_id in number,
68 p_elig_prof_id in number);
69
70
71
72 function is_profile_attached_to_ug(p_elig_prof_id in number)
73 return varchar2;
74
75 procedure create_eligibility_object
76 (p_eligibility_profile_id in number,
77 p_user_group_id in number,
78 p_business_group_id in number,
79 p_result out nocopy varchar2);
80
81 procedure delete_eligibility_object(
82 p_user_group_id in varchar2,
83 p_eligibility_profile_id in varchar2,
84 p_result out nocopy varchar);
85
86 function get_elig_object_id(p_user_group_id in number)
87 return number ;
88
89
90 function submit_conc_request(
91 p_user_group_id in varchar2,
92 p_elig_prfl_id in varchar2 default NULL,
93 p_enable_debug in varchar2 default 'N')
94 return number;
95
96 PROCEDURE process_elig_profile_multi
97 (p_validate IN varchar2 DEFAULT 'N'
98 ,p_action_id IN number
99 ,p_business_group_id IN number
100 ,p_learner_group_id IN number
101 ,p_elig_prof_id IN number
102 ,p_enable_logging IN varchar2 DEFAULT 'N'
103 ,p_chunk_size IN number
104 ,p_thread_count IN number);
105
106 Procedure check_all_slaves_finished(p_rpt_flag Boolean default FALSE);
107
108 end ota_elig_profile_util;
109
110
[Home] [Help]