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_GB_OSP_FUNCTIONS dependencies on PQP_GAP_DAILY_ABSENCES

Line 83: g_parttimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;

79: /*check it absence round_to handle*/
80:
81: /* g_parttimers_entitl_round_to VARCHAR2(10):=null;
82: g_parttimers_absence_round_to VARCHAR2(10):=null;
83: g_parttimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;
84: g_fulltimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;
85: g_fulltimers_entitl_round_to VARCHAR2(10):=null ;
86: g_fulltimers_absence_round_to VARCHAR2(10):=null;*/
87:

Line 84: g_fulltimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;

80:
81: /* g_parttimers_entitl_round_to VARCHAR2(10):=null;
82: g_parttimers_absence_round_to VARCHAR2(10):=null;
83: g_parttimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;
84: g_fulltimers_rounding_factor pqp_gap_daily_absences.duration%TYPE;
85: g_fulltimers_entitl_round_to VARCHAR2(10):=null ;
86: g_fulltimers_absence_round_to VARCHAR2(10):=null;*/
87:
88: g_pt_entitl_rounding_type VARCHAR2(10):=null;

Line 89: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;

85: g_fulltimers_entitl_round_to VARCHAR2(10):=null ;
86: g_fulltimers_absence_round_to VARCHAR2(10):=null;*/
87:
88: g_pt_entitl_rounding_type VARCHAR2(10):=null;
89: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
90: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
91: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
92: g_abs_rounding_precision pqp_gap_daily_absences.duration%TYPE;
93: g_abs_rounding_type VARCHAR2(10):='ROUNDTO' ;

Line 90: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;

86: g_fulltimers_absence_round_to VARCHAR2(10):=null;*/
87:
88: g_pt_entitl_rounding_type VARCHAR2(10):=null;
89: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
90: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
91: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
92: g_abs_rounding_precision pqp_gap_daily_absences.duration%TYPE;
93: g_abs_rounding_type VARCHAR2(10):='ROUNDTO' ;
94: g_round_cache_plan_id NUMBER;

Line 92: g_abs_rounding_precision pqp_gap_daily_absences.duration%TYPE;

88: g_pt_entitl_rounding_type VARCHAR2(10):=null;
89: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
90: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
91: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
92: g_abs_rounding_precision pqp_gap_daily_absences.duration%TYPE;
93: g_abs_rounding_type VARCHAR2(10):='ROUNDTO' ;
94: g_round_cache_plan_id NUMBER;
95:
96: --

Line 3069: pqp_gap_daily_absences.working_days_per_week%TYPE := 7 ;

3065: l_current_factor NUMBER ;
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:

Line 3071: pqp_gap_daily_absences.working_days_per_week%TYPE ;

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;
3075: l_fte pqp_gap_daily_absences.fte%TYPE ;

Line 3074: l_working_days_per_week pqp_gap_daily_absences.working_days_per_week%TYPE;

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;
3075: l_fte pqp_gap_daily_absences.fte%TYPE ;
3076: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
3077: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
3078: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;

Line 3075: l_fte pqp_gap_daily_absences.fte%TYPE ;

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;
3075: l_fte pqp_gap_daily_absences.fte%TYPE ;
3076: l_FT_absence_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
3077: l_FT_working_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
3078: l_assignment_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
3079: l_is_full_timer BOOLEAN ;

Line 5553: pqp_gap_daily_absences.working_days_per_week%TYPE ;

5549: l_retval NUMBER(11, 5) := 0;
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:

Line 5555: pqp_gap_daily_absences.working_days_per_week%TYPE ;

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 ;
5559: l_ft_factor NUMBER ;

Line 6302: l_balance pqp_gap_daily_absences.DURATION%TYPE;

6298: RETURN NUMBER
6299: IS
6300: l_error_message VARCHAR2(100);
6301: l_error_code NUMBER;
6302: l_balance pqp_gap_daily_absences.DURATION%TYPE;
6303: l_proc_step NUMBER(38,10):=0;
6304: l_proc_name VARCHAR2(61):=
6305: g_package_name||'get_paid_days_duration';
6306: BEGIN

Line 6362: l_balance pqp_gap_daily_absences.DURATION%TYPE;

6358: RETURN NUMBER
6359: IS
6360: l_error_message VARCHAR2(100);
6361: l_error_code NUMBER;
6362: l_balance pqp_gap_daily_absences.DURATION%TYPE;
6363: l_proc_step NUMBER(38,10):=0;
6364: l_proc_name VARCHAR2(61):=
6365: g_package_name||'get_entitled_days_duration';
6366: BEGIN

Line 6423: l_balance pqp_gap_daily_absences.DURATION%TYPE;

6419: RETURN NUMBER
6420: IS
6421: l_error_message VARCHAR2(100);
6422: l_error_code NUMBER;
6423: l_balance pqp_gap_daily_absences.DURATION%TYPE;
6424: l_proc_step NUMBER(38,10):=0;
6425: l_proc_name VARCHAR2(61):=
6426: g_package_name||'get_wp_days_duration';
6427: BEGIN

Line 7556: FROM pqp_gap_daily_absences gda

7552: ,p_level_of_entitlement IN VARCHAR2 DEFAULT NULL
7553: ,p_level_of_pay IN VARCHAR2 DEFAULT NULL
7554: ) IS
7555: SELECT MIN(gda.absence_date) abs_date
7556: FROM pqp_gap_daily_absences gda
7557: WHERE gda.gap_absence_plan_id = p_gap_absence_plan_id
7558: AND ( ( p_level_of_entitlement IS NOT NULL
7559: AND
7560: gda.level_of_entitlement = p_level_of_entitlement

Line 7581: FROM pqp_gap_daily_absences gda

7577: ,p_level_of_entitlement IN VARCHAR2 DEFAULT NULL
7578: ,p_level_of_pay IN VARCHAR2 DEFAULT NULL
7579: ) IS
7580: SELECT MAX(gda.absence_date) abs_date
7581: FROM pqp_gap_daily_absences gda
7582: WHERE gda.gap_absence_plan_id = p_gap_absence_plan_id
7583: AND ( ( p_level_of_entitlement IS NOT NULL
7584: AND
7585: gda.level_of_entitlement = p_level_of_entitlement

Line 10461: ,pqp_gap_daily_absences gda

10457: ,p_range_end_date IN DATE
10458: ) IS
10459: SELECT NVL(SUM(gda.duration),0) days
10460: FROM pqp_gap_absence_plans gap
10461: ,pqp_gap_daily_absences gda
10462: WHERE gap.assignment_id = p_assignment_id
10463: AND gap.pl_id = p_plan_id
10464: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
10465: -- commented out due to perf changes

Line 10500: ,pqp_gap_daily_absences gda

10496: ,p_range_end_date IN DATE
10497: ) IS
10498: SELECT MAX(ABSENCE_DATE) NB_END_DT, MIN(ABSENCE_DATE) NB_START_DT
10499: FROM pqp_gap_absence_plans gap
10500: ,pqp_gap_daily_absences gda
10501: WHERE gap.assignment_id = p_assignment_id
10502: AND gap.pl_id = p_plan_id
10503: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
10504: AND gda.level_of_pay = p_level_of_payment