DBA Data[Home] [Help]

APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on STANDARD

Line 109: l_standard_work_days_in_week

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;
109: l_standard_work_days_in_week
110: pqp_gap_daily_absences.working_days_per_week%TYPE ;
111: l_fulltime BOOLEAN ;
112:
113: BEGIN

Line 203: l_standard_work_days_in_week :=

199: ,p_default_wp =>
200: p_plan_information.default_work_pattern_name
201: ) ;
202:
203: l_standard_work_days_in_week :=
204: pqp_schedule_calculation_pkg.get_working_days_in_week (
205: p_assignment_id => p_assignment_id
206: ,p_business_group_id => p_business_group_id
207: ,p_effective_date => p_create_start_date

Line 217: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=

213: IF g_debug THEN
214: debug(' No of Working Days in Week:'||l_working_days_in_week);
215: END IF;
216:
217: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
218: l_standard_work_days_in_week THEN
219: p_entitlement_uom := 'C' ;
220: p_working_days_per_week := 7 ;
221: l_fulltime := TRUE ;

Line 218: l_standard_work_days_in_week THEN

214: debug(' No of Working Days in Week:'||l_working_days_in_week);
215: END IF;
216:
217: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
218: l_standard_work_days_in_week THEN
219: p_entitlement_uom := 'C' ;
220: p_working_days_per_week := 7 ;
221: l_fulltime := TRUE ;
222: p_fte:=1;

Line 225: p_fte:= l_working_days_in_week/l_standard_work_days_in_week;

221: l_fulltime := TRUE ;
222: p_fte:=1;
223: ELSE
224: p_entitlement_uom := 'W' ;
225: p_fte:= l_working_days_in_week/l_standard_work_days_in_week;
226: p_working_days_per_week := l_working_days_in_week ;
227: l_fulltime := FALSE ;
228: END IF;
229:

Line 250: ,p_standard_work_days_in_week => l_standard_work_days_in_week

246: ,p_total_entitlement => l_total_entitlements
247: ,p_total_remaining => l_total_remaining
248: ,p_4_year_rolling_period => TRUE
249: ,p_working_days_in_week => p_working_days_per_week
250: ,p_standard_work_days_in_week => l_standard_work_days_in_week
251: ,p_fulltime => l_fulltime
252: ,p_lookup_type => p_plan_information.plan_types_to_extend_period
253: ) ;
254:

Line 276: ,p_standard_work_days_in_week => l_standard_work_days_in_week

272: ,p_total_entitlement => p_entitlements(1).entitlement
273: ,p_total_remaining => l_fullpay_duration
274: ,p_4_year_rolling_period => FALSE
275: ,p_working_days_in_week => p_working_days_per_week
276: ,p_standard_work_days_in_week => l_standard_work_days_in_week
277: ,p_fulltime => l_fulltime
278: ,p_lookup_type => p_plan_information.plan_types_to_extend_period
279: ) ;
280: l_proc_step := 40 ;

Line 430: ,p_standard_work_days_in_week IN NUMBER

426: ,p_total_remaining IN OUT NOCOPY NUMBER
427: ,p_4_year_rolling_period IN BOOLEAN--TRUE for 4year
428: -- PT Changes
429: ,p_working_days_in_week IN NUMBER
430: ,p_standard_work_days_in_week IN NUMBER
431: ,p_fulltime IN BOOLEAN
432: ,p_lookup_type IN VARCHAR2
433: ) RETURN DATE IS
434:

Line 671: IF p_working_days_in_week < p_standard_work_days_in_week THEN

667: -- PT Changes
668: -- Here we need check if FT or PT and add days accrodingly
669: -- From 5 Change it to refer to Default_work_pattern days
670:
671: IF p_working_days_in_week < p_standard_work_days_in_week THEN
672: -- call add_working_days function here
673: l_proc_step := 75 ;
674: -- l_rolling_end_date :=
675: -- pqp_schedule_calculation_pkg.add_working_days