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_GAP_DAILY_ABSENCES

Line 16: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;

12: g_deduct_absence_for pqp_configuration_values.PCV_INFORMATION9%TYPE;
13:
14: -- Cache for rounding of factors
15: g_pt_entitl_rounding_type VARCHAR2(10):=null;
16: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
17: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
18: g_round_cache_plan_id NUMBER;
19: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
20: g_open_ended_no_pay_days NUMBER;

Line 17: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;

13:
14: -- Cache for rounding of factors
15: g_pt_entitl_rounding_type VARCHAR2(10):=null;
16: g_pt_rounding_precision pqp_gap_daily_absences.duration%TYPE;
17: g_ft_rounding_precision pqp_gap_daily_absences.duration%TYPE;
18: g_round_cache_plan_id NUMBER;
19: g_ft_entitl_rounding_type VARCHAR2(10):=null ;
20: g_open_ended_no_pay_days NUMBER;
21: g_log_duration_summary VARCHAR2(20) := NULL;

Line 34: FROM pqp_gap_daily_absences

30: IS
31: SELECT level_of_pay GAP_LEVEL, MIN(absence_date) START_DATE,
32: MAX(absence_date) END_DATE, SUM(DURATION) DURATION,
33: SUM(DURATION_IN_HOURS) DURATION_IN_HOURS
34: FROM pqp_gap_daily_absences
35: WHERE gap_absence_plan_id = p_gap_absence_plan_id
36: GROUP BY level_of_pay
37: HAVING level_of_pay LIKE '%BAND%'
38: OR level_of_pay LIKE 'NOBANDMIN'

Line 49: FROM pqp_gap_daily_absences

45: IS
46: SELECT level_of_entitlement GAP_LEVEL, MIN(absence_date) START_DATE,
47: MAX(absence_date) END_DATE,SUM(DURATION) DURATION,
48: SUM(DURATION_IN_HOURS) DURATION_IN_HOURS
49: FROM pqp_gap_daily_absences
50: WHERE gap_absence_plan_id = p_gap_absence_plan_id
51: GROUP BY level_of_entitlement
52: HAVING level_of_entitlement LIKE '%BAND%'
53: OR level_of_entitlement LIKE 'WAITINGDAY'

Line 494: --desc pqp_gap_daily_absences

490: END IF;
491:
492: --FORALL i IN 1..5000 -- use FORALL statement
493: -- INSERT INTO parts VALUES (pnums(i), pnames(i));
494: --desc pqp_gap_daily_absences
495: -- Name Null? Type
496: -- ------------------------------- -------- ----
497: -- GAP_DAILY_ABSENCE_ID NOT NULL NUMBER(15)
498: -- GAP_ABSENCE_PLAN_ID NOT NULL NUMBER(15)

Line 548: INSERT INTO pqp_gap_daily_absences

