APPS.PQP_NL_ABP_FUNCTIONS dependencies on PQP_NL_ABP_FUNCTIONS

Line 1: PACKAGE BODY PQP_NL_ABP_FUNCTIONS AS

1: PACKAGE BODY PQP_NL_ABP_FUNCTIONS AS
2: /* $Header: pqpnlabp.pkb 120.34 2008/01/03 12:53:48 rsahai noship $ */
3: -- =============================================================================
4: -- to_nl_date: Function to convert the date to the appropriate value
5: -- since the ben logs contain dates in the NL Language -- 31-MEI-05

Line 6420: l_ret_val := pqp_nl_abp_functions.get_abp_calc_eff_dt

6416: l_effective_date DATE;
6417:
6418: BEGIN
6419:
6420: l_ret_val := pqp_nl_abp_functions.get_abp_calc_eff_dt
6421: (p_date_earned => p_date_earned
6422: ,p_business_group_id => p_business_group_id
6423: ,p_assignment_id => p_assignment_id
6424: ,p_effective_date => l_effective_date

Line 7332: hr_utility.set_location ('Entering function: pqp_nl_abp_functions.Get_Retro_Addnl_Amt' , 2100);

7328: l_addl_calc_flag per_assignment_extra_info.aei_information3%TYPE;
7329:
7330: BEGIN
7331:
7332: hr_utility.set_location ('Entering function: pqp_nl_abp_functions.Get_Retro_Addnl_Amt' , 2100);
7333: hr_utility.set_location ('p_bg_id: '||TO_CHAR(p_bg_id) , 2110);
7334: hr_utility.set_location ('p_date_earned : '||TO_CHAR(p_date_earned) , 2120);
7335: hr_utility.set_location ('p_asg_id: '||TO_CHAR(p_asg_id) , 2130);
7336: hr_utility.set_location ('p_element_type_id: '||TO_CHAR(p_element_type_id) , 2140);

Line 7392: hr_utility.set_location ('Exiting pqp_nl_abp_functions.Get_Retro_addnl_Amt function', 2240);

7388: FETCH csr_iv_id INTO l_iv_id_basis;
7389: CLOSE csr_iv_id;
7390: hr_utility.set_location ('iv basis id ER:' || TO_CHAR(l_iv_id_basis), 2230);
7391: ELSE
7392: hr_utility.set_location ('Exiting pqp_nl_abp_functions.Get_Retro_addnl_Amt function', 2240);
7393: p_dedn_retro_amt := 0;
7394: RETURN 1; -- return failure, since parameter passed in not EE or ER*/
7395: END IF;
7396:

Line 7414: l_ret_val := pqp_nl_abp_functions.get_absence_adjustment

7410:
7411: /* code for checking the sickness flag as yes or no in the formula */
7412: IF p_sick_flag = 'Y' THEN
7413: hr_utility.set_location ('Sickness flag is Y', 2290);
7414: l_ret_val := pqp_nl_abp_functions.get_absence_adjustment
7415: (p_asg_id,
7416: csr_basis.orig_date_earned, --p_date_earned,
7417: p_bg_id,
7418: 0,

Line 7470: hr_utility.set_location ('Returning from pqp_nl_abp_functions.Get_Retro_addnl_Amt function', 2375);

7466:
7467: END IF;
7468:
7469: hr_utility.set_location ('p_dedn_retro_amt: ' || TO_CHAR(p_dedn_retro_amt), 2370);
7470: hr_utility.set_location ('Returning from pqp_nl_abp_functions.Get_Retro_addnl_Amt function', 2375);
7471:
7472: RETURN 0; -- success
7473:
7474: EXCEPTION

Line 7476: hr_utility.set_location ('Exception occured in pqp_nl_abp_functions.get_retro_addnl_amt', 2380);

7472: RETURN 0; -- success
7473:
7474: EXCEPTION
7475: WHEN OTHERS THEN
7476: hr_utility.set_location ('Exception occured in pqp_nl_abp_functions.get_retro_addnl_amt', 2380);
7477: p_dedn_retro_amt := 0;
7478: RETURN 1; -- fail
7479:
7480: --hr_utility.trace_off;

Line 7483: END pqp_nl_abp_functions;

7479:
7480: --hr_utility.trace_off;
7481: END Get_Retro_Addnl_Amt;
7482: --
7483: END pqp_nl_abp_functions;