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_ABSVAL_PKG

Line 1: PACKAGE BODY pqp_absval_pkg AS

1: PACKAGE BODY pqp_absval_pkg AS
2: /* $Header: pqabsbal.pkb 120.21 2012/01/12 11:21:03 rajganga noship $ */
3: --
4: -- Global Varaibles
5:

Line 6: g_package_name VARCHAR2(31):= 'pqp_absval_pkg.';

2: /* $Header: pqabsbal.pkb 120.21 2012/01/12 11:21:03 rajganga noship $ */
3: --
4: -- Global Varaibles
5:
6: g_package_name VARCHAR2(31):= 'pqp_absval_pkg.';
7:
8: g_plan_information rec_plan_information;
9: g_pl_id ben_pl_f.pl_typ_id%TYPE;
10: g_debug BOOLEAN:= hr_utility.debug_enabled;

Line 452: (p_daily_absences IN pqp_absval_pkg.t_daily_absences

448: --
449: --
450: --
451: PROCEDURE write_daily_absences
452: (p_daily_absences IN pqp_absval_pkg.t_daily_absences
453: ,p_gap_absence_plan_id IN pqp_gap_absence_plans.gap_absence_plan_id%TYPE
454: )
455: IS
456:

Line 623: (p_absence_summary_tbl IN OUT NOCOPY pqp_absval_pkg.t_duration_summary

619:
620:
621:
622: PROCEDURE write_duration_summary
623: (p_absence_summary_tbl IN OUT NOCOPY pqp_absval_pkg.t_duration_summary
624: )
625: IS
626:
627: l_proc_name VARCHAR2(61) := g_package_name||'write_duration_summary';

Line 727: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;

723: l_proc_step NUMBER(20,10) ;
724: k BINARY_INTEGER;
725: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
726: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
727: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
728: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
729: l_duration_summary pqp_absval_pkg.t_duration_summary ;
730:
731: BEGIN

Line 728: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;

724: k BINARY_INTEGER;
725: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
726: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
727: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
728: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
729: l_duration_summary pqp_absval_pkg.t_duration_summary ;
730:
731: BEGIN
732: g_debug := hr_utility.debug_enabled;

Line 729: l_duration_summary pqp_absval_pkg.t_duration_summary ;

725: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
726: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
727: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
728: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
729: l_duration_summary pqp_absval_pkg.t_duration_summary ;
730:
731: BEGIN
732: g_debug := hr_utility.debug_enabled;
733:

Line 832: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;

828: k BINARY_INTEGER;
829: l BINARY_INTEGER;
830: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
831: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
832: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
833: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
834: l_duration_summary pqp_absval_pkg.t_duration_summary ;
835:
836: BEGIN

Line 833: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;

829: l BINARY_INTEGER;
830: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
831: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
832: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
833: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
834: l_duration_summary pqp_absval_pkg.t_duration_summary ;
835:
836: BEGIN
837: g_debug := hr_utility.debug_enabled;

Line 834: l_duration_summary pqp_absval_pkg.t_duration_summary ;

830: l_absence_pay_summary csr_pay_level_summary%ROWTYPE;
831: l_absence_ent_summary csr_ent_level_summary%ROWTYPE;
832: l_ent_summary_existing_rows pqp_absval_pkg.t_gap_level ;
833: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
834: l_duration_summary pqp_absval_pkg.t_duration_summary ;
835:
836: BEGIN
837: g_debug := hr_utility.debug_enabled;
838:

Line 1017: ,p_entitlement_granted IN pqp_absval_pkg.t_entitlements

1013:
1014: PROCEDURE write_absence_summary
1015: (p_gap_absence_plan_id IN NUMBER
1016: ,p_assignment_id IN NUMBER
1017: ,p_entitlement_granted IN pqp_absval_pkg.t_entitlements
1018: ,p_entitlement_used_to_date IN pqp_absval_pkg.t_entitlements
1019: ,p_entitlement_remaining IN pqp_absval_pkg.t_entitlements
1020: ,p_fte IN NUMBER DEFAULT 1
1021: ,p_working_days_per_week IN NUMBER DEFAULT NULL

Line 1018: ,p_entitlement_used_to_date IN pqp_absval_pkg.t_entitlements

1014: PROCEDURE write_absence_summary
1015: (p_gap_absence_plan_id IN NUMBER
1016: ,p_assignment_id IN NUMBER
1017: ,p_entitlement_granted IN pqp_absval_pkg.t_entitlements
1018: ,p_entitlement_used_to_date IN pqp_absval_pkg.t_entitlements
1019: ,p_entitlement_remaining IN pqp_absval_pkg.t_entitlements
1020: ,p_fte IN NUMBER DEFAULT 1
1021: ,p_working_days_per_week IN NUMBER DEFAULT NULL
1022: ,p_entitlement_uom IN VARCHAR2

Line 1019: ,p_entitlement_remaining IN pqp_absval_pkg.t_entitlements

1015: (p_gap_absence_plan_id IN NUMBER
1016: ,p_assignment_id IN NUMBER
1017: ,p_entitlement_granted IN pqp_absval_pkg.t_entitlements
1018: ,p_entitlement_used_to_date IN pqp_absval_pkg.t_entitlements
1019: ,p_entitlement_remaining IN pqp_absval_pkg.t_entitlements
1020: ,p_fte IN NUMBER DEFAULT 1
1021: ,p_working_days_per_week IN NUMBER DEFAULT NULL
1022: ,p_entitlement_uom IN VARCHAR2
1023: ,p_update IN BOOLEAN

Line 2201: ,p_absences_taken IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2197: (p_assignment_id IN NUMBER
2198: ,p_pl_typ_id IN NUMBER
2199: ,p_range_from_date IN DATE --not absence start and end dates
2200: ,p_range_to_date IN DATE --period for which sum is taken
2201: ,p_absences_taken IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2202: -- ,p_message OUT NOCOPY VARCHAR2
2203: ) --RETURN NUMBER
2204: IS
2205: --Person level Absence Aggregation changes

Line 2233: l_absences_taken_nc pqp_absval_pkg.t_entitlements;

2229: l_proc_name VARCHAR2(61):=
2230: g_package_name||'get_absences_taken';
2231:
2232: -- nocopy changes
2233: l_absences_taken_nc pqp_absval_pkg.t_entitlements;
2234:
2235: BEGIN
2236: IF g_debug THEN
2237: debug_enter(l_proc_name);

Line 2563: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2559: ,p_scheme_period_type IN VARCHAR2
2560: ,p_scheme_period_duration IN VARCHAR2
2561: ,p_scheme_period_uom IN VARCHAR2
2562: ,p_scheme_period_start IN VARCHAR2
2563: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2564: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2565: -- ,p_message OUT NOCOPY VARCHAR2
2566: -- Added for CS
2567: ,p_dualrolling_4_year IN BOOLEAN

Line 2564: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2560: ,p_scheme_period_duration IN VARCHAR2
2561: ,p_scheme_period_uom IN VARCHAR2
2562: ,p_scheme_period_start IN VARCHAR2
2563: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2564: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2565: -- ,p_message OUT NOCOPY VARCHAR2
2566: -- Added for CS
2567: ,p_dualrolling_4_year IN BOOLEAN
2568: ,p_override_scheme_start_date IN DATE

Line 2594: l_entitlements_nc pqp_absval_pkg.t_entitlements;

2590: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2591: l_error_message fnd_new_messages.message_text%TYPE;
2592:
2593: --nocopy changes
2594: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2595: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;
2596: l_balance_date DATE;
2597:
2598: i BINARY_INTEGER:=0;

Line 2595: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;

2591: l_error_message fnd_new_messages.message_text%TYPE;
2592:
2593: --nocopy changes
2594: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2595: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;
2596: l_balance_date DATE;
2597:
2598: i BINARY_INTEGER:=0;
2599: j BINARY_INTEGER:=0;

Line 2755: pqp_absval_pkg.get_calendar_days_to_extend(

2751:
2752: l_cutoff_counter := l_cutoff_counter + 1 ;
2753:
2754: l_calendar_days_to_extend :=
2755: pqp_absval_pkg.get_calendar_days_to_extend(
2756: p_period_start_date => l_period_start_date
2757: ,p_period_end_date => l_period_end_date
2758: ,p_assignment_id => p_assignment_id
2759: ,p_business_group_id => p_business_group_id

Line 3103: ,p_entitlements IN pqp_absval_pkg.t_entitlements

3099: --
3100: PROCEDURE get_entitlements_remaining
3101: (p_assignment_id IN NUMBER -- LG/PT
3102: ,p_effective_date IN DATE -- LG/PT
3103: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3104: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
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

Line 3104: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements

3100: PROCEDURE get_entitlements_remaining
3101: (p_assignment_id IN NUMBER -- LG/PT
3102: ,p_effective_date IN DATE -- LG/PT
3103: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3104: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
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

Line 3106: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance

3102: ,p_effective_date IN DATE -- LG/PT
3103: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3104: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
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

Line 3127: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements ;

3123: g_package_name||
3124: 'get_entitlements_remaining';
3125:
3126: --nocopy changes
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 ;

Line 3129: l_absences_taken_to_date pqp_absval_pkg.t_entitlements

3125:
3126: --nocopy changes
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 ;

Line 3374: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences

3370: -- of the row handler to ensure that the data is valid prior to the bulk
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

Line 3477: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements

3473: ,p_absence_end_date IN DATE
3474: ,p_entitlement_UOM IN VARCHAR2
3475: ,p_payment_UOM IN VARCHAR2
3476: ,p_output_type IN ff_exec.outputs_t
3477: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
3478: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3479: ,p_error_code OUT NOCOPY NUMBER
3480: ,p_message OUT NOCOPY VARCHAR2
3481: ,p_working_days_per_week IN NUMBER

Line 3478: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences

3474: ,p_entitlement_UOM IN VARCHAR2
3475: ,p_payment_UOM IN VARCHAR2
3476: ,p_output_type IN ff_exec.outputs_t
3477: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
3478: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3479: ,p_error_code OUT NOCOPY NUMBER
3480: ,p_message OUT NOCOPY VARCHAR2
3481: ,p_working_days_per_week IN NUMBER
3482: ,p_fte IN NUMBER -- LG/PT

Line 3530: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements;

3526: l_datatype fnd_lookup_values.lookup_code%TYPE;
3527: l_override_work_pattern pay_user_columns.user_column_name%TYPE;
3528: l_override_work_pattern_yn fnd_lookup_values.lookup_code%TYPE;
3529:
3530: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements;
3531: l_minimum_pay_defined NUMBER ;
3532: l_minimum_pay_rate NUMBER ;
3533: ------- Minimum pay rate enhancment --------
3534: l_minpay_start_date DATE;

Line 5343: l_entitlements pqp_absval_pkg.t_entitlements;

5339: l_value VARCHAR2(240);
5340: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5341:
5342: l_plan_information rec_plan_information;
5343: l_entitlements pqp_absval_pkg.t_entitlements;
5344: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5345: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5346: l_daily_absences pqp_absval_pkg.t_daily_absences;
5347: --table of pqp_gda_shd.g_rec_type

Line 5344: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;

5340: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5341:
5342: l_plan_information rec_plan_information;
5343: l_entitlements pqp_absval_pkg.t_entitlements;
5344: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5345: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5346: l_daily_absences pqp_absval_pkg.t_daily_absences;
5347: --table of pqp_gda_shd.g_rec_type
5348: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;

Line 5345: l_entitlements_remaining pqp_absval_pkg.t_entitlements;

5341:
5342: l_plan_information rec_plan_information;
5343: l_entitlements pqp_absval_pkg.t_entitlements;
5344: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5345: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5346: l_daily_absences pqp_absval_pkg.t_daily_absences;
5347: --table of pqp_gda_shd.g_rec_type
5348: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5349: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;

Line 5346: l_daily_absences pqp_absval_pkg.t_daily_absences;

5342: l_plan_information rec_plan_information;
5343: l_entitlements pqp_absval_pkg.t_entitlements;
5344: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5345: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5346: l_daily_absences pqp_absval_pkg.t_daily_absences;
5347: --table of pqp_gda_shd.g_rec_type
5348: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5349: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5350:

Line 6757: ( p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

6753: END IF;
6754: END get_factors ;
6755:
6756: PROCEDURE convert_entitlements
6757: ( p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
6758: ,p_current_factor IN NUMBER
6759: ,p_ft_factor IN NUMBER
6760: ) IS
6761: l_proc_name VARCHAR2(61) := g_package_name||'convert_entitlements';

Line 6763: l_entitlements_nc pqp_absval_pkg.t_entitlements ;

6759: ,p_ft_factor IN NUMBER
6760: ) IS
6761: l_proc_name VARCHAR2(61) := g_package_name||'convert_entitlements';
6762: l_proc_step NUMBER(20,10) ;
6763: l_entitlements_nc pqp_absval_pkg.t_entitlements ;
6764: i NUMBER ;
6765:
6766: BEGIN
6767: g_debug := hr_utility.debug_enabled;

Line 6826: END pqp_absval_pkg;

6822: END IF;
6823: END convert_entitlements ;
6824:
6825:
6826: END pqp_absval_pkg;