PACKAGE: APPS.HXT_RETRO_PA

Source

1 PACKAGE HXT_RETRO_PA AUTHID CURRENT_USER AS
2 /* $Header: hxtrpa.pkh 120.0 2005/05/29 05:55:39 appldev noship $ */
3   g_user_id	        fnd_user.user_id%TYPE    := fnd_global.User_Id;
4   g_sysdate	        DATE 		        := trunc(SYSDATE);
5   g_batch_err_id        hxt_errors.ppb_id%TYPE   DEFAULT NULL;
6   g_timecard_err_id     hxt_errors.tim_id%TYPE   DEFAULT NULL;
7   g_sum_hours_err_id    hxt_errors.hrw_id%TYPE   DEFAULT NULL;
8   g_time_period_err_id  hxt_errors.ptp_id%TYPE   DEFAULT NULL;
9   g_err_effective_start DATE			DEFAULT TRUNC(SYSDATE);
10   g_err_effective_end   DATE                    DEFAULT hr_general.end_of_time; --sir149 --FORMS60
11 
12   g_error_log_error    EXCEPTION;
13   g_hours_per_year     NUMBER                  := FND_PROFILE.Value( 'HXT_HOURS_PER_YEAR' );
14 
15 PROCEDURE retro_pa_process(	o_err_buf OUT NOCOPY VARCHAR2,
16 				o_ret_code OUT NOCOPY NUMBER,
17 				i_payroll_id IN NUMBER,
18               	       		i_time_period_id IN NUMBER);
19 
20 FUNCTION retro_non_ewr_transfer(i_timecard_id IN NUMBER,
21 			  	   i_ending_date IN DATE,
22 				   i_annual_pay_periods IN NUMBER,
23                                    i_employee_number IN VARCHAR2,
24 				   o_location OUT NOCOPY VARCHAR2,
25 				   o_error_text OUT NOCOPY VARCHAR2,
26 				   o_system_text OUT NOCOPY VARCHAR2)RETURN NUMBER;
27 
28 FUNCTION log_transfer_errors(	i_location IN VARCHAR2,
29 				i_error_text IN VARCHAR2,
30 			        i_system_text IN VARCHAR2)RETURN NUMBER;
31 
32 END HXT_RETRO_PA;