DBA Data[Home] [Help]

APPS.HR_GBBAL dependencies on HR_GBBAL

Line 1: PACKAGE BODY hr_gbbal AS

1: PACKAGE BODY hr_gbbal AS
2: /* $Header: pygbbal.pkb 120.14 2011/04/26 11:57:01 npannamp ship $ */
3: --------------------------------------------------------------------------------
4: g_assignment_action_id number;
5: g_start_of_year per_time_periods.regular_payment_date%type;

Line 3424: 'hr_gbbal.check_expiry',

3420: 'User dimension defined by Request Id ' || l_req_id,
3421: NULL,
3422: NULL,
3423: 'N',
3424: 'hr_gbbal.check_expiry',
3425: 'P',
3426: NULL
3427: );
3428:

Line 3451: p_user_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_user_effective_date,null);

3447: p_owner_start_period DATE;
3448: BEGIN
3449:
3450: -- This is only for USER REGULAR BALANCES
3451: p_user_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_user_effective_date,null);
3452: p_owner_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_owner_effective_date,null);
3453: IF p_user_start_period = p_owner_start_period THEN
3454: p_expiry_information := 0; -- FALSE
3455: ELSE

Line 3452: p_owner_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_owner_effective_date,null);

3448: BEGIN
3449:
3450: -- This is only for USER REGULAR BALANCES
3451: p_user_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_user_effective_date,null);
3452: p_owner_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_owner_effective_date,null);
3453: IF p_user_start_period = p_owner_start_period THEN
3454: p_expiry_information := 0; -- FALSE
3455: ELSE
3456: p_expiry_information := 1; -- TRUE

Line 3499: p_owner_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_owner_effective_date,null);

3495: p_expiry_information := TRUNC(ADD_MONTHS(l_regular_payment_date, 3), 'Q')-1;
3496:
3497: ELSIF p_dimension_name = '_ASG_QTD USER-REG ASG 06-04 RESET 04'
3498: THEN
3499: p_owner_start_period := hr_gbbal.dimension_reset_date(p_dimension_name, p_owner_effective_date,null);
3500:
3501: p_expiry_information := ADD_MONTHS(p_owner_start_period,3) - 1;
3502: -- TRUNC(ADD_MONTHS(p_owner_effective_date, 3), 'Q')+ 4;
3503:

Line 3940: g_start_of_year := hr_gbbal.span_start(l_regular_payment_date, 1, '06-04');

3936:
3937:
3938: begin
3939: if g_start_of_year is null then -- first call this session
3940: g_start_of_year := hr_gbbal.span_start(l_regular_payment_date, 1, '06-04');
3941: /*
3942: open CSR_initialization_exists;
3943: fetch CSR_initialization_exists into g_initialization_exists;
3944: close CSR_initialization_exists;

Line 4285: END hr_gbbal;

4281: return l_action_id;
4282: END get_master_action_id;
4283: --
4284: --
4285: END hr_gbbal;