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);
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
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:
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;