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.16.12010000.3 2008/08/08 07:11:55 ubhat ship $ */
3: --
4: -- Global Varaibles
5:

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

2: /* $Header: pqabsbal.pkb 120.16.12010000.3 2008/08/08 07:11:55 ubhat ship $ */
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 2180: ,p_absences_taken IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2176: (p_assignment_id IN NUMBER
2177: ,p_pl_typ_id IN NUMBER
2178: ,p_range_from_date IN DATE --not absence start and end dates
2179: ,p_range_to_date IN DATE --period for which sum is taken
2180: ,p_absences_taken IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2181: -- ,p_message OUT NOCOPY VARCHAR2
2182: ) --RETURN NUMBER
2183: IS
2184: --Person level Absence Aggregation changes

Line 2212: l_absences_taken_nc pqp_absval_pkg.t_entitlements;

2208: l_proc_name VARCHAR2(61):=
2209: g_package_name||'get_absences_taken';
2210:
2211: -- nocopy changes
2212: l_absences_taken_nc pqp_absval_pkg.t_entitlements;
2213:
2214: BEGIN
2215: IF g_debug THEN
2216: debug_enter(l_proc_name);

Line 2542: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2538: ,p_scheme_period_type IN VARCHAR2
2539: ,p_scheme_period_duration IN VARCHAR2
2540: ,p_scheme_period_uom IN VARCHAR2
2541: ,p_scheme_period_start IN VARCHAR2
2542: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2543: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2544: -- ,p_message OUT NOCOPY VARCHAR2
2545: -- Added for CS
2546: ,p_dualrolling_4_year IN BOOLEAN

Line 2543: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements

2539: ,p_scheme_period_duration IN VARCHAR2
2540: ,p_scheme_period_uom IN VARCHAR2
2541: ,p_scheme_period_start IN VARCHAR2
2542: ,p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2543: ,p_absences_taken_to_date IN OUT NOCOPY pqp_absval_pkg.t_entitlements
2544: -- ,p_message OUT NOCOPY VARCHAR2
2545: -- Added for CS
2546: ,p_dualrolling_4_year IN BOOLEAN
2547: ,p_override_scheme_start_date IN DATE

Line 2573: l_entitlements_nc pqp_absval_pkg.t_entitlements;

2569: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2570: l_error_message fnd_new_messages.message_text%TYPE;
2571:
2572: --nocopy changes
2573: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2574: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;
2575: l_balance_date DATE;
2576:
2577: i BINARY_INTEGER:=0;

Line 2574: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;

2570: l_error_message fnd_new_messages.message_text%TYPE;
2571:
2572: --nocopy changes
2573: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2574: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;
2575: l_balance_date DATE;
2576:
2577: i BINARY_INTEGER:=0;
2578: j BINARY_INTEGER:=0;

