DBA Data[Home] [Help]

APPS.HXC_TKG_UPD dependencies on HXC_TKG_SHD

Line 54: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

50: -- Internal Row Handler Use Only.
51: --
52: -- ----------------------------------------------------------------------------
53: Procedure update_dml
54: (p_rec in out nocopy hxc_tkg_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) ;
58: --

Line 69: hxc_tkg_shd.g_api_dml := true; -- Set the api dml status

65: --
66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
68: --
69: hxc_tkg_shd.g_api_dml := true; -- Set the api dml status
70: --
71: -- Update the hxc_tk_groups Row
72: --
73: update hxc_tk_groups

Line 86: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

82: ,last_update_login = fnd_global.login_id
83:
84: where tk_group_id = p_rec.tk_group_id;
85: --
86: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
87: --
88: if g_debug then
89: hr_utility.set_location(' Leaving:'||l_proc, 10);
90: end if;

Line 95: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
96: hxc_tkg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated

Line 96: hxc_tkg_shd.constraint_error

92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
96: hxc_tkg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

Line 100: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

96: hxc_tkg_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_tkg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated

Line 101: hxc_tkg_shd.constraint_error

97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_tkg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

Line 105: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

101: hxc_tkg_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_tkg_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

Line 106: hxc_tkg_shd.constraint_error

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_tkg_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;

Line 109: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

105: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_tkg_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;
111: End update_dml;
112: --
113: -- ----------------------------------------------------------------------------

Line 144: (p_rec in hxc_tkg_shd.g_rec_type

140: -- Internal Row Handler Use Only.
141: --
142: -- ----------------------------------------------------------------------------
143: Procedure pre_update
144: (p_rec in hxc_tkg_shd.g_rec_type
145: ) is
146: --
147: l_proc varchar2(72) ;
148: --

Line 189: (p_rec in hxc_tkg_shd.g_rec_type

185: -- Internal Row Handler Use Only.
186: --
187: -- ----------------------------------------------------------------------------
188: Procedure post_update
189: (p_rec in hxc_tkg_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) ;
193: --

Line 214: => hxc_tkg_shd.g_old_rec.tk_group_name

210: => p_rec.object_version_number
211: ,p_business_group_id
212: => p_rec.business_group_id
213: ,p_tk_group_name_o
214: => hxc_tkg_shd.g_old_rec.tk_group_name
215: ,p_tk_resource_id_o
216: => hxc_tkg_shd.g_old_rec.tk_resource_id
217: ,p_object_version_number_o
218: => hxc_tkg_shd.g_old_rec.object_version_number

Line 216: => hxc_tkg_shd.g_old_rec.tk_resource_id

212: => p_rec.business_group_id
213: ,p_tk_group_name_o
214: => hxc_tkg_shd.g_old_rec.tk_group_name
215: ,p_tk_resource_id_o
216: => hxc_tkg_shd.g_old_rec.tk_resource_id
217: ,p_object_version_number_o
218: => hxc_tkg_shd.g_old_rec.object_version_number
219: );
220: --

Line 218: => hxc_tkg_shd.g_old_rec.object_version_number

214: => hxc_tkg_shd.g_old_rec.tk_group_name
215: ,p_tk_resource_id_o
216: => hxc_tkg_shd.g_old_rec.tk_resource_id
217: ,p_object_version_number_o
218: => hxc_tkg_shd.g_old_rec.object_version_number
219: );
220: --
221: exception
222: --

Line 278: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

274: -- Internal Row Handler Use Only.
275: --
276: -- ----------------------------------------------------------------------------
277: Procedure convert_defs
278: (p_rec in out nocopy hxc_tkg_shd.g_rec_type
279: ) is
280: --
281: Begin
282: --

Line 290: hxc_tkg_shd.g_old_rec.tk_group_name;

286: -- is being used then we must set to the 'current' argument value.
287: --
288: If (p_rec.tk_group_name = hr_api.g_varchar2) then
289: p_rec.tk_group_name :=
290: hxc_tkg_shd.g_old_rec.tk_group_name;
291: End If;
292: --
293: End convert_defs;
294: --

Line 299: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

295: -- ----------------------------------------------------------------------------
296: -- |---------------------------------< upd >----------------------------------|
297: -- ----------------------------------------------------------------------------
298: Procedure upd
299: (p_rec in out nocopy hxc_tkg_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72) ;
303: --

Line 313: hxc_tkg_shd.lck

309: end if;
310: --
311: -- We must lock the row which we need to update.
312: --
313: hxc_tkg_shd.lck
314: (p_rec.tk_group_id
315: ,p_rec.object_version_number
316: );
317: --

Line 355: l_rec hxc_tkg_shd.g_rec_type;

351: ,p_tk_resource_id in number
352: ,p_business_group_id in number
353: ) is
354: --
355: l_rec hxc_tkg_shd.g_rec_type;
356: l_proc varchar2(72) ;
357: --
358: Begin
359: g_debug :=hr_utility.debug_enabled;

Line 369: hxc_tkg_shd.convert_args

365: -- Call conversion function to turn arguments into the
366: -- l_rec structure.
367: --
368: l_rec :=
369: hxc_tkg_shd.convert_args
370: (p_tk_group_id
371: ,p_tk_group_name
372: ,p_tk_resource_id
373: ,p_object_version_number