DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS dependencies on HR_ASSIGNMENT_EXTRA_INFO_API

Line 1732: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

1728: hr_utility.trace('Calling csr_get_starter_details2');
1729: l_starter_decl := l_starter_rec.starter_decl;
1730: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
1731: l_ovn := l_starter_rec.object_version_number;
1732: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
1733: p_object_version_number => l_ovn,
1734: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
1735: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
1736: p_aei_information8 => 'Y');

Line 1767: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

1763: if l_pensioner_rec.annual_pension is not null then
1764: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
1765: end if;
1766: l_ovn := l_pensioner_rec.object_version_number;
1767: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
1768: p_object_version_number => l_ovn,
1769: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
1770: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
1771: p_aei_information9 => 'Y');

Line 1814: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

1810: l_starter_decl := l_expat_rec.expat_statement;
1811: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
1812: l_epm6_scheme := l_expat_rec.epm6_scheme;
1813: l_ovn := l_expat_rec.object_version_number;
1814: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
1815: p_object_version_number => l_ovn,
1816: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
1817: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
1818: p_aei_information19 => 'Y');

Line 2041: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

2037: ) into l_periods_covered from dual;
2038: hr_utility.trace('test4');
2039: -- reset the periods covered value to 1
2040: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2041: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2042: p_object_version_number => l_ovn_extra_info,
2043: p_assignment_extra_info_id => l_asg_info_id,
2044: p_aei_information_category => 'GB_PAY_RTI',
2045: p_aei_information1 => 1);

Line 2560: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

2556: hr_utility.trace('Calling csr_get_starter_details2');
2557: l_starter_decl := l_starter_rec.starter_decl;
2558: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
2559: l_ovn := l_starter_rec.object_version_number;
2560: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2561: p_object_version_number => l_ovn,
2562: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
2563: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2564: p_aei_information8 => 'Y');

Line 2595: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

2591: if l_pensioner_rec.annual_pension is not null then
2592: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
2593: end if;
2594: l_ovn := l_pensioner_rec.object_version_number;
2595: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2596: p_object_version_number => l_ovn,
2597: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
2598: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2599: p_aei_information9 => 'Y');

Line 2642: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

2638: l_starter_decl := l_expat_rec.expat_statement;
2639: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
2640: l_epm6_scheme := l_expat_rec.epm6_scheme;
2641: l_ovn := l_expat_rec.object_version_number;
2642: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2643: p_object_version_number => l_ovn,
2644: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
2645: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2646: p_aei_information19 => 'Y');

Line 2878: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

2874: ) into l_periods_covered from dual;
2875: hr_utility.trace('test4');
2876: -- reset the periods covered value to 1
2877: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2878: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2879: p_object_version_number => l_ovn_extra_info,
2880: p_assignment_extra_info_id => l_asg_info_id,
2881: p_aei_information_category => 'GB_PAY_RTI',
2882: p_aei_information1 => 1);

Line 3383: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

3379: hr_utility.trace('Calling csr_get_starter_details2');
3380: l_starter_decl := l_starter_rec.starter_decl;
3381: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
3382: l_ovn := l_starter_rec.object_version_number;
3383: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3384: p_object_version_number => l_ovn,
3385: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
3386: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3387: p_aei_information8 => 'Y');

Line 3417: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

3413: if l_pensioner_rec.annual_pension is not null then
3414: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
3415: end if;
3416: l_ovn := l_pensioner_rec.object_version_number;
3417: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3418: p_object_version_number => l_ovn,
3419: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
3420: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3421: p_aei_information9 => 'Y');

Line 3464: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

3460: l_starter_decl := l_expat_rec.expat_statement;
3461: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
3462: l_epm6_scheme := l_expat_rec.epm6_scheme;
3463: l_ovn := l_expat_rec.object_version_number;
3464: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3465: p_object_version_number => l_ovn,
3466: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
3467: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3468: p_aei_information19 => 'Y');

Line 3665: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

3661: ) into l_periods_covered from dual;
3662: hr_utility.trace('test4');
3663: -- reset the periods covered value to 1
3664: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
3665: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3666: p_object_version_number => l_ovn_extra_info,
3667: p_assignment_extra_info_id => l_asg_info_id,
3668: p_aei_information_category => 'GB_PAY_RTI',
3669: p_aei_information1 => 1);

Line 7212: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

7208: FETCH csr_aei_starter_details INTO l_aei_starter_rec;
7209: CLOSE csr_aei_starter_details;
7210:
7211: IF l_aei_starter_rec.aei_information8 = 'Y' THEN
7212: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7213: p_object_version_number => l_ovn,
7214: p_assignment_extra_info_id => l_aei_starter_rec.assignment_extra_info_id,
7215: p_aei_information_category => p_type,
7216: p_aei_information8 => 'N');

Line 7227: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

7223: FETCH csr_aei_pensioner_details INTO l_aei_pensioner_rec;
7224: CLOSE csr_aei_pensioner_details;
7225:
7226: IF l_aei_pensioner_rec.aei_information9 = 'Y' THEN
7227: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7228: p_object_version_number => l_ovn,
7229: p_assignment_extra_info_id => l_aei_pensioner_rec.assignment_extra_info_id,
7230: p_aei_information_category => p_type,
7231: p_aei_information9 => 'N');

Line 7242: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,

7238: FETCH csr_aei_expat_details INTO l_aei_expat_rec;
7239: CLOSE csr_aei_expat_details;
7240:
7241: IF l_aei_expat_rec.aei_information19 = 'Y' THEN
7242: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7243: p_object_version_number => l_ovn,
7244: p_assignment_extra_info_id => l_aei_expat_rec.assignment_extra_info_id,
7245: p_aei_information_category => p_type,
7246: p_aei_information19 => 'N');

Line 9227: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',

9223:
9224: --EXPAT Flag
9225: IF l_new_starter.starter_flag = 'Y' THEN
9226: IF l_new_starter.l_ovn IS NOT NULL THEN
9227: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
9228: p_aei_information8 => 'N');
9229: END IF;
9230: END IF;
9231: --PENSIONER Flag

Line 9234: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',

9230: END IF;
9231: --PENSIONER Flag
9232: IF l_new_starter.pensioner_flag = 'Y' THEN
9233: IF l_new_starter.l_ovn IS NOT NULL THEN
9234: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
9235: p_aei_information9 => 'N');
9236: END IF;
9237: END IF;
9238: --STARTER Flag

Line 9241: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',

9237: END IF;
9238: --STARTER Flag
9239: IF l_new_starter.expat_flag = 'Y' THEN
9240: IF l_new_starter.l_ovn IS NOT NULL THEN
9241: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_new_starter.l_ovn, p_assignment_extra_info_id => l_new_starter.l_aei_id, p_aei_information_category => 'GB_RTI_ASG_DETAILS',
9242: p_aei_information19 => 'N');
9243: END IF;
9244: END IF;
9245: