1 package pay_core_utils AUTHID CURRENT_USER as
2 /* $Header: pycorutl.pkh 120.11 2011/12/12 11:32:04 asnell ship $ */
3 --
4 g_cache_business_group BOOLEAN;
8 type char_array is table of varchar(30) index by binary_integer;
5 g_business_group_id PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE;
6
7 type date_array is table of date index by binary_integer;
9 --
10 -- Set up the types to hold the dynamic contexts details.
11 --
12 type t_contexts_rec is record
13 (context_name ff_contexts.context_name%type,
14 is_context_def boolean,
15 input_value_name pay_input_values_f.name%type,
16 default_plsql varchar2(60)
17 );
18 --
19 type t_contexts_tab is table of t_contexts_rec index by binary_integer;
20 --
21 -- Set up the types to hold the dynamic sql statements.
22 --
23 type t_sql_stm_rec is record
24 (statement varchar2(1000),
25 sql_cur number
26 );
27 --
28 type t_sql_stm_tab is table of t_sql_stm_rec index by binary_integer;
29 --
30 function get_sql_cursor(p_statement in varchar2,
31 p_sql_cur out nocopy number) return boolean;
32 --
33 procedure close_all_sql_cursors;
34 procedure close_sql_cursor(p_sql_cur in number);
35 --
36 g_sql_cursors t_sql_stm_tab;
37 --
38 --
39 ------------------------------ get_parameter -------------------------------
40 function get_parameter(name in varchar2,
41 parameter_list varchar2) return varchar2;
42 ------------------------------ remove_parameter -------------------------------
43 function remove_parameter(p_name in varchar2,
44 p_parameter_list varchar2) return varchar2;
45
46 function get_business_group (p_statement varchar2) return number;
47 function get_business_group_withbind (p_statement in varchar2,
48 p_bindvar in number ) return number;
49 function get_dyt_business_group (p_statement varchar2) return number;
50 function get_dyt_business_group (p_statement varchar2, p_bindvar number) return number;
51 function get_legislation_code (p_bg_id number) return varchar2;
52 procedure reset_cached_values;
53 procedure get_time_definition(p_element_entry in number,
54 p_asg_act_id in number,
55 p_time_def_id out nocopy number);
56 function get_time_period_start(p_payroll_action_id in number
57 ) return date;
58 function get_entry_end_date(p_element_type_id in number,
59 p_payroll_action_id in number,
60 p_assignment_action_id in number,
61 p_date_earned in date ) return date;
62 procedure get_prorated_dates(p_ee_id in number,
63 p_asg_act_id in number,
64 p_time_def_type in varchar2,
65 p_time_def_id in out nocopy number,
66 p_date_array out nocopy char_array,
67 p_type_array out nocopy char_array
68 );
69 procedure set_prorate_dates(p_et_id in number,
70 p_asg_act_id in number,
71 p_date_array in char_array,
72 p_type_array in char_array,
73 p_arr_cnt in number,
74 p_prd_end out nocopy varchar2,
75 p_start_date out nocopy varchar2,
76 p_end_date out nocopy varchar2
77 );
78 procedure get_rr_id( p_rr_id_list out nocopy varchar2);
79 procedure get_aa_id( p_aa_id_list out nocopy varchar2);
80 procedure get_rb_id( p_rb_id_list out nocopy varchar2);
81 procedure push_message(p_applid in number,
82 p_msg_name in varchar2,
83 p_level in varchar2
84 );
85 procedure push_message(p_applid in number,
86 p_msg_name in varchar2,
87 p_msg_txt in varchar2,
88 p_level in varchar2
89 );
90 procedure push_token(
91 p_tok_name in varchar2,
92 p_tok_value in varchar2
93 );
94 procedure pop_message(
95 p_msg_text out nocopy varchar2
96 );
97 procedure pop_message(
98 p_msg_text out nocopy varchar2,
99 p_sev_level out nocopy varchar2
100 );
101 procedure mesg_stack_error_hdlr(p_pactid in number);
102
103 function get_pp_action_id(p_action_type in varchar2,
104 p_action_id in number) return number;
105 function include_action_in_payment(p_calling_action_type in varchar2,
106 p_calling_action_id in number,
107 p_run_action_id in number
108 ) return varchar2;
109 procedure set_pap_group_id(p_pap_group_id in number);
110 function get_pap_group_id return number;
111 pay_action_parameter_group_id number;
112 procedure get_action_parameter(p_para_name in varchar2,
113 p_para_value out nocopy varchar2,
114 p_found out nocopy boolean
115 );
116 procedure get_report_f_parameter(
117 p_payroll_action_id in number,
118 p_para_name in varchar2,
119 p_para_value out nocopy varchar2,
120 p_found out nocopy boolean
121 );
122 procedure get_legislation_rule(p_legrul_name in varchar2,
126 );
123 p_legislation in varchar2,
124 p_legrul_value out nocopy varchar2,
125 p_found out nocopy boolean
127 procedure unset_context_iv_cache;
128 procedure get_leg_context_iv_name(p_context_name in varchar2,
129 p_legislation in varchar2,
130 p_inp_val_name out nocopy varchar2,
131 p_found out nocopy boolean
132 );
133 procedure get_dynamic_contexts(p_business_group_id in number,
134 p_context_list out nocopy t_contexts_tab
135 );
136 function check_ctx_set (p_ee_id in number,
137 p_context_name in varchar2,
138 p_context_value in varchar2
139 ) return varchar2;
140 procedure assert_condition (p_location in varchar2,
141 p_condition in boolean);
142 function get_process_path(p_asg_action_id in number)
143 return varchar2;
144 procedure get_upgrade_status(p_bus_grp_id in number,
145 p_short_name in varchar2,
146 p_status out nocopy varchar2,
147 p_raise_error in boolean default TRUE);
148 function get_upgrade_status(p_bus_grp_id in number,
149 p_short_name in varchar2,
150 p_raise_error in varchar2 default 'TRUE')
151 return varchar2;
152
153 function getprl(p_pactid in number) return varchar2;
154 function get_context_iv_name (p_asg_act_id in number,
155 p_context in varchar2)
156 return varchar2;
157
158 function is_element_included (p_element_type_id in number,
159 p_run_type_id in number,
160 p_effective_date in date,
161 p_business_group_id in number,
162 p_legislation in varchar2,
163 p_label in varchar)
164 return varchar2;
165 /* Bug 11708644, PAYROLL/PROJECTS INTEGRATION FOR 12.2 */
166 procedure update_prj_flag ( p_element_type_id in pay_element_types_f.element_type_id%TYPE,
167 p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
168 p_flag in varchar2,
169 p_status out nocopy VARCHAR2
170 );
171 end pay_core_utils;