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

Line 6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');

2: /* $Header: pykryea.pkb 120.18.12010000.6 2008/08/12 10:26:35 vaisriva ship $ */
3: ------------------------------------------------------------------------
4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');

Line 7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');

3: ------------------------------------------------------------------------
4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');

Line 8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');

4: -- Constants
5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313

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

5: ------------------------------------------------------------------------
6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170

Line 10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');

6: c_00010101 constant date := fnd_date.canonical_to_date('0001/01/01');
7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: ------------------------------------------------------------------------

Line 11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');

7: c_20020101 constant date := fnd_date.canonical_to_date('2002/01/01');
8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: ------------------------------------------------------------------------
15: -- Global Variables

Line 12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313

8: c_20030101 constant date := fnd_date.canonical_to_date('2003/01/01');
9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: ------------------------------------------------------------------------
15: -- Global Variables
16: ------------------------------------------------------------------------

Line 13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170

9: c_20040101 constant date := fnd_date.canonical_to_date('2004/01/01');
10: c_20050101 constant date := fnd_date.canonical_to_date('2005/01/01');
11: c_20060101 constant date := fnd_date.canonical_to_date('2006/01/01');
12: c_20070101 constant date := fnd_date.canonical_to_date('2007/01/01'); -- Bug 5734313
13: c_20080101 constant date := fnd_date.canonical_to_date('2008/01/01'); -- Bug 6705170
14: ------------------------------------------------------------------------
15: -- Global Variables
16: ------------------------------------------------------------------------
17: g_package constant varchar2(31) := ' pay_kr_yea_pkg.';

Line 267: p_archive_item_value := fnd_date.canonical_to_date(l_archive_item_value_tbl(p_user_entity_id));

263: ----------------------------------------------------------------
264: is
265: begin
266: if l_archive_item_value_tbl.exists(p_user_entity_id) then
267: p_archive_item_value := fnd_date.canonical_to_date(l_archive_item_value_tbl(p_user_entity_id));
268: end if;
269: end set_archive_item;
270: begin
271: ------------------------------------------------------------------------

Line 520: set_archive_item(p_user_entity_id, fnd_date.date_to_canonical(p_archive_item_value));

516: p_archive_item_value in date)
517: ----------------------------------------------------------------
518: is
519: begin
520: set_archive_item(p_user_entity_id, fnd_date.date_to_canonical(p_archive_item_value));
521: end set_archive_item;
522: begin
523: if p_report_type = g_archive_item.report_type
524: and p_report_qualifier = g_archive_item.report_qualifier

Line 791: select fnd_date.canonical_to_date(aei_information1),

787: p_stax_tbl out nocopy t_number_tbl)
788: ------------------------------------------------------------------------
789: is
790: cursor csr_aei is
791: select fnd_date.canonical_to_date(aei_information1),
792: aei_information2,
793: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD'),
794: nvl(to_number(aei_information4), 0),
795: nvl(to_number(aei_information5), 0),

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

808: nvl(to_number(aei_information17), 0) -- Bug 6024342
809: from per_assignment_extra_info
810: where assignment_id = p_assignment_id
811: and information_type = 'KR_YEA_PREV_ER_INFO'
812: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
813: order by 1;
814: begin
815: open csr_aei;
816: fetch csr_aei bulk collect into

Line 900: fnd_date.canonical_to_date(aei_information13),

896: nvl(to_number(aei_information7), 0),
897: nvl(to_number(aei_information8), 0),
898: nvl(to_number(aei_information9), 0),
899: nvl(to_number(aei_information10), 0),
900: fnd_date.canonical_to_date(aei_information13),
901: fnd_date.canonical_to_date(aei_information14),
902: nvl(to_number(aei_information15), 0),
903: fnd_date.canonical_to_date(aei_information16),
904: nvl(to_number(aei_information17), 0),

Line 901: fnd_date.canonical_to_date(aei_information14),

897: nvl(to_number(aei_information8), 0),
898: nvl(to_number(aei_information9), 0),
899: nvl(to_number(aei_information10), 0),
900: fnd_date.canonical_to_date(aei_information13),
901: fnd_date.canonical_to_date(aei_information14),
902: nvl(to_number(aei_information15), 0),
903: fnd_date.canonical_to_date(aei_information16),
904: nvl(to_number(aei_information17), 0),
905: fnd_date.canonical_to_date(aei_information25),

Line 903: fnd_date.canonical_to_date(aei_information16),

