DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on STANDARD

Line 3070: l_standard_work_days_in_week

3066: l_ft_factor NUMBER ;
3067:
3068: l_working_days_in_week
3069: pqp_gap_daily_absences.working_days_per_week%TYPE := 7 ;
3070: l_standard_work_days_in_week
3071: pqp_gap_daily_absences.working_days_per_week%TYPE ;
3072: l_entitlements_divisor NUMBER := 7 ;
3073:
3074: l_working_days_per_week pqp_gap_daily_absences.working_days_per_week%TYPE;

Line 3178: -- the standard entitlements for CS Full timer are BAND1-182 and BAND2-182

3174: -- In Civil Service Scheme for part timers and Fulltimers only one Entitlement
3175: -- UDT is created. But the entitlements can be derived based on the
3176: -- number of days the part timers work.
3177: -- For example :
3178: -- the standard entitlements for CS Full timer are BAND1-182 and BAND2-182
3179: -- For a part timer working 3 days in week entitlements will be
3180: -- BAND1 = FLOOR(182 * 3 / 7) = 78
3181: -- BAND2 = FLOOR(182 * 3 / 7) = 78
3182:

Line 3260: -- the standard work pattern call is required as we have

3256: -- this gets executed when called for CS
3257: -- get the number of working days per week.
3258: -- IF the person is a Full timer there may not be any assignment
3259: -- level work pattern. so pass a default work pattern
3260: -- the standard work pattern call is required as we have
3261: -- to compare to know if the person is Full timer or part timer
3262:
3263: l_working_days_in_week :=
3264: pqp_schedule_calculation_pkg.get_working_days_in_week (

Line 3272: -- because we want the days in standard work pattern but not

3268: ,p_default_wp => l_FT_working_wp --l_default_work_pattern
3269: ) ;
3270:
3271: -- Default Work Pattern is passed as Over Ride Work Pattern
3272: -- because we want the days in standard work pattern but not
3273: -- at assignment level.
3274: -- if we pass that as p_default_wp the function returns the
3275: -- number of days at assignment level work pattern if
3276: -- there is any

Line 3278: l_standard_work_days_in_week :=

3274: -- if we pass that as p_default_wp the function returns the
3275: -- number of days at assignment level work pattern if
3276: -- there is any
3277:
3278: l_standard_work_days_in_week :=
3279: pqp_schedule_calculation_pkg.get_working_days_in_week (
3280: p_assignment_id => p_assignment_id
3281: ,p_business_group_id => p_business_group_id
3282: ,p_effective_date => p_effective_date

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

3281: ,p_business_group_id => p_business_group_id
3282: ,p_effective_date => p_effective_date
3283: ,p_override_wp => l_FT_working_wp --l_default_work_pattern
3284: ) ;
3285: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
3286: l_standard_work_days_in_week THEN
3287: l_working_days_in_week := 7 ;
3288: END IF;
3289:

Line 3286: l_standard_work_days_in_week THEN

3282: ,p_effective_date => p_effective_date
3283: ,p_override_wp => l_FT_working_wp --l_default_work_pattern
3284: ) ;
3285: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
3286: l_standard_work_days_in_week THEN
3287: l_working_days_in_week := 7 ;
3288: END IF;
3289:
3290: l_current_factor := l_working_days_in_week ;

Line 5554: l_standard_work_days_in_week

5550: -- Added for CS
5551: l_dualrolling_4_year BOOLEAN := FALSE ;
5552: l_working_days_in_week
5553: pqp_gap_daily_absences.working_days_per_week%TYPE ;
5554: l_standard_work_days_in_week
5555: pqp_gap_daily_absences.working_days_per_week%TYPE ;
5556:
5557:
5558: l_current_factor NUMBER ;

Line 5816: -- the standard work pattern call is required as we have

5812: -- this gets executed when called for CS
5813: -- get the number of working days per week.
5814: -- IF the person is a Full timer there may not be any assignment
5815: -- level work pattern. so pass a default work pattern
5816: -- the standard work pattern call is required as we have
5817: -- to compare to know if the person is Full timer or part timer
5818:
5819: l_working_days_in_week :=
5820: pqp_schedule_calculation_pkg.get_working_days_in_week

Line 5828: -- because we want the days in standard work pattern but not

5824: ,p_effective_date => p_effective_date
5825: ,p_default_wp => p_default_work_pattern
5826: ) ;
5827: -- Default Work Pattern is passed as Over Ride Work Pattern
5828: -- because we want the days in standard work pattern but not
5829: -- at assignment level.
5830: -- if we pass that as p_default_wp the function returns the
5831: -- number of days at assignment level work pattern if
5832: -- there is any

Line 5839: l_standard_work_days_in_week :=

5835: IF g_debug THEN
5836: debug(l_proc_name, 57+i/10000);
5837: END IF;
5838:
5839: l_standard_work_days_in_week :=
5840: pqp_schedule_calculation_pkg.get_working_days_in_week
5841: (
5842: p_assignment_id => p_assignment_id
5843: ,p_business_group_id => p_business_group_id

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

5850: debug(l_proc_name, 59+i/10000);
5851: END IF;
5852:
5853:
5854: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
5855: l_standard_work_days_in_week THEN
5856: l_working_days_in_week := 7 ;
5857: END IF;
5858:

Line 5855: l_standard_work_days_in_week THEN

5851: END IF;
5852:
5853:
5854: IF NVL(l_working_days_in_week,l_standard_work_days_in_week) >=
5855: l_standard_work_days_in_week THEN
5856: l_working_days_in_week := 7 ;
5857: END IF;
5858:
5859: l_proc_step := 60+i/10000;