[Home] [Help]
20: --
21: l_proc varchar2(72) := g_package||'set_base_key_value';
22: --
23: Begin
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_pur_ins.g_user_row_id_i := p_user_row_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pay_pur_ins.g_user_row_id_i := p_user_row_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
29: End set_base_key_value;
30: --
31: --
32: -- ----------------------------------------------------------------------------
101: l_last_updated_by pay_user_rows_f.last_updated_by%TYPE;
102: l_last_update_login pay_user_rows_f.last_update_login%TYPE;
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc, 5);
106: --
107: -- Get the object version number for the insert
108: --
109: p_rec.object_version_number :=
122: -- If the datetrack_mode is not INSERT then we must populate the WHO
123: -- columns with the 'old' creation values and 'new' updated values.
124: --
125: If (p_datetrack_mode <> hr_api.g_insert) then
126: hr_utility.set_location(l_proc, 10);
127: --
128: -- Select the 'old' created values
129: --
130: Open C_Sel1;
188: ,l_last_update_login
189: );
190: --
191: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
192: hr_utility.set_location(' Leaving:'||l_proc, 15);
193: --
194: Exception
195: When hr_api.check_integrity_violated Then
196: -- A check constraint has been violated
268: --
269: l_proc varchar2(72) := g_package||'insert_dml';
270: --
271: Begin
272: hr_utility.set_location('Entering:'||l_proc, 5);
273: --
274: pay_pur_ins.dt_insert_dml
275: (p_rec => p_rec
276: ,p_effective_date => p_effective_date
278: ,p_validation_start_date => p_validation_start_date
279: ,p_validation_end_date => p_validation_end_date
280: );
281: --
282: hr_utility.set_location(' Leaving:'||l_proc, 10);
283: End insert_dml;
284: --
285: -- ----------------------------------------------------------------------------
286: -- |------------------------------< pre_insert >------------------------------|
340: l_proc varchar2(72) := g_package||'pre_insert';
341: l_exists varchar2(1);
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: If (pay_pur_ins.g_user_row_id_i is not null) Then
347: --
348: -- Verify registered primary key values not already in use
377: Close C_Sel1;
378: End If;
379: --
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: End pre_insert;
383: --
384: -- ----------------------------------------------------------------------------
385: -- |----------------------------< post_insert >-------------------------------|
425: --
426: l_proc varchar2(72) := g_package||'post_insert';
427: --
428: Begin
429: hr_utility.set_location('Entering:'||l_proc, 5);
430: begin
431: --
432: -- insert ownerships if applicable
433: create_app_ownerships
477: ,p_hook_type => 'AI');
478: --
479: end;
480: --
481: hr_utility.set_location(' Leaving:'||l_proc, 10);
482: End post_insert;
483: --
484: -- ----------------------------------------------------------------------------
485: -- |-------------------------------< ins_lck >--------------------------------|
529: l_validation_start_date date;
530: l_validation_end_date date;
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Validate the datetrack mode mode getting the validation start
536: -- and end dates for the specified datetrack operation.
537: --
550: --
551: p_validation_start_date := l_validation_start_date;
552: p_validation_end_date := l_validation_end_date;
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 10);
555: --
556: End ins_lck;
557: --
558: -- ----------------------------------------------------------------------------
570: l_validation_start_date date;
571: l_validation_end_date date;
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call the lock operation
577: --
578: pay_pur_ins.ins_lck
632: --
633: -- Call to raise any errors on multi-message list
634: hr_multi_message.end_validation_set;
635: --
636: hr_utility.set_location('Leaving:'||l_proc,10);
637: end ins;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------------< ins >----------------------------------|
658: l_rec pay_pur_shd.g_rec_type;
659: l_proc varchar2(72) := g_package||'ins';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call conversion function to turn arguments into the
665: -- p_rec structure.
666: --
696: p_effective_end_date := l_rec.effective_end_date;
697: p_object_version_number := l_rec.object_version_number;
698: --
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: End ins;
702: --
703: end pay_pur_ins;