DBA Data[Home] [Help]

PACKAGE: APPS.PER_EQT_INS

Source


1 Package per_eqt_ins AUTHID CURRENT_USER as
2 /* $Header: peeqtrhi.pkh 120.0 2005/05/31 08:13:14 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------------< ins >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --   This procedure is the record interface for the insert process
11 --   for the specified entity. The role of this process is to insert a fully
12 --   validated row, into the HR schema passing back to  the calling process,
13 --   any system generated values (e.g. primary and object version number
14 --   attributes). This process is the main backbone of the ins
15 --   process. The processing of this procedure is as follows:
16 --   1) If the p_validate parameter has been set to true then a savepoint is
17 --      issued.
18 --   2) The controlling validation process insert_validate is then executed
19 --      which will execute all private and public validation business rule
20 --      processes.
21 --   3) The pre_insert business process is then executed which enables any
22 --      logic to be processed before the insert dml process is executed.
23 --   4) The insert_dml process will physical perform the insert dml into the
24 --      specified entity.
25 --   5) The post_insert business process is then executed which enables any
26 --      logic to be processed after the insert dml process.
27 --   6) If the p_validate parameter has been set to true an exception is
28 --      raised which is handled and processed by performing a rollback to the
29 --      savepoint which was issued at the beginning of the Ins process.
30 --
31 -- Pre Conditions:
32 --   The main parameters to the this process have to be in the record
33 --   format.
34 --
35 -- In Parameters:
36 --   p_validate
37 --     Determines if the process is to be validated. Setting this
38 --     boolean value to true will invoke the process to be validated. The
39 --     default is false. The validation is controlled by a savepoint and
40 --     rollback mechanism. The savepoint is issued at the beginning of the
41 --     process and is rollbacked at the end of the process
42 --     when all the processing has been completed. The rollback is controlled
43 --     by raising and handling the exception hr_api.validate_enabled. We use
44 --     the exception because, by raising the exception with the business
45 --     process, we can exit successfully without having any of the 'OUT'
46 --     parameters being set.
47 --
48 -- Post Success:
49 --   A fully validated row will be inserted into the specified entity
50 --   without being committed. If the p_validate parameter has been set to true
51 --   then all the work will be rolled back.
52 --
53 -- Post Failure:
54 --   If an error has occurred, an error message will be supplied with the work
55 --   rolled back.
56 --
57 -- Developer Implementation Notes:
58 --   None.
59 --
60 -- Access Status:
61 --   Internal Development Use Only.
62 --
63 -- {End Of Comments}
64 -- ----------------------------------------------------------------------------
65 /* Procedure ins
66   (
67   p_rec            in out nocopy per_eqt_shd.g_rec_type,
68   p_effective_date in     date,
69   p_validate       in     boolean default false
70   );  */
71 --
72 -- ----------------------------------------------------------------------------
73 -- |---------------------------------< ins >----------------------------------|
74 -- ----------------------------------------------------------------------------
75 -- {Start Of Comments}
76 --
77 -- Description:
78 --   This procedure is the attribute interface for the insert
79 --   process for the specified entity and is the outermost layer. The role
80 --   of this process is to insert a fully validated row into the HR schema
81 --   passing back to the calling process, any system generated values
82 --   (e.g. object version number attributes).The processing of this
83 --   procedure is as follows:
84 --   1) The attributes are converted into a local record structure by
85 --      calling the convert_args function.
86 --   2) After the conversion has taken place, the corresponding record ins
87 --      interface process is executed.
88 --   3) OUT parameters are then set to their corresponding record attributes.
89 --
90 -- Pre Conditions:
91 --
92 -- In Parameters:
93 --   p_validate
94 --     Determines if the process is to be validated. Setting this
95 --     Boolean value to true will invoke the process to be validated.
96 --     The default is false.
97 --
98 -- Post Success:
99 --   A fully validated row will be inserted for the specified entity
100 --   without being committed (or rollbacked depending on the p_validate
101 --   status).
102 --
103 -- Post Failure:
104 --   If an error has occurred, an error message will be supplied with the work
105 --   rolled back.
106 --
107 -- Developer Implementation Notes:
108 --   None.
109 --
110 -- Access Status:
111 --   Internal Development Use Only.
112 --
113 -- {End Of Comments}
114 -- ----------------------------------------------------------------------------
115 
116 -- Added  Developer DF columns as arguments to ins procedure
117 
118 Procedure ins
119   (
120   p_qualification_type_id  out nocopy number,
121   p_name                   in varchar2,
122   p_category               in varchar2,
123   p_rank                   in number           default null,
124   p_attribute_category     in varchar2         default null,
125   p_attribute1             in varchar2         default null,
126   p_attribute2             in varchar2         default null,
127   p_attribute3             in varchar2         default null,
128   p_attribute4             in varchar2         default null,
129   p_attribute5             in varchar2         default null,
130   p_attribute6             in varchar2         default null,
131   p_attribute7             in varchar2         default null,
132   p_attribute8             in varchar2         default null,
133   p_attribute9             in varchar2         default null,
134   p_attribute10            in varchar2         default null,
135   p_attribute11            in varchar2         default null,
136   p_attribute12            in varchar2         default null,
137   p_attribute13            in varchar2         default null,
138   p_attribute14            in varchar2         default null,
139   p_attribute15            in varchar2         default null,
140   p_attribute16            in varchar2         default null,
141   p_attribute17            in varchar2         default null,
142   p_attribute18            in varchar2         default null,
143   p_attribute19            in varchar2         default null,
144   p_attribute20            in varchar2         default null,
145   p_object_version_number  out nocopy number,
146   p_effective_date         in  date,
147   p_information_category   in varchar2         default null,
148   p_information1           in varchar2         default null,
149   p_information2           in varchar2         default null,
150   p_information3           in varchar2         default null,
151   p_information4           in varchar2         default null,
152   p_information5           in varchar2         default null,
153   p_information6           in varchar2         default null,
154   p_information7           in varchar2         default null,
155   p_information8           in varchar2         default null,
156   p_information9           in varchar2         default null,
157   p_information10          in varchar2         default null,
158   p_information11          in varchar2         default null,
159   p_information12          in varchar2         default null,
160   p_information13          in varchar2         default null,
161   p_information14          in varchar2         default null,
162   p_information15          in varchar2         default null,
163   p_information16          in varchar2         default null,
164   p_information17          in varchar2         default null,
165   p_information18          in varchar2         default null,
166   p_information19          in varchar2         default null,
167   p_information20          in varchar2         default null,
168   p_information21          in varchar2         default null,
169   p_information22          in varchar2         default null,
170   p_information23          in varchar2         default null,
171   p_information24          in varchar2         default null,
172   p_information25          in varchar2         default null,
173   p_information26          in varchar2         default null,
174   p_information27          in varchar2         default null,
175   p_information28          in varchar2         default null,
176   p_information29          in varchar2         default null,
177   p_information30          in varchar2         default null,
178   p_validate               in boolean          default false
179 -- BUG3356369
180  ,p_qual_framework_id      in number          default null
181  ,p_qualification_type     in varchar2        default null
182  ,p_credit_type            in varchar2        default null
183  ,p_credits                in number          default null
184  ,p_level_type             in varchar2        default null
185  ,p_level_number           in number          default null
186  ,p_field                  in varchar2        default null
187  ,p_sub_field              in varchar2        default null
188  ,p_provider               in varchar2        default null
189  ,p_qa_organization        in varchar2        default null
190   );
191 --
192 end per_eqt_ins;