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 3109: -- ,p_avg_working_days_standard IN NUMBER -- LG/PT

3105: ,p_entitlement_UOM IN VARCHAR2
3106: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance
3107: ,p_is_full_timer IN BOOLEAN
3108: -- ,p_avg_working_days_assignment IN NUMBER --LG/PT
3109: -- ,p_avg_working_days_standard IN NUMBER -- LG/PT
3110: -- ,p_message OUT NOCOPY VARCHAR2
3111: -- LG/PT
3112: -- ,p_track_part_timers IN VARCHAR2 DEFAULT 'N'
3113: ) --RETURN NUMBER

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

5364: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
5365:
5366:
5367: --LG/PT
5368: -- l_standard_working_days pqp_gap_daily_absences.working_days_per_week%TYPE;
5369: -- l_standard_ft_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5370: -- l_assignment_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5371: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5372: l_current_factor NUMBER ;

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

5365:
5366:
5367: --LG/PT
5368: -- l_standard_working_days pqp_gap_daily_absences.working_days_per_week%TYPE;
5369: -- l_standard_ft_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5370: -- l_assignment_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;
5371: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5372: l_current_factor NUMBER ;
5373: l_ft_factor NUMBER ;

Line 6130: FUNCTION get_absence_standard_ft_wp(p_business_group_id IN NUMBER

6126:
6127:
6128:
6129:
6130: FUNCTION get_absence_standard_ft_wp(p_business_group_id IN NUMBER
6131: ,p_assignment_id IN NUMBER
6132: ,p_effective_date IN DATE
6133: ,p_absence_schedule_wp IN VARCHAR2
6134: ,p_default_wp IN VARCHAR2

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

6135: ,p_entitlement_uom IN VARCHAR2
6136: ,p_contract_wp OUT NOCOPY VARCHAR2 )
6137: RETURN VARCHAR2 IS
6138: l_proc_step NUMBER(20,10);
6139: l_proc_name VARCHAR2(61):= g_package_name||'get_absence_standard_ft_wp';
6140: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6141:
6142: BEGIN
6143:

Line 6140: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

6136: ,p_contract_wp OUT NOCOPY VARCHAR2 )
6137: RETURN VARCHAR2 IS
6138: l_proc_step NUMBER(20,10);
6139: l_proc_name VARCHAR2(61):= g_package_name||'get_absence_standard_ft_wp';
6140: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6141:
6142: BEGIN
6143:
6144: g_debug := hr_utility.debug_enabled;

Line 6158: l_standard_ft_work_pattern := p_absence_schedule_wp ;

6154: END IF ;
6155:
6156: IF p_absence_schedule_wp IS NOT NULL THEN
6157: l_proc_step := 20 ;
6158: l_standard_ft_work_pattern := p_absence_schedule_wp ;
6159: ELSIF p_default_wp IS NOT NULL THEN
6160: l_proc_step := 30 ;
6161: l_standard_ft_work_pattern := p_default_wp ;
6162: ELSE

Line 6161: l_standard_ft_work_pattern := p_default_wp ;

6157: l_proc_step := 20 ;
6158: l_standard_ft_work_pattern := p_absence_schedule_wp ;
6159: ELSIF p_default_wp IS NOT NULL THEN
6160: l_proc_step := 30 ;
6161: l_standard_ft_work_pattern := p_default_wp ;
6162: ELSE
6163: l_proc_step := 40 ;
6164: l_standard_ft_work_pattern :=
6165: get_contract_level_wp (

Line 6164: l_standard_ft_work_pattern :=

6160: l_proc_step := 30 ;
6161: l_standard_ft_work_pattern := p_default_wp ;
6162: ELSE
6163: l_proc_step := 40 ;
6164: l_standard_ft_work_pattern :=
6165: get_contract_level_wp (
6166: p_business_group_id => p_business_group_id
6167: ,p_assignment_id => p_assignment_id
6168: ,p_effective_date => p_effective_date ) ;

Line 6170: p_contract_wp := l_standard_ft_work_pattern ;

6166: p_business_group_id => p_business_group_id
6167: ,p_assignment_id => p_assignment_id
6168: ,p_effective_date => p_effective_date ) ;
6169:
6170: p_contract_wp := l_standard_ft_work_pattern ;
6171:
6172: END IF ;
6173:
6174: IF l_standard_ft_work_pattern IS NULL THEN

Line 6174: IF l_standard_ft_work_pattern IS NULL THEN

6170: p_contract_wp := l_standard_ft_work_pattern ;
6171:
6172: END IF ;
6173:
6174: IF l_standard_ft_work_pattern IS NULL THEN
6175: IF p_entitlement_uom <> 'H' THEN
6176: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6177: ELSE
6178: -- Raise Error.

Line 6176: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';

6172: END IF ;
6173:
6174: IF l_standard_ft_work_pattern IS NULL THEN
6175: IF p_entitlement_uom <> 'H' THEN
6176: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6177: ELSE
6178: -- Raise Error.
6179: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
6180: hr_utility.raise_error ;

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

6182: END IF ;
6183:
6184: l_proc_step := 50 ;
6185: IF g_debug THEN
6186: debug('l_standard_ft_work_pattern:'||l_standard_ft_work_pattern);
6187: debug_exit(l_proc_name);
6188: END IF ;
6189:
6190: RETURN l_standard_ft_work_pattern ;

Line 6190: RETURN l_standard_ft_work_pattern ;

6186: debug('l_standard_ft_work_pattern:'||l_standard_ft_work_pattern);
6187: debug_exit(l_proc_name);
6188: END IF ;
6189:
6190: RETURN l_standard_ft_work_pattern ;
6191:
6192: EXCEPTION
6193: WHEN OTHERS THEN
6194: p_contract_wp := NULL ;

Line 6207: END get_absence_standard_ft_wp ;

6203: fnd_message.raise_error;
6204: ELSE
6205: RAISE;
6206: END IF;
6207: END get_absence_standard_ft_wp ;
6208:
6209:
6210: -- Move to pqp_schedule_calc_pkg and llok at caching options at a correct level
6211: FUNCTION get_average_days_per_week(

Line 6218: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

6214: ,p_work_pattern IN VARCHAR2 )
6215: RETURN NUMBER IS
6216: l_proc_step NUMBER(20,10);
6217: l_proc_name VARCHAR2(61):= g_package_name||'get_average_days_per_week';
6218: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6219: l_average_days_per_week NUMBER ;
6220: BEGIN
6221:
6222: g_debug := hr_utility.debug_enabled;

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

6230: END IF ;
6231:
6232: -- cache this results at this level.
6233: -- do we need to consider effective_Date for caching.
6234: -- if we, lets say the standard work pattern is same for most of the employees
6235: -- but as effective date will vary ( its absence start date ),
6236: -- the caching may not be effective....
6237:
6238: l_average_days_per_week :=

Line 6641: get_absence_standard_ft_wp(

6637: -- ELSE -- IF l_plan_information.absence_days_type IN ('C','W') THEN
6638: -- This information is available for Hours too as they have
6639: -- Work Pattern attached.
6640: l_FT_absence_wp :=
6641: get_absence_standard_ft_wp(
6642: p_business_group_id => p_business_group_id
6643: ,p_assignment_id => p_assignment_id
6644: ,p_effective_date => p_effective_date
6645: ,p_absence_schedule_wp => p_absence_schedule_wp