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 2616: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2612: l_ft_factor NUMBER;
2613: l_fte_value NUMBER ;
2614: l_working_days_per_week NUMBER ;
2615: l_fte NUMBER ;
2616: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2617: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2618: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2619: l_is_full_timer BOOLEAN ;
2620: l_cutoff_counter NUMBER ;

Line 2617: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2613: l_fte_value NUMBER ;
2614: l_working_days_per_week NUMBER ;
2615: l_fte NUMBER ;
2616: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2617: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2618: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2619: l_is_full_timer BOOLEAN ;
2620: l_cutoff_counter NUMBER ;
2621: l_csr_ckh_lookup csr_ckh_lookup%ROWTYPE;

Line 2618: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

2614: l_working_days_per_week NUMBER ;
2615: l_fte NUMBER ;
2616: l_ft_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2617: l_ft_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2618: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
2619: l_is_full_timer BOOLEAN ;
2620: l_cutoff_counter NUMBER ;
2621: l_csr_ckh_lookup csr_ckh_lookup%ROWTYPE;
2622: l_is_assignment_wp BOOLEAN;

Line 5364: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;

5360: l_scheme_category pay_element_type_extra_info.eei_information1%TYPE ;
5361: l_working_days_per_week pqp_gap_daily_absences.working_days_per_week%TYPE;
5362:
5363: l_override_scheme_start_date DATE;
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;

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

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

Line 5371: l_contract_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

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

Line 5376: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5372: l_current_factor NUMBER ;
5373: l_ft_factor NUMBER ;
5374: -- i NUMBER ;
5375: l_fte pqp_gap_daily_absences.fte%TYPE ;
5376: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5377: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5378: l_is_full_timer BOOLEAN ;
5379: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5380: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

Line 5377: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5373: l_ft_factor NUMBER ;
5374: -- i NUMBER ;
5375: l_fte pqp_gap_daily_absences.fte%TYPE ;
5376: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5377: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5378: l_is_full_timer BOOLEAN ;
5379: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5380: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5381: l_update_summary BOOLEAN;

Line 5379: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5375: l_fte pqp_gap_daily_absences.fte%TYPE ;
5376: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5377: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5378: l_is_full_timer BOOLEAN ;
5379: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5380: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5381: l_update_summary BOOLEAN;
5382: l_is_assignment_wp BOOLEAN;
5383:

Line 5380: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;

5376: l_FT_absence_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5377: l_FT_working_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5378: l_is_full_timer BOOLEAN ;
5379: l_override_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5380: l_assignment_wp pqp_assignment_Attributes_f.work_pattern%TYPE ;
5381: l_update_summary BOOLEAN;
5382: l_is_assignment_wp BOOLEAN;
5383:
5384: BEGIN

Line 6052: FROM pqp_assignment_attributes_f

6048: p_business_group_id NUMBER
6049: ,p_assignment_id NUMBER
6050: ,p_effective_date DATE ) IS
6051: SELECT contract_type
6052: FROM pqp_assignment_attributes_f
6053: WHERE business_group_id = p_business_group_id
6054: AND assignment_id = p_assignment_id
6055: AND p_effective_date BETWEEN effective_start_date
6056: AND effective_end_date ;

Line 6057: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;

6053: WHERE business_group_id = p_business_group_id
6054: AND assignment_id = p_assignment_id
6055: AND p_effective_date BETWEEN effective_start_date
6056: AND effective_end_date ;
6057: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6058: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6059: l_error_code NUMBER ;
6060: l_error_message fnd_new_messages.message_text%TYPE ;
6061:

Line 6058: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6054: AND assignment_id = p_assignment_id
6055: AND p_effective_date BETWEEN effective_start_date
6056: AND effective_end_date ;
6057: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6058: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6059: l_error_code NUMBER ;
6060: l_error_message fnd_new_messages.message_text%TYPE ;
6061:
6062:

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

6283: ,p_is_assignment_wp OUT NOCOPY BOOLEAN)
6284: RETURN VARCHAR2 IS
6285: l_proc_step NUMBER(20,10);
6286: l_proc_name VARCHAR2(61):= g_package_name||'get_assignment_work_pattern';
6287: l_assignment_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6288:
6289:
6290: BEGIN
6291:

Line 6602: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6598: ) IS
6599: l_proc_name VARCHAR2(61) := g_package_name||'get_factors';
6600: l_proc_step NUMBER(20,10) ;
6601:
6602: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6603: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6604: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6605: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6606:

Line 6603: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6599: l_proc_name VARCHAR2(61) := g_package_name||'get_factors';
6600: l_proc_step NUMBER(20,10) ;
6601:
6602: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6603: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6604: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6605: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6606:
6607: l_FT_working_dpw NUMBER ;

Line 6604: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6600: l_proc_step NUMBER(20,10) ;
6601:
6602: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6603: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6604: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6605: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6606:
6607: l_FT_working_dpw NUMBER ;
6608: l_FT_absence_wp_dpw NUMBER ;

Line 6605: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

6601:
6602: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6603: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6604: l_contract_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6605: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6606:
6607: l_FT_working_dpw NUMBER ;
6608: l_FT_absence_wp_dpw NUMBER ;
6609: l_assignment_wp_dpw NUMBER ;