[Home] [Help]
PACKAGE: APPS.HXT_TIME_GEN
Source
1 PACKAGE HXT_Time_Gen AUTHID CURRENT_USER AS
2 /* $Header: hxttgen.pkh 115.13 2002/11/28 01:38:58 fassadi ship $ */
3
4 -- Declare globals
5 g_payroll_id per_time_periods.payroll_id%TYPE;
6 g_time_period_id per_time_periods.time_period_id%TYPE;
7 g_user_id fnd_user.user_id%TYPE := FND_GLOBAL.User_Id;
8 g_user_name fnd_user.user_name%TYPE := HXT_UTIL.Fnd_Username( g_user_id );
9 g_bus_group_id hr_organization_units.business_group_id%TYPE :=
10 FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
11 g_batch_size NUMBER := FND_PROFILE.Value( 'HXT_BATCH_SIZE' );
12 g_sysdate DATE := trunc(SYSDATE);
13 g_sysdatetime DATE := SYSDATE;
14 g_login_id fnd_user.last_update_login%TYPE := FND_GLOBAL.login_id;
15 g_err_loc hxt_errors.location%TYPE;
16 g_sub_loc hxt_errors.location%TYPE;
17 g_errors BOOLEAN := FALSE;
18 g_sqlerrm hxt_errors.ora_message%TYPE;
19 g_autogen_error hxt_errors.error_msg%TYPE;
20 g_date_worked_error EXCEPTION;
21 g_form_level_error EXCEPTION;
22 g_del_obs_tim_error EXCEPTION; --SIR216
23 g_osp_id hxt_work_shifts.off_shift_prem_id%TYPE;
24 g_sdf_id hxt_work_shifts.shift_diff_ovrrd_id%TYPE;
25
26
27
28 ------------------------------------------------------------------
29 PROCEDURE Generate_Time( errbuf OUT NOCOPY VARCHAR2
30 , retcode OUT NOCOPY NUMBER
31 , a_payroll_id IN NUMBER
32 , a_time_period_id IN NUMBER
33 , a_reference_number IN VARCHAR2);
34 ------------------------------------------------------------------
35
36 PROCEDURE Gen_Work_Plan( a_start DATE
37 , a_end DATE
38 , a_tws_id NUMBER );
39
40 ------------------------------------------------------------------
41
42 PROCEDURE Gen_Rot_Plan( a_start DATE
43 , a_end DATE
44 , a_rtp_id NUMBER );
45
46 ------------------------------------------------------------------
47
48 FUNCTION Create_Batch( a_tim_cntr NUMBER, a_reference_num VARCHAR2 ) RETURN NUMBER;
49
50 ------------------------------------------------------------------
51
52 FUNCTION Create_Timecard( a_batch_id NUMBER default null) RETURN NUMBER;
53
54 ------------------------------------------------------------------
55
56 PROCEDURE Create_HRW( a_assignment_id NUMBER
57 , a_date_worked DATE
58 , a_tim_id NUMBER
59 , a_time_in DATE
60 , a_time_out DATE
61 , a_start DATE
62 , a_hours NUMBER);
63 -- , a_group_id IN NUMBER);
64
65 ------------------------------------------------------------------
66
67 FUNCTION Get_HXT_Seqno RETURN NUMBER;
68
69 ------------------------------------------------------------------
70
71 -- PROCEDURE Get_Group_ID (a_group_id OUT NUMBER);
72
73 ------------------------------------------------------------------
74
75 FUNCTION Get_Next_Batch_Id RETURN NUMBER;
76
77 ------------------------------------------------------------------
78 --BEGIN SPR C389 BY BC
79 PROCEDURE Get_Work_Day( a_date IN DATE
80 , a_work_id IN NUMBER
81 , a_osp_id OUT NOCOPY NUMBER
82 , a_sdf_id OUT NOCOPY NUMBER
83 , a_standard_start OUT NOCOPY NUMBER
84 , a_standard_stop OUT NOCOPY NUMBER
85 , a_early_start OUT NOCOPY NUMBER
86 , a_late_stop OUT NOCOPY NUMBER
87 , a_hours OUT NOCOPY NUMBER);
88 ------------------------------------------------------------------
89 END hxt_time_gen;