1 Package pay_pbf_ins as
2 /* $Header: pypbfrhi.pkh 120.0 2005/05/29 07:23:13 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< set_base_key_value >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of Comments}
7 -- Description:
8 -- This procedure is called to register the next ID value from the database
9 -- sequence.
10 --
11 -- Prerequisites:
12 --
13 -- In Parameters:
14 -- Primary Key
15 --
16 -- Post Success:
17 --
18 -- Post Failure:
19 --
20 -- Developer Implementation Notes:
21 -- None.
22 --
23 -- Access Status:
24 -- Internal Development Use Only.
25 --
26 -- {End of Comments}
27 -- ----------------------------------------------------------------------------
28 procedure set_base_key_value
29 (p_balance_feed_id in number);
30 --
31 -- ----------------------------------------------------------------------------
32 -- |------------------------------< insert_dml >------------------------------|
33 -- ----------------------------------------------------------------------------
34 -- {Start Of Comments}
35 --
36 -- Description:
37 -- This procedure calls the dt_insert_dml control logic which handles
38 -- the actual datetrack dml.
39 --
40 -- Prerequisites:
41 -- This is an internal private procedure which must be called from the ins
42 -- procedure and must have all mandatory attributes set (except the
43 -- object_version_number which is initialised within the dt_insert_dml
44 -- procedure).
45 --
46 -- In Parameters:
47 -- A Pl/Sql record structure.
48 --
49 -- Post Success:
50 -- Processing contines.
51 --
52 -- Post Failure:
53 -- No specific error handling is required within this procedure.
54 --
55 -- Developer Implementation Notes:
56 -- None.
57 --
58 -- Access Status:
59 -- Internal Row Handler Use Only.
60 --
61 -- {End Of Comments}
62 -- ----------------------------------------------------------------------------
63 Procedure insert_dml
64 (p_rec in out nocopy pay_pbf_shd.g_rec_type
65 ,p_effective_date in date
66 ,p_datetrack_mode in varchar2
67 ,p_validation_start_date in date
68 ,p_validation_end_date in date
69 );
70 --
71 -- ----------------------------------------------------------------------------
72 -- |---------------------------------< ins >----------------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start Of Comments}
75 --
76 -- Description:
77 -- This procedure is the record interface for the insert process
78 -- for the specified entity. The role of this process is to insert a fully
79 -- validated row, into the HR schema passing back to the calling process,
80 -- any system generated values (e.g. primary and object version number
81 -- attributes). This process is the main backbone of the ins business
82 -- process. The processing of this procedure is as follows:
83 -- 1) We must lock parent rows (if any exist).
84 -- 2) The controlling validation process insert_validate is then executed
85 -- which will execute all private and public validation business rule
86 -- processes.
87 -- 3) The pre_insert process is then executed which enables any
88 -- logic to be processed before the insert dml process is executed.
89 -- 4) The insert_dml process will physical perform the insert dml into the
90 -- specified entity.
91 -- 5) The post_insert process is then executed which enables any
92 -- logic to be processed after the insert dml process.
93 --
94 -- Prerequisites:
95 -- The main parameters to the process have to be in the record
96 -- format.
97 --
98 -- In Parameters:
99 -- p_effective_date
100 -- Specifies the date of the datetrack insert operation.
101 --
102 -- p_initial_feed
103 -- The parameter p_initial_feed is obsolete and hence the value
104 -- passed here will not be used.
105 -- This parameter is no longer used because from the input value id
106 -- provided it can be derived whether the feed is for
107 -- initial balance feed or not.
108 --
109 -- Post Success:
110 -- A fully validated row will be inserted into the specified entity
111 -- without being committed.
112 --
113 -- Post Failure:
114 -- If an error has occurred, an error message will be raised.
115 --
116 -- Developer Implementation Notes:
117 -- None.
118 --
119 -- Access Status:
120 -- Internal Development Use Only.
121 --
122 -- {End Of Comments}
123 -- ----------------------------------------------------------------------------
124 Procedure ins
125 (p_effective_date in date
126 ,p_initial_feed in boolean
127 ,p_rec in out nocopy pay_pbf_shd.g_rec_type
128 ,p_exist_run_result_warning out nocopy boolean
129 );
130 --
131 -- ----------------------------------------------------------------------------
132 -- |---------------------------------< ins >----------------------------------|
133 -- ----------------------------------------------------------------------------
134 -- {Start Of Comments}
135 --
136 -- Description:
137 -- This procedure is the attribute interface for the insert
138 -- process for the specified entity and is the outermost layer. The role
139 -- of this process is to insert a fully validated row into the HR schema
140 -- passing back to the calling process, any system generated values
141 -- (e.g. object version number attributes). The processing of this
142 -- procedure is as follows:
143 -- 1) The attributes are converted into a local record structure by
144 -- calling the convert_args function.
145 -- 2) After the conversion has taken place, the corresponding record ins
146 -- interface process is executed.
147 -- 3) OUT parameters are then set to their corresponding record attributes.
148 --
149 -- Prerequisites:
150 --
151 -- In Parameters:
152 -- p_effective_date
153 -- Specifies the date of the datetrack insert operation.
154 --
155 -- p_initial_feed
156 -- The parameter p_initial_feed is obsolete and hence the value
157 -- passed here will not be used.
158 -- This parameter is no longer used because from the input value id
159 -- provided it can be derived whether the feed is for
160 -- initial balance feed or not.
161 --
162 -- Post Success:
163 -- A fully validated row will be inserted for the specified entity
164 -- without being committed.
165 --
166 -- Post Failure:
167 -- If an error has occurred, an error message will be raised.
168 --
169 -- Developer Implementation Notes:
170 -- None.
171 --
172 -- Access Status:
173 -- Internal Development Use Only.
174 --
175 -- {End Of Comments}
176 -- ----------------------------------------------------------------------------
177 Procedure ins
178 (p_effective_date in date
179 ,p_balance_type_id in number
180 ,p_input_value_id in number
181 ,p_scale in number
182 ,p_business_group_id in number default null
183 ,p_legislation_code in varchar2 default null
184 ,p_legislation_subgroup in varchar2 default null
185 ,p_initial_feed in boolean
186 ,p_balance_feed_id out nocopy number
187 ,p_object_version_number out nocopy number
188 ,p_effective_start_date out nocopy date
189 ,p_effective_end_date out nocopy date
190 ,p_exist_run_result_warning out nocopy boolean
191 );
192 --
193 end pay_pbf_ins;