54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: p_rec.object_version_number := 1; -- Initialise the object version
60: --
61: -- Insert the row into: per_sec_profile_assignments
62: --
84: p_rec.end_date,
85: p_rec.object_version_number
86: );
87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: Exception
90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: per_asp_shd.constraint_error
146: --
147: Cursor C_Sel1 is select per_sec_profile_assignments_s.nextval from sys.dual;
148: --
149: Begin
150: hr_utility.set_location('Entering:'||l_proc, 5);
151: --
152: --
153: -- Select the next sequence number
154: --
155: Open C_Sel1;
156: Fetch C_Sel1 Into p_rec.sec_profile_assignment_id;
157: Close C_Sel1;
158: --
159: hr_utility.set_location(' Leaving:'||l_proc, 10);
160: End pre_insert;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------------< post_insert >------------------------------|
195: --
196: l_proc varchar2(72) := g_package||'post_insert';
197: --
198: Begin
199: hr_utility.set_location('Entering:'||l_proc, 5);
200: --
201:
202: --
203: -- Synchronize the dates in fnd_user_resp_groups for the assignment we
243: -- End of API User Hook for post_insert.
244: --
245: */
246: --
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End post_insert;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |---------------------------------< ins >----------------------------------|
257: --
258: l_proc varchar2(72) := g_package||'ins';
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: -- Call the supporting insert validate operations
264: --
265: per_asp_bus.insert_validate(p_rec);
297: l_rec per_asp_shd.g_rec_type;
298: l_proc varchar2(72) := g_package||'ins';
299: --
300: Begin
301: hr_utility.set_location('Entering:'||l_proc, 5);
302: --
303: -- Call conversion function to turn arguments into the
304: -- p_rec structure.
305: --
328: --
329: p_sec_profile_assignment_id := l_rec.sec_profile_assignment_id;
330: p_object_version_number := l_rec.object_version_number;
331: --
332: hr_utility.set_location(' Leaving:'||l_proc, 10);
333: End ins;
334: --
335: end per_asp_ins;