APPS.IRC_VCE_INS dependencies on IRC_VCE_INS

Line 1: Package Body irc_vce_ins as

1: Package Body irc_vce_ins as
2: /* $Header: irvcerhi.pkb 120.1 2005/12/13 06:42:58 cnholmes noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' irc_vce_ins.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' irc_vce_ins.'; -- Global package name
9: --
10: -- The following global variables are only to be used by
11: -- the set_base_key_value and pre_insert procedures.
12: --

Line 159: If (irc_vce_ins.g_vacancy_id_i is not null or

155: --
156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: If (irc_vce_ins.g_vacancy_id_i is not null or
160: irc_vce_ins.g_variable_comp_lookup_i is not null) Then
161: --
162: -- Verify registered primary key values not already in use
163: --

Line 160: irc_vce_ins.g_variable_comp_lookup_i is not null) Then

156: Begin
157: hr_utility.set_location('Entering:'||l_proc, 5);
158: --
159: If (irc_vce_ins.g_vacancy_id_i is not null or
160: irc_vce_ins.g_variable_comp_lookup_i is not null) Then
161: --
162: -- Verify registered primary key values not already in use
163: --
164: --

Line 168: irc_vce_ins.g_vacancy_id_i;

164: --
165: -- Use registered key values and clear globals
166: --
167: p_rec.vacancy_id :=
168: irc_vce_ins.g_vacancy_id_i;
169: irc_vce_ins.g_vacancy_id_i := null;
170: p_rec.variable_comp_lookup :=
171: irc_vce_ins.g_variable_comp_lookup_i;
172: irc_vce_ins.g_variable_comp_lookup_i := null;

Line 169: irc_vce_ins.g_vacancy_id_i := null;

165: -- Use registered key values and clear globals
166: --
167: p_rec.vacancy_id :=
168: irc_vce_ins.g_vacancy_id_i;
169: irc_vce_ins.g_vacancy_id_i := null;
170: p_rec.variable_comp_lookup :=
171: irc_vce_ins.g_variable_comp_lookup_i;
172: irc_vce_ins.g_variable_comp_lookup_i := null;
173: End If;

Line 171: irc_vce_ins.g_variable_comp_lookup_i;

167: p_rec.vacancy_id :=
168: irc_vce_ins.g_vacancy_id_i;
169: irc_vce_ins.g_vacancy_id_i := null;
170: p_rec.variable_comp_lookup :=
171: irc_vce_ins.g_variable_comp_lookup_i;
172: irc_vce_ins.g_variable_comp_lookup_i := null;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 172: irc_vce_ins.g_variable_comp_lookup_i := null;

168: irc_vce_ins.g_vacancy_id_i;
169: irc_vce_ins.g_vacancy_id_i := null;
170: p_rec.variable_comp_lookup :=
171: irc_vce_ins.g_variable_comp_lookup_i;
172: irc_vce_ins.g_variable_comp_lookup_i := null;
173: End If;
174: --
175: hr_utility.set_location(' Leaving:'||l_proc, 10);
176: End pre_insert;

Line 269: irc_vce_ins.pre_insert(p_rec);

265: --
266: --
267: -- Call the supporting pre-insert operation
268: --
269: irc_vce_ins.pre_insert(p_rec);
270: --
271: -- Insert the row
272: --
273: irc_vce_ins.insert_dml(p_rec);

Line 273: irc_vce_ins.insert_dml(p_rec);

269: irc_vce_ins.pre_insert(p_rec);
270: --
271: -- Insert the row
272: --
273: irc_vce_ins.insert_dml(p_rec);
274: --
275: -- Call the supporting post-insert operation
276: --
277: irc_vce_ins.post_insert

Line 277: irc_vce_ins.post_insert

273: irc_vce_ins.insert_dml(p_rec);
274: --
275: -- Call the supporting post-insert operation
276: --
277: irc_vce_ins.post_insert
278: (p_effective_date
279: ,p_rec
280: );
281: --

Line 317: irc_vce_ins.ins

313: --
314: -- Having converted the arguments into the irc_vce_rec
315: -- plsql record structure we call the corresponding record business process.
316: --
317: irc_vce_ins.ins
318: (p_effective_date
319: ,l_rec
320: );
321: --

Line 330: end irc_vce_ins;

326: --
327: hr_utility.set_location(' Leaving:'||l_proc, 10);
328: End ins;
329: --
330: end irc_vce_ins;