1 Package hxc_tkg_upd as
2 /* $Header: hxctkgrhi.pkh 120.0.12010000.1 2008/07/28 11:24:10 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------------< upd >---------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 -- Description:
9 -- This procedure is the record interface for the update
10 -- process for the specified entity. The role of this process is
11 -- to update a fully validated row for the HR schema passing back
12 -- to the calling process, any system generated values (e.g.
13 -- object version number attribute). This process is the main
14 -- backbone of the upd business process. The processing of this
15 -- procedure is as follows:
16 -- 1) The row to be updated is locked and selected into the record
17 -- structure g_old_rec.
18 -- 2) Because on update parameters which are not part of the update do not
19 -- have to be defaulted, we need to build up the updated row by
20 -- converting any system defaulted parameters to their corresponding
21 -- value.
22 -- 3) The controlling validation process update_validate is then executed
23 -- which will execute all private and public validation business rule
24 -- processes.
25 -- 4) The pre_update process is then executed which enables any
26 -- logic to be processed before the update dml process is executed.
27 -- 5) The update_dml process will physical perform the update dml into the
28 -- specified entity.
29 -- 6) The post_update process is then executed which enables any
30 -- logic to be processed after the update dml process.
31 --
32 -- Prerequisites:
33 -- The main parameters to the business process have to be in the record
34 -- format.
35 --
36 -- In Parameters:
37 --
38 -- Post Success:
39 -- The specified row will be fully validated and updated for the specified
40 -- entity without being committed.
41 --
42 -- Post Failure:
43 -- If an error has occurred, an error message will be raised.
44 --
45 -- Developer Implementation Notes:
46 -- None.
47 --
48 -- Access Status:
49 -- Internal Development Use Only.
50 --
51 -- ----------------------------------------------------------------------------
52 Procedure upd
53 (p_rec in out nocopy hxc_tkg_shd.g_rec_type
54 );
55 --
56 -- ----------------------------------------------------------------------------
57 -- |---------------------------------< upd >----------------------------------|
58 -- ----------------------------------------------------------------------------
59 --
60 -- Description:
61 -- This procedure is the attribute interface for the update
62 -- process for the specified entity and is the outermost layer. The role
63 -- of this process is to update a fully validated row into the HR schema
64 -- passing back to the calling process, any system generated values
65 -- (e.g. object version number attributes). The processing of this
66 -- procedure is as follows:
67 -- 1) The attributes are converted into a local record structure by
68 -- calling the convert_args function.
69 -- 2) After the conversion has taken place, the corresponding record upd
70 -- interface process is executed.
71 -- 3) OUT parameters are then set to their corresponding record attributes.
72 --
73 -- Prerequisites:
74 --
75 -- In Parameters:
76 --
77 -- Post Success:
78 -- A fully validated row will be updated for the specified entity
79 -- without being committed.
80 --
81 -- Post Failure:
82 -- If an error has occurred, an error message will be raised.
83 --
84 -- Developer Implementation Notes:
85 -- None.
86 --
87 -- Access Status:
88 -- Internal Development Use Only.
89 --
90 -- ----------------------------------------------------------------------------
91 Procedure upd
92 (p_tk_group_id in number
93 ,p_object_version_number in out nocopy number
94 ,p_tk_group_name in varchar2
95 ,p_tk_resource_id in number
96 ,p_business_group_id in number
97 );
98 --
99 end hxc_tkg_upd;