[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: pqp_vre_ins.g_vehicle_repository_id_i := p_vehicle_repository_id;
27: --
28: hr_utility.set_location(' Leaving:'||l_proc, 20);
24: hr_utility.set_location('Entering:'||l_proc, 10);
25: --
26: pqp_vre_ins.g_vehicle_repository_id_i := p_vehicle_repository_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 pqp_vehicle_repository_f.last_updated_by%TYPE;
102: l_last_update_login pqp_vehicle_repository_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;
332: ,l_last_update_login
333: );
334: --
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 15);
337: --
338: EXCEPTION
339: WHEN hr_api.check_integrity_violated THEN
340: -- A check constraint has been violated
364: --
365: l_proc varchar2(72) := g_package||'insert_dml';
366: --
367: BEGIN
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: pqp_vre_ins.dt_insert_dml
371: (p_rec => p_rec
372: ,p_effective_date => p_effective_date
374: ,p_validation_start_date => p_validation_start_date
375: ,p_validation_end_date => p_validation_end_date
376: );
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: END insert_dml;
380: --
381: -- ----------------------------------------------------------------------------
382: -- |------------------------------< pre_insert >------------------------------|
436: l_proc VARCHAR2(72) := g_package||'pre_insert';
437: l_exists VARCHAR2(1);
438: --
439: BEGIN
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: IF (pqp_vre_ins.g_vehicle_repository_id_i is not null) THEN
443: --
444: -- Verify registered primary key values not already in use
473: CLOSE C_Sel1;
474: End If;
475: --
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: END pre_insert;
479: --
480: -- ----------------------------------------------------------------------------
481: -- |----------------------------< post_insert >-------------------------------|
519: --
520: l_proc VARCHAR2(72) := g_package||'post_insert';
521: --
522: BEGIN
523: hr_utility.set_location('Entering:'||l_proc, 5);
524: BEGIN
525: --
526: pqp_vre_rki.after_insert
527: (p_effective_date => p_effective_date
620: ,p_hook_type => 'AI');
621: --
622: END;
623: --
624: hr_utility.set_location(' Leaving:'||l_proc, 10);
625: END post_insert;
626: --
627: -- ----------------------------------------------------------------------------
628: -- |-------------------------------< ins_lck >--------------------------------|
672: l_validation_start_date DATE;
673: l_validation_end_date DATE;
674: --
675: Begin
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: -- Validate the datetrack mode mode getting the validation start
679: -- and end dates for the specified datetrack operation.
680: --
693: --
694: p_validation_start_date := l_validation_start_date;
695: p_validation_end_date := l_validation_end_date;
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: --
699: END ins_lck;
700: --
701: -- ----------------------------------------------------------------------------
711: l_validation_start_date date;
712: l_validation_end_date date;
713: --
714: BEGIN
715: hr_utility.set_location('Entering:'||l_proc, 5);
716: --
717: -- Call the lock operation
718: --
719: pqp_vre_ins.ins_lck
769: --
770: -- Call to raise any errors on multi-message list
771: hr_multi_message.end_validation_set;
772: --
773: hr_utility.set_location('Leaving:'||l_proc,10);
774: END ins;
775: --
776: -- ----------------------------------------------------------------------------
777: -- |---------------------------------< ins >----------------------------------|
865: l_rec pqp_vre_shd.g_rec_type;
866: l_proc VARCHAR2(72) := g_package||'ins';
867: --
868: BEGIN
869: hr_utility.set_location('Entering:'||l_proc, 5);
870: --
871: -- Call conversion function to turn arguments into the
872: -- p_rec structure.
873: --
973: p_effective_end_date := l_rec.effective_end_date;
974: p_object_version_number := l_rec.object_version_number;
975: --
976: --
977: hr_utility.set_location(' Leaving:'||l_proc, 10);
978: END ins;
979: --
980: END pqp_vre_ins;