DBA Data[Home] [Help]

APPS.PAY_IE_P35_XML_PKG dependencies on PAY_IE_P35

Line 1: PACKAGE BODY PAY_IE_P35_XML_PKG AS

1: PACKAGE BODY PAY_IE_P35_XML_PKG AS
2: /* $Header: pyiep35p.pkb 120.15.12020000.4 2013/02/04 11:44:12 rsahai ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- get_IANA_charset

Line 165: pay_ie_p35.get_parameter (

161: AND paaf.effective_start_date <= l_end_date
162: AND paaf.effective_end_date >= l_start_date
163: AND paaf.ASSIGNMENT_TYPE <> 'A' --16210193
164: AND TO_DATE (
165: pay_ie_p35.get_parameter (
166: ppa.payroll_action_id,
167: 'END_DATE'
168: ),
169: 'YYYY/MM/DD'

Line 310: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();

306: vCtr := 1;
307: --vXMLTable(vCtr).xmlString := ' '; -- get_IANA_charset
308: vXMLTable(vCtr).xmlString := ' ';
309: vCtr := vCtr + 1;
310: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
311: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
312: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
313: hr_utility.set_location('End Date : '||p_end_date,100);
314:

Line 311: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();

307: --vXMLTable(vCtr).xmlString := ' '; -- get_IANA_charset
308: vXMLTable(vCtr).xmlString := ' ';
309: vCtr := vCtr + 1;
310: l_start_date := PAY_IE_P35_XML_PKG.get_start_date();
311: -- l_end_date := PAY_IE_P35_XML_PKG.get_end_date();
312: l_end_date := fnd_date.canonical_to_date(p_end_date); --4641756
313: hr_utility.set_location('End Date : '||p_end_date,100);
314:
315: l_reporting_year := to_char(l_start_date,'RRRR'); --12382953

Line 515: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'

511: INTO l_start_date
512: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
513: WHERE fpo.profile_option_id = fpov.profile_option_id
514: AND fpo.application_id = fpov.application_id
515: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
516: AND fpov.level_id = 10001
517: AND fpov.level_value = 0;
518:
519: RETURN l_start_date;

Line 537: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'

533: INTO l_end_date
534: FROM fnd_profile_option_values fpov, fnd_profile_options fpo
535: WHERE fpo.profile_option_id = fpov.profile_option_id
536: AND fpo.application_id = fpov.application_id
537: AND fpo.profile_option_name = 'PAY_IE_P35_REPORTING_YEAR'
538: AND fpov.level_id = 10001
539: AND fpov.level_value = 0;
540:
541: RETURN l_end_date;

Line 544: END PAY_IE_P35_XML_PKG;

540:
541: RETURN l_end_date;
542: END get_end_date;
543: --
544: END PAY_IE_P35_XML_PKG;