DBA Data[Home] [Help]

APPS.PAY_AU_BAL_UPLOAD dependencies on HR_AU_ROUTES

Line 129: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_cal_year_start) ;

125:
126: if (p_dimension_name = '_ASG_CAL_YTD') or (p_dimension_name = '_ASG_LE_CAL_YTD')then
127:
128: -- get start of dimension
129: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_cal_year_start) ;
130: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
131: if l_expiry_date > p_upload_date
132: then
133: raise e_bad_expiry_date ;

Line 139: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_fbt_year_start) ;

135:
136: elsif (p_dimension_name = '_ASG_FBT_YTD') or (p_dimension_name = '_ASG_LE_FBT_YTD') then
137:
138: -- get start of dimension
139: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_fbt_year_start) ;
140: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
141: if l_expiry_date > p_upload_date
142: then
143: raise e_bad_expiry_date ;

Line 149: l_dimension_start_date := hr_au_routes.fiscal_span_start(p_upload_date, 4, l_business_group_id) ;

145:
146: elsif (p_dimension_name = '_ASG_FY_QTD')or (p_dimension_name = '_ASG_LE_FY_QTD') then
147:
148: -- get start of dimension
149: l_dimension_start_date := hr_au_routes.fiscal_span_start(p_upload_date, 4, l_business_group_id) ;
150: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
151: if l_expiry_date > p_upload_date
152: then
153: raise e_bad_expiry_date ;

Line 159: l_dimension_start_date := hr_au_routes.fiscal_span_start(p_upload_date, 1, l_business_group_id) ;

155:
156: elsif (p_dimension_name = '_ASG_FY_YTD') or (p_dimension_name = '_ASG_LE_FY_YTD')then
157:
158: -- get start of dimension
159: l_dimension_start_date := hr_au_routes.fiscal_span_start(p_upload_date, 1, l_business_group_id) ;
160: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
161: if l_expiry_date > p_upload_date
162: then
163: raise e_bad_expiry_date ;

Line 169: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 12, g_cal_year_start) ;

165:
166: elsif (p_dimension_name = '_ASG_MTD')or (p_dimension_name = '_ASG_LE_MTD') then
167:
168: -- get start of dimension
169: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 12, g_cal_year_start) ;
170: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
171: if l_expiry_date > p_upload_date
172: then
173: raise e_bad_expiry_date ;

Line 197: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 4, g_tax_year_start) ;

193:
194: elsif (p_dimension_name = '_ASG_QTD') or (p_dimension_name = '_ASG_LE_QTD') then
195:
196: -- get start of dimension
197: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 4, g_tax_year_start) ;
198: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
199: if l_expiry_date > p_upload_date
200: then
201: raise e_bad_expiry_date ;

Line 217: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_tax_year_start) ;

213:
214: -- get start of dimension
215: /* Bug 4516174 Modified the frequency from 4 to 1 */
216:
217: l_dimension_start_date := hr_au_routes.span_start(p_upload_date, 1, g_tax_year_start) ;
218: l_expiry_date := greatest(l_asg_start_date, l_dimension_start_date) ;
219: if l_expiry_date > p_upload_date
220: then
221: raise e_bad_expiry_date ;