1 Package hr_icx_ins AUTHID CURRENT_USER as
2 /* $Header: hricxrhi.pkh 120.0 2005/05/31 00:51:03 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |-------------------------------< ins_or_sel >-----------------------------|
5 -- ----------------------------------------------------------------------------
6 procedure ins_or_sel
7 (p_segment1 in varchar2 default null,
8 p_segment2 in varchar2 default null,
9 p_segment3 in varchar2 default null,
10 p_segment4 in varchar2 default null,
11 p_segment5 in varchar2 default null,
12 p_segment6 in varchar2 default null,
13 p_segment7 in varchar2 default null,
14 p_segment8 in varchar2 default null,
15 p_segment9 in varchar2 default null,
16 p_segment10 in varchar2 default null,
17 p_segment11 in varchar2 default null,
18 p_segment12 in varchar2 default null,
19 p_segment13 in varchar2 default null,
20 p_segment14 in varchar2 default null,
21 p_segment15 in varchar2 default null,
22 p_segment16 in varchar2 default null,
23 p_segment17 in varchar2 default null,
24 p_segment18 in varchar2 default null,
25 p_segment19 in varchar2 default null,
26 p_segment20 in varchar2 default null,
27 p_segment21 in varchar2 default null,
28 p_segment22 in varchar2 default null,
29 p_segment23 in varchar2 default null,
30 p_segment24 in varchar2 default null,
31 p_segment25 in varchar2 default null,
32 p_segment26 in varchar2 default null,
33 p_segment27 in varchar2 default null,
34 p_segment28 in varchar2 default null,
35 p_segment29 in varchar2 default null,
36 p_segment30 in varchar2 default null,
37 p_context_type in varchar2 default null,
38 p_item_context_id out nocopy number,
39 p_concatenated_segments out nocopy varchar2
40 );
41 --
42 -- ----------------------------------------------------------------------------
43 -- |---------------------------------< ins >----------------------------------|
44 -- ----------------------------------------------------------------------------
45 -- {Start Of Comments}
46 --
47 -- Description:
48 -- This procedure is the record interface for the insert process
49 -- for the specified entity. The role of this process is to insert a fully
50 -- validated row, into the HR schema passing back to the calling process,
51 -- any system generated values (e.g. primary and object version number
52 -- attributes). This process is the main backbone of the ins
53 -- process. The processing of this procedure is as follows:
54 -- 1) The controlling validation process insert_validate is executed
55 -- which will execute all private and public validation business rule
56 -- processes.
57 -- 2) The pre_insert business process is then executed which enables any
58 -- logic to be processed before the insert dml process is executed.
59 -- 3) The insert_dml process will physical perform the insert dml into the
60 -- specified entity.
61 -- 4) The post_insert business process is then executed which enables any
62 -- logic to be processed after the insert dml process.
63 --
64 -- Prerequisites:
65 -- The main parameters to the this process have to be in the record
66 -- format.
67 --
68 -- In Parameters:
69 --
70 -- Post Success:
71 -- A fully validated row will be inserted into the specified entity
72 -- without being committed.
73 --
74 -- Post Failure:
75 -- If an error has occurred, an error message will be raised.
76 --
77 -- Developer Implementation Notes:
78 -- None.
79 --
80 -- Access Status:
81 -- Internal Development Use Only.
82 --
83 -- {End Of Comments}
84 -- ----------------------------------------------------------------------------
85 Procedure ins
86 (p_effective_date in date
87 ,p_rec in out nocopy hr_icx_shd.g_rec_type
88 );
89 --
90 -- ----------------------------------------------------------------------------
91 -- |---------------------------------< ins >----------------------------------|
92 -- ----------------------------------------------------------------------------
93 -- {Start Of Comments}
94 --
95 -- Description:
96 -- This procedure is the attribute interface for the insert
97 -- process for the specified entity and is the outermost layer. The role
98 -- of this process is to insert a fully validated row into the HR schema
99 -- passing back to the calling process, any system generated values
100 -- (e.g. object version number attributes).The processing of this
101 -- procedure is as follows:
102 -- 1) The attributes are converted into a local record structure by
103 -- calling the convert_args function.
104 -- 2) After the conversion has taken place, the corresponding record ins
105 -- interface process is executed.
106 -- 3) OUT parameters are then set to their corresponding record attributes.
107 --
108 -- Prerequisites:
109 --
110 -- In Parameters:
111 --
112 -- Post Success:
113 -- A fully validated row will be inserted for the specified entity
114 -- without being committed.
115 --
116 -- Post Failure:
117 -- If an error has occurred, an error message will be raised.
118 --
119 -- Developer Implementation Notes:
120 -- None.
121 --
122 -- Access Status:
123 -- Internal Development Use Only.
124 --
125 -- {End Of Comments}
126 -- ----------------------------------------------------------------------------
127 Procedure ins
128 (p_effective_date in date
129 ,p_id_flex_num in number
130 ,p_summary_flag in varchar2
131 ,p_enabled_flag in varchar2
132 ,p_start_date_active in date default null
133 ,p_end_date_active in date default null
134 ,p_segment1 in varchar2 default null
135 ,p_segment2 in varchar2 default null
136 ,p_segment3 in varchar2 default null
137 ,p_segment4 in varchar2 default null
138 ,p_segment5 in varchar2 default null
139 ,p_segment6 in varchar2 default null
140 ,p_segment7 in varchar2 default null
141 ,p_segment8 in varchar2 default null
142 ,p_segment9 in varchar2 default null
143 ,p_segment10 in varchar2 default null
144 ,p_segment11 in varchar2 default null
145 ,p_segment12 in varchar2 default null
146 ,p_segment13 in varchar2 default null
147 ,p_segment14 in varchar2 default null
148 ,p_segment15 in varchar2 default null
149 ,p_segment16 in varchar2 default null
150 ,p_segment17 in varchar2 default null
151 ,p_segment18 in varchar2 default null
152 ,p_segment19 in varchar2 default null
153 ,p_segment20 in varchar2 default null
154 ,p_segment21 in varchar2 default null
155 ,p_segment22 in varchar2 default null
156 ,p_segment23 in varchar2 default null
157 ,p_segment24 in varchar2 default null
158 ,p_segment25 in varchar2 default null
159 ,p_segment26 in varchar2 default null
160 ,p_segment27 in varchar2 default null
161 ,p_segment28 in varchar2 default null
162 ,p_segment29 in varchar2 default null
163 ,p_segment30 in varchar2 default null
164 ,p_item_context_id out nocopy number
165 ,p_object_version_number out nocopy number
166 );
167 --
168 end hr_icx_ins;