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_SCHEDULE_CALCULATION_PKG

Line 9: pqp_schedule_calculation_pkg.g_udt_name;

5: g_debug BOOLEAN:= hr_utility.debug_enabled;
6:
7:
8: g_udt_name VARCHAR2(80):=
9: pqp_schedule_calculation_pkg.g_udt_name;
10:
11: g_default_start_day VARCHAR2(30):=
12: pqp_schedule_calculation_pkg.g_default_start_day;
13:

Line 12: pqp_schedule_calculation_pkg.g_default_start_day;

8: g_udt_name VARCHAR2(80):=
9: pqp_schedule_calculation_pkg.g_udt_name;
10:
11: g_default_start_day VARCHAR2(30):=
12: pqp_schedule_calculation_pkg.g_default_start_day;
13:
14: g_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
16: g_balance_date DATE := hr_api.g_date;

Line 3264: pqp_schedule_calculation_pkg.get_working_days_in_week (

3260: -- the standard work pattern call is required as we have
3261: -- to compare to know if the person is Full timer or part timer
3262:
3263: l_working_days_in_week :=
3264: pqp_schedule_calculation_pkg.get_working_days_in_week (
3265: p_assignment_id => p_assignment_id
3266: ,p_business_group_id => p_business_group_id
3267: ,p_effective_date => p_effective_date
3268: ,p_default_wp => l_FT_working_wp --l_default_work_pattern

Line 3279: pqp_schedule_calculation_pkg.get_working_days_in_week (

3275: -- number of days at assignment level work pattern if
3276: -- there is any
3277:
3278: l_standard_work_days_in_week :=
3279: pqp_schedule_calculation_pkg.get_working_days_in_week (
3280: p_assignment_id => p_assignment_id
3281: ,p_business_group_id => p_business_group_id
3282: ,p_effective_date => p_effective_date
3283: ,p_override_wp => l_FT_working_wp --l_default_work_pattern

Line 3816: ,p_work_dates IN pqp_schedule_calculation_pkg.t_working_dates

3812: -- dates passed as input. Checks for each date is defined in UDT as a
3813: -- holiday and returns the count of holidays.
3814: FUNCTION pqp_gb_get_no_of_work_holidays(
3815: p_business_group_id IN NUMBER
3816: ,p_work_dates IN pqp_schedule_calculation_pkg.t_working_dates
3817: ,p_table_id IN NUMBER
3818: ,p_column_name IN VARCHAR2
3819: ,p_value IN VARCHAR2
3820: )

Line 3916: l_working_dates pqp_schedule_calculation_pkg.t_working_dates;

3912: l_work_holidays NUMBER;
3913: l_proc_step NUMBER(38,10):=0;
3914: l_proc_name VARCHAR2(61):=
3915: g_package_name||'pqp_gb_get_work_abs_days_udt';
3916: l_working_dates pqp_schedule_calculation_pkg.t_working_dates;
3917: BEGIN
3918: IF g_debug THEN
3919: debug_enter(l_proc_name);
3920: debug('p_assignment_id:'||p_assignment_id);

Line 3933: pqp_schedule_calculation_pkg.get_days_worked(

3929: END IF;
3930: -- Call Work Patterns function to get Collection of Working Dates
3931: debug(l_proc_name, 10);
3932: l_work_days :=
3933: pqp_schedule_calculation_pkg.get_days_worked(
3934: p_assignment_id => p_assignment_id
3935: ,p_business_group_id => p_business_group_id
3936: ,p_date_start => p_start_date
3937: ,p_date_end => p_end_date

Line 4013: pqp_schedule_calculation_pkg.get_days_worked(

4009: IF p_table_id IS NULL
4010: THEN
4011: debug(l_proc_name, 10);
4012: l_count :=
4013: pqp_schedule_calculation_pkg.get_days_worked(
4014: p_assignment_id => p_assignment_id
4015: ,p_business_group_id => p_business_group_id
4016: ,p_date_start => p_start_date
4017: ,p_date_end => p_end_date

Line 4226: -- p_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE

4222: --
4223: --
4224: --
4225: -- PROCEDURE get_day_dets(
4226: -- p_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE
4227: -- ,p_calc_stdt IN DATE
4228: -- ,p_calc_edt IN DATE
4229: -- ,p_day_no OUT NOCOPY NUMBER
4230: -- ,p_days_in_wp OUT NOCOPY NUMBER

Line 4362: ,p_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE

4358: -- END get_day_dets;
4359:
4360: PROCEDURE get_next_working_date_wp(
4361: p_business_group_id IN NUMBER
4362: ,p_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE
4363: ,p_curr_date IN OUT NOCOPY DATE
4364: ,p_balance_days IN OUT NOCOPY NUMBER
4365: ,p_table_id IN NUMBER
4366: ,p_column_name IN VARCHAR2

Line 4412: pqp_schedule_calculation_pkg.get_day_dets

4408:
4409: -- Set Calculation End Date for this Work Pattern
4410: l_calc_endt := p_wp_dets.effective_end_date;
4411: --Get day number on calculation start date and number of days in Work Pattern
4412: pqp_schedule_calculation_pkg.get_day_dets
4413: (p_wp_dets => p_wp_dets
4414: ,p_calc_stdt => l_calc_stdt
4415: ,p_calc_edt => l_calc_endt
4416: ,p_day_no => l_day_no -- OUT

Line 4564: r_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;

4560: l_err_msg_name fnd_new_messages.message_name%TYPE;
4561: l_proc_step NUMBER(38,10):=0;
4562: l_proc_name VARCHAR2(61):=
4563: g_package_name||'get_next_working_date';
4564: r_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;
4565: r_def_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;
4566: BEGIN /*get_next_working_date*/
4567: IF g_debug THEN
4568: debug_enter(l_proc_name);

Line 4565: r_def_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;

4561: l_proc_step NUMBER(38,10):=0;
4562: l_proc_name VARCHAR2(61):=
4563: g_package_name||'get_next_working_date';
4564: r_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;
4565: r_def_wp_dets pqp_schedule_calculation_pkg.c_wp_dets%ROWTYPE;
4566: BEGIN /*get_next_working_date*/
4567: IF g_debug THEN
4568: debug_enter(l_proc_name);
4569: debug('p_assignment_id:'||p_assignment_id);

Line 4587: FOR r_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets_up(p_assignment_id, p_date_start)

4583: -- have been added to start date
4584: l_balance_days := FLOOR(p_days) + 1;
4585: l_curr_date := p_date_start;
4586:
4587: FOR r_wp_dets IN pqp_schedule_calculation_pkg.c_wp_dets_up(p_assignment_id, p_date_start)
4588: LOOP /* Get Work Pattern Details */
4589: -- Only if this aat record contains a work pattern
4590: IF r_wp_dets.work_pattern IS NOT NULL
4591: THEN

Line 5820: pqp_schedule_calculation_pkg.get_working_days_in_week

5816: -- the standard work pattern call is required as we have
5817: -- to compare to know if the person is Full timer or part timer
5818:
5819: l_working_days_in_week :=
5820: pqp_schedule_calculation_pkg.get_working_days_in_week
5821: (
5822: p_assignment_id => p_assignment_id
5823: ,p_business_group_id => p_business_group_id
5824: ,p_effective_date => p_effective_date

Line 5840: pqp_schedule_calculation_pkg.get_working_days_in_week

5836: debug(l_proc_name, 57+i/10000);
5837: END IF;
5838:
5839: l_standard_work_days_in_week :=
5840: pqp_schedule_calculation_pkg.get_working_days_in_week
5841: (
5842: p_assignment_id => p_assignment_id
5843: ,p_business_group_id => p_business_group_id
5844: ,p_effective_date => p_effective_date