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 PQP_ASSIGNMENT_ATTRIBUTES_F

Line 2595: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2591: l_ft_factor NUMBER;
2592: l_fte_value NUMBER ;
2593: l_working_days_per_week NUMBER ;
2594: l_fte NUMBER ;
2595: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2596: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2597: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2598: l_is_full_timer BOOLEAN ;
2599: l_cutoff_counter NUMBER ;

Line 2596: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2592: l_fte_value NUMBER ;
2593: l_working_days_per_week NUMBER ;
2594: l_fte NUMBER ;
2595: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2596: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2597: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2598: l_is_full_timer BOOLEAN ;
2599: l_cutoff_counter NUMBER ;
2600: l_csr_ckh_lookup csr_ckh_lookup%ROWTYPE;

Line 2597: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2593: l_working_days_per_week NUMBER ;
2594: l_fte NUMBER ;
2595: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2596: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2597: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2598: l_is_full_timer BOOLEAN ;
2599: l_cutoff_counter NUMBER ;
2600: l_csr_ckh_lookup csr_ckh_lookup%ROWTYPE;
2601: l_is_assignment_wp BOOLEAN;

Line 5336: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

5332: l_scheme_category pay_element_type_extra_info.eei_information1%TYPE ;
5333: l_working_days_per_week pqp_gap_daily_absences.working_days_per_week%TYPE;
5334:
5335: l_override_scheme_start_date DATE;
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;

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 5342: -- l_assignment_work_pattern pqp_assignment_Attributes_f.work_pattern%TYPE ;

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 ;
5346: -- i NUMBER ;

Line 5343: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

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 ;
5346: -- i NUMBER ;
5347: l_fte pqp_gap_daily_absences.fte%TYPE ;

Line 5348: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5344: l_current_factor NUMBER ;
5345: l_ft_factor NUMBER ;
5346: -- i NUMBER ;
5347: l_fte pqp_gap_daily_absences.fte%TYPE ;
5348: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5349: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5350: l_is_full_timer BOOLEAN ;
5351: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5352: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

Line 5349: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5345: l_ft_factor NUMBER ;
5346: -- i NUMBER ;
5347: l_fte pqp_gap_daily_absences.fte%TYPE ;
5348: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5349: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5350: l_is_full_timer BOOLEAN ;
5351: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5352: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5353: l_update_summary BOOLEAN;

Line 5351: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5347: l_fte pqp_gap_daily_absences.fte%TYPE ;
5348: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5349: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5350: l_is_full_timer BOOLEAN ;
5351: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5352: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5353: l_update_summary BOOLEAN;
5354: l_is_assignment_wp BOOLEAN;
5355:

Line 5352: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5348: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5349: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5350: l_is_full_timer BOOLEAN ;
5351: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5352: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5353: l_update_summary BOOLEAN;
5354: l_is_assignment_wp BOOLEAN;
5355:
5356: BEGIN

Line 6024: FROM pqp_assignment_attributes_f

6020: p_business_group_id NUMBER
6021: ,p_assignment_id NUMBER
6022: ,p_effective_date DATE ) IS
6023: SELECT contract_type
6024: FROM pqp_assignment_attributes_f
6025: WHERE business_group_id = p_business_group_id
6026: AND assignment_id = p_assignment_id
6027: AND p_effective_date BETWEEN effective_start_date
6028: AND effective_end_date ;

Line 6029: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;

6025: WHERE business_group_id = p_business_group_id
6026: AND assignment_id = p_assignment_id
6027: AND p_effective_date BETWEEN effective_start_date
6028: AND effective_end_date ;
6029: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6030: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6031: l_error_code NUMBER ;
6032: l_error_message fnd_new_messages.message_text%TYPE ;
6033:

Line 6030: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6026: AND assignment_id = p_assignment_id
6027: AND p_effective_date BETWEEN effective_start_date
6028: AND effective_end_date ;
6029: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6030: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6031: l_error_code NUMBER ;
6032: l_error_message fnd_new_messages.message_text%TYPE ;
6033:
6034:

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 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 6259: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

6255: ,p_is_assignment_wp OUT NOCOPY BOOLEAN)
6256: RETURN VARCHAR2 IS
6257: l_proc_step NUMBER(20,10);
6258: l_proc_name VARCHAR2(61):= g_package_name||'get_assignment_work_pattern';
6259: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6260:
6261:
6262: BEGIN
6263:

Line 6531: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6527: ) IS
6528: l_proc_name VARCHAR2(61) := g_package_name||'get_factors';
6529: l_proc_step NUMBER(20,10) ;
6530:
6531: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6532: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6533: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6534: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6535:

Line 6532: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6528: l_proc_name VARCHAR2(61) := g_package_name||'get_factors';
6529: l_proc_step NUMBER(20,10) ;
6530:
6531: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6532: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6533: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6534: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6535:
6536: l_FT_working_dpw NUMBER ;

Line 6533: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6529: l_proc_step NUMBER(20,10) ;
6530:
6531: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6532: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6533: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6534: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6535:
6536: l_FT_working_dpw NUMBER ;
6537: l_FT_absence_wp_dpw NUMBER ;

Line 6534: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6530:
6531: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6532: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6533: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6534: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6535:
6536: l_FT_working_dpw NUMBER ;
6537: l_FT_absence_wp_dpw NUMBER ;
6538: l_assignment_wp_dpw NUMBER ;