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

Line 434: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

430: if g_debug then
431: hr_utility.set_location(l_proc,50);
432: end if;
433: --
434: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));
435: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
436: l_organization_id := pay_balance_pkg.run_db_item(c_org_iv_name,g_business_group_id,g_legislation_code);
437: --
438: if g_debug and l_debug_cnt < 1 then

Line 620: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

616: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
617: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
618: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
619: elsif l_inputs(i).name = 'DATE_EARNED' then
620: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
621: --
622: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
623: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
624: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then

Line 663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

659: hr_utility.trace('payroll_id : '||g_payroll_id);
660: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
661: hr_utility.trace('assignment_id : '||g_assignment_id);
662: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
663: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
664: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
665: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
666: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
667: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);

Line 808: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);

804: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
805: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
806: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
807: elsif l_inputs(i).name = 'DATE_EARNED' then
808: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
809: --
810: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
811: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
812: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then

Line 847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));

843: hr_utility.trace('payroll_id : '||g_payroll_id);
844: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
845: hr_utility.trace('assignment_id : '||g_assignment_id);
846: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
847: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
848: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
849: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
850: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
851: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);

Line 1215: fnd_date.canonical_to_date(paei.aei_information3) start_date,

1211: null lip_prem_bon_ele,
1212: null cmi_prem_bal,
1213: null cmi_prem_mth_ele,
1214: null cmi_prem_bon_ele,
1215: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1216: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1217: paei.aei_information5 ins_type,
1218: null ins_period_start_date,
1219: paei.aei_information6 ins_period,

Line 1216: fnd_date.canonical_to_date(paei.aei_information4) end_date,

1212: null cmi_prem_bal,
1213: null cmi_prem_mth_ele,
1214: null cmi_prem_bon_ele,
1215: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1216: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1217: paei.aei_information5 ins_type,
1218: null ins_period_start_date,
1219: paei.aei_information6 ins_period,
1220: paei.aei_information7 contractor_name,

Line 1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1227: and paei.information_type = 'JP_ASS_LIG_INFO'
1228: -- include PC for customized valuset
1229: --and paei.aei_information1 in ('GIP','LINC')
1230: and g_effective_date
1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1233: and hoi.org_information1 = paei.aei_information2
1234: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION12,'O')
1235: and hoi.org_information_context

Line 1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1228: -- include PC for customized valuset
1229: --and paei.aei_information1 in ('GIP','LINC')
1230: and g_effective_date
1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1233: and hoi.org_information1 = paei.aei_information2
1234: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION12,'O')
1235: and hoi.org_information_context
1236: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1271: fnd_date.canonical_to_date(paei.aei_information3) start_date,

1267: null lip_prem_bon_ele,
1268: hoi.org_information11 cmi_prem_bal,
1269: hoi.org_information12 cmi_prem_mth_ele,
1270: hoi.org_information13 cmi_prem_bon_ele,
1271: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1272: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1273: paei.aei_information5 ins_type,
1274: null ins_period_start_date,
1275: paei.aei_information6 ins_period,

Line 1272: fnd_date.canonical_to_date(paei.aei_information4) end_date,

1268: hoi.org_information11 cmi_prem_bal,
1269: hoi.org_information12 cmi_prem_mth_ele,
1270: hoi.org_information13 cmi_prem_bon_ele,
1271: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1272: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1273: paei.aei_information5 ins_type,
1274: null ins_period_start_date,
1275: paei.aei_information6 ins_period,
1276: paei.aei_information7 contractor_name,

Line 1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1283: and paei.information_type = 'JP_ASS_CMI_INFO'
1284: -- include PC for customized valuset
1285: --and paei.aei_information1 in ('GIP','LINC')
1286: and g_effective_date
1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1289: and hoi.org_information1 = paei.aei_information2
1290: and nvl(hoi.ORG_INFORMATION10,'N') = 'N'
1291: and hoi.org_information_context

Line 1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1284: -- include PC for customized valuset
1285: --and paei.aei_information1 in ('GIP','LINC')
1286: and g_effective_date
1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1289: and hoi.org_information1 = paei.aei_information2
1290: and nvl(hoi.ORG_INFORMATION10,'N') = 'N'
1291: and hoi.org_information_context
1292: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1327: fnd_date.canonical_to_date(paei.aei_information3) start_date,

1323: hoi.org_information9 lip_prem_bon_ele,
1324: null cmi_prem_bal,
1325: null cmi_prem_mth_ele,
1326: null cmi_prem_bon_ele,
1327: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1328: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1329: paei.aei_information5 ins_type,
1330: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1331: paei.aei_information7 ins_period,