544: debug(l_proc_name, 20);
545: END IF;
546:
547: FORALL i IN p_daily_absences.FIRST..p_daily_absences.LAST
548: INSERT INTO pqp_gap_daily_absences
549: (gap_daily_absence_id --NOT NULL NUMBER(15)
550: ,gap_absence_plan_id --NOT NULL NUMBER(15)
551: ,absence_date --NOT NULL DATE
552: ,work_pattern_day_type --NOT NULL VARCHAR2(30)

Line 566: (pqp_gap_daily_absences_s.NEXTVAL

562: -- ,creation_date -- DATE
563: ,object_version_number -- NUMBER(15)
564: )
565: VALUES
566: (pqp_gap_daily_absences_s.NEXTVAL
567: ,l_gap_absence_plan_ids(i) --NOT NULL NUMBER(15)
568: ,l_absence_dates(i) --NOT NULL DATE
569: ,l_work_pattern_day_types(i) --NOT NULL VARCHAR2(30)
570: ,l_level_of_entitlements(i) --NOT NULL VARCHAR2(30)

Line 1163: FROM pqp_gap_daily_absences gda

1159: debug(l_proc_name, l_proc_step);
1160: END IF;
1161:
1162: DELETE
1163: FROM pqp_gap_daily_absences gda
1164: WHERE gda.gap_absence_plan_id = l_gap_absence_plan.gap_absence_plan_id
1165: AND gda.absence_date
1166: BETWEEN NVL(p_delete_start_date,gda.absence_date)
1167: AND NVL(p_delete_end_date,gda.absence_date);

Line 1172: debug('pqp_gap_daily_absences rows deleted.');

1168:
1169: l_proc_step := 30;
1170: IF g_debug THEN
1171: debug(SQL%ROWCOUNT);
1172: debug('pqp_gap_daily_absences rows deleted.');
1173: debug(l_proc_name, l_proc_step);
1174: END IF;
1175:
1176: OPEN csr_gap_daily_absences_exists(l_gap_absence_plan.gap_absence_plan_id);

Line 2273: ,pqp_gap_daily_absences gda

2269: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2270: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2271: FROM pqp_gap_absence_plans gap
2272: ,ben_pl_f pln
2273: ,pqp_gap_daily_absences gda
2274: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2275: (SELECT other_asg.assignment_id
2276: FROM per_all_assignments_f this_asg
2277: ,per_all_assignments_f other_asg

Line 2318: ,pqp_gap_daily_absences gda

2314: ,SUM(gda.duration/gda.working_days_per_week) sum_of_duration_per_week
2315: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2316: FROM pqp_gap_absence_plans gap
2317: ,ben_pl_f pln
2318: ,pqp_gap_daily_absences gda
2319: WHERE gap.assignment_id IN -- automatically makes the assignment list distinct
2320: (SELECT asg.assignment_id
2321: FROM per_all_assignments_f asg
2322: WHERE asg.person_id = l_person_id

Line 2351: ,pqp_gap_daily_absences gda

2347: -- LG/PT
2348: ,SUM(gda.duration_in_hours/fte) sum_of_fte_hours
2349: FROM pqp_gap_absence_plans gap
2350: ,ben_pl_f pln
2351: ,pqp_gap_daily_absences gda
2352: WHERE gap.assignment_id = p_assignment_id
2353: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id
2354: AND pln.pl_id = gap.pl_id
2355: AND p_range_to_date

Line 3131: l_fte_value pqp_gap_daily_absences.fte%TYPE ;

3127: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements ;
3128: -- LG/PT
3129: l_absences_taken_to_date pqp_absval_pkg.t_entitlements
3130: := p_absences_taken_to_date ;
3131: l_fte_value pqp_gap_daily_absences.fte%TYPE ;
3132: l_current_factor NUMBER ;
3133: l_ft_factor NUMBER ;
3134:
3135: BEGIN

Line 3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE

3371: -- insert call
3372: --
3373: PROCEDURE set_daily_absence_cache
3374: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE

Line 3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE

3372: --
3373: PROCEDURE set_daily_absence_cache
3374: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE

Line 3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE

3373: PROCEDURE set_daily_absence_cache
3374: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE

Line 3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE

3374: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT

Line 3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE

3375: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE

Line 3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE

3376: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE

Line 3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE

3377: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3385: )

Line 3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT

3378: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE
3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3385: )
3386: IS

Line 3490: l_part_start_day pqp_gap_daily_absences.duration%TYPE;

3486: ,p_is_assignment_wp IN BOOLEAN
3487: )
3488: IS
3489:
3490: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
3491: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
3492: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
3493:
3494: l_duration NUMBER ;

Line 3491: l_part_end_day pqp_gap_daily_absences.duration%TYPE;

3487: )
3488: IS
3489:
3490: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
3491: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
3492: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
3493:
3494: l_duration NUMBER ;
3495: l_duration_to_process NUMBER ;

Line 3507: l_work_pattern_day_type pqp_gap_daily_absences.work_pattern_day_type%TYPE;

3503: l_count_for_entitlement BOOLEAN;
3504: l_entitled_to_be_paid BOOLEAN;
3505: l_is_working_day BOOLEAN;
3506:
3507: l_work_pattern_day_type pqp_gap_daily_absences.work_pattern_day_type%TYPE;
3508: l_level_of_entitlement pqp_gap_daily_absences.level_of_entitlement%TYPE;
3509: l_level_of_pay pqp_gap_daily_absences.level_of_pay%TYPE;
3510:
3511: i BINARY_INTEGER;

Line 3508: l_level_of_entitlement pqp_gap_daily_absences.level_of_entitlement%TYPE;

