PACKAGE: APPS.HXT_TRAN_PA

Source

1 PACKAGE HXT_TRAN_PA AUTHID CURRENT_USER AS
2 /* $Header: hxtpa.pkh 120.0 2005/05/29 05:54:38 appldev noship $ */
3 
4   g_user_id	       fnd_user.user_id%TYPE    := fnd_global.User_Id;
5   g_sysdate	       DATE 		        := trunc(SYSDATE);
6   g_batch_err_id       hxt_errors.ppb_id%TYPE   DEFAULT NULL;
7   g_timecard_err_id    hxt_errors.tim_id%TYPE   DEFAULT NULL;
8   g_sum_hours_err_id   hxt_errors.hrw_id%TYPE   DEFAULT NULL;
9   g_time_period_err_id hxt_errors.ptp_id%TYPE   DEFAULT NULL;
10   g_err_effective_start DATE		       DEFAULT TRUNC(SYSDATE);
11   g_err_effective_end   DATE                   DEFAULT hr_general.end_of_time;  --FORMS60
12   g_error_log_error    EXCEPTION;
13   g_hours_per_year     NUMBER                  := FND_PROFILE.Value( 'HXT_HOURS_PER_YEAR' );
14 
15 PROCEDURE transfer_timecards(	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 non_eff_wage_rate_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_TRAN_PA;