eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on PQP_ABSVAL_PKG

Line 10: -- g_plan_information pqp_absval_pkg.rec_plan_information ;

6: -----------------
7:
8: g_nested_level NUMBER:= 0;
9: g_package_name VARCHAR2(31) := 'pqp_gb_css_daily_absences.' ;
10: -- g_plan_information pqp_absval_pkg.rec_plan_information ;
11: g_debug BOOLEAN ;
12: -- Cache for rounding of factors
13: g_pt_entitl_rounding_type VARCHAR2(10):=null;
14: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;

Line 69: -- This Procedure is called from pqp_absval_pkg.create_absence_plan_details

65: BEGIN
66: pqp_utilities.debug_exit(p_proc_name,p_trace_off);
67: END debug_exit;
68:
69: -- This Procedure is called from pqp_absval_pkg.create_absence_plan_details
70: -- The logic of derving Review Dates and calculating the Remaining
71: -- entitlement is coded in this.
72:
73: PROCEDURE create_absence_plan_details

Line 81: ,p_entitlements IN pqp_absval_pkg.t_entitlements

77: ,p_pl_id IN NUMBER
78: ,p_pl_typ_id IN NUMBER
79: ,p_create_start_date IN DATE
80: ,p_create_end_date IN DATE
81: ,p_entitlements IN pqp_absval_pkg.t_entitlements
82: ,p_plan_information IN pqp_absval_pkg.rec_plan_information
83: ,p_entitlements_remaining OUT NOCOPY pqp_absval_pkg.t_entitlements
84: ,p_entitlement_UOM OUT NOCOPY VARCHAR2
85: ,p_working_days_per_week OUT NOCOPY NUMBER

Line 82: ,p_plan_information IN pqp_absval_pkg.rec_plan_information

78: ,p_pl_typ_id IN NUMBER
79: ,p_create_start_date IN DATE
80: ,p_create_end_date IN DATE
81: ,p_entitlements IN pqp_absval_pkg.t_entitlements
82: ,p_plan_information IN pqp_absval_pkg.rec_plan_information
83: ,p_entitlements_remaining OUT NOCOPY pqp_absval_pkg.t_entitlements
84: ,p_entitlement_UOM OUT NOCOPY VARCHAR2
85: ,p_working_days_per_week OUT NOCOPY NUMBER
86: ,p_fte OUT NOCOPY NUMBER

Line 83: ,p_entitlements_remaining OUT NOCOPY pqp_absval_pkg.t_entitlements

79: ,p_create_start_date IN DATE
80: ,p_create_end_date IN DATE
81: ,p_entitlements IN pqp_absval_pkg.t_entitlements
82: ,p_plan_information IN pqp_absval_pkg.rec_plan_information
83: ,p_entitlements_remaining OUT NOCOPY pqp_absval_pkg.t_entitlements
84: ,p_entitlement_UOM OUT NOCOPY VARCHAR2
85: ,p_working_days_per_week OUT NOCOPY NUMBER
86: ,p_fte OUT NOCOPY NUMBER
87: ) IS

Line 104: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements

100: l_working_days_in_week
101: pqp_gap_daily_absences.working_days_per_week%TYPE ;
102: i NUMBER ;
103:
104: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements
105: := p_entitlements_remaining;
106: l_entitlement_UOM_nc VARCHAR2(30) := p_entitlement_UOM ;
107: l_working_days_per_week_nc pqp_gap_daily_absences.working_days_per_week%TYPE
108: := p_working_days_per_week;

Line 435: l_absences_taken pqp_absval_pkg.t_entitlements ;

431: ,p_fulltime IN BOOLEAN
432: ,p_lookup_type IN VARCHAR2
433: ) RETURN DATE IS
434:
435: l_absences_taken pqp_absval_pkg.t_entitlements ;
436: l_rolling_end_date DATE := p_absence_start_date ;
437: l_rolling_start_date DATE ;
438: l_total_entitlement NUMBER := 0 ; --p_total_entitlement ; -- PT Changes
439: l_total_absences_taken NUMBER := 0 ;

Line 532: -- get_paid_absence_days use get_absences_taken in pqp_absval_pkg

528: debug('Rolling Start date:'||l_rolling_start_date);
529: debug('Eligible Days:'||l_total_entitlement);
530: END IF;
531:
532: -- get_paid_absence_days use get_absences_taken in pqp_absval_pkg
533: -- For 4 year scheme sum all the bands returned from that
534: -- For Full Paid only take BAND1
535:
536: IF g_debug THEN

Line 543: pqp_absval_pkg.get_absences_taken

539: debug('l_rolling_start_date:'||l_rolling_start_date);
540: debug('l_rolling_end_date:'||l_rolling_end_date);
541: END IF ;
542: l_absences_taken.DELETE;
543: pqp_absval_pkg.get_absences_taken
544: (p_assignment_id => p_assignment_id
545: ,p_pl_typ_id => p_pl_typ_id
546: ,p_range_from_date => l_rolling_start_date
547: ,p_range_to_date => l_rolling_end_date-1

Line 819: pqp_absval_pkg.get_scheme_start_date(

815:
816: l_proc_step := 10 ;
817: -- get period end date for the calander period
818: l_period_start_date :=
819: pqp_absval_pkg.get_scheme_start_date(
820: p_assignment_id => p_assignment_id
821: ,p_scheme_period_type => p_scheme_period_type
822: ,p_scheme_period_duration => p_scheme_period_duration
823: ,p_scheme_period_uom => p_scheme_period_uom

Line 836: pqp_absval_pkg.get_calendar_days_to_extend(

832:
833: loop
834: --Was earlier calling get_no_pay_days of the same package
835: l_no_pay_days :=
836: pqp_absval_pkg.get_calendar_days_to_extend(
837: p_period_start_date => l_period_start_date
838: ,p_period_end_date => l_period_end_date
839: ,p_assignment_id => p_assignment_id
840: ,p_business_group_id => p_business_group_id