[Home] [Help]
PACKAGE: APPS.HXC_EXT_TIMECARD
Source
1 Package hxc_ext_timecard as
2 /* $Header: hxcxtime.pkh 120.0 2005/05/29 05:02 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Public Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' hxc_ext_timecard.'; -- Global package name
9
10 -- Summary Level Timecard Data Elements
11
12 OTL_TC_START_DATE DATE;
13 OTL_TC_END_DATE DATE;
14 OTL_TC_STATUS VARCHAR2(30);
15 OTL_TC_COMMENTS VARCHAR2(2000);
16 OTL_TC_DELTED VARCHAR2(1);
17
18 -- Detail Level Timecard Data Elements
19
20 OTL_DAY DATE;
21 OTL_DAY_COMMENTS VARCHAR2(2000);
22 OTL_MEASURE NUMBER;
23 OTL_DAY_START DATE;
24 OTL_DAY_STOP DATE;
25 OTL_PA_SYS_LINK_FUNCN VARCHAR2(3);
26 OTL_PA_BILLABLE_FLAG VARCHAR2(1);
27 OTL_PA_TASK VARCHAR2(25);
28 OTL_PA_PROJECT VARCHAR2(25);
29 OTL_PA_EXPENDITURE_TYPE VARCHAR2(30);
30 OTL_PA_EXPENDITURE_COMMENT VARCHAR2(150);
31 OTL_PAY_ELEMENT_NAME VARCHAR2(80);
32 OTL_PAY_COST_CENTRE VARCHAR2(80);
33 OTL_PO_NUMBER VARCHAR2(20);
34 OTL_PO_LINE_ID NUMBER(15);
35 OTL_PO_PRICE_TYPE VARCHAR2(30);
36 OTL_ALIAS_ELEMENTS_EXP_SLF VARCHAR2(80);
37 OTL_ALIAS_EXPENDITURE_ELEMENTS VARCHAR2(80);
38 OTL_ALIAS_EXPENDITURE_TYPES VARCHAR2(80);
39 OTL_ALIAS_LOCATIONS VARCHAR2(80);
40 OTL_ALIAS_PAYROLL_ELEMENTS VARCHAR2(80);
41 OTL_ALIAS_PROJECTS VARCHAR2(80);
42 OTL_ALIAS_TASKS VARCHAR2(80);
43 OTL_ALIAS_RATE_TYPE_EXP_SLF VARCHAR2(80);
44
45 -- Global parameter record for PO
46
47 TYPE param_rec IS RECORD (
48 start_date DATE
49 , end_date DATE
50 , status VARCHAR2(30)
51 , vendor_id NUMBER(15)
52 , retrieval_process VARCHAR2(80)
53 , buyer_supplier VARCHAR2(30)
54 , p_business_group_id NUMBER(15)
55 , p_person_id NUMBER(15) );
56
57 g_params param_rec;
58
59 PROCEDURE po_otl_extract (
60 errbuf out NOCOPY varchar2,
61 retcode out NOCOPY number,
62 p_ext_dfn_id in number,
63 p_effective_date in varchar2,
64 p_business_group_id in number,
65 p_start_date in varchar2,
66 p_end_date in varchar2,
67 p_timecard_status in varchar2,
68 p_vendor_id in varchar2 default null,
69 p_person_id in varchar2 default null,
70 p_retrieval_process in varchar2,
71 p_buyer_supplier in varchar2 default 'BUYER' );
72
73 PROCEDURE process_summary (
74 p_person_id in number,
75 p_ext_rslt_id in number,
76 p_ext_file_id in number,
77 p_ext_crit_prfl_id in number,
78 p_data_typ_cd in varchar2,
79 p_ext_typ_cd in varchar2,
80 p_effective_date in date );
81
82 PROCEDURE process_detail (
83 p_tbb_id in number,
84 p_tbb_ovn in number,
85 p_person_id in number,
86 p_ext_rslt_id in number,
87 p_ext_file_id in number,
88 p_ext_crit_prfl_id in number,
89 p_data_typ_cd in varchar2,
90 p_ext_typ_cd in varchar2,
91 p_effective_date in date );
92
93 end hxc_ext_timecard;