Line 2734: pqp_absval_pkg.get_calendar_days_to_extend(

2730:
2731: l_cutoff_counter := l_cutoff_counter + 1 ;
2732:
2733: l_calendar_days_to_extend :=
2734: pqp_absval_pkg.get_calendar_days_to_extend(
2735: p_period_start_date => l_period_start_date
2736: ,p_period_end_date => l_period_end_date
2737: ,p_assignment_id => p_assignment_id
2738: ,p_business_group_id => p_business_group_id

Line 3082: ,p_entitlements IN pqp_absval_pkg.t_entitlements

3078: --
3079: PROCEDURE get_entitlements_remaining
3080: (p_assignment_id IN NUMBER -- LG/PT
3081: ,p_effective_date IN DATE -- LG/PT
3082: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3083: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
3084: ,p_entitlement_UOM IN VARCHAR2
3085: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance
3086: ,p_is_full_timer IN BOOLEAN

Line 3083: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements

3079: PROCEDURE get_entitlements_remaining
3080: (p_assignment_id IN NUMBER -- LG/PT
3081: ,p_effective_date IN DATE -- LG/PT
3082: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3083: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
3084: ,p_entitlement_UOM IN VARCHAR2
3085: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance
3086: ,p_is_full_timer IN BOOLEAN
3087: -- ,p_avg_working_days_assignment IN NUMBER --LG/PT

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

3081: ,p_effective_date IN DATE -- LG/PT
3082: ,p_entitlements IN pqp_absval_pkg.t_entitlements
3083: ,p_absences_taken_to_date IN pqp_absval_pkg.t_entitlements
3084: ,p_entitlement_UOM IN VARCHAR2
3085: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements--t_ent_run_balance
3086: ,p_is_full_timer IN BOOLEAN
3087: -- ,p_avg_working_days_assignment IN NUMBER --LG/PT
3088: -- ,p_avg_working_days_standard IN NUMBER -- LG/PT
3089: -- ,p_message OUT NOCOPY VARCHAR2

Line 3106: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements ;

3102: g_package_name||
3103: 'get_entitlements_remaining';
3104:
3105: --nocopy changes
3106: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements ;
3107: -- LG/PT
3108: l_absences_taken_to_date pqp_absval_pkg.t_entitlements
3109: := p_absences_taken_to_date ;
3110: l_fte_value pqp_gap_daily_absences.fte%TYPE ;

Line 3108: l_absences_taken_to_date pqp_absval_pkg.t_entitlements

3104:
3105: --nocopy changes
3106: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements ;
3107: -- LG/PT
3108: l_absences_taken_to_date pqp_absval_pkg.t_entitlements
3109: := p_absences_taken_to_date ;
3110: l_fte_value pqp_gap_daily_absences.fte%TYPE ;
3111: l_current_factor NUMBER ;
3112: l_ft_factor NUMBER ;

Line 3353: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences

3349: -- of the row handler to ensure that the data is valid prior to the bulk
3350: -- insert call
3351: --
3352: PROCEDURE set_daily_absence_cache
3353: (p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3354: ,p_absence_date IN pqp_gap_daily_absences.absence_date%TYPE
3355: ,p_work_pattern_day_type IN pqp_gap_daily_absences.work_pattern_day_type%TYPE
3356: ,p_level_of_entitlement IN pqp_gap_daily_absences.level_of_entitlement%TYPE
3357: ,p_level_of_pay IN pqp_gap_daily_absences.level_of_pay%TYPE

Line 3456: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements

3452: ,p_absence_end_date IN DATE
3453: ,p_entitlement_UOM IN VARCHAR2
3454: ,p_payment_UOM IN VARCHAR2
3455: ,p_output_type IN ff_exec.outputs_t
3456: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
3457: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3458: ,p_error_code OUT NOCOPY NUMBER
3459: ,p_message OUT NOCOPY VARCHAR2
3460: ,p_working_days_per_week IN NUMBER

Line 3457: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences

3453: ,p_entitlement_UOM IN VARCHAR2
3454: ,p_payment_UOM IN VARCHAR2
3455: ,p_output_type IN ff_exec.outputs_t
3456: ,p_entitlements_remaining IN OUT NOCOPY pqp_absval_pkg.t_entitlements
3457: ,p_daily_absences IN OUT NOCOPY pqp_absval_pkg.t_daily_absences
3458: ,p_error_code OUT NOCOPY NUMBER
3459: ,p_message OUT NOCOPY VARCHAR2
3460: ,p_working_days_per_week IN NUMBER
3461: ,p_fte IN NUMBER -- LG/PT

Line 3509: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements;

3505: l_datatype fnd_lookup_values.lookup_code%TYPE;
3506: l_override_work_pattern pay_user_columns.user_column_name%TYPE;
3507: l_override_work_pattern_yn fnd_lookup_values.lookup_code%TYPE;
3508:
3509: l_entitlements_remaining_nc pqp_absval_pkg.t_entitlements;
3510: l_minimum_pay_defined NUMBER ;
3511: l_minimum_pay_rate NUMBER ;
3512: ------- Minimum pay rate enhancment --------
3513: l_minpay_start_date DATE;

Line 5315: l_entitlements pqp_absval_pkg.t_entitlements;

5311: l_value VARCHAR2(240);
5312: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5313:
5314: l_plan_information rec_plan_information;
5315: l_entitlements pqp_absval_pkg.t_entitlements;
5316: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5317: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5318: l_daily_absences pqp_absval_pkg.t_daily_absences;
5319: --table of pqp_gda_shd.g_rec_type

Line 5316: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;

5312: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5313:
5314: l_plan_information rec_plan_information;
5315: l_entitlements pqp_absval_pkg.t_entitlements;
5316: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5317: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5318: l_daily_absences pqp_absval_pkg.t_daily_absences;
5319: --table of pqp_gda_shd.g_rec_type
5320: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;

Line 5317: l_entitlements_remaining pqp_absval_pkg.t_entitlements;

5313:
5314: l_plan_information rec_plan_information;
5315: l_entitlements pqp_absval_pkg.t_entitlements;
5316: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5317: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5318: l_daily_absences pqp_absval_pkg.t_daily_absences;
5319: --table of pqp_gda_shd.g_rec_type
5320: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5321: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;

Line 5318: l_daily_absences pqp_absval_pkg.t_daily_absences;

5314: l_plan_information rec_plan_information;
5315: l_entitlements pqp_absval_pkg.t_entitlements;
5316: l_absences_taken_to_date pqp_absval_pkg.t_entitlements;
5317: l_entitlements_remaining pqp_absval_pkg.t_entitlements;
5318: l_daily_absences pqp_absval_pkg.t_daily_absences;
5319: --table of pqp_gda_shd.g_rec_type
5320: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5321: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5322:

Line 6686: ( p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements

6682: END IF;
6683: END get_factors ;
6684:
6685: PROCEDURE convert_entitlements
6686: ( p_entitlements IN OUT NOCOPY pqp_absval_pkg.t_entitlements
6687: ,p_current_factor IN NUMBER
6688: ,p_ft_factor IN NUMBER
6689: ) IS
6690: l_proc_name VARCHAR2(61) := g_package_name||'convert_entitlements';

Line 6692: l_entitlements_nc pqp_absval_pkg.t_entitlements ;

6688: ,p_ft_factor IN NUMBER
6689: ) IS
6690: l_proc_name VARCHAR2(61) := g_package_name||'convert_entitlements';
6691: l_proc_step NUMBER(20,10) ;
6692: l_entitlements_nc pqp_absval_pkg.t_entitlements ;
6693: i NUMBER ;
6694:
6695: BEGIN
6696: g_debug := hr_utility.debug_enabled;

Line 6755: END pqp_absval_pkg;

6751: END IF;
6752: END convert_entitlements ;
6753:
6754:
6755: END pqp_absval_pkg;