1 Package hxc_timekeeper_errors AS
2 /* $Header: hxctkerror.pkh 120.1 2005/06/28 23:45:00 dragarwa noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hxc_timekeeper_errors.';
7 --
8
9 TYPE t_error_info IS RECORD
10 (
11 ERROR_ID NUMBER,
12 TRANSACTION_DETAIL_ID NUMBER,
13 TIME_BUILDING_BLOCK_ID NUMBER,
14 TIME_BUILDING_BLOCK_OVN NUMBER,
15 TIME_ATTRIBUTE_ID NUMBER,
16 TIME_ATTRIBUTE_OVN NUMBER,
17 MESSAGE_NAME VARCHAR2(30),
18 MESSAGE_FIELD VARCHAR2(80),
19 MESSAGE_TOKENS VARCHAR2(4000),
20 APPLICATION_SHORT_NAME VARCHAR2(50),
21 SCOPE_LEVEL VARCHAR2(80),
22 MESSAGE_LEVEL VARCHAR2(30),
23 MESSAGE_TEXT VARCHAR2(4000),
24 PERSON_FULL_NAME VARCHAR2(240),
25 START_PERIOD DATE,
26 END_PERIOD DATE,
27 MEASURE NUMBER
28 );
29
30 TYPE t_error_table IS TABLE OF t_error_info
31 INDEX BY BINARY_INTEGER;
32
33
34 -- public procedure
35 -- show_timecard_errors
36 --
37 -- description
38 -- used in the timekeeper form errors window to display
39 -- the errors associated with a timecard in error
40 -- Also translates the message_name into an actual message
41
42 procedure show_timecard_errors (
43 p_error_table IN OUT NOCOPY t_error_table
44 , p_timecard_id IN NUMBER
45 , p_timecard_ovn IN NUMBER
46 , p_full_name IN VARCHAR2
47 );
48
49 PROCEDURE maintain_errors
50 (p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
51 ,p_timecard_id IN OUT NOCOPY NUMBER
52 ,p_timecard_ovn IN OUT NOCOPY NUMBER);
53
54 PROCEDURE rollback_tc_or_set_err_status
55 (p_message_table in out nocopy HXC_MESSAGE_TABLE_TYPE
56 ,p_blocks in out nocopy hxc_block_table_type
57 ,p_attributes in out nocopy hxc_attribute_table_type
58 ,p_rollback in out nocopy BOOLEAN
59 ,p_status_error out NOCOPY BOOLEAN);
60
61
62 end hxc_timekeeper_errors;
[Home] [Help]