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