DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on HR_ASSIGNMENT_EXTRA_INFO_API

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

2233: hr_utility.trace('Calling csr_get_starter_details2');
2234: l_starter_decl := l_starter_rec.starter_decl;
2235: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
2236: l_ovn := l_starter_rec.object_version_number;
2237: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2238: p_object_version_number => l_ovn,
2239: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
2240: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2241: p_aei_information8 => 'Y');

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

2268: if l_pensioner_rec.annual_pension is not null then
2269: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
2270: end if;
2271: l_ovn := l_pensioner_rec.object_version_number;
2272: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2273: p_object_version_number => l_ovn,
2274: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
2275: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2276: p_aei_information9 => 'Y');

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

2315: l_starter_decl := l_expat_rec.expat_statement;
2316: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
2317: l_epm6_scheme := l_expat_rec.epm6_scheme;
2318: l_ovn := l_expat_rec.object_version_number;
2319: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2320: p_object_version_number => l_ovn,
2321: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
2322: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2323: p_aei_information19 => 'Y');

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

2531: ) into l_periods_covered from dual;
2532: hr_utility.trace('test4');
2533: -- reset the periods covered value to 1
2534: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
2535: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
2536: p_object_version_number => l_ovn_extra_info,
2537: p_assignment_extra_info_id => l_asg_info_id,
2538: p_aei_information_category => 'GB_PAY_RTI',
2539: p_aei_information1 => 1);

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

3029: hr_utility.trace('Calling csr_get_starter_details2');
3030: l_starter_decl := l_starter_rec.starter_decl;
3031: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
3032: l_ovn := l_starter_rec.object_version_number;
3033: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3034: p_object_version_number => l_ovn,
3035: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
3036: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3037: p_aei_information8 => 'Y');

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

3064: if l_pensioner_rec.annual_pension is not null then
3065: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
3066: end if;
3067: l_ovn := l_pensioner_rec.object_version_number;
3068: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3069: p_object_version_number => l_ovn,
3070: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
3071: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3072: p_aei_information9 => 'Y');

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

3111: l_starter_decl := l_expat_rec.expat_statement;
3112: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
3113: l_epm6_scheme := l_expat_rec.epm6_scheme;
3114: l_ovn := l_expat_rec.object_version_number;
3115: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3116: p_object_version_number => l_ovn,
3117: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
3118: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3119: p_aei_information19 => 'Y');

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

3339: ) into l_periods_covered from dual;
3340: hr_utility.trace('test4');
3341: -- reset the periods covered value to 1
3342: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
3343: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3344: p_object_version_number => l_ovn_extra_info,
3345: p_assignment_extra_info_id => l_asg_info_id,
3346: p_aei_information_category => 'GB_PAY_RTI',
3347: p_aei_information1 => 1);

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

3841: hr_utility.trace('Calling csr_get_starter_details2');
3842: l_starter_decl := l_starter_rec.starter_decl;
3843: l_continue_with_student_loan := l_starter_rec.continue_with_student_loan;
3844: l_ovn := l_starter_rec.object_version_number;
3845: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3846: p_object_version_number => l_ovn,
3847: p_assignment_extra_info_id => l_starter_rec.assignment_extra_info_id,
3848: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3849: p_aei_information8 => 'Y');

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

3875: if l_pensioner_rec.annual_pension is not null then
3876: l_annual_pension := (l_pensioner_rec.annual_pension)*100;
3877: end if;
3878: l_ovn := l_pensioner_rec.object_version_number;
3879: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3880: p_object_version_number => l_ovn,
3881: p_assignment_extra_info_id => l_pensioner_rec.assignment_extra_info_id,
3882: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3883: p_aei_information9 => 'Y');

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

3922: l_starter_decl := l_expat_rec.expat_statement;
3923: l_eea_cw_citizen := l_expat_rec.eea_cw_citizen;
3924: l_epm6_scheme := l_expat_rec.epm6_scheme;
3925: l_ovn := l_expat_rec.object_version_number;
3926: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
3927: p_object_version_number => l_ovn,
3928: p_assignment_extra_info_id => l_expat_rec.assignment_extra_info_id,
3929: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
3930: p_aei_information19 => 'Y');

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

4113: ) into l_periods_covered from dual;
4114: hr_utility.trace('test4');
4115: -- reset the periods covered value to 1
4116: elsif l_periods_covered IS NOT NULL AND l_periods_covered <> 1 THEN
4117: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
4118: p_object_version_number => l_ovn_extra_info,
4119: p_assignment_extra_info_id => l_asg_info_id,
4120: p_aei_information_category => 'GB_PAY_RTI',
4121: p_aei_information1 => 1);

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

7837: FETCH csr_aei_starter_details INTO l_aei_starter_rec;
7838: CLOSE csr_aei_starter_details;
7839:
7840: IF l_aei_starter_rec.aei_information8 = 'Y' THEN
7841: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7842: p_object_version_number => l_ovn,
7843: p_assignment_extra_info_id => l_aei_starter_rec.assignment_extra_info_id,
7844: p_aei_information_category => p_type,
7845: p_aei_information8 => 'N');

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

7852: FETCH csr_aei_pensioner_details INTO l_aei_pensioner_rec;
7853: CLOSE csr_aei_pensioner_details;
7854:
7855: IF l_aei_pensioner_rec.aei_information9 = 'Y' THEN
7856: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7857: p_object_version_number => l_ovn,
7858: p_assignment_extra_info_id => l_aei_pensioner_rec.assignment_extra_info_id,
7859: p_aei_information_category => p_type,
7860: p_aei_information9 => 'N');

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

7867: FETCH csr_aei_expat_details INTO l_aei_expat_rec;
7868: CLOSE csr_aei_expat_details;
7869:
7870: IF l_aei_expat_rec.aei_information19 = 'Y' THEN
7871: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false,
7872: p_object_version_number => l_ovn,
7873: p_assignment_extra_info_id => l_aei_expat_rec.assignment_extra_info_id,
7874: p_aei_information_category => p_type,
7875: p_aei_information19 => 'N');

Line 9874: 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',

9870:
9871: --EXPAT Flag
9872: IF l_new_starter.starter_flag = 'Y' THEN
9873: IF l_new_starter.l_ovn IS NOT NULL THEN
9874: 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',
9875: p_aei_information8 => 'N');
9876: END IF;
9877: END IF;
9878: --PENSIONER Flag

Line 9881: 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',

9877: END IF;
9878: --PENSIONER Flag
9879: IF l_new_starter.pensioner_flag = 'Y' THEN
9880: IF l_new_starter.l_ovn IS NOT NULL THEN
9881: 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',
9882: p_aei_information9 => 'N');
9883: END IF;
9884: END IF;
9885: --STARTER Flag

Line 9888: 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',

9884: END IF;
9885: --STARTER Flag
9886: IF l_new_starter.expat_flag = 'Y' THEN
9887: IF l_new_starter.l_ovn IS NOT NULL THEN
9888: 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',
9889: p_aei_information19 => 'N');
9890: END IF;
9891: END IF;
9892: