eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA20110101_PKG dependencies on FND_DATE

Line 5: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01') ;

1: package body pay_kr_yea20110101_pkg as
2: /* $Header: pykryea10.pkb 120.11.12020000.9 2012/07/05 13:15:09 amnaraya ship $ */
3: -- Constant
4: -- Bug 3966549
5: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01') ;
6: -- End of 3966549
7: -- Bug 9231094
8: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01') ;
9: c_20130101 constant date := fnd_date.canonical_to_date('2013/01/01') ;

Line 8: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01') ;

4: -- Bug 3966549
5: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01') ;
6: -- End of 3966549
7: -- Bug 9231094
8: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01') ;
9: c_20130101 constant date := fnd_date.canonical_to_date('2013/01/01') ;
10: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01') ;
11:
12: -- Bug 9393732

Line 9: c_20130101 constant date := fnd_date.canonical_to_date('2013/01/01') ;

5: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01') ;
6: -- End of 3966549
7: -- Bug 9231094
8: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01') ;
9: c_20130101 constant date := fnd_date.canonical_to_date('2013/01/01') ;
10: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01') ;
11:
12: -- Bug 9393732
13: l_pledt_tax_exem number default 0;

Line 10: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01') ;

6: -- End of 3966549
7: -- Bug 9231094
8: c_20100101 constant date := fnd_date.canonical_to_date('2010/01/01') ;
9: c_20130101 constant date := fnd_date.canonical_to_date('2013/01/01') ;
10: c_20120101 constant date := fnd_date.canonical_to_date('2012/01/01') ;
11:
12: -- Bug 9393732
13: l_pledt_tax_exem number default 0;
14: l_tlaw_tax_exem number default 0;

Line 268: select fnd_date.canonical_to_date(aei_information1) Effective_date,

264: l_user_entered_flag varchar2(2) := null;
265:
266: --
267: cursor get_donation_details is
268: select fnd_date.canonical_to_date(aei_information1) Effective_date,
269: aei_information8 Donation_Code,
270: to_number(aei_information2) Donated_Year,
271: to_number(aei_information9) Donated_Amount,
272: to_number(aei_information3) Exempted_Balance,

Line 281: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

277: from per_assignment_extra_info
278: where assignment_id = p_assignment_id
279: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
280: and assignment_extra_info_id = p_asg_info_id
281: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
282: --
283: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
284: select assignment_extra_info_id, object_version_number
285: from per_assignment_extra_info

Line 290: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY');

286: where assignment_id = p_assignment_id
287: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
288: and aei_information2 = p_donated_year
289: and aei_information8 = p_donation_code
290: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY');
291: --
292: begin
293: --
294: if g_debug then

Line 380: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),

376: p_validate => false,
377: p_assignment_extra_info_id => p_asg_info_id,
378: p_object_version_number => l_ovn,
379: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
380: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
381: p_aei_information2 => l_donation_year,
382: p_aei_information3 => l_exem_balance,
383: p_aei_information4 => p_exem_for_target_year,
384: p_aei_information5 => l_carryoveramt,

Line 435: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),

431: p_validate => false,
432: p_assignment_id => p_assignment_id,
433: p_information_type => 'KR_YEA_DONATION_TYPE_DETAIL',
434: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
435: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
436: p_aei_information2 => l_donation_year,
437: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
438: p_aei_information4 => '0',
439: p_aei_information5 => '0',

Line 481: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),

477: p_validate => false,
478: p_assignment_extra_info_id => l_asgInfoId,
479: p_object_version_number => l_ovn1,
480: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
481: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
482: p_aei_information2 => l_donation_year,
483: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
484: p_aei_information4 => '0',
485: p_aei_information5 => '0',

Line 543: fnd_date.canonical_to_date(aei_information1) effective_date,

539: l_amt_sub_exem number := 0;
540: --
541: cursor get_donation_details is
542: select assignment_extra_info_id asg_info_id,
543: fnd_date.canonical_to_date(aei_information1) effective_date,
544: to_number(aei_information2) donated_year,
545: to_number(aei_information9) donated_amount,
546: to_number(aei_information3) exempted_balance,
547: to_number(aei_information10) amt_sub_to_exem,

Line 554: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

550: where assignment_id = p_assignment_id
551: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
552: and aei_information8 = p_donation_code
553: and aei_information2 = to_char(p_effective_date, 'YYYY')
554: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
555:
556: begin
557: --
558: if g_debug then

Line 595: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),

591: p_validate => false,
592: p_assignment_extra_info_id => l_asg_info_id,
593: p_object_version_number => l_ovn,
594: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
595: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
596: p_aei_information2 => l_donation_year,
597: p_aei_information3 => l_exem_balance,
598: p_aei_information4 => p_exem_for_target_year,
599: p_aei_information5 => '0',

Line 642: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')

638: select assignment_extra_info_id
639: from per_assignment_extra_info
640: where assignment_id = p_assignment_id
641: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
642: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
643: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));
644: --
645: begin
646: for i in del_future_details loop

Line 673: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

669: to_number(aei_information11) obsolete_amt
670: from per_assignment_extra_info
671: where assignment_id = p_assignment_id
672: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
673: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
674: --
675: begin
676: --
677: for i in chk_donation_details loop

Line 1700: get_globalvalue('KR_YEA_RELIGIOUS_DONATION_TAX_EXEM_PER2',fnd_date.canonical_to_date(to_char(p_yea_info.spec_rel_grpby_don_year_tbl(i)||'/01/01')))), l_spec_actual_amount);

1696: + least(trunc( (p_yea_info.taxable_income
1697: - p_yea_info.donation1_tax_exem
1698: - p_yea_info.donation3_tax_exem
1699: - p_yea_info.esoa_don_tax_exem2004) *
1700: get_globalvalue('KR_YEA_RELIGIOUS_DONATION_TAX_EXEM_PER2',fnd_date.canonical_to_date(to_char(p_yea_info.spec_rel_grpby_don_year_tbl(i)||'/01/01')))), l_spec_actual_amount);
1701:
1702: p_yea_info.spec_rel_max_exem_amt(i) := l_spec_year_limit;
1703: p_yea_info.max_donation2_tax_exem := p_yea_info.max_donation2_tax_exem + l_spec_year_limit;
1704:

Line 1895: get_globalvalue('KR_YEA_DONATION2_TAX_EXEM_PER',fnd_date.canonical_to_date(to_char(p_yea_info.spec_rel_grpby_don_year_tbl(i)||'/01/01')))),

1891:
1892: l_spec_year_limit := least(trunc( (p_yea_info.taxable_income - p_yea_info.donation1_tax_exem
1893: - p_yea_info.donation3_tax_exem
1894: - p_yea_info.esoa_don_tax_exem2004) *
1895: get_globalvalue('KR_YEA_DONATION2_TAX_EXEM_PER',fnd_date.canonical_to_date(to_char(p_yea_info.spec_rel_grpby_don_year_tbl(i)||'/01/01')))),
1896: p_yea_info.spec_rel_amt_grpby_year_tbl(i));
1897:
1898: p_yea_info.spec_rel_max_exem_amt(i) := l_spec_year_limit;
1899: p_yea_info.max_donation2_tax_exem := p_yea_info.max_donation2_tax_exem + l_spec_year_limit;