899: nvl(to_number(aei_information10), 0),
900: fnd_date.canonical_to_date(aei_information13),
901: fnd_date.canonical_to_date(aei_information14),
902: nvl(to_number(aei_information15), 0),
903: fnd_date.canonical_to_date(aei_information16),
904: nvl(to_number(aei_information17), 0),
905: fnd_date.canonical_to_date(aei_information25),
906: nvl(to_number(aei_information26), 0),
907: nvl(to_number(aei_information18), 0),

Line 905: fnd_date.canonical_to_date(aei_information25),

901: fnd_date.canonical_to_date(aei_information14),
902: nvl(to_number(aei_information15), 0),
903: fnd_date.canonical_to_date(aei_information16),
904: nvl(to_number(aei_information17), 0),
905: fnd_date.canonical_to_date(aei_information25),
906: nvl(to_number(aei_information26), 0),
907: nvl(to_number(aei_information18), 0),
908: nvl(to_number(aei_information19), 0),
909: nvl(to_number(aei_information20), 0),

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

920: nvl(to_number(aei_information24), 0)
921: from per_assignment_extra_info
922: where assignment_id = p_assignment_id
923: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO'
924: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
925:
926: cursor csr_aei2 is
927: select nvl(to_number(aei_information2), 0) -- Bug 3971542 Employee's occupational training (educational) expense
928: ,nvl(to_number(aei_information3), 0) -- Bug 4704848

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

932: ,nvl(to_number(aei_information11), 0) -- Bug 7260606
933: from per_assignment_extra_info
934: where assignment_id = p_assignment_id
935: and information_type = 'KR_YEA_SP_TAX_EXEM_INFO2'
936: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
937:
938: --
939: -- Bug 5255234 Cursor to get the dependent Insurnace Expenses.
940: --

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

980: ,nvl(sum(decode(aei_information9,'A',0,'B',0,decode(aei_information7,0,0,(nvl(aei_information3,0) + nvl(aei_information11,0))))),0) -- Dependent Total
981: from per_assignment_extra_info
982: where assignment_id = p_assignment_id
983: and information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
984: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
985: begin
986: open csr_aei;
987: fetch csr_aei into
988: p_hi_prem,

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

1083: nvl(to_number(aei_information4), 0)
1084: from per_assignment_extra_info
1085: where assignment_id = p_assignment_id
1086: and information_type = 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO'
1087: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1088: begin
1089: open csr_aei;
1090: fetch csr_aei bulk collect into
1091: p_contact_type_tbl,

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

1108: nvl(to_number(aei_information3), 0)
1109: from per_assignment_extra_info
1110: where assignment_id = p_assignment_id
1111: and information_type = 'KR_YEA_FW_TAX_EXEM_INFO'
1112: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1113: begin
1114: open csr_aei;
1115: fetch csr_aei into
1116: p_educ_expense,

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

1132: nvl(to_number(aei_information3), 0)
1133: from per_assignment_extra_info
1134: where assignment_id = p_assignment_id
1135: and information_type = 'KR_YEA_HOU_EXP_TAX_EXEM_INFO'
1136: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1137: begin
1138: open csr_aei;
1139: fetch csr_aei bulk collect into
1140: p_saving_type_tbl,

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

1203: nvl(to_number(aei_information20), 0) -- Small Business Installment Amount Bug 6895093
1204: from per_assignment_extra_info
1205: where assignment_id = p_assignment_id
1206: and information_type = 'KR_YEA_TAX_EXEM_INFO'
1207: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1208:
1209: --Bug 5255234
1210: -- Bug 5879106
1211: cursor csr_get_dpnt_card_expense is

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

1295: nvl(to_number(aei_information5), 0)
1296: from per_assignment_extra_info
1297: where assignment_id = p_assignment_id
1298: and information_type = 'KR_YEA_TAX_BREAK_INFO'
1299: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1300: begin
1301: open csr_aei;
1302: fetch csr_aei into
1303: p_housing_loan_interest_repay,

Line 1326: select fnd_date.canonical_to_date(aei_information1),

1322: p_submission_date in out nocopy date)
1323: ------------------------------------------------------------------------
1324: is
1325: cursor csr_aei is
1326: select fnd_date.canonical_to_date(aei_information1),
1327: aei_information2,
1328: aei_information3,
1329: nvl(to_number(aei_information4), 0),
1330: nvl(to_number(aei_information5), 0),

Line 1334: fnd_date.canonical_to_date(aei_information9),

