1 PACKAGE hxc_timekeeper_wf_pkg AUTHID CURRENT_USER AS
2 /* $Header: hxctimekeeperwf.pkh 120.0 2005/05/29 06:27:05 appldev noship $ */
3
4 FUNCTION GET_ITEM_KEY RETURN NUMBER;
5
6 FUNCTION GET_NAME(
7 p_person_id in number,
8 p_effective_date in DATE)
9 RETURN VARCHAR2;
10
11 PROCEDURE start_child_process
12 (p_tc_item_type IN VARCHAR2
13 ,p_tc_item_key IN VARCHAR2
14 ,p_tc_process_name IN VARCHAR2
15 ,p_tc_bb_id IN NUMBER
16 ,p_tc_bb_ovn IN NUMBER
17 ,p_tc_start_time IN DATE
18 ,p_tc_stop_time IN DATE
19 ,p_tc_resource_id IN NUMBER
20 ,p_tc_timekeeper_id IN NUMBER
21 ,p_tc_tk_nofity_type IN VARCHAR2
22 ,p_tc_tk_nofity_to IN VARCHAR2
23 );
24
25 PROCEDURE start_tk_wf_process
26 (p_item_type IN varchar2
27 ,p_item_key IN varchar2
28 ,p_process_name IN varchar2
29 ,p_tc_bb_id IN number
30 ,p_tc_ovn IN number
31 ,p_tc_resource_id IN NUMBER
32 ,p_timekeeper_id IN NUMBER
33 ,p_tk_nofity_type IN VARCHAR2
34 ,p_tk_nofity_to IN VARCHAR2);
35
36 PROCEDURE START_TK_NOTIFICATION (
37 p_itemtype in varchar2,
38 p_itemkey in varchar2,
39 p_actid in number,
40 p_funcmode in varchar2,
41 p_result in out nocopy varchar2);
42
43 PROCEDURE FIND_NTF_TO(
44 p_itemtype in varchar2,
45 p_itemkey in varchar2,
46 p_actid in number,
47 p_funcmode in varchar2,
48 p_result in out nocopy varchar2) ;
49
50 PROCEDURE PERSON_NOTIFY(
51 p_itemtype in varchar2,
52 p_itemkey in varchar2,
53 p_actid in number,
54 p_funcmode in varchar2,
55 p_result in out nocopy varchar2) ;
56
57 PROCEDURE SUPERVISOR_NOTIFY(
58 p_itemtype in varchar2,
59 p_itemkey in varchar2,
60 p_actid in number,
61 p_funcmode in varchar2,
62 p_result in out nocopy varchar2) ;
63
64 PROCEDURE capture_approved_status(
65 p_itemtype in varchar2,
66 p_itemkey in varchar2,
67 p_actid in number,
68 p_funcmode in varchar2,
69 p_result in out nocopy varchar2);
70
71 PROCEDURE capture_rejected_status(
72 p_itemtype in varchar2,
73 p_itemkey in varchar2,
74 p_actid in number,
75 p_funcmode in varchar2,
76 p_result in out nocopy varchar2);
77
78 PROCEDURE update_tk_ntf_result(
79 p_itemtype in varchar2,
80 p_itemkey in varchar2,
81 p_actid in number,
82 p_funcmode in varchar2,
83 p_result in out nocopy varchar2);
84
85 PROCEDURE cancel_previous_notifications
86 ( p_tk_audit_item_type in varchar2
87 ,p_tk_audit_item_key in varchar2
88 );
89
90 procedure capture_timeout_status(
91 p_itemtype in varchar2,
92 p_itemkey in varchar2,
93 p_actid in number,
94 p_funcmode in varchar2,
95 p_result in out nocopy varchar2);
96
97 Function begin_audit_process
98 (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
99 ,p_timecard_ovn in hxc_time_building_blocks.object_version_number%type
100 ,p_resource_id in hxc_time_building_blocks.resource_id%type
101 ,p_timekeeper_id in hxc_time_building_blocks.resource_id%type
102 ,p_tk_audit_enabled in VARCHAR2
103 ,p_tk_notify_to in VARCHAR2
104 ,p_tk_notify_type in VARCHAR2
105 ,p_property_table hxc_timecard_prop_table_type
106 ) return VARCHAR2 ;
107
108 END hxc_timekeeper_wf_pkg;
109