3504: l_entitled_to_be_paid BOOLEAN;
3505: l_is_working_day BOOLEAN;
3506:
3507: l_work_pattern_day_type pqp_gap_daily_absences.work_pattern_day_type%TYPE;
3508: l_level_of_entitlement pqp_gap_daily_absences.level_of_entitlement%TYPE;
3509: l_level_of_pay pqp_gap_daily_absences.level_of_pay%TYPE;
3510:
3511: i BINARY_INTEGER;
3512: dd BINARY_INTEGER:=0;

Line 3509: l_level_of_pay pqp_gap_daily_absences.level_of_pay%TYPE;

3505: l_is_working_day BOOLEAN;
3506:
3507: l_work_pattern_day_type pqp_gap_daily_absences.work_pattern_day_type%TYPE;
3508: l_level_of_entitlement pqp_gap_daily_absences.level_of_entitlement%TYPE;
3509: l_level_of_pay pqp_gap_daily_absences.level_of_pay%TYPE;
3510:
3511: i BINARY_INTEGER;
3512: dd BINARY_INTEGER:=0;
3513: cc BINARY_INTEGER:=0;

Line 3550: l_waiting_days_used pqp_gap_daily_absences.duration%TYPE;

3546: l_waiting_days_remaining NUMBER;--Waiting days remaining during the iteration
3547: l_duration_to_set_as_waiting NUMBER;--Duration of waiting period processed in one iteration
3548: l_waiting_entitlement VARCHAR2(30);
3549: l_waiting_pay VARCHAR2(30) ;
3550: l_waiting_days_used pqp_gap_daily_absences.duration%TYPE;
3551: negative_value EXCEPTION;
3552: ------Waiting Period enhancements
3553:
3554:

Line 4932: l_part_start_day pqp_gap_daily_absences.duration%TYPE;

4928: l_proc_name VARCHAR2(61):=
4929: g_package_name||
4930: 'update_absence_plan_details';
4931: l_open_ended_no_pay_days NUMBER;
4932: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
4933: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
4934: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
4935: BEGIN
4936:

Line 4933: l_part_end_day pqp_gap_daily_absences.duration%TYPE;

4929: g_package_name||
4930: 'update_absence_plan_details';
4931: l_open_ended_no_pay_days NUMBER;
4932: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
4933: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
4934: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
4935: BEGIN
4936:
4937:

Line 5361: l_working_days_per_week pqp_gap_daily_absences.working_days_per_week%TYPE;

5357: 'create_absence_plan_details';
5358:
5359: l_entitlement_UOM pay_element_type_extra_info.eei_information1%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:

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

Line 5973: -- write the child PQP_GAP_DAILY_ABSENCES row

5969: );
5970: l_update_summary := TRUE ;
5971: END IF; -- IF l_gap_absence_plan.gap_absence_plan_id IS NULL
5972:
5973: -- write the child PQP_GAP_DAILY_ABSENCES row
5974: l_proc_step := 140;
5975: IF g_debug THEN
5976: debug(l_proc_name, 140);
5977: END IF;

Line 6371: from pqp_gap_daily_absences gda

6367: -- now this cursor is getting total paid absences taken for the plan that are to be included in extension rule
6368: -- wherever the query is changed the comment is wriiten accordingly.
6369: CURSOR csr_css_no_pay_days IS
6370: select NVL(SUM(gda.duration),0)
6371: from pqp_gap_daily_absences gda
6372: ,pqp_gap_absence_plans gap
6373: ,ben_pl_f pl
6374: ,hr_lookups hrl --added extra 7585452
6375: where pl.pl_id = gap.pl_id

Line 6400: from pqp_gap_daily_absences gda

6396: -- wherever the query is changed the comment is wriiten accordingly.
6397:
6398: CURSOR csr_css_no_pay_curpos IS
6399: select NVL(SUM(gda.duration),0)
6400: from pqp_gap_daily_absences gda
6401: ,pqp_gap_absence_plans gap
6402: ,ben_pl_f pl
6403: ,hr_lookups hrl --added extra 7585452
6404: where gap.assignment_id IN

Line 6440: from pqp_gap_daily_absences gda

6436: -- wherever the query is changed the comment is written accordingly.
6437:
6438: CURSOR csr_css_no_pay_allpos(p_person_id IN NUMBER) IS
6439: select NVL(SUM(gda.duration),0)
6440: from pqp_gap_daily_absences gda
6441: ,pqp_gap_absence_plans gap
6442: ,ben_pl_f pl
6443: ,hr_lookups hrl --added extra 7585452
6444: where gap.assignment_id IN