1330: nvl(to_number(aei_information5), 0),
1331: nvl(to_number(aei_information6), 0),
1332: nvl(to_number(aei_information7), 0),
1333: nvl(to_number(aei_information8), 0),
1334: fnd_date.canonical_to_date(aei_information9),
1335: fnd_date.canonical_to_date(aei_information10)
1336: from per_assignment_extra_info
1337: where assignment_id = p_assignment_id
1338: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'

Line 1335: fnd_date.canonical_to_date(aei_information10)

1331: nvl(to_number(aei_information6), 0),
1332: nvl(to_number(aei_information7), 0),
1333: nvl(to_number(aei_information8), 0),
1334: fnd_date.canonical_to_date(aei_information9),
1335: fnd_date.canonical_to_date(aei_information10)
1336: from per_assignment_extra_info
1337: where assignment_id = p_assignment_id
1338: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
1339: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');

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

1335: fnd_date.canonical_to_date(aei_information10)
1336: from per_assignment_extra_info
1337: where assignment_id = p_assignment_id
1338: and information_type = 'KR_YEA_OVS_TAX_BREAK_INFO'
1339: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY');
1340: begin
1341: open csr_aei;
1342: fetch csr_aei into
1343: p_tax_paid_date,

Line 1375: fnd_date.canonical_to_date(aei_information2),

1371: ------------------------------------------------------------------------
1372: is
1373: cursor csr_aei is
1374: select aei_information1,
1375: fnd_date.canonical_to_date(aei_information2),
1376: fnd_date.canonical_to_date(aei_information3),
1377: fnd_date.canonical_to_date(aei_information5),
1378: fnd_date.canonical_to_date(aei_information6)
1379: from per_assignment_extra_info

Line 1376: fnd_date.canonical_to_date(aei_information3),

1372: is
1373: cursor csr_aei is
1374: select aei_information1,
1375: fnd_date.canonical_to_date(aei_information2),
1376: fnd_date.canonical_to_date(aei_information3),
1377: fnd_date.canonical_to_date(aei_information5),
1378: fnd_date.canonical_to_date(aei_information6)
1379: from per_assignment_extra_info
1380: where assignment_id = p_assignment_id

Line 1377: fnd_date.canonical_to_date(aei_information5),

1373: cursor csr_aei is
1374: select aei_information1,
1375: fnd_date.canonical_to_date(aei_information2),
1376: fnd_date.canonical_to_date(aei_information3),
1377: fnd_date.canonical_to_date(aei_information5),
1378: fnd_date.canonical_to_date(aei_information6)
1379: from per_assignment_extra_info
1380: where assignment_id = p_assignment_id
1381: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'

Line 1378: fnd_date.canonical_to_date(aei_information6)

1374: select aei_information1,
1375: fnd_date.canonical_to_date(aei_information2),
1376: fnd_date.canonical_to_date(aei_information3),
1377: fnd_date.canonical_to_date(aei_information5),
1378: fnd_date.canonical_to_date(aei_information6)
1379: from per_assignment_extra_info
1380: where assignment_id = p_assignment_id
1381: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
1382: and p_effective_date between -- Bug 5083240: Consider end date to be last day of contract_expiry_date year

Line 1383: fnd_date.canonical_to_date(aei_information2)

1379: from per_assignment_extra_info
1380: where assignment_id = p_assignment_id
1381: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
1382: and p_effective_date between -- Bug 5083240: Consider end date to be last day of contract_expiry_date year
1383: fnd_date.canonical_to_date(aei_information2)
1384: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;
1385: --
1386: --
1387: cursor csr_fw_contract_earn(

Line 1384: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;

1380: where assignment_id = p_assignment_id
1381: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO'
1382: and p_effective_date between -- Bug 5083240: Consider end date to be last day of contract_expiry_date year
1383: fnd_date.canonical_to_date(aei_information2)
1384: and (add_months(trunc(fnd_date.canonical_to_date(aei_information3), 'YYYY'), 12) - 1) ;
1385: --
1386: --
1387: cursor csr_fw_contract_earn(
1388: p_contr_start_date date,

Line 2405: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_displaydate(l_effective_date));

2401: close csr_archive_exists;
2402:
2403: if l_effective_date > p_effective_date then
2404: fnd_message.set_name('PAY', 'PAY_KR_YEA_ALREADY_PROCESSED');
2405: fnd_message.set_token('EFFECTIVE_DATE', fnd_date.date_to_displaydate(l_effective_date));
2406: p_error := fnd_message.get;
2407: return;
2408: else
2409: if p_report_category in ('N', 'I') then