[Home] [Help]
51: --
52: l_proc varchar2(72) := g_package||'insert_dml';
53: --
54: Begin
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: --
57: per_jbd_shd.g_api_dml := true; -- Set the api dml status
58: --
59: -- Insert the row into: per_job_definitions
136: );
137: --
138: per_jbd_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: per_jbd_shd.g_api_dml := false; -- Unset the api dml status
202: --
203: Cursor C_Sel1 is select per_job_definitions_s.nextval from sys.dual;
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: --
209: -- Select the next sequence number
210: --
211: Open C_Sel1;
212: Fetch C_Sel1 Into p_rec.job_definition_id;
213: Close C_Sel1;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 10);
216: End pre_insert;
217: --
218: -- ----------------------------------------------------------------------------
219: -- |-----------------------------< post_insert >------------------------------|
251: --
252: l_proc varchar2(72) := g_package||'post_insert';
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End post_insert;
259: --
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: hr_utility.set_location(' Leaving:'||l_proc, 10);
258: End post_insert;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |---------------------------------< ins >----------------------------------|
268: --
269: l_proc varchar2(72) := g_package||'ins';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: -- Determine if the business process is to be validated.
275: --
276: If p_validate then
302: If p_validate then
303: Raise HR_Api.Validate_Enabled;
304: End If;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: Exception
308: When HR_Api.Validate_Enabled Then
309: --
310: -- As the Validate_Enabled exception has been raised
357: l_rec per_jbd_shd.g_rec_type;
358: l_proc varchar2(72) := g_package||'ins';
359: --
360: Begin
361: hr_utility.set_location('Entering:'||l_proc, 5);
362: --
363: -- Call conversion function to turn arguments into the
364: -- p_rec structure.
365: --
410: -- are specified as an OUT's we must set these values.
411: --
412: p_job_definition_id := l_rec.job_definition_id;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 10);
415: End ins;
416: --
417: -- ----------------------------------------------------------------------------
418: -- |-------------------------------< ins_or_sel >-----------------------------|
458: l_proc varchar2(72) := g_package||'ins_or_sel';
459:
460: --
461: begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- determine if a job combination exists
465: --
466: per_jbd_shd.segment_combination_check
510: -- null The segment combination is null
511: -- id A segment combination has been found
512: --
513: if (l_job_definition_id = -1) then
514: hr_utility.set_location(l_proc, 10);
515: --
516: -- a new combination needs to be inserted
517: --
518: per_jbd_ins.ins
562: -- we return the primary key as null
563: --
564: p_job_definition_id := null;
565: end if;
566: hr_utility.set_location(' Leaving:'||l_proc, 15);
567: end ins_or_sel;
568: --
569: end per_jbd_ins;