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_ABSVAL_PKG dependencies on STANDARD

Line 3088: -- ,p_avg_working_days_standard IN NUMBER -- LG/PT

3084: ,p_entitlement_UOM IN VARCHAR2
3085: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance
3086: ,p_is_full_timer IN BOOLEAN
3087: -- ,p_avg_working_days_assignment IN NUMBER --LG/PT
3088: -- ,p_avg_working_days_standard IN NUMBER -- LG/PT
3089: -- ,p_message OUT NOCOPY VARCHAR2
3090: -- LG/PT
3091: -- ,p_track_part_timers IN VARCHAR2 DEFAULT 'N'
3092: ) --RETURN NUMBER

Line 5340: -- l_standard_working_days pqp_gap_daily_absences.working_days_per_week%TYPE;

5336: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
5337:
5338:
5339: --LG/PT
5340: -- l_standard_working_days pqp_gap_daily_absences.working_days_per_week%TYPE;
5341: -- l_standard_ft_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5342: -- l_assignment_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5343: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5344: l_current_factor NUMBER ;

Line 5341: -- l_standard_ft_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;

5337:
5338:
5339: --LG/PT
5340: -- l_standard_working_days pqp_gap_daily_absences.working_days_per_week%TYPE;
5341: -- l_standard_ft_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5342: -- l_assignment_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5343: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5344: l_current_factor NUMBER ;
5345: l_ft_factor NUMBER ;

Line 6102: FUNCTION get_absence_standard_ft_wp(p_business_group_id IN NUMBER

6098:
6099:
6100:
6101:
6102: FUNCTION get_absence_standard_ft_wp(p_business_group_id IN NUMBER
6103: ,p_assignment_id IN NUMBER
6104: ,p_effective_date IN DATE
6105: ,p_absence_schedule_wp IN VARCHAR2
6106: ,p_default_wp IN VARCHAR2

Line 6111: l_proc_name VARCHAR2(61):= g_package_name||'get_absence_standard_ft_wp';

6107: ,p_entitlement_uom IN VARCHAR2
6108: ,p_contract_wp OUT NOCOPY VARCHAR2 )
6109: RETURN VARCHAR2 IS
6110: l_proc_step NUMBER(20,10);
6111: l_proc_name VARCHAR2(61):= g_package_name||'get_absence_standard_ft_wp';
6112: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6113:
6114: BEGIN
6115:

Line 6112: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

6108: ,p_contract_wp OUT NOCOPY VARCHAR2 )
6109: RETURN VARCHAR2 IS
6110: l_proc_step NUMBER(20,10);
6111: l_proc_name VARCHAR2(61):= g_package_name||'get_absence_standard_ft_wp';
6112: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6113:
6114: BEGIN
6115:
6116: g_debug := hr_utility.debug_enabled;

Line 6130: l_standard_ft_work_pattern := p_absence_schedule_wp ;

6126: END IF ;
6127:
6128: IF p_absence_schedule_wp IS NOT NULL THEN
6129: l_proc_step := 20 ;
6130: l_standard_ft_work_pattern := p_absence_schedule_wp ;
6131: ELSIF p_default_wp IS NOT NULL THEN
6132: l_proc_step := 30 ;
6133: l_standard_ft_work_pattern := p_default_wp ;
6134: ELSE

Line 6133: l_standard_ft_work_pattern := p_default_wp ;

