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 430: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(g_effective_date));

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

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

610: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
611: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
612: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
613: elsif l_inputs(i).name = 'DATE_EARNED' then
614: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
615: --
616: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
617: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
618: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then

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

647: hr_utility.trace('payroll_id : '||g_payroll_id);
648: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
649: hr_utility.trace('assignment_id : '||g_assignment_id);
650: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
651: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
652: hr_utility.trace('i_info_type : '||p_ins_info_rec.info_type);
653: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
654: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
655: hr_utility.trace('i_lig_prem_bal : '||p_ins_info_rec.lig_prem_bal);

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

786: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
787: elsif l_inputs(i).name = 'ASSIGNMENT_ACTION_ID' then
788: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_action_id);
789: elsif l_inputs(i).name = 'DATE_EARNED' then
790: l_inputs(i).value := fnd_date.date_to_canonical(g_effective_date);
791: --
792: elsif l_inputs(i).name = 'I_ASSIGNMENT_ID' then
793: l_inputs(i).value := fnd_number.number_to_canonical(g_assignment_id);
794: elsif l_inputs(i).name = 'I_ASSIGNMENT_ACTION_ID' then

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

825: hr_utility.trace('payroll_id : '||g_payroll_id);
826: hr_utility.trace('payroll_action_id : '||g_payroll_action_id);
827: hr_utility.trace('assignment_id : '||g_assignment_id);
828: hr_utility.trace('assignment_action_id : '||g_assignment_action_id);
829: hr_utility.trace('effective_date : '||fnd_date.date_to_canonical(g_effective_date));
830: hr_utility.trace('i_ins_class : '||p_ins_info_rec.ins_class);
831: hr_utility.trace('i_ins_term_type : '||p_ins_info_rec.ins_term_type);
832: hr_utility.trace('i_ins_comp_code : '||p_ins_info_rec.ins_comp_code);
833: hr_utility.trace('i_eqi_prem_bal : '||p_ins_info_rec.eqi_prem_bal);

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

1173: hoi.org_information6 lig_prem_bon_ele,
1174: null lip_prem_bal,
1175: null lip_prem_mth_ele,
1176: null lip_prem_bon_ele,
1177: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1178: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1179: paei.aei_information5 ins_type,
1180: null ins_period_start_date,
1181: paei.aei_information6 ins_period,

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

1174: null lip_prem_bal,
1175: null lip_prem_mth_ele,
1176: null lip_prem_bon_ele,
1177: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1178: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1179: paei.aei_information5 ins_type,
1180: null ins_period_start_date,
1181: paei.aei_information6 ins_period,
1182: paei.aei_information7 contractor_name,

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

1189: and paei.information_type = 'JP_ASS_LIG_INFO'
1190: -- include PC for customized valuset
1191: --and paei.aei_information1 in ('GIP','LINC')
1192: and g_effective_date
1193: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1194: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1195: and hoi.org_information1 = paei.aei_information2
1196: and hoi.org_information_context
1197: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

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

1190: -- include PC for customized valuset
1191: --and paei.aei_information1 in ('GIP','LINC')
1192: and g_effective_date
1193: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1194: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1195: and hoi.org_information1 = paei.aei_information2
1196: and hoi.org_information_context
1197: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')
1198: and hoi.organization_id = g_organization_id

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

1223: null lig_prem_bon_ele,
1224: hoi.org_information7 lip_prem_bal,
1225: hoi.org_information8 lip_prem_mth_ele,
1226: hoi.org_information9 lip_prem_bon_ele,
1227: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1228: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1229: paei.aei_information5 ins_type,
1230: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1231: paei.aei_information7 ins_period,

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

1224: hoi.org_information7 lip_prem_bal,
1225: hoi.org_information8 lip_prem_mth_ele,
1226: hoi.org_information9 lip_prem_bon_ele,
1227: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1228: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1229: paei.aei_information5 ins_type,
1230: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1231: paei.aei_information7 ins_period,
1232: paei.aei_information8 contractor_name,

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

1226: hoi.org_information9 lip_prem_bon_ele,
1227: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1228: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1229: paei.aei_information5 ins_type,
1230: fnd_date.canonical_to_date(paei.aei_information6) ins_period_start_date,
1231: paei.aei_information7 ins_period,
1232: paei.aei_information8 contractor_name,
1233: paei.aei_information9 beneficiary_name,
1234: paei.aei_information10 beneficiary_relship,

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

1239: and paei.information_type = 'JP_ASS_LIP_INFO'
1240: -- include PC for customized valuset
1241: --and paei.aei_information1 in ('GIP','LINC')
1242: and g_effective_date
1243: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1244: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1245: and hoi.org_information1 = paei.aei_information2
1246: and hoi.org_information_context
1247: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

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

1240: -- include PC for customized valuset
1241: --and paei.aei_information1 in ('GIP','LINC')
1242: and g_effective_date
1243: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1244: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1245: and hoi.org_information1 = paei.aei_information2
1246: and hoi.org_information_context
1247: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')
1248: and hoi.organization_id = g_organization_id

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

