1291: ,p_weekly_tax_credit => l_weekly_tax_credit
1292: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1293: ,p_monthly_tax_credit => l_monthly_tax_credit
1294: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1295: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1296: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1297: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1298: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1299: ,p_object_version_number => l_api_ovn
1292: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1293: ,p_monthly_tax_credit => l_monthly_tax_credit
1294: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1295: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1296: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1297: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1298: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1299: ,p_object_version_number => l_api_ovn
1300: ,p_effective_start_date => l_start_date
1293: ,p_monthly_tax_credit => l_monthly_tax_credit
1294: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1295: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1296: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1297: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1298: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1299: ,p_object_version_number => l_api_ovn
1300: ,p_effective_start_date => l_start_date
1301: ,p_effective_end_date => l_end_date
1294: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1295: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1296: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1297: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1298: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1299: ,p_object_version_number => l_api_ovn
1300: ,p_effective_start_date => l_start_date
1301: ,p_effective_end_date => l_end_date
1302: );
1320: ,p_weekly_tax_credit => l_weekly_tax_credit
1321: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1322: ,p_monthly_tax_credit => l_monthly_tax_credit
1323: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1324: ,p_tax_deducted_to_date => hr_api.g_number
1325: ,p_pay_to_date => hr_api.g_number
1326: ,p_disability_benefit => hr_api.g_number
1327: ,p_lump_sum_payment => hr_api.g_number
1328: ,p_object_version_number => l_api_ovn
1321: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1322: ,p_monthly_tax_credit => l_monthly_tax_credit
1323: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1324: ,p_tax_deducted_to_date => hr_api.g_number
1325: ,p_pay_to_date => hr_api.g_number
1326: ,p_disability_benefit => hr_api.g_number
1327: ,p_lump_sum_payment => hr_api.g_number
1328: ,p_object_version_number => l_api_ovn
1329: ,p_effective_start_date => l_start_date
1322: ,p_monthly_tax_credit => l_monthly_tax_credit
1323: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1324: ,p_tax_deducted_to_date => hr_api.g_number
1325: ,p_pay_to_date => hr_api.g_number
1326: ,p_disability_benefit => hr_api.g_number
1327: ,p_lump_sum_payment => hr_api.g_number
1328: ,p_object_version_number => l_api_ovn
1329: ,p_effective_start_date => l_start_date
1330: ,p_effective_end_date => l_end_date);
1323: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1324: ,p_tax_deducted_to_date => hr_api.g_number
1325: ,p_pay_to_date => hr_api.g_number
1326: ,p_disability_benefit => hr_api.g_number
1327: ,p_lump_sum_payment => hr_api.g_number
1328: ,p_object_version_number => l_api_ovn
1329: ,p_effective_start_date => l_start_date
1330: ,p_effective_end_date => l_end_date);
1331: else -- asg start date > paye start date then update using asg start date
1344: ,p_weekly_tax_credit => l_weekly_tax_credit
1345: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1346: ,p_monthly_tax_credit => l_monthly_tax_credit
1347: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1348: ,p_tax_deducted_to_date => hr_api.g_number
1349: ,p_pay_to_date => hr_api.g_number
1350: ,p_disability_benefit => hr_api.g_number
1351: ,p_lump_sum_payment => hr_api.g_number
1352: ,p_object_version_number => l_api_ovn
1345: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1346: ,p_monthly_tax_credit => l_monthly_tax_credit
1347: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1348: ,p_tax_deducted_to_date => hr_api.g_number
1349: ,p_pay_to_date => hr_api.g_number
1350: ,p_disability_benefit => hr_api.g_number
1351: ,p_lump_sum_payment => hr_api.g_number
1352: ,p_object_version_number => l_api_ovn
1353: ,p_effective_start_date => l_start_date
1346: ,p_monthly_tax_credit => l_monthly_tax_credit
1347: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1348: ,p_tax_deducted_to_date => hr_api.g_number
1349: ,p_pay_to_date => hr_api.g_number
1350: ,p_disability_benefit => hr_api.g_number
1351: ,p_lump_sum_payment => hr_api.g_number
1352: ,p_object_version_number => l_api_ovn
1353: ,p_effective_start_date => l_start_date
1354: ,p_effective_end_date => l_end_date);
1347: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1348: ,p_tax_deducted_to_date => hr_api.g_number
1349: ,p_pay_to_date => hr_api.g_number
1350: ,p_disability_benefit => hr_api.g_number
1351: ,p_lump_sum_payment => hr_api.g_number
1352: ,p_object_version_number => l_api_ovn
1353: ,p_effective_start_date => l_start_date
1354: ,p_effective_end_date => l_end_date);
1355: end if; -- end of check with asg start date
1369: ,p_weekly_tax_credit => l_weekly_tax_credit
1370: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1371: ,p_monthly_tax_credit => l_monthly_tax_credit
1372: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1373: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1374: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1375: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1376: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1377: ,p_object_version_number => l_api_ovn
1370: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1371: ,p_monthly_tax_credit => l_monthly_tax_credit
1372: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1373: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1374: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1375: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1376: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1377: ,p_object_version_number => l_api_ovn
1378: ,p_effective_start_date => l_start_date
1371: ,p_monthly_tax_credit => l_monthly_tax_credit
1372: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1373: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1374: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1375: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1376: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1377: ,p_object_version_number => l_api_ovn
1378: ,p_effective_start_date => l_start_date
1379: ,p_effective_end_date => l_end_date);
1372: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1373: ,p_tax_deducted_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_tax_deducted_to_date) -- tax credit upload change
1374: ,p_pay_to_date => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,p_pay_to_date) -- tax credit upload change
1375: ,p_disability_benefit => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1376: ,p_lump_sum_payment => decode_value_number(p_tax_upload_flag='X',hr_api.g_number,null) -- tax credit upload change
1377: ,p_object_version_number => l_api_ovn
1378: ,p_effective_start_date => l_start_date
1379: ,p_effective_end_date => l_end_date);
1380: end if; --P_DATETRACK_UPDATE_MODE = 'CORRECTION'
1473: ,p_weekly_tax_credit => l_weekly_tax_credit
1474: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1475: ,p_monthly_tax_credit => l_monthly_tax_credit
1476: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1477: ,p_tax_deducted_to_date => hr_api.g_number
1478: ,p_pay_to_date => hr_api.g_number
1479: ,p_disability_benefit => hr_api.g_number
1480: ,p_lump_sum_payment => hr_api.g_number
1481: ,p_object_version_number => l_api_ovn
1474: ,p_weekly_std_rate_cut_off => l_weekly_std_rate_cut_off
1475: ,p_monthly_tax_credit => l_monthly_tax_credit
1476: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1477: ,p_tax_deducted_to_date => hr_api.g_number
1478: ,p_pay_to_date => hr_api.g_number
1479: ,p_disability_benefit => hr_api.g_number
1480: ,p_lump_sum_payment => hr_api.g_number
1481: ,p_object_version_number => l_api_ovn
1482: ,p_effective_start_date => l_start_date
1475: ,p_monthly_tax_credit => l_monthly_tax_credit
1476: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1477: ,p_tax_deducted_to_date => hr_api.g_number
1478: ,p_pay_to_date => hr_api.g_number
1479: ,p_disability_benefit => hr_api.g_number
1480: ,p_lump_sum_payment => hr_api.g_number
1481: ,p_object_version_number => l_api_ovn
1482: ,p_effective_start_date => l_start_date
1483: ,p_effective_end_date => l_end_date
1476: ,p_monthly_std_rate_cut_off => l_monthly_std_rate_cut_off
1477: ,p_tax_deducted_to_date => hr_api.g_number
1478: ,p_pay_to_date => hr_api.g_number
1479: ,p_disability_benefit => hr_api.g_number
1480: ,p_lump_sum_payment => hr_api.g_number
1481: ,p_object_version_number => l_api_ovn
1482: ,p_effective_start_date => l_start_date
1483: ,p_effective_end_date => l_end_date
1484: );