DBA Data[Home] [Help]

APPS.HXT_TRAN_PA dependencies on HXT_ERRORS

Line 6: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;

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

Line 7: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;

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

Line 8: g_sum_hours_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;

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;

Line 9: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;

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