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.HR_PAYROLLS dependencies on PER_TIME_PERIODS

Line 19: g_reset_period_start_date per_time_periods.start_date%type;

15: -- Warning variables used by the form
16: g_weeks_reset_warn BOOLEAN := FALSE;
17: g_end_date_changed_warn BOOLEAN := FALSE;
18: g_no_of_weeks_reset NUMBER := 0;
19: g_reset_period_start_date per_time_periods.start_date%type;
20: g_reset_period_end_date per_time_periods.end_date%type;
21: g_reset_period_name per_time_periods.period_name%type;
22: g_new_end_date per_time_periods.end_date%type;
23: g_constant_end_date BOOLEAN := FALSE;

Line 20: g_reset_period_end_date per_time_periods.end_date%type;

16: g_weeks_reset_warn BOOLEAN := FALSE;
17: g_end_date_changed_warn BOOLEAN := FALSE;
18: g_no_of_weeks_reset NUMBER := 0;
19: g_reset_period_start_date per_time_periods.start_date%type;
20: g_reset_period_end_date per_time_periods.end_date%type;
21: g_reset_period_name per_time_periods.period_name%type;
22: g_new_end_date per_time_periods.end_date%type;
23: g_constant_end_date BOOLEAN := FALSE;
24: --

Line 21: g_reset_period_name per_time_periods.period_name%type;

17: g_end_date_changed_warn BOOLEAN := FALSE;
18: g_no_of_weeks_reset NUMBER := 0;
19: g_reset_period_start_date per_time_periods.start_date%type;
20: g_reset_period_end_date per_time_periods.end_date%type;
21: g_reset_period_name per_time_periods.period_name%type;
22: g_new_end_date per_time_periods.end_date%type;
23: g_constant_end_date BOOLEAN := FALSE;
24: --
25: -- This procedure does not currently use PER_TIME_PERIOD_RULES, since that

Line 22: g_new_end_date per_time_periods.end_date%type;

18: g_no_of_weeks_reset NUMBER := 0;
19: g_reset_period_start_date per_time_periods.start_date%type;
20: g_reset_period_end_date per_time_periods.end_date%type;
21: g_reset_period_name per_time_periods.period_name%type;
22: g_new_end_date per_time_periods.end_date%type;
23: g_constant_end_date BOOLEAN := FALSE;
24: --
25: -- This procedure does not currently use PER_TIME_PERIOD_RULES, since that
26: -- table is subject to some change.

Line 446: from per_time_periods ptp

442: count(time_period_id)
443: into earliest_start_date,
444: latest_end_date,
445: no_periods
446: from per_time_periods ptp
447: where ptp.payroll_id = p_pay_det.payroll_id;
448: --
449: if no_periods = 0 then
450: --

Line 496: ,p_period_number in per_time_periods.period_num%type

492: --
493: end derive_payroll_dates;
494: --
495: PROCEDURE chk_reset ( p_payroll_details in payroll_rec_type
496: ,p_period_number in per_time_periods.period_num%type
497: ,p_no_of_periods in per_time_period_types.number_per_fiscal_year%type
498: ,p_period_start_date in per_time_periods.start_date%type
499: ,p_next_leg_start_date in date
500: ,p_period_end_date in out nocopy per_time_periods.end_date%type

Line 498: ,p_period_start_date in per_time_periods.start_date%type

494: --
495: PROCEDURE chk_reset ( p_payroll_details in payroll_rec_type
496: ,p_period_number in per_time_periods.period_num%type
497: ,p_no_of_periods in per_time_period_types.number_per_fiscal_year%type
498: ,p_period_start_date in per_time_periods.start_date%type
499: ,p_next_leg_start_date in date
500: ,p_period_end_date in out nocopy per_time_periods.end_date%type
501: ,p_no_of_weeks_reset in out nocopy number ) IS
502: --

Line 500: ,p_period_end_date in out nocopy per_time_periods.end_date%type

496: ,p_period_number in per_time_periods.period_num%type
497: ,p_no_of_periods in per_time_period_types.number_per_fiscal_year%type
498: ,p_period_start_date in per_time_periods.start_date%type
499: ,p_next_leg_start_date in date
500: ,p_period_end_date in out nocopy per_time_periods.end_date%type
501: ,p_no_of_weeks_reset in out nocopy number ) IS
502: --
503: proc_name CONSTANT varchar2(50) := 'hr_payrolls.chk_reset';
504: --

Line 633: ,p_reset_period_name IN OUT nocopy per_time_periods.period_name%type

629: --
630: PROCEDURE get_warnings ( p_weeks_reset_warn IN OUT nocopy boolean
631: ,p_end_date_changed_warn IN OUT nocopy boolean
632: ,p_no_of_weeks_reset IN OUT nocopy number
633: ,p_reset_period_name IN OUT nocopy per_time_periods.period_name%type
634: ,p_new_end_date IN OUT nocopy per_time_periods.end_date%type ) IS
635: --
636: proc_name CONSTANT varchar2(50) := 'hr_payrolls.get_warnings';
637: --

Line 634: ,p_new_end_date IN OUT nocopy per_time_periods.end_date%type ) IS

630: PROCEDURE get_warnings ( p_weeks_reset_warn IN OUT nocopy boolean
631: ,p_end_date_changed_warn IN OUT nocopy boolean
632: ,p_no_of_weeks_reset IN OUT nocopy number
633: ,p_reset_period_name IN OUT nocopy per_time_periods.period_name%type
634: ,p_new_end_date IN OUT nocopy per_time_periods.end_date%type ) IS
635: --
636: proc_name CONSTANT varchar2(50) := 'hr_payrolls.get_warnings';
637: --
638: BEGIN

Line 693: l_period_name per_time_periods.period_name%type ;

689: period_start_date date;
690: period_end_date date;
691: current_regular_pay_date date;
692: l_period_number number;
693: l_period_name per_time_periods.period_name%type ;
694: l_display_period_type per_time_period_types.display_period_type%type ;
695: l_first_period_end_date date;
696: l_period_generate_count number := 1;
697: l_tax_year number(4);

Line 1024: insert into per_time_periods

1020: --
1021: hr_utility.set_location('l_period_name '||l_period_name,10);
1022: -- Insert the processing time period.
1023: hr_utility.set_location(proc_name, 7);
1024: insert into per_time_periods
1025: (time_period_id,
1026: payroll_id,
1027: start_date,
1028: end_date,

Line 1046: per_time_periods_s.nextval,

1042: created_by,
1043: creation_date,
1044: payslip_view_date)
1045: select
1046: per_time_periods_s.nextval,
1047: p_pay_det.payroll_id,
1048: period_start_date,
1049: period_end_date,
1050: current_regular_pay_date,

Line 1155: from per_time_periods

1151: statem varchar2(512);
1152: --
1153: cursor get_period_last_end_date(c_payroll_id in number) is
1154: select max(end_date)
1155: from per_time_periods
1156: where payroll_id = c_payroll_id;
1157: --
1158: begin
1159: --

Line 1438: FROM per_time_periods

1434: --
1435: cursor get_name (c_payroll_id IN NUMBER,
1436: c_date_earned IN DATE) is
1437: SELECT period_name
1438: FROM per_time_periods
1439: WHERE payroll_id = c_payroll_id
1440: AND c_date_earned between start_date and end_date;
1441: --
1442: BEGIN