Line 1328: fnd_date.canonical_to_date(paei.aei_information4) end_date,

1324: null cmi_prem_bal,
1325: null cmi_prem_mth_ele,
1326: null cmi_prem_bon_ele,
1327: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1328: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1329: paei.aei_information5 ins_type,
1330: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1331: paei.aei_information7 ins_period,
1332: paei.aei_information8 contractor_name,

Line 1330: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,

1326: null cmi_prem_bon_ele,
1327: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1328: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1329: paei.aei_information5 ins_type,
1330: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1331: paei.aei_information7 ins_period,
1332: paei.aei_information8 contractor_name,
1333: paei.aei_information9 beneficiary_name,
1334: paei.aei_information10 beneficiary_relship,

Line 1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1339: and paei.information_type = 'JP_ASS_LIP_INFO'
1340: -- include PC for customized valuset
1341: --and paei.aei_information1 in ('GIP','LINC')
1342: and g_effective_date
1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1345: and hoi.org_information1 = paei.aei_information2
1346: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION13,'O')
1347: and hoi.org_information_context

Line 1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1340: -- include PC for customized valuset
1341: --and paei.aei_information1 in ('GIP','LINC')
1342: and g_effective_date
1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1345: and hoi.org_information1 = paei.aei_information2
1346: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION13,'O')
1347: and hoi.org_information_context
1348: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1380: fnd_date.canonical_to_date(paei.aei_information3) start_date,

1376: hoi.org_information9 eqi_prem_bon_ele,
1377: hoi.org_information4 ai_prem_bal,
1378: hoi.org_information5 ai_prem_mth_ele,
1379: hoi.org_information6 ai_prem_bon_ele,
1380: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1381: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1382: paei.aei_information5 ins_type,
1383: paei.aei_information6 ins_period,
1384: paei.aei_information7 contractor_name,

Line 1381: fnd_date.canonical_to_date(paei.aei_information4) end_date,

1377: hoi.org_information4 ai_prem_bal,
1378: hoi.org_information5 ai_prem_mth_ele,
1379: hoi.org_information6 ai_prem_bon_ele,
1380: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1381: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1382: paei.aei_information5 ins_type,
1383: paei.aei_information6 ins_period,
1384: paei.aei_information7 contractor_name,
1385: paei.aei_information8 beneficiary_name,

Line 1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1393: -- include PC for customized valuset
1394: --and paei.aei_information13 = 'AP'
1395: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1396: and g_effective_date
1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1399: and hoi.org_information1 = paei.aei_information2
1400: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1401: and hoi.organization_id = g_organization_id

Line 1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1394: --and paei.aei_information13 = 'AP'
1395: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1396: and g_effective_date
1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1399: and hoi.org_information1 = paei.aei_information2
1400: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1401: and hoi.organization_id = g_organization_id
1402: -- irregular case for duplicate org

Line 1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

1627: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

Line 1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

1628: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1629: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

Line 1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

1630: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1631: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1632: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1633: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1634: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1635: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1636: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1637: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1638: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

Line 1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

1711: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

Line 1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

1712: hr_utility.trace('cmi_prem_bal : '||l_li_info_rec.cmi_prem_bal);
1713: hr_utility.trace('cmi_prem_mth_ele : '||l_li_info_rec.cmi_prem_mth_ele);
1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

Line 1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

1714: hr_utility.trace('cmi_prem_bon_ele : '||l_li_info_rec.cmi_prem_bon_ele);
1715: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1716: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1717: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1718: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1719: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1720: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1721: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1722: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

Line 1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));

1795: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

Line 1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));

1796: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1797: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

Line 1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));

1798: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1799: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1800: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1801: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1802: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1803: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1804: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1805: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1806: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

Line 1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));

1882: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);

Line 1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));

1883: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1884: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1885: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1886: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1887: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1888: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1889: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1890: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1891: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);

Line 2429: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));

2425: hr_utility.set_location(l_proc,10);
2426: end if;
2427: --
2428: -- set context.
2429: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2430: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2431: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2432: --
2433: if g_debug then

Line 2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));

2431: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2432: --
2433: if g_debug then
2434: hr_utility.set_location(l_proc,20);
2435: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2436: hr_utility.trace('assignment_id : '||l_assignment_id);
2437: hr_utility.trace('tax_type : '||l_tax_type);
2438: end if;
2439: --