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_YEA20100101_PKG dependencies on FND_DATE

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

1: package body pay_kr_yea20100101_pkg as
2: /* $Header: pykryea9.pkb 120.18 2011/08/29 05:53:49 keyazawa noship $ */
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 258: select fnd_date.canonical_to_date(aei_information1) Effective_date,

254: l_obsolete_amt number := 0;
255: l_carryoveramt number := 0;
256: --
257: cursor get_donation_details is
258: select fnd_date.canonical_to_date(aei_information1) Effective_date,
259: aei_information8 Donation_Code,
260: to_number(aei_information2) Donated_Year,
261: to_number(aei_information9) Donated_Amount,
262: to_number(aei_information3) Exempted_Balance,

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

265: from per_assignment_extra_info
266: where assignment_id = p_assignment_id
267: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
268: and assignment_extra_info_id = p_asg_info_id
269: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
270: --
271: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
272: select assignment_extra_info_id, object_version_number
273: from per_assignment_extra_info

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

274: where assignment_id = p_assignment_id
275: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
276: and aei_information2 = p_donated_year
277: and aei_information8 = p_donation_code
278: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY');
279: --
280: begin
281: --
282: if g_debug then

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

357: p_validate => false,
358: p_assignment_extra_info_id => p_asg_info_id,
359: p_object_version_number => l_ovn,
360: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
361: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
362: p_aei_information2 => l_donation_year,
363: p_aei_information3 => l_exem_balance,
364: p_aei_information4 => p_exem_for_target_year,
365: p_aei_information5 => l_carryoveramt,

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

412: p_validate => false,
413: p_assignment_id => p_assignment_id,
414: p_information_type => 'KR_YEA_DONATION_TYPE_DETAIL',
415: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
416: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
417: p_aei_information2 => l_donation_year,
418: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
419: p_aei_information4 => '0',
420: p_aei_information5 => '0',

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

458: p_validate => false,
459: p_assignment_extra_info_id => l_asgInfoId,
460: p_object_version_number => l_ovn1,
461: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
462: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
463: p_aei_information2 => l_donation_year,
464: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
465: p_aei_information4 => '0',
466: p_aei_information5 => '0',

Line 524: fnd_date.canonical_to_date(aei_information1) effective_date,

520: l_amt_sub_exem number := 0;
521: --
522: cursor get_donation_details is
523: select assignment_extra_info_id asg_info_id,
524: fnd_date.canonical_to_date(aei_information1) effective_date,
525: to_number(aei_information2) donated_year,
526: to_number(aei_information9) donated_amount,
527: to_number(aei_information3) exempted_balance,
528: to_number(aei_information10) amt_sub_to_exem,

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

531: where assignment_id = p_assignment_id
532: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
533: and aei_information8 = p_donation_code
534: and aei_information2 = to_char(p_effective_date, 'YYYY')
535: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
536:
537: begin
538: --
539: if g_debug then

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

572: p_validate => false,
573: p_assignment_extra_info_id => l_asg_info_id,
574: p_object_version_number => l_ovn,
575: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
576: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
577: p_aei_information2 => l_donation_year,
578: p_aei_information3 => l_exem_balance,
579: p_aei_information4 => p_exem_for_target_year,
580: p_aei_information5 => '0',

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

619: select assignment_extra_info_id
620: from per_assignment_extra_info
621: where assignment_id = p_assignment_id
622: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
623: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
624: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));
625: --
626: begin
627: for i in del_future_details loop

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

650: to_number(aei_information11) obsolete_amt
651: from per_assignment_extra_info
652: where assignment_id = p_assignment_id
653: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
654: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
655: --
656: begin
657: --
658: for i in chk_donation_details loop