[Home] [Help]
PACKAGE: APPS.HXT_TIME_GEN
Source
1 PACKAGE HXT_Time_Gen AUTHID CURRENT_USER AS
2 /* $Header: hxttgen.pkh 120.0.12010000.2 2009/02/25 15:50:21 asrajago 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 -- Bug 7359347
28 -- New global variable for session date
29
30 g_gen_session_date DATE;
31
32
33
34 ------------------------------------------------------------------
35 PROCEDURE Generate_Time( errbuf OUT NOCOPY VARCHAR2
36 , retcode OUT NOCOPY NUMBER
37 , a_payroll_id IN NUMBER
38 , a_time_period_id IN NUMBER
39 , a_reference_number IN VARCHAR2);
40 ------------------------------------------------------------------
41
42 PROCEDURE Gen_Work_Plan( a_start DATE
43 , a_end DATE
44 , a_tws_id NUMBER );
45
46 ------------------------------------------------------------------
47
48 PROCEDURE Gen_Rot_Plan( a_start DATE
49 , a_end DATE
50 , a_rtp_id NUMBER );
51
52 ------------------------------------------------------------------
53
54 FUNCTION Create_Batch( a_tim_cntr NUMBER, a_reference_num VARCHAR2 ) RETURN NUMBER;
55
56 ------------------------------------------------------------------
57
58 FUNCTION Create_Timecard( a_batch_id NUMBER default null) RETURN NUMBER;
59
60 ------------------------------------------------------------------
61
62 PROCEDURE Create_HRW( a_assignment_id NUMBER
63 , a_date_worked DATE
64 , a_tim_id NUMBER
65 , a_time_in DATE
66 , a_time_out DATE
67 , a_start DATE
68 , a_hours NUMBER);
69 -- , a_group_id IN NUMBER);
70
71 ------------------------------------------------------------------
72
73 FUNCTION Get_HXT_Seqno RETURN NUMBER;
74
75 ------------------------------------------------------------------
76
77 -- PROCEDURE Get_Group_ID (a_group_id OUT NUMBER);
78
79 ------------------------------------------------------------------
80
81 FUNCTION Get_Next_Batch_Id RETURN NUMBER;
82
83 ------------------------------------------------------------------
84 --BEGIN SPR C389 BY BC
85 PROCEDURE Get_Work_Day( a_date IN DATE
86 , a_work_id IN NUMBER
87 , a_osp_id OUT NOCOPY NUMBER
88 , a_sdf_id OUT NOCOPY NUMBER
89 , a_standard_start OUT NOCOPY NUMBER
90 , a_standard_stop OUT NOCOPY NUMBER
91 , a_early_start OUT NOCOPY NUMBER
92 , a_late_stop OUT NOCOPY NUMBER
93 , a_hours OUT NOCOPY NUMBER);
94 ------------------------------------------------------------------
95 END hxt_time_gen;