1 PACKAGE HXT_TIME_PAY AUTHID CURRENT_USER AS
2 /* $Header: hxttpay.pkh 120.1.12010000.2 2009/02/26 07:51:21 asrajago ship $ */
3
4
5
6
7
8 -- Bug 7359347
9 -- Global variable for session date
10 g_pay_session_date DATE;
11
12
13 FUNCTION pay (
14 g_ep_id IN NUMBER,
15 g_ep_type IN VARCHAR2,
16 g_egt_id IN NUMBER,
17 g_sdf_id IN NUMBER,
18 g_hdp_id IN NUMBER,
19 g_hol_id IN NUMBER,
20 g_pep_id IN NUMBER,
21 g_pip_id IN NUMBER,
22 g_sdovr_id IN NUMBER,
23 g_osp_id IN NUMBER,
24 g_hol_yn IN VARCHAR2,
25 g_person_id IN NUMBER,
26 g_location IN VARCHAR2,
27 g_ID IN NUMBER,
28 g_TIM_ID IN NUMBER,
29 g_DATE_WORKED IN DATE,
30 g_ASSIGNMENT_ID IN NUMBER,
31 g_HOURS IN NUMBER,
32 g_TIME_IN IN DATE,
33 g_TIME_OUT IN DATE,
34 g_ELEMENT_TYPE_ID IN NUMBER,
35 g_FCL_EARN_REASON_CODE IN VARCHAR2,
36 g_FFV_COST_CENTER_ID IN NUMBER,
37 g_FFV_LABOR_ACCOUNT_ID IN NUMBER,
38 g_TAS_ID IN NUMBER,
39 g_LOCATION_ID IN NUMBER,
40 g_SHT_ID IN NUMBER,
41 g_HRW_COMMENT IN VARCHAR2,
42 g_FFV_RATE_CODE_ID IN NUMBER,
43 g_RATE_MULTIPLE IN NUMBER,
44 g_HOURLY_RATE IN NUMBER,
45 g_AMOUNT IN NUMBER,
46 g_FCL_TAX_RULE_CODE IN VARCHAR2,
47 g_SEPARATE_CHECK_FLAG IN VARCHAR2,
48 g_SEQNO IN NUMBER,
49 g_CREATED_BY IN NUMBER,
50 g_CREATION_DATE IN DATE,
51 g_LAST_UPDATED_BY IN NUMBER,
52 g_LAST_UPDATE_DATE IN DATE,
53 g_LAST_UPDATE_LOGIN IN NUMBER,
54 g_EFFECTIVE_START_DATE IN DATE,
55 g_EFFECTIVE_END_DATE IN DATE,
56 g_PROJECT_ID IN NUMBER,
57 g_PAY_STATUS IN VARCHAR2,
58 g_PA_STATUS IN VARCHAR2,
59 g_RETRO_BATCH_ID IN NUMBER,
60 g_STATE_NAME IN VARCHAR2 DEFAULT NULL,
61 g_COUNTY_NAME IN VARCHAR2 DEFAULT NULL,
62 g_CITY_NAME IN VARCHAR2 DEFAULT NULL,
63 g_ZIP_CODE IN VARCHAR2 DEFAULT NULL
64 -- g_GROUP_ID IN NUMBER
65 )
66 RETURN NUMBER;
67
68 PROCEDURE get_retro_fields( p_tim_id IN NUMBER
69 ,p_batch_name IN VARCHAR2 DEFAULT NULL
70 ,p_batch_ref IN VARCHAR2 DEFAULT NULL
71 ,p_pay_status OUT NOCOPY VARCHAR2
72 ,p_pa_status OUT NOCOPY VARCHAR2
73 ,p_retro_batch_id OUT NOCOPY NUMBER
74 ,p_error_status OUT NOCOPY NUMBER
75 ,p_sqlerrm OUT NOCOPY VARCHAR2);
76 END;