[Home] [Help]
15: l_proc varchar2(72) := g_package||'convert_defs';
16: --
17: Begin
18: --
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: -- We must now examine each argument value in the
22: -- p_rec plsql record structure
23: -- to see if a system default is being used. If a system default
123: p_rec.segment20 :=
124: hr_cgd_shd.g_old_rec.segment20;
125: End If;
126: --
127: hr_utility.set_location(' Leaving:'||l_proc, 10);
128: --
129: End convert_defs;
130: --
131: -- ----------------------------------------------------------------------------
164: l_concatenated_segments varchar2(2000);
165: l_segs_changed boolean;
166: --
167: begin
168: hr_utility.set_location('Entering:'||l_proc, 5);
169: --
170: -- Derive if any segments are changing
171: If ((l_rec.segment1 = hr_api.g_varchar2) AND
172: (l_rec.segment2 = hr_api.g_varchar2) AND
242: --
243: if hr_cgd_shd.api_updating
244: (p_cagr_grade_def_id => l_rec.cagr_grade_def_id) then
245: --
246: hr_utility.set_location(l_proc, 10);
247: --
248: -- the current row exists and we have populated the g_old_rec
249: -- we must now build up the new record by converting the
250: -- arguments into a record structure and converting any of the
322: l_rec.id_flex_num := null;
323: end if;
324: end if;
325: --
326: hr_utility.set_location(l_proc, 15);
327: --
328: -- call the ins_or_sel process
329: --
330: hr_cgd_ins.ins_or_sel
357: -- set the out arguments
358: --
359: p_cagr_grade_def_id := l_rec.cagr_grade_def_id;
360: p_concatenated_segments := l_concatenated_segments;
361: hr_utility.set_location(' Leaving:'||l_proc, 20);
362: END IF;
363: --
364: end upd_or_sel;
365: end hr_cgd_upd;