DBA Data[Home] [Help]

APPS.HXC_TKG_INS dependencies on HXC_TKG_SHD

Line 53: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

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

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

62: hr_utility.set_location('Entering:'||l_proc, 5);
63: end if;
64: p_rec.object_version_number := 1; -- Initialise the object version
65: --
66: hxc_tkg_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Insert the row into: hxc_tk_groups
69: --
70: insert into hxc_tk_groups

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

91: ,sysdate
92: ,fnd_global.login_id
93: );
94: --
95: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
96: --
97: if g_debug then
98: hr_utility.set_location(' Leaving:'||l_proc, 10);
99: end if;

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

99: end if;
100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_tkg_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated

Line 104: hxc_tkg_shd.constraint_error

100: Exception
101: When hr_api.check_integrity_violated Then
102: -- A check constraint has been violated
103: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
104: hxc_tkg_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

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

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

Line 109: hxc_tkg_shd.constraint_error

105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When hr_api.parent_integrity_violated Then
107: -- Parent integrity has been violated
108: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
109: hxc_tkg_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

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

109: hxc_tkg_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tkg_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status

Line 114: hxc_tkg_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.unique_integrity_violated Then
112: -- Unique integrity has been violated
113: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tkg_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
118: Raise;

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

113: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
114: hxc_tkg_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When Others Then
117: hxc_tkg_shd.g_api_dml := false; -- Unset the api dml status
118: Raise;
119: End insert_dml;
120: --
121: -- ----------------------------------------------------------------------------

Line 157: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

153: -- Internal Row Handler Use Only.
154: --
155: -- ----------------------------------------------------------------------------
156: Procedure pre_insert
157: (p_rec in out nocopy hxc_tkg_shd.g_rec_type
158: ) is
159: --
160: l_proc varchar2(72) ;
161: --

Line 214: (p_rec in hxc_tkg_shd.g_rec_type

210: -- Internal Row Handler Use Only.
211: --
212: -- ----------------------------------------------------------------------------
213: Procedure post_insert
214: (p_rec in hxc_tkg_shd.g_rec_type
215: ) is
216: --
217: l_proc varchar2(72) ;
218: --

Line 259: (p_rec in out nocopy hxc_tkg_shd.g_rec_type

255: -- ----------------------------------------------------------------------------
256: -- |---------------------------------< ins >----------------------------------|
257: -- ----------------------------------------------------------------------------
258: Procedure ins
259: (p_rec in out nocopy hxc_tkg_shd.g_rec_type
260: ) is
261: --
262: l_proc varchar2(72) ;
263: --

Line 307: l_rec hxc_tkg_shd.g_rec_type;

303: ,p_object_version_number out nocopy number
304: ,p_business_group_id in number
305: ) is
306: --
307: l_rec hxc_tkg_shd.g_rec_type;
308: l_proc varchar2(72) ;
309: --
310: Begin
311: g_debug :=hr_utility.debug_enabled;

Line 321: hxc_tkg_shd.convert_args

317: -- Call conversion function to turn arguments into the
318: -- p_rec structure.
319: --
320: l_rec :=
321: hxc_tkg_shd.convert_args
322: (null
323: ,p_tk_group_name
324: ,p_tk_resource_id
325: ,null