[Home] [Help]
27: from per_assignment_extra_info
28: where assignment_id = p_assignment_id
29: and assignment_extra_info_id <> p_assignment_extra_info_id
30: and information_type = p_information_type
31: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY'));
32: begin
33: if p_information_type in ('KR_YEA_SP_TAX_EXEM_INFO',
34: 'KR_YEA_TAX_EXEM_INFO',
35: 'KR_YEA_TAX_BREAK_INFO',
33: if p_information_type in ('KR_YEA_SP_TAX_EXEM_INFO',
34: 'KR_YEA_TAX_EXEM_INFO',
35: 'KR_YEA_TAX_BREAK_INFO',
36: 'KR_YEA_OVS_TAX_BREAK_INFO') then
37: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
38: --
39: -- Lock first assignment record in this calendar year
40: -- to guarantee uniqueness.
41: --
108: and information_type = p_information_type
109: and aei_information12 = l_aei_information12
110: and aei_information13 = l_aei_information13
111: and aei_information15 = '1'
112: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
113: --
114: cursor csr_oth(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
115: select sum(nvl(aei_information3,0))
116: from per_assignment_extra_info
118: and information_type = p_information_type
119: and aei_information12 = l_aei_information12
120: and aei_information13 = l_aei_information13
121: and aei_information15 = '2'
122: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
123: --
124: cursor csr_cont_rel_id is
125: select contact_relationship_id, national_identifier,
126: decode(nvl(cont_information11,decode(contact_type, 'S','3','P','1','B','5','SISTER','5',
168: begin
169: --
170: if p_information_type = 'KR_YEA_DETAIL_DONATION_INFO' and p_aei_information12 in ('5','4','3','2','1') then
171: --
172: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1;
173: --
174: for i in csr_cont_rel_id loop
175: l_cont_rel_id := i.contact_relationship_id;
176: l_ni_number := i.national_identifier;
387: and information_type = p_information_type_o
388: and aei_information12 = l_aei_information12
389: and aei_information13 = l_aei_information13
390: and aei_information15 = '1'
391: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
392: --
393: cursor csr_oth(l_aei_information12 in varchar2,l_aei_information13 in varchar2, p_effective_date in date) is
394: select sum(nvl(aei_information3,0))
395: from per_assignment_extra_info
397: and information_type = p_information_type_o
398: and aei_information12 = l_aei_information12
399: and aei_information13 = l_aei_information13
400: and aei_information15 = '2'
401: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
402: --
403: cursor csr_cont_rel_id is
404: select contact_relationship_id, national_identifier,
405: decode(nvl(cont_information11,decode(contact_type, 'S','3','P','1','B','5','SISTER','5',
447: begin
448: --
449: if p_information_type_o = 'KR_YEA_DETAIL_DONATION_INFO' and p_aei_information12_o in ('5','4','3','2','1') then
450: --
451: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1_o),'YYYY'),12) - 1;
452: --
453: for i in csr_cont_rel_id loop
454: l_cont_rel_id := i.contact_relationship_id;
455: l_ni_number := i.national_identifier;
640: and information_type = p_information_type
641: and aei_information2 = p_aei_information2
642: and nvl(aei_information7,'0') = nvl(p_aei_information7,'0') -- Bug 9213683
643: and nvl(aei_information8,'0') = nvl(p_aei_information8,'0')
644: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
645: --
646: begin
647: if (p_information_type = 'KR_YEA_DONATION_TYPE_DETAIL') then
648: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
644: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
645: --
646: begin
647: if (p_information_type = 'KR_YEA_DONATION_TYPE_DETAIL') then
648: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
649: l_year := to_char(fnd_date.canonical_to_date(p_aei_information1), 'YYYY');
650: if (fnd_number.canonical_to_number(p_aei_information2) < 2008 or
651: fnd_number.canonical_to_number(p_aei_information2) > fnd_number.canonical_to_number(l_year)) then
652: fnd_message.set_name('PAY', 'PAY_KR_TAX_PD_OUT_OF_RANGE');
645: --
646: begin
647: if (p_information_type = 'KR_YEA_DONATION_TYPE_DETAIL') then
648: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
649: l_year := to_char(fnd_date.canonical_to_date(p_aei_information1), 'YYYY');
650: if (fnd_number.canonical_to_number(p_aei_information2) < 2008 or
651: fnd_number.canonical_to_number(p_aei_information2) > fnd_number.canonical_to_number(l_year)) then
652: fnd_message.set_name('PAY', 'PAY_KR_TAX_PD_OUT_OF_RANGE');
653: fnd_message.raise_error;
733: where assignment_id = p_assignment_id
734: and information_type = p_information_type
735: and aei_information8 = p_aei_information8
736: and aei_information13 = '1'
737: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
738: --
739: cursor csr_oth(p_aei_information8 in varchar2, p_effective_date in date) is
740: select sum(nvl(aei_information3,0) + nvl(aei_information11,0))
741: from per_assignment_extra_info
742: where assignment_id = p_assignment_id
743: and information_type = p_information_type
744: and aei_information8 = p_aei_information8
745: and aei_information13 <> '1'
746: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
747: --
748: cursor csr_cont_rel_id is
749: select distinct pkc.contact_relationship_id, pkc.national_identifier
750: from pay_kr_contact_v pkc
789: begin
790: --
791: if p_information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' then
792: --
793: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1;
794: --
795: for i in csr_cont_rel_id loop
796: l_cont_rel_id := i.contact_relationship_id;
797: l_ni_number := i.national_identifier;
1003: where assignment_id = p_assignment_id_o
1004: and information_type = p_information_type_o
1005: and aei_information8 = p_aei_information8
1006: and aei_information13 = '1'
1007: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1008: --
1009: cursor csr_oth(p_aei_information8 in varchar2, p_effective_date in date) is
1010: select sum(nvl(aei_information3,0))
1011: from per_assignment_extra_info
1012: where assignment_id = p_assignment_id_o
1013: and information_type = p_information_type_o
1014: and aei_information8 = p_aei_information8
1015: and aei_information13 <> '1'
1016: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1017: --
1018: cursor csr_cont_rel_id is
1019: select distinct contact_relationship_id, national_identifier
1020: from pay_kr_contact_v pkc
1059: begin
1060: --
1061: if p_information_type_o = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO' then
1062: --
1063: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1_o),'YYYY'),12) - 1;
1064: --
1065: for i in csr_cont_rel_id loop
1066: l_cont_rel_id := i.contact_relationship_id;
1067: l_ni_number := i.national_identifier;
1248: and assignment_extra_info_id <> p_assignment_extra_info_id
1249: and information_type = p_information_type
1250: and aei_information2 = p_aei_information2
1251: and aei_information4 = p_aei_information4
1252: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
1253: --
1254: begin
1255: if (p_information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL') then
1256: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
1252: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
1253: --
1254: begin
1255: if (p_information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL') then
1256: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
1257: l_year := to_char(fnd_date.canonical_to_date(p_aei_information1), 'YYYY');
1258: --
1259: -- Check whether the 'Non-Taxable Earnings' and 'Business Registration No.' pair is unique.
1260: --
1253: --
1254: begin
1255: if (p_information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL') then
1256: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
1257: l_year := to_char(fnd_date.canonical_to_date(p_aei_information1), 'YYYY');
1258: --
1259: -- Check whether the 'Non-Taxable Earnings' and 'Business Registration No.' pair is unique.
1260: --
1261: open csr_unique;
1326: and information_type = p_information_type
1327: and aei_information2 = l_aei_information2
1328: and aei_information5 = l_aei_information5
1329: and aei_information6 = '1'
1330: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1331: --
1332: cursor csr_oth(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1333: select sum(nvl(aei_information4,0))
1334: from per_assignment_extra_info
1336: and information_type = p_information_type
1337: and aei_information2 = l_aei_information2
1338: and aei_information5 = l_aei_information5
1339: and aei_information6 = '2'
1340: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1341: --
1342: cursor csr_cont_rel_id is
1343: select contact_relationship_id, national_identifier,
1344: nvl(cont_information11,decode(contact_type,'P','1','S','3',
1387: begin
1388: --
1389: if p_information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO' then
1390: --
1391: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1;
1392: l_year := to_number(to_char(l_effective_date,'YYYY'));
1393: if l_year > 2008 then
1394: --
1395: if (p_aei_information6 is null) or (p_aei_information7 is null) then
1612: and information_type = p_information_type_o
1613: and aei_information2 = l_aei_information2
1614: and aei_information5 = l_aei_information5
1615: and aei_information6 = '1'
1616: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1617: --
1618: cursor csr_oth(l_aei_information2 in varchar2,l_aei_information5 in varchar2, p_effective_date in date) is
1619: select sum(nvl(aei_information4,0))
1620: from per_assignment_extra_info
1622: and information_type = p_information_type_o
1623: and aei_information2 = l_aei_information2
1624: and aei_information5 = l_aei_information5
1625: and aei_information6 = '2'
1626: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1627: --
1628: cursor csr_cont_rel_id is
1629: select contact_relationship_id, national_identifier,
1630: nvl(cont_information11,decode(contact_type,'P','1','S','3',
1673: begin
1674: --
1675: if p_information_type_o = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO' then
1676: --
1677: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1_o),'YYYY'),12) - 1;
1678: l_year := to_number(to_char(l_effective_date,'YYYY'));
1679: if l_year > 2008 then
1680: --
1681: for i in csr_cont_rel_id loop
1864: begin
1865: --
1866: if (p_information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO') then
1867:
1868: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1;
1869: l_year := to_number(to_char(l_effective_date,'YYYY'));
1870:
1871: if (p_aei_information7 <> '0') and (l_year > 2008) then
1872:
1909: assignment_id = p_assignment_id
1910: and information_type = p_information_type
1911: and aei_information6 = p_aei_information6
1912: and assignment_extra_info_id <> nvl(p_assignment_extra_info_id,0)
1913: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
1914:
1915: cursor csr_dup_acc_number is
1916: select 'Y'
1917: from per_assignment_extra_info
1920: and information_type = p_information_type
1921: and aei_information2 = p_aei_information2
1922: and aei_information4 = p_aei_information4
1923: and assignment_extra_info_id <> nvl(p_assignment_extra_info_id,0)
1924: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(l_effective_date, 'YYYY');
1925:
1926: begin
1927: if (p_information_type in ('KR_YEA_SEP_PEN_DETAILS','KR_YEA_PEN_SAVING_DETAILS',
1928: 'KR_YEA_HOU_SAVING_DETAILS','KR_YEA_LT_STOCK_SAVING_DETAILS')) then
1926: begin
1927: if (p_information_type in ('KR_YEA_SEP_PEN_DETAILS','KR_YEA_PEN_SAVING_DETAILS',
1928: 'KR_YEA_HOU_SAVING_DETAILS','KR_YEA_LT_STOCK_SAVING_DETAILS')) then
1929:
1930: l_effective_date := fnd_date.canonical_to_date(p_aei_information1);
1931: l_dup_priority := 'N';
1932: l_dup_acc_number := 'N';
1933: open csr_priority;
1934: fetch csr_priority into l_dup_priority;
1998:
1999: begin
2000: if p_information_type = 'KR_YEA_HOU_SAVING_DETAILS' and p_aei_information2 = 'HST1' then
2001:
2002: l_hou_sub_saving_limit := get_globalvalue('KR_YEA_HOUSINSAVINTYPE_HST1',fnd_date.canonical_to_date(p_aei_information1));
2003:
2004: if p_aei_information5 > l_hou_sub_saving_limit then
2005: fnd_message.set_name('PAY' , 'PAY_KR_MAX_HOU_SUB_SAVING');
2006: fnd_message.set_token('LIMIT',l_hou_sub_saving_limit);
2016: p_aei_information3 in varchar2,
2017: p_information_type in varchar2) is
2018:
2019: cursor csr_hou_cont_dates is
2020: select fnd_date.canonical_to_date(aei_information2) cont_start_date,
2021: fnd_date.canonical_to_date(aei_information3) cont_end_date
2022: from per_assignment_extra_info
2023: where
2024: assignment_id = p_assignment_id
2017: p_information_type in varchar2) is
2018:
2019: cursor csr_hou_cont_dates is
2020: select fnd_date.canonical_to_date(aei_information2) cont_start_date,
2021: fnd_date.canonical_to_date(aei_information3) cont_end_date
2022: from per_assignment_extra_info
2023: where
2024: assignment_id = p_assignment_id
2025: and information_type = p_information_type
2023: where
2024: assignment_id = p_assignment_id
2025: and information_type = p_information_type
2026: and assignment_extra_info_id <> nvl(p_assignment_extra_info_id,0)
2027: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(fnd_date.canonical_to_date(p_aei_information1), 'YYYY');
2028: l_flag varchar2(1);
2029: l_curr_start_date date;
2030: l_curr_end_date date;
2031: begin
2031: begin
2032: l_flag := 'N';
2033: if p_information_type = 'KR_YEA_HOU_RENT_DETAILS' then
2034:
2035: l_curr_start_date := fnd_date.canonical_to_date(p_aei_information2);
2036: l_curr_end_date := fnd_date.canonical_to_date(p_aei_information3);
2037:
2038: for i in csr_hou_cont_dates loop
2039: if l_curr_start_date between i.cont_start_date and i.cont_end_date then
2032: l_flag := 'N';
2033: if p_information_type = 'KR_YEA_HOU_RENT_DETAILS' then
2034:
2035: l_curr_start_date := fnd_date.canonical_to_date(p_aei_information2);
2036: l_curr_end_date := fnd_date.canonical_to_date(p_aei_information3);
2037:
2038: for i in csr_hou_cont_dates loop
2039: if l_curr_start_date between i.cont_start_date and i.cont_end_date then
2040: l_flag := 'Y';
2072: from per_assignment_extra_info
2073: where assignment_id = p_assignment_id
2074: and information_type = p_information_type
2075: and aei_information5 = p_aei_information5
2076: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2077: --
2078: cursor csr_get_donation_type_details(p_donated_year in varchar2, p_aei_information5 in varchar2, p_effective_date in date) is
2079: select assignment_extra_info_id
2080: from per_assignment_extra_info
2081: where assignment_id = p_assignment_id
2082: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2083: and aei_information2 = p_donated_year
2084: and aei_information8 = p_aei_information5
2085: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2086: --
2087: cursor validate_detail_rec(p_donated_year in varchar2, p_effective_date in date) is
2088: select assignment_extra_info_id
2089: from per_assignment_extra_info
2089: from per_assignment_extra_info
2090: where assignment_id = p_assignment_id
2091: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2092: and aei_information2 = p_donated_year
2093: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
2094: and aei_information8 not in (select distinct aei_information5
2095: from per_assignment_extra_info
2096: where assignment_id = p_assignment_id
2097: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
2094: and aei_information8 not in (select distinct aei_information5
2095: from per_assignment_extra_info
2096: where assignment_id = p_assignment_id
2097: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
2098: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY'));
2099: --
2100: cursor csr_donations_avail(p_effective_date in date) is
2101: select distinct aei_information5
2102: from per_assignment_extra_info
2101: select distinct aei_information5
2102: from per_assignment_extra_info
2103: where assignment_id = p_assignment_id
2104: and information_type = 'KR_YEA_DETAIL_DONATION_INFO'
2105: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2106: ----------------------------------------------------------------------------------------------
2107: begin
2108: --
2109: l_donated_amt := null;
2114: l_ovn := null;
2115: --
2116: if p_information_type = 'KR_YEA_DETAIL_DONATION_INFO' and p_aei_information12 in ('5','4','3','2','1') then
2117: --
2118: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1;
2119: l_donated_year := to_char(l_effective_date,'YYYY');
2120: --
2121: for i in csr_donations_avail(l_effective_date) loop
2122: --
2136: p_validate => false,
2137: p_assignment_extra_info_id => l_don_type_asg_info_id,
2138: p_object_version_number => l_ovn,
2139: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
2140: p_aei_information1 => fnd_date.date_to_canonical(l_effective_date),
2141: p_aei_information2 => l_donated_year,
2142: p_aei_information3 => '0',
2143: p_aei_information4 => '0',
2144: p_aei_information5 => '0',
2173: p_validate => false,
2174: p_assignment_id => p_assignment_id,
2175: p_information_type => 'KR_YEA_DONATION_TYPE_DETAIL',
2176: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
2177: p_aei_information1 => fnd_date.date_to_canonical(l_effective_date),
2178: p_aei_information2 => l_donated_year,
2179: p_aei_information3 => '0',
2180: p_aei_information4 => '0',
2181: p_aei_information5 => '0',
2243: from per_assignment_extra_info
2244: where assignment_id = p_assignment_id_o
2245: and information_type = p_information_type_o
2246: and aei_information5 = p_aei_information5_o
2247: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2248: --
2249: cursor csr_get_donation_type_details(p_donated_year in varchar2, p_effective_date in date) is
2250: select assignment_extra_info_id,
2251: object_version_number
2253: where assignment_id = p_assignment_id_o
2254: and information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
2255: and aei_information2 = p_donated_year
2256: and aei_information8 = p_aei_information5_o
2257: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
2258: --
2259:
2260:
2261: ----------------------------------------------------------------------------------------------
2268: l_ovn := null;
2269: --
2270: if p_information_type_o = 'KR_YEA_DETAIL_DONATION_INFO' and p_aei_information12_o in ('5','4','3','2','1') then
2271: --
2272: l_effective_date := add_months(trunc(fnd_date.canonical_to_date(p_aei_information1_o),'YYYY'),12) - 1;
2273: l_donated_year := to_char(l_effective_date,'YYYY');
2274: --
2275: open csr_get_donation_details(l_effective_date);
2276: fetch csr_get_donation_details into l_donated_amt;
2286: p_validate => false,
2287: p_assignment_extra_info_id => l_don_type_asg_info_id,
2288: p_object_version_number => l_ovn,
2289: p_aei_information_category => 'KR_YEA_DONATION_TYPE_DETAIL',
2290: p_aei_information1 => fnd_date.date_to_canonical(l_effective_date),
2291: p_aei_information2 => l_donated_year,
2292: p_aei_information3 => '0',
2293: p_aei_information4 => '0',
2294: p_aei_information5 => '0',
2349: begin
2350: --
2351: if p_information_type = 'KR_YEA_DETAIL_DONATION_INFO' then
2352: --
2353: l_year := to_char((add_months(trunc(fnd_date.canonical_to_date(p_aei_information1),'YYYY'),12) - 1),'YYYY');
2354: --
2355: if ((p_aei_information12 <> '1') and
2356: (p_aei_information5 = '20' or p_aei_information5 = '42') and
2357: (to_number(l_year) >= 2008)) then
2365: end if;
2366: --
2367: -- Bug 13247926
2368: if ( (p_aei_information5 = '30')
2369: and (fnd_date.canonical_to_date(p_aei_information2) > to_date('2011/06/30', 'YYYY/MM/DD'))
2370: and (to_number(l_year) >= 2011) )
2371: then
2372: l_donation_type := hr_general.decode_lookup('KR_YEA_DONATION_TYPE', p_aei_information5);
2373: fnd_message.set_name('PAY', 'PAY_KR_TAX_LAW_DON_ERROR');
2394: c_20140101 := to_date('01-01-2014','DD-MM-YYYY');
2395:
2396: if p_information_type in('KR_YEA_TAX_REDUCTION_SMB','KR_YEA_TAX_REDUCTION_TEACHERS','KR_YEA_TAX_REDUCTION_MARINE') then
2397:
2398: l_curr_start_date := fnd_date.canonical_to_date(p_aei_information1);
2399: l_curr_end_date := fnd_date.canonical_to_date(p_aei_information2);
2400:
2401: if l_curr_start_date < c_20120101 or l_curr_start_date >= c_20140101 then
2402: l_flag := 'Y';
2395:
2396: if p_information_type in('KR_YEA_TAX_REDUCTION_SMB','KR_YEA_TAX_REDUCTION_TEACHERS','KR_YEA_TAX_REDUCTION_MARINE') then
2397:
2398: l_curr_start_date := fnd_date.canonical_to_date(p_aei_information1);
2399: l_curr_end_date := fnd_date.canonical_to_date(p_aei_information2);
2400:
2401: if l_curr_start_date < c_20120101 or l_curr_start_date >= c_20140101 then
2402: l_flag := 'Y';
2403: elsif l_curr_start_date > l_curr_end_date then
2422: begin
2423: c_20150101 := to_date('01-01-2015','DD-MM-YYYY');
2424:
2425: if p_information_type in('KR_YEA_FW_TAX_BREAK_INFO') then
2426: l_contract_date := fnd_date.canonical_to_date(p_aei_information2);
2427: l_expiry_date := fnd_date.canonical_to_date(p_aei_information3);
2428:
2429: if l_expiry_date < l_contract_date or l_expiry_date >= c_20150101 then
2430: fnd_message.set_name('PAY' , 'PAY_KR_FW_TAX_BREAK_END_DATE');
2423: c_20150101 := to_date('01-01-2015','DD-MM-YYYY');
2424:
2425: if p_information_type in('KR_YEA_FW_TAX_BREAK_INFO') then
2426: l_contract_date := fnd_date.canonical_to_date(p_aei_information2);
2427: l_expiry_date := fnd_date.canonical_to_date(p_aei_information3);
2428:
2429: if l_expiry_date < l_contract_date or l_expiry_date >= c_20150101 then
2430: fnd_message.set_name('PAY' , 'PAY_KR_FW_TAX_BREAK_END_DATE');
2431: fnd_message.raise_error;