1 package pay_core_utils as
2 /* $Header: pycorutl.pkh 120.7.12010000.2 2008/10/01 06:12:55 ankagarw ship $ */
3 --
4 g_cache_business_group BOOLEAN;
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;
8 type char_array is table of varchar(30) 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_dyt_business_group (p_statement varchar2) return number;
48 function get_legislation_code (p_bg_id number) return varchar2;
49 procedure reset_cached_values;
50 procedure get_time_definition(p_element_entry in number,
51 p_asg_act_id in number,
52 p_time_def_id out nocopy number);
53 function get_time_period_start(p_payroll_action_id in number
54 ) return date;
55 function get_entry_end_date(p_element_type_id in number,
56 p_payroll_action_id in number,
57 p_assignment_action_id in number,
58 p_date_earned in date ) return date;
59 procedure get_prorated_dates(p_ee_id in number,
60 p_asg_act_id in number,
61 p_time_def_type in varchar2,
62 p_time_def_id in out nocopy number,
63 p_date_array out nocopy char_array,
64 p_type_array out nocopy char_array
65 );
66 procedure set_prorate_dates(p_et_id in number,
67 p_asg_act_id in number,
68 p_date_array in char_array,
69 p_type_array in char_array,
70 p_arr_cnt in number,
71 p_prd_end out nocopy varchar2,
72 p_start_date out nocopy varchar2,
73 p_end_date out nocopy varchar2
74 );
75 procedure get_rr_id( p_rr_id_list out nocopy varchar2);
76 procedure get_aa_id( p_aa_id_list out nocopy varchar2);
77 procedure get_rb_id( p_rb_id_list out nocopy varchar2);
78 procedure push_message(p_applid in number,
79 p_msg_name in varchar2,
80 p_level in varchar2
81 );
82 procedure push_message(p_applid in number,
83 p_msg_name in varchar2,
84 p_msg_txt in varchar2,
85 p_level in varchar2
86 );
87 procedure push_token(
88 p_tok_name in varchar2,
89 p_tok_value in varchar2
90 );
91 procedure pop_message(
92 p_msg_text out nocopy varchar2
93 );
94 procedure pop_message(
95 p_msg_text out nocopy varchar2,
96 p_sev_level out nocopy varchar2
97 );
98 procedure mesg_stack_error_hdlr(p_pactid in number);
99
100 function get_pp_action_id(p_action_type in varchar2,
101 p_action_id in number) return number;
102 function include_action_in_payment(p_calling_action_type in varchar2,
103 p_calling_action_id in number,
104 p_run_action_id in number
105 ) return varchar2;
106 procedure set_pap_group_id(p_pap_group_id in number);
107 function get_pap_group_id return number;
108 pay_action_parameter_group_id number;
109 procedure get_action_parameter(p_para_name in varchar2,
110 p_para_value out nocopy varchar2,
111 p_found out nocopy boolean
112 );
113 procedure get_report_f_parameter(
114 p_payroll_action_id in number,
115 p_para_name in varchar2,
116 p_para_value out nocopy varchar2,
117 p_found out nocopy boolean
118 );
119 procedure get_legislation_rule(p_legrul_name in varchar2,
120 p_legislation in varchar2,
121 p_legrul_value out nocopy varchar2,
122 p_found out nocopy boolean
123 );
124 procedure unset_context_iv_cache;
125 procedure get_leg_context_iv_name(p_context_name in varchar2,
126 p_legislation in varchar2,
127 p_inp_val_name out nocopy varchar2,
128 p_found out nocopy boolean
129 );
130 procedure get_dynamic_contexts(p_business_group_id in number,
131 p_context_list out nocopy t_contexts_tab
132 );
133 function check_ctx_set (p_ee_id in number,
134 p_context_name in varchar2,
135 p_context_value in varchar2
136 ) return varchar2;
137 procedure assert_condition (p_location in varchar2,
138 p_condition in boolean);
139 function get_process_path(p_asg_action_id in number)
140 return varchar2;
141 procedure get_upgrade_status(p_bus_grp_id in number,
142 p_short_name in varchar2,
143 p_status out nocopy varchar2,
144 p_raise_error in boolean default TRUE);
145 function get_upgrade_status(p_bus_grp_id in number,
146 p_short_name in varchar2,
147 p_raise_error in varchar2 default 'TRUE')
148 return varchar2;
149
150 function getprl(p_pactid in number) return varchar2;
151 function get_context_iv_name (p_asg_act_id in number,
152 p_context in varchar2)
153 return varchar2;
154
155 function is_element_included (p_element_type_id in number,
156 p_run_type_id in number,
157 p_effective_date in date,
158 p_business_group_id in number,
159 p_legislation in varchar2,
160 p_label in varchar)
161 return varchar2;
162 end pay_core_utils;