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