1: PACKAGE BODY PAY_IE_P35_XML_PKG AS
2: /* $Header: pyiep35p.pkb 120.11.12010000.1 2008/07/27 22:50:15 appldev ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- get_IANA_charset
160: AND flex.segment4 = p_emp_no
161: AND paaf.effective_start_date <= l_end_date
162: AND paaf.effective_end_date >= l_start_date
163: AND TO_DATE (
164: pay_ie_p35.get_parameter (
165: ppa.payroll_action_id,
166: 'END_DATE'
167: ),
168: 'YYYY/MM/DD'
286: vCtr := 1;
287: --vXMLTable(vCtr).xmlString := '
288: vXMLTable(vCtr).xmlString := '
289: vCtr := vCtr + 1;
290: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
291: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
292: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
293: hr_utility.set_location('End Date : '||p_end_date,100);
294:
287: --vXMLTable(vCtr).xmlString := '
288: vXMLTable(vCtr).xmlString := '
289: vCtr := vCtr + 1;
290: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
291: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
292: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
293: hr_utility.set_location('End Date : '||p_end_date,100);
294:
295: IF p_payroll = 0 then
449: INTO l_start_date
450: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
451: WHERE fpo.profile_option_id = fpov.profile_option_id
452: AND fpo.application_id = fpov.application_id
453: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
454: AND fpov.level_id = 10001
455: AND fpov.level_value = 0;
456:
457: RETURN l_start_date;
471: INTO l_end_date
472: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
473: WHERE fpo.profile_option_id = fpov.profile_option_id
474: AND fpo.application_id = fpov.application_id
475: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
476: AND fpov.level_id = 10001
477: AND fpov.level_value = 0;
478:
479: RETURN l_end_date;
478:
479: RETURN l_end_date;
480: END get_end_date;
481: --
482: END PAY_IE_P35_XML_PKG;