48: --
49: l_proc varchar2(72) := g_package||'insert_dml';
50: --
51: Begin
52: hr_utility.set_location('Entering:'||l_proc, 5);
53: p_rec.object_version_number := 1; -- Initialise the object version
54: --
55: --
56: -- Insert the row into: pqh_worksheet_bdgt_elmnts
70: p_rec.object_version_number
71: );
72: --
73: --
74: hr_utility.set_location(' Leaving:'||l_proc, 10);
75: Exception
76: When hr_api.check_integrity_violated Then
77: -- A check constraint has been violated
78: pqh_wel_shd.constraint_error
132: --
133: Cursor C_Sel1 is select pqh_worksheet_bdgt_elmnts_s.nextval from sys.dual;
134: --
135: Begin
136: hr_utility.set_location('Entering:'||l_proc, 5);
137: --
138: --
139: -- Select the next sequence number
140: --
141: Open C_Sel1;
142: Fetch C_Sel1 Into p_rec.worksheet_bdgt_elmnt_id;
143: Close C_Sel1;
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End pre_insert;
147: --
148: -- ----------------------------------------------------------------------------
149: -- |-----------------------------< post_insert >------------------------------|
181: --
182: l_proc varchar2(72) := g_package||'post_insert';
183: --
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: -- Start of API User Hook for post_insert.
189: --
210: --
211: -- End of API User Hook for post_insert.
212: --
213: --
214: hr_utility.set_location(' Leaving:'||l_proc, 10);
215: End post_insert;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |---------------------------------< ins >----------------------------------|
224: --
225: l_proc varchar2(72) := g_package||'ins';
226: --
227: Begin
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: -- Call the supporting insert validate operations
231: --
232: pqh_wel_bus.insert_validate(p_rec);
259: l_rec pqh_wel_shd.g_rec_type;
260: l_proc varchar2(72) := g_package||'ins';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: -- Call conversion function to turn arguments into the
266: -- p_rec structure.
267: --
285: --
286: p_worksheet_bdgt_elmnt_id := l_rec.worksheet_bdgt_elmnt_id;
287: p_object_version_number := l_rec.object_version_number;
288: --
289: hr_utility.set_location(' Leaving:'||l_proc, 10);
290: End ins;
291: --
292: end pqh_wel_ins;