1 PACKAGE HXC_RPT_LOAD_TC_SNAPSHOT AS
2 /* $Header: hxcrpttcsnpsht.pkh 120.3.12010000.2 2008/10/30 16:57:27 asrajago ship $ */
3
4 TYPE ALIAS_REC IS RECORD
5 (
6 layout_id NUMBER,
7 alias_column NUMBER,
8 alias_name VARCHAR2(50),
9 alias_definition_id NUMBER
10 );
11
12 TYPE NUMTABLE IS TABLE OF NUMBER;
13 TYPE VARCHARTABLE IS TABLE OF VARCHAR2(2000);
14 TYPE DATETABLE IS TABLE OF DATE;
15 TYPE ALIASTAB IS TABLE OF ALIAS_REC;
16 TYPE FLOATTABLE IS TABLE OF NUMBER(22,14);
17
18 g_request_sysdate DATE;
19
20
21 PROCEDURE load_tc_snapshot ( errbuf OUT NOCOPY VARCHAR2 ,
22 retcode OUT NOCOPY NUMBER ,
23 p_date_from IN VARCHAR2 ,
24 p_date_to IN VARCHAR2 ,
25 p_data_regen IN VARCHAR2 ,
26 p_record_save IN VARCHAR2 ,
27 p_org_id IN NUMBER DEFAULT NULL,
28 p_locn_id IN NUMBER DEFAULT NULL,
29 p_payroll_id IN NUMBER DEFAULT NULL,
30 p_supervisor_id IN NUMBER DEFAULT NULL,
31 p_person_id IN NUMBER DEFAULT NULL
32 );
33
34 PROCEDURE resource_where_clause ( p_date_from IN DATE
35 , p_date_to IN DATE
36 , p_org_id IN NUMBER DEFAULT NULL
37 , p_locn_id IN NUMBER DEFAULT NULL
38 , p_payroll_id IN NUMBER DEFAULT NULL
39 , p_supervisor_id IN NUMBER DEFAULT NULL
40 , p_person_id IN NUMBER DEFAULT NULL
41 );
42
43 PROCEDURE load_tc_level_info ( p_resource_list IN VARCHAR2
44 , p_tc_from IN DATE
45 , p_tc_to IN DATE
46 , p_request_id IN VARCHAR2 DEFAULT NULL
47 );
48
49
50 PROCEDURE load_detail_info ( p_request_sysdate IN DATE
51 );
52
53 PROCEDURE update_layout_ids ;
54
55 PROCEDURE populate_attributes( p_layout_id IN NUMBER DEFAULT NULL,
56 p_alias_tab OUT NOCOPY ALIASTAB
57 );
58
59 PROCEDURE translate_attributes( p_layout_id IN NUMBER DEFAULT NULL
60 );
61
62 PROCEDURE translate_aliases( p_layout_id IN NUMBER DEFAULT NULL,
63 p_alias_tab IN ALIASTAB DEFAULT NULL
64 );
65
66 PROCEDURE fetch_history_from_date;
67
68 PROCEDURE update_transaction_ids(p_record_save IN VARCHAR2);
69
70 PROCEDURE log_time_capture( p_request_id IN VARCHAR2,
71 p_request_sysdate IN DATE
72 );
73
74 PROCEDURE update_last_touched_date;
75
76 PROCEDURE update_timecard_comments;
77
78 PROCEDURE translate_cla_reasons;
79
80 PROCEDURE clear_history_data;
81
82 PROCEDURE translate_created_by;
83
84 PROCEDURE translate_last_updated_by;
85
86 PROCEDURE insert_queries ( p_vo_name IN VARCHAR2,
87 p_query IN VARCHAR2);
88
89
90 END HXC_RPT_LOAD_TC_SNAPSHOT;
91