1 Package hr_who AUTHID CURRENT_USER as
2 /* $Header: hrwhopls.pkh 115.1 2002/12/05 17:06:06 apholt ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------------< who >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure determines if the AOL who columns on insert have been set
11 -- (e.g. checks to see if the arguments are null). If the arguments are
12 -- set then the argument values will be passed back with the original value.
13 -- If the arguments aren't set then they are set using AOL api calls.
14 --
15 -- Pre Conditions:
16 -- Should only be executed from a trigger when inserting.
17 --
18 -- In Arguments:
19 -- p_new_created_by - :new.created_by trigger value.
20 -- p_new_creation_date - :new.creation_date value.
21 --
22 -- Post Success:
23 -- If the arguments are set then the argument values will be passed back
24 -- with the original values.
25 -- If the arguments aren't set then they are set using AOL api calls.
26 --
27 -- Post Failure:
28 -- The procedure should NOT error.
29 --
30 -- Developer Implementation Notes:
31 -- None.
32 --
33 -- {End Of Comments}
34 -- ----------------------------------------------------------------------------
35 Procedure who(p_new_created_by in out nocopy number,
36 p_new_creation_date in out nocopy date);
37 -- ----------------------------------------------------------------------------
38 -- |---------------------------------< who >----------------------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 -- This procedure determines if the AOL who columns on update have been set
44 -- (e.g. checks to see if the arguments are null or if they are the same as
45 -- the old record on the server). If the arguments are set to new
46 -- values then the argument values will be passed back with the original
47 -- value.
48 -- If the arguments aren't set or are the same as the old record values then
49 -- they are set using AOL api calls.
50 --
51 -- Pre Conditions:
52 -- Should only be executed from a trigger when updating.
53 --
54 -- In Arguments:
55 -- p_new_last_update_date - :new.last_update_date trigger value
56 -- p_new_last_updated_by - :new.last_updated_by trigger value
57 -- p_new_last_update_login - :new.last_update_login trigger value
58 -- p_old_last_update_date - :old.last_update_date trigger value
59 -- p_old_last_updated_by - :old.last_updated_by trigger value
60 -- p_old_last_update_login - :old.last_update_login trigger value
61 --
62 -- Post Success:
63 -- If the arguments are set then the argument values will be passed back
64 -- with the original values.
65 -- If the arguments aren't set or are the same as the old record values then
66 -- they are set using AOL api calls.
67 --
68 -- Post Failure:
69 -- The procedure should NOT error.
70 --
71 -- Developer Implementation Notes:
72 -- None.
73 --
74 -- {End Of Comments}
75 -- ----------------------------------------------------------------------------
76 Procedure who(p_new_last_update_date in out nocopy date,
77 p_new_last_updated_by in out nocopy number,
78 p_new_last_update_login in out nocopy number,
79 p_old_last_update_date in date,
80 p_old_last_updated_by in number,
81 p_old_last_update_login in number);
82 end hr_who;