6129: l_proc_step := 20 ;
6130: l_standard_ft_work_pattern := p_absence_schedule_wp ;
6131: ELSIF p_default_wp IS NOT NULL THEN
6132: l_proc_step := 30 ;
6133: l_standard_ft_work_pattern := p_default_wp ;
6134: ELSE
6135: l_proc_step := 40 ;
6136: l_standard_ft_work_pattern :=
6137: get_contract_level_wp (

Line 6136: l_standard_ft_work_pattern :=

6132: l_proc_step := 30 ;
6133: l_standard_ft_work_pattern := p_default_wp ;
6134: ELSE
6135: l_proc_step := 40 ;
6136: l_standard_ft_work_pattern :=
6137: get_contract_level_wp (
6138: p_business_group_id => p_business_group_id
6139: ,p_assignment_id => p_assignment_id
6140: ,p_effective_date => p_effective_date ) ;

Line 6142: p_contract_wp := l_standard_ft_work_pattern ;

6138: p_business_group_id => p_business_group_id
6139: ,p_assignment_id => p_assignment_id
6140: ,p_effective_date => p_effective_date ) ;
6141:
6142: p_contract_wp := l_standard_ft_work_pattern ;
6143:
6144: END IF ;
6145:
6146: IF l_standard_ft_work_pattern IS NULL THEN

Line 6146: IF l_standard_ft_work_pattern IS NULL THEN

6142: p_contract_wp := l_standard_ft_work_pattern ;
6143:
6144: END IF ;
6145:
6146: IF l_standard_ft_work_pattern IS NULL THEN
6147: IF p_entitlement_uom <> 'H' THEN
6148: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6149: ELSE
6150: -- Raise Error.

Line 6148: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';

6144: END IF ;
6145:
6146: IF l_standard_ft_work_pattern IS NULL THEN
6147: IF p_entitlement_uom <> 'H' THEN
6148: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6149: ELSE
6150: -- Raise Error.
6151: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
6152: hr_utility.raise_error ;

Line 6158: debug('l_standard_ft_work_pattern:'||l_standard_ft_work_pattern);

6154: END IF ;
6155:
6156: l_proc_step := 50 ;
6157: IF g_debug THEN
6158: debug('l_standard_ft_work_pattern:'||l_standard_ft_work_pattern);
6159: debug_exit(l_proc_name);
6160: END IF ;
6161:
6162: RETURN l_standard_ft_work_pattern ;

Line 6162: RETURN l_standard_ft_work_pattern ;

6158: debug('l_standard_ft_work_pattern:'||l_standard_ft_work_pattern);
6159: debug_exit(l_proc_name);
6160: END IF ;
6161:
6162: RETURN l_standard_ft_work_pattern ;
6163:
6164: EXCEPTION
6165: WHEN OTHERS THEN
6166: p_contract_wp := NULL ;

Line 6179: END get_absence_standard_ft_wp ;

6175: fnd_message.raise_error;
6176: ELSE
6177: RAISE;
6178: END IF;
6179: END get_absence_standard_ft_wp ;
6180:
6181:
6182: -- Move to pqp_schedule_calc_pkg and llok at caching options at a correct level
6183: FUNCTION get_average_days_per_week(

Line 6190: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

6186: ,p_work_pattern IN VARCHAR2 )
6187: RETURN NUMBER IS
6188: l_proc_step NUMBER(20,10);
6189: l_proc_name VARCHAR2(61):= g_package_name||'get_average_days_per_week';
6190: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6191: l_average_days_per_week NUMBER ;
6192: BEGIN
6193:
6194: g_debug := hr_utility.debug_enabled;

Line 6206: -- if we, lets say the standard work pattern is same for most of the employees

6202: END IF ;
6203:
6204: -- cache this results at this level.
6205: -- do we need to consider effective_Date for caching.
6206: -- if we, lets say the standard work pattern is same for most of the employees
6207: -- but as effective date will vary ( its absence start date ),
6208: -- the caching may not be effective....
6209:
6210: l_average_days_per_week :=

Line 6570: get_absence_standard_ft_wp(

6566: -- ELSE -- IF l_plan_information.absence_days_type IN ('C','W') THEN
6567: -- This information is available for Hours too as they have
6568: -- Work Pattern attached.
6569: l_FT_absence_wp :=
6570: get_absence_standard_ft_wp(
6571: p_business_group_id => p_business_group_id
6572: ,p_assignment_id => p_assignment_id
6573: ,p_effective_date => p_effective_date
6574: ,p_absence_schedule_wp => p_absence_schedule_wp