[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_pod_shd.g_api_dml := true; -- Set the api dml status
58: --
59: -- Insert the row into: per_position_definitions
136: );
137: --
138: per_pod_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_pod_shd.g_api_dml := false; -- Unset the api dml status
202: --
203: Cursor C_Sel1 is select per_position_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: --
219: p_rec.enabled_flag := 'Y';
220: p_rec.start_date_active := null;
221: p_rec.end_date_active := null;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 10);
224: End pre_insert;
225: --
226: -- ----------------------------------------------------------------------------
227: -- |-----------------------------< post_insert >------------------------------|
259: --
260: l_proc varchar2(72) := g_package||'post_insert';
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End post_insert;
267: --
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: hr_utility.set_location(' Leaving:'||l_proc, 10);
266: End post_insert;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |---------------------------------< ins >----------------------------------|
276: --
277: l_proc varchar2(72) := g_package||'ins';
278: --
279: Begin
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: -- Determine if the business process is to be validated.
283: --
284: If p_validate then
309: If p_validate then
310: Raise HR_Api.Validate_Enabled;
311: End If;
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: Exception
315: When HR_Api.Validate_Enabled Then
316: --
317: -- As the Validate_Enabled exception has been raised
367: l_rec per_pod_shd.g_rec_type;
368: l_proc varchar2(72) := g_package||'ins';
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: -- Call conversion function to turn arguments into the
374: -- p_rec structure.
375: --
423: -- are specified as an OUT's we must set these values.
424: --
425: p_position_definition_id := l_rec.position_definition_id;
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 10);
428: End ins;
429: --
430: -- ----------------------------------------------------------------------------
431: -- |-------------------------------< ins_or_sel >-----------------------------|
471: l_proc varchar2(72) := g_package||'ins_or_sel';
472: --
473: --
474: begin
475: hr_utility.set_location('Entering:'||l_proc, 5);
476: --
477: -- determine if a people group combination exists
478: --
479: per_pod_shd.segment_combination_check
521: -- null The segment combination is null
522: -- id A segment combination has been found
523: --
524: if (l_position_definition_id = -1) then
525: hr_utility.set_location(l_proc, 10);
526: --
527: -- a new combination needs to be inserted
528: --
529: per_pod_ins.ins
576: -- we return the primary key as null
577: --
578: p_position_definition_id := null;
579: end if;
580: hr_utility.set_location(' Leaving:'||l_proc, 10);
581: end ins_or_sel;
582: --
583: end per_pod_ins;