DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_NL_ABP_FUNCTIONS

Line 2428: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);

2424: FETCH c_hire_dt_cur INTO l_hire_date;
2425: IF c_hire_dt_cur%FOUND THEN
2426: -- The effective date is now the valid assignemnt
2427: --start date for the assignment
2428: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
2429: IF(l_error_status = trim(to_char(1,'9'))) Then
2430: fnd_message.set_name('PQP',l_error_message);
2431: p_error_message :='Error : '|| fnd_message.get();
2432: p_salary_balance_value :=0;

Line 2842: l_ret_val := pqp_nl_abp_functions.get_eoy_bonus_percentage

2838: -- Call the function to derive EOY Bonus
2839: -- percentage from the org level
2840: --
2841:
2842: l_ret_val := pqp_nl_abp_functions.get_eoy_bonus_percentage
2843: (p_date_earned => p_date_earned
2844: ,p_business_group_id => p_business_group_id
2845: ,p_assignment_id => p_assignment_id
2846: ,p_eoy_bonus_percentage => l_eoy_bonus_perc

Line 3255: l_ret_val := PQP_NL_ABP_FUNCTIONS.get_participation_date

3251: -- if the pension type is an ABP PT, find the participation start date
3252: -- from the ASG/ORG EITs
3253: IF l_is_abp_pt = 1 THEN
3254: l_dimension_name := 'Assignment Year To Date';
3255: l_ret_val := PQP_NL_ABP_FUNCTIONS.get_participation_date
3256: (p_assignment_id => p_assignment_id
3257: ,p_date_earned => p_date_earned
3258: ,p_business_group_id => p_business_group_id
3259: ,p_pension_type_id => p_pension_type_id

Line 3300: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);

3296:
3297: IF l_is_abp_pt = 0 THEN
3298: -- NON-ABP Pension Types
3299: -- The effective date is now the valid assignment start date
3300: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
3301: IF (l_error_status = trim(to_char(1,'9'))) Then
3302: fnd_message.set_name('PQP',l_error_message);
3303: p_error_message :='Error' || fnd_message.get();
3304: RETURN 0;

Line 4977: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);

4973: --
4974: --l_effective_date := TO_DATE('01/01/'||to_char(l_run_year),'DD/MM/YYYY');
4975: -- Get valid assignment start date
4976:
4977: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
4978: IF (l_error_status = trim(to_char(1,'9'))) Then
4979: RETURN 0;
4980: End IF;
4981: