DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_NL_ABP_FUNCTIONS

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

2349: FETCH c_hire_dt_cur INTO l_hire_date;
2350: IF c_hire_dt_cur%FOUND THEN
2351: -- The effective date is now the valid assignemnt
2352: --start date for the assignment
2353: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
2354: IF(l_error_status = trim(to_char(1,'9'))) Then
2355: fnd_message.set_name('PQP',l_error_message);
2356: p_error_message :='Error : '|| fnd_message.get();
2357: p_salary_balance_value :=0;

Line 2767: l_ret_val := pqp_nl_abp_functions.get_eoy_bonus_percentage

2763: -- Call the function to derive EOY Bonus
2764: -- percentage from the org level
2765: --
2766:
2767: l_ret_val := pqp_nl_abp_functions.get_eoy_bonus_percentage
2768: (p_date_earned => p_date_earned
2769: ,p_business_group_id => p_business_group_id
2770: ,p_assignment_id => p_assignment_id
2771: ,p_eoy_bonus_percentage => l_eoy_bonus_perc

Line 3158: l_ret_val := PQP_NL_ABP_FUNCTIONS.get_participation_date

3154: -- if the pension type is an ABP PT, find the participation start date
3155: -- from the ASG/ORG EITs
3156: IF l_is_abp_pt = 1 THEN
3157: l_dimension_name := 'Assignment Year To Date';
3158: l_ret_val := PQP_NL_ABP_FUNCTIONS.get_participation_date
3159: (p_assignment_id => p_assignment_id
3160: ,p_date_earned => p_date_earned
3161: ,p_business_group_id => p_business_group_id
3162: ,p_pension_type_id => p_pension_type_id

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

3199:
3200: IF l_is_abp_pt = 0 THEN
3201: -- NON-ABP Pension Types
3202: -- The effective date is now the valid assignment start date
3203: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
3204: IF (l_error_status = trim(to_char(1,'9'))) Then
3205: fnd_message.set_name('PQP',l_error_message);
3206: p_error_message :='Error' || fnd_message.get();
3207: RETURN 0;

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

4876: --
4877: --l_effective_date := TO_DATE('01/01/'||to_char(l_run_year),'DD/MM/YYYY');
4878: -- Get valid assignment start date
4879:
4880: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
4881: IF (l_error_status = trim(to_char(1,'9'))) Then
4882: RETURN 0;
4883: End IF;
4884: