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

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

1: package body pay_kr_yea20120101_pkg as
2: /* $Header: pykryea11.pkb 120.0.12020000.16 2013/03/08 07:09:34 scireddy 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 288: select fnd_date.canonical_to_date(aei_information1) Effective_date,

284: l_user_entered_flag varchar2(2) := null;
285:
286: --
287: cursor get_donation_details is
288: select fnd_date.canonical_to_date(aei_information1) Effective_date,
289: aei_information8 Donation_Code,
290: to_number(aei_information2) Donated_Year,
291: to_number(aei_information9) Donated_Amount,
292: to_number(aei_information3) Exempted_Balance,

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

297: from per_assignment_extra_info
298: where assignment_id = p_assignment_id
299: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
300: and assignment_extra_info_id = p_asg_info_id
301: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
302: --
303: cursor check_records_exists(p_donated_year in varchar2,p_donation_code in varchar2) is
304: select assignment_extra_info_id, object_version_number
305: from per_assignment_extra_info

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

306: where assignment_id = p_assignment_id
307: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
308: and aei_information2 = p_donated_year
309: and aei_information8 = p_donation_code
310: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY');
311: --
312: begin
313: --
314: if g_debug then

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

401: p_validate => false,
402: p_assignment_extra_info_id => p_asg_info_id,
403: p_object_version_number => l_ovn,
404: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
405: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
406: p_aei_information2 => l_donation_year,
407: p_aei_information3 => l_exem_balance,
408: p_aei_information4 => p_exem_for_target_year,
409: p_aei_information5 => l_carryoveramt,

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

456: p_validate => false,
457: p_assignment_id => p_assignment_id,
458: p_information_type => 'KR_YEA_DONATION_TYPE_DETAIL',
459: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
460: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
461: p_aei_information2 => l_donation_year,
462: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
463: p_aei_information4 => '0',
464: p_aei_information5 => '0',

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

502: p_validate => false,
503: p_assignment_extra_info_id => l_asgInfoId,
504: p_object_version_number => l_ovn1,
505: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
506: p_aei_information1 => fnd_date.date_to_canonical(add_months(l_eff_date,12)),
507: p_aei_information2 => l_donation_year,
508: p_aei_information3 => (l_exem_balance + p_exem_for_target_year),
509: p_aei_information4 => '0',
510: p_aei_information5 => '0',

Line 568: fnd_date.canonical_to_date(aei_information1) effective_date,

564: l_amt_sub_exem number := 0;
565: --
566: cursor get_donation_details is
567: select assignment_extra_info_id asg_info_id,
568: fnd_date.canonical_to_date(aei_information1) effective_date,
569: to_number(aei_information2) donated_year,
570: to_number(aei_information9) donated_amount,
571: to_number(aei_information3) exempted_balance,
572: to_number(aei_information10) amt_sub_to_exem,

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

575: where assignment_id = p_assignment_id
576: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
577: and aei_information8 = p_donation_code
578: and aei_information2 = to_char(p_effective_date, 'YYYY')
579: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
580:
581: begin
582: --
583: if g_debug then

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

616: p_validate => false,
617: p_assignment_extra_info_id => l_asg_info_id,
618: p_object_version_number => l_ovn,
619: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
620: p_aei_information1 => fnd_date.date_to_canonical(l_eff_date),
621: p_aei_information2 => l_donation_year,
622: p_aei_information3 => l_exem_balance,
623: p_aei_information4 => p_exem_for_target_year,
624: p_aei_information5 => '0',

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

663: select assignment_extra_info_id
664: from per_assignment_extra_info
665: where assignment_id = p_assignment_id
666: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
667: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(add_months(p_effective_date,12), 'YYYY')
668: and to_number(aei_information2) < to_number(to_char(add_months(p_effective_date,12),'YYYY'));
669: --
670: begin
671: for i in del_future_details loop

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

694: to_number(aei_information11) obsolete_amt
695: from per_assignment_extra_info
696: where assignment_id = p_assignment_id
697: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
698: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
699: --
700: begin
701: --
702: for i in chk_donation_details loop