DBA Data[Home] [Help]

APPS.PQP_GB_OMP_DAILY_ABSENCES dependencies on PQP_GB_OMP_DAILY_ABSENCES

Line 1: PACKAGE BODY pqp_gb_omp_daily_absences AS

1: PACKAGE BODY pqp_gb_omp_daily_absences AS
2: /* $Header: pqgbdomp.pkb 120.3.12000000.1 2007/01/16 03:44:14 appldev noship $ */
3: -----------------
4:
5: e_novalue EXCEPTION;

Line 9: g_package_name VARCHAR2(31) := 'pqp_gb_omp_daily_absences.' ;

5: e_novalue EXCEPTION;
6: -----------------
7:
8: g_nested_level NUMBER:= 0;
9: g_package_name VARCHAR2(31) := 'pqp_gb_omp_daily_absences.' ;
10: g_pl_id ben_pl_f.pl_typ_id%TYPE;
11: g_plan_information rec_plan_information ;
12: g_debug BOOLEAN ;
13: g_log_duration_summary VARCHAR2(20) := NULL;

Line 262: pqp_gb_omp_daily_absences.get_plan_extra_info_n_cache_it(

258: END IF;
259:
260:
261: -- get the Scheme Details into Record g_plan_information
262: pqp_gb_omp_daily_absences.get_plan_extra_info_n_cache_it(
263: p_pl_id => p_pl_id
264: ,p_plan_information => l_plan_information
265: ,p_pl_typ_id => p_pl_typ_id
266: ,p_error_code => l_error_code

Line 329: pqp_gb_omp_daily_absences.get_entitlement_info (

325: l_proc_step := 30 ;
326: debug(l_proc_name,30);
327: END IF ;
328:
329: pqp_gb_omp_daily_absences.get_entitlement_info (
330: p_business_group_id => p_business_group_id
331: ,p_effective_date => p_absence_date_start
332: ,p_assignment_id => p_assignment_id
333: ,p_pl_id => p_pl_id

Line 353: pqp_gb_omp_daily_absences.get_entitlements_consumed(

349: -- the current absence, this will return rows only in case of update.
350: -- otherwise there should not be any record existing. All the used
351: -- Bands will be stored in g_band_bal_info collection.
352:
353: pqp_gb_omp_daily_absences.get_entitlements_consumed(
354: p_assignment_id => p_assignment_id
355: ,p_business_group_id => p_business_group_id
356: ,p_effective_date => l_generate_start_date -- l_absence_start_date
357: ,p_absence_id => p_absence_id

Line 371: pqp_gb_omp_daily_absences.get_entitlements_remaining

367: debug(l_proc_name,40);
368: END IF ;
369:
370: -- get final balance
371: pqp_gb_omp_daily_absences.get_entitlements_remaining
372: ( p_entitlements => l_entitlements
373: ,p_absences_taken_to_date => l_absences_taken_to_date
374: ,p_entitlement_uom => l_abs_ent_uom
375: ,p_entitlements_remaining => l_entitlements_remaining

Line 1541: END pqp_gb_omp_daily_absences ;

1537:
1538: END get_entitlement_balance;
1539:
1540:
1541: END pqp_gb_omp_daily_absences ;