[Home] [Help]
PACKAGE: APPS.HXT_TRAN_PA
Source
1 PACKAGE HXT_TRAN_PA 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;