1274: hoi.org_information9 eqi_prem_bon_ele,
1275: hoi.org_information4 ai_prem_bal,
1276: hoi.org_information5 ai_prem_mth_ele,
1277: hoi.org_information6 ai_prem_bon_ele,
1278: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1279: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1280: paei.aei_information5 ins_type,
1281: paei.aei_information6 ins_period,
1282: paei.aei_information7 contractor_name,

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

1275: hoi.org_information4 ai_prem_bal,
1276: hoi.org_information5 ai_prem_mth_ele,
1277: hoi.org_information6 ai_prem_bon_ele,
1278: fnd_date.canonical_to_date(paei.aei_information3) start_date,
1279: fnd_date.canonical_to_date(paei.aei_information4) end_date,
1280: paei.aei_information5 ins_type,
1281: paei.aei_information6 ins_period,
1282: paei.aei_information7 contractor_name,
1283: paei.aei_information8 beneficiary_name,

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

1291: -- include PC for customized valuset
1292: --and paei.aei_information13 = 'AP'
1293: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1294: and g_effective_date
1295: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1296: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1297: and hoi.org_information1 = paei.aei_information2
1298: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1299: and hoi.organization_id = g_organization_id

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

1292: --and paei.aei_information13 = 'AP'
1293: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1294: and g_effective_date
1295: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1296: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1297: and hoi.org_information1 = paei.aei_information2
1298: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1299: and hoi.organization_id = g_organization_id
1300: -- irregular case for duplicate org

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

1513: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

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

1514: hr_utility.trace('lig_prem_bal : '||l_li_info_rec.lig_prem_bal);
1515: hr_utility.trace('lig_prem_mth_ele : '||l_li_info_rec.lig_prem_mth_ele);
1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

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

1516: hr_utility.trace('lig_prem_bon_ele : '||l_li_info_rec.lig_prem_bon_ele);
1517: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1518: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1519: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1520: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1521: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1522: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1523: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1524: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

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

1593: hr_utility.trace('calc_prem_ff : '||l_li_info_rec.calc_prem_ff);
1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);

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

1594: hr_utility.trace('lip_prem_bal : '||l_li_info_rec.lip_prem_bal);
1595: hr_utility.trace('lip_prem_mth_ele : '||l_li_info_rec.lip_prem_mth_ele);
1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);

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

1596: hr_utility.trace('lip_prem_bon_ele : '||l_li_info_rec.lip_prem_bon_ele);
1597: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_li_info_rec.start_date));
1598: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_li_info_rec.end_date));
1599: hr_utility.trace('ins_type : '||l_li_info_rec.ins_type);
1600: hr_utility.trace('ins_period_start_date : '||fnd_date.date_to_canonical(l_li_info_rec.ins_period_start_date));
1601: hr_utility.trace('ins_period : '||l_li_info_rec.ins_period);
1602: hr_utility.trace('contractor_name : '||l_li_info_rec.contractor_name);
1603: hr_utility.trace('beneficiary_name : '||l_li_info_rec.beneficiary_name);
1604: hr_utility.trace('beneficiary_relship : '||l_li_info_rec.beneficiary_relship);

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

1678: hr_utility.trace('eqi_prem_bon_ele : '||l_ai_info_rec.eqi_prem_bon_ele);
1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);

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

1679: hr_utility.trace('ai_prem_bal : '||l_ai_info_rec.ai_prem_bal);
1680: hr_utility.trace('ai_prem_mth_ele : '||l_ai_info_rec.ai_prem_mth_ele);
1681: hr_utility.trace('ai_prem_bon_ele : '||l_ai_info_rec.ai_prem_bon_ele);
1682: hr_utility.trace('start_date : '||fnd_date.date_to_canonical(l_ai_info_rec.start_date));
1683: hr_utility.trace('end_date : '||fnd_date.date_to_canonical(l_ai_info_rec.end_date));
1684: hr_utility.trace('ins_type : '||l_ai_info_rec.ins_type);
1685: hr_utility.trace('ins_period : '||l_ai_info_rec.ins_period);
1686: hr_utility.trace('contractor_name : '||l_ai_info_rec.contractor_name);
1687: hr_utility.trace('beneficiary_name : '||l_ai_info_rec.beneficiary_name);

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

2181: hr_utility.set_location(l_proc,10);
2182: end if;
2183: --
2184: -- set context.
2185: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_effective_date));
2186: pay_balance_pkg.set_context('ASSIGNMENT_ID',fnd_number.number_to_canonical(l_assignment_id));
2187: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2188: --
2189: if g_debug then

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

2187: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name,g_business_group_id,g_legislation_code);
2188: --
2189: if g_debug then
2190: hr_utility.set_location(l_proc,20);
2191: hr_utility.trace('date_earned : '||fnd_date.date_to_canonical(p_effective_date));
2192: hr_utility.trace('assignment_id : '||l_assignment_id);
2193: hr_utility.trace('tax_type : '||l_tax_type);
2194: end if;
2195: --