DBA Data[Home] [Help]

APPS.PAY_AU_BAL_UPLOAD dependencies on HR_AU_ROUTES

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

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

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

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

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

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

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

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

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

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

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

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

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

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