[Home] [Help]
PACKAGE: APPS.PAY_RETRO_PKG
Source
1 package pay_retro_pkg
2 /* $Header: pyretpay.pkh 120.6.12020000.2 2012/07/06 11:57:30 vmaripal ship $ */
3 AUTHID CURRENT_USER as
4 --
5 --
6 /*
7 PRODUCT
8 Oracle*Payroll
9 --
10 NAME
11 pyretpay.pkh
12 --
13 DESCRIPTION
14 --
15 MODIFIED (DD-MON-YYYY)
16 vpallapo 16-JAN-2012 Modified get_retro_element, added
17 p_payroll_id and p_assact_id
18 kkawol 02-AUG-2007 Added reset_recorded_request and
19 process_recorded_request.
20 nbristow 15-JAN-2006 Added overlap_adjustments.
21 nbristow 12-SEP-2006 Added new get_entry_path.
22 nbristow 01-JUN-2006 Added process_retro_entry.
23 nbristow 14-MAR-2006 Added get_retro_asg_id.
24 kkawol 26-JAN-2006 added get_entry_path to convert entry
25 paths for retropay into new shorter format.
26 nbristow 25-NOV-2004 Allow Retropaying multi assignments.
27 jford 07-SEP-2004 get_retro_component_id, 3 params in pyretutl.pkh
28 tbattoo 09-AUG-2004 Added functions to suport reversals in retropay
29 jford 27-JUL-2004 maintain_retro_entry
30 nbristow 14-JUL-2004 Changes for Enhanced Retro Notifiction.
31 nbristow 15-MAR-2004 Added is_retro_rr.
32 kkawol 09-DEC-2003 Added latest_replace_ovl_ee,
33 latest_replace_ovl_del_ee.
34 kkawol 20-NOV-2003 Passing bus grp id to get_retro_element,
35 this is required when calling is_date_in_span.
36 nbristow 07-OCT-2003 Added nocopy to get_ee_overlap_date.
37 nbristow 07-OCT-2003 Added process_retro_value.
38 nbristow 03-OCT-2003 Added get_ee_overlap_date.
39 nbristow 02-SEP-2003 Changed get_retro_element to
40 return correct element.
41 nbristow 28-AUG-2003 Added dbdrv statements.
42 nbristow 27-AUG-2003 Changes for Advanced Retropay.
43 jalloun 30-JUL-1996 Added error handling.
44 nbristow 12-MAR-1996 Created.
45 */
46 procedure retro_run_proc;
47 procedure retro_end_proc;
48 function process_retro_entry(
49 p_element_entry_id in number,
50 p_element_type_id in number,
51 p_retro_comp_id in number,
52 p_retro_asg_id in number,
53 p_ee_creator_id in number,
54 p_action_sequence in number
55 )
56 return number;
57 function get_rr_source_id(p_rr_id in number)
58 return number;
59 function get_rr_source_type(p_rr_id in number)
60 return varchar2;
61 function process_value(p_value_type in varchar2,
62 p_entry_id in number,
63 p_element_type_id in number,
64 p_retro_comp_id in number,
65 p_retro_asg_id in number,
66 p_result_type in varchar2)
67 return varchar2;
68 function is_retro_entry(p_creator_type in varchar2)
69 return number;
70 function is_retro_rr(p_element_entry_id in number,
71 p_date in date)
72 return number;
73 function get_reprocess_type(
74 p_entry_id in number,
75 p_element_type_id in number,
76 p_retro_comp_id in number,
77 p_retro_asg_id in number,
78 p_default_type in varchar2 default 'R'
79 )
80 return varchar2;
81 function get_retro_process_type(
82 p_entry_id in number,
83 p_element_type_id in number,
84 p_retro_comp_id in number,
85 p_retro_asg_id in number,
86 p_source_type in varchar2
87 )
88 return varchar2;
89 function get_source_element_type (p_entry_id in number,
90 p_aa_id in number)
91 return number;
92 --
93 procedure get_retro_element(p_element_type_id in number,
94 p_retro_eff_date in date,
95 p_run_eff_date in date,
96 p_retro_comp_id in number,
97 p_adjustment_type in varchar2,
98 p_retro_ele_type_id out nocopy number,
99 p_business_group_id in number default null,
100 p_payroll_id in number default 0,
101 p_assact_id in number default 0
102 );
103 function process_retro_value(
104 p_entry_id in number,
105 p_element_type_id in number,
106 p_retro_comp_id in number,
107 p_retro_asg_id in number
108 )
109 return varchar2;
110 --
111 procedure get_ee_overlap_date(p_assact in number,
112 p_start_date in date,
113 p_effective_date in date,
114 p_adj_start_date out nocopy date
115 );
116 --
117 function latest_replace_ovl_ee ( p_element_entry_id in NUMBER)
118 return varchar2;
119 --
120 function latest_replace_ovl_del_ee ( p_element_entry_id in NUMBER)
121 return varchar2;
122 --
123 FUNCTION get_retro_component_id (
124 p_element_entry_id in number,
125 p_ef_date in date)
126 return number;
127 --
128 procedure maintain_retro_entry
129 (
130 p_retro_assignment_id IN NUMBER
131 , p_element_entry_id IN NUMBER
132 , p_element_type_id IN NUMBER
133 , p_reprocess_date IN DATE
134 , p_eff_date IN DATE
135 , p_retro_component_id IN NUMBER
136 , p_owner_type IN VARCHAR2 default 'S' --System
137 , p_system_reprocess_date IN DATE default hr_api.g_eot
138 );
139 --
140 procedure merge_retro_assignments(p_asg_act_id in number);
141 --
142 procedure generate_obj_grp_actions (p_pactid in number,
143 p_chunk_number in number);
144 --
145 function get_asg_from_pg_action(p_obj_grp_id in number,
146 p_obj_type in varchar2,
147 p_pactid in number)
148 return number;
149 --
150 function get_entry_path( p_entry_process_path in varchar2,
151 p_source_type in varchar2,
152 p_element_type_id in number,
153 p_run_result_id in number)
154 return varchar2;
155 function get_entry_path( p_run_result_id in number)
156 return varchar2;
157 --
158 function get_retro_asg_id(p_assignment_action in number)
159 return number;
160 --
161 procedure overlap_adjustments(p_asg_act_id in number,
162 p_definition_id in number,
163 p_component_id in number,
164 p_ele_set_id in number
165 );
166 --
167 function process_recorded_date (p_process in varchar2,
168 p_assignment_id in varchar2,
169 p_adj_start_date in date,
170 p_assact_id in number)
171 return date;
172 --
173 procedure reset_recorded_request(p_assact_id in number);
174 --
175 end pay_retro_pkg;