1 PACKAGE pay_batch_object_status_pkg AS
2 /* $Header: pybos.pkh 120.1 2006/09/26 14:48:26 thabara noship $ */
3
4 --
5 -- ----------------------------------------------------------------------------
6 -- get_status
7 --
8 -- Returns the status of the specified object.
9 -- ----------------------------------------------------------------------------
10 function get_status
11 (p_object_type in varchar2
12 ,p_object_id in number
13 ) return varchar2;
14 --
15 -- ----------------------------------------------------------------------------
16 -- get_status_meaning
17 --
18 -- Returns the status meaning of the specified object.
19 -- ----------------------------------------------------------------------------
20 function get_status_meaning
21 (p_object_type in varchar2
22 ,p_object_id in number
23 ,p_default_status in varchar2 default null
24 ) return varchar2;
25 --
26 -- ----------------------------------------------------------------------------
27 -- lock_batch_object
28 --
29 -- Locks the object status record.
30 -- If p_object_status is specified, see if the status is up to date.
31 -- If the batch object does not exist, the default status will be used instead.
32 -- ----------------------------------------------------------------------------
33 procedure lock_batch_object
34 (p_object_type in varchar2
35 ,p_object_id in number
36 ,p_object_status in varchar2 default null
37 ,p_default_status in varchar2 default null
38 );
39 --
40 -- ----------------------------------------------------------------------------
41 -- chk_complete_status
42 --
43 -- Locks the object record and see if the status is complete.
44 -- ----------------------------------------------------------------------------
45 procedure chk_complete_status
46 (p_object_type in varchar2
47 ,p_object_id in number
48 );
49 --
50 -- ----------------------------------------------------------------------------
51 -- set_status
52 --
53 -- Sets the object status.
54 -- ----------------------------------------------------------------------------
55 procedure set_status
56 (p_object_type in varchar2
57 ,p_object_id in number
58 ,p_object_status in varchar2
59 ,p_payroll_action_id in number default null
60 );
61 --
62 -- ----------------------------------------------------------------------------
63 -- delete_object_status
64 --
65 -- Deletes the object status record.
66 -- ----------------------------------------------------------------------------
67 procedure delete_object_status
68 (p_object_type in varchar2
69 ,p_object_id in number
70 ,p_payroll_action_id in number default null
71 );
72 -------------------------------------------------------------------------------
73
74 end pay_batch_object_status_pkg;
[Home] [Help]