eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TKGQ_DEL dependencies on HXC_TKGQ_SHD

Line 46: (p_rec in hxc_tkgq_shd.g_rec_type

42: -- Internal Row Handler Use Only.
43: --
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml
46: (p_rec in hxc_tkgq_shd.g_rec_type
47: ) is
48: --
49: l_proc varchar2(72) ;
50: --

Line 58: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status

54: l_proc := g_package||'delete_dml';
55: hr_utility.set_location('Entering:'||l_proc, 5);
56: end if;
57: --
58: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status
59:
60: -- first of all delete any child rows
61:
62: delete from hxc_tk_group_query_criteria tkgqc

Line 74: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

70: delete from hxc_tk_group_queries tkgq
71: where tkgq.tk_group_query_id = p_rec.tk_group_query_id;
72:
73: --
74: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
75: --
76: if g_debug then
77: hr_utility.set_location(' Leaving:'||l_proc, 10);
78: end if;

Line 83: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

79: --
80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tkgq_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

Line 84: hxc_tkgq_shd.constraint_error

80: Exception
81: When hr_api.child_integrity_violated then
82: -- Child integrity has been violated
83: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tkgq_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;

Line 87: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status

83: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
84: hxc_tkgq_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
88: Raise;
89: End delete_dml;
90: --
91: -- ----------------------------------------------------------------------------

Line 121: Procedure pre_delete(p_rec in hxc_tkgq_shd.g_rec_type) is

117: -- Access Status:
118: -- Internal Row Handler Use Only.
119: --
120: -- ----------------------------------------------------------------------------
121: Procedure pre_delete(p_rec in hxc_tkgq_shd.g_rec_type) is
122: --
123: l_proc varchar2(72) ;
124: --
125: Begin

Line 164: Procedure post_delete(p_rec in hxc_tkgq_shd.g_rec_type) is

160: -- Access Status:
161: -- Internal Row Handler Use Only.
162: --
163: -- -----------------------------------------------------------------------------
164: Procedure post_delete(p_rec in hxc_tkgq_shd.g_rec_type) is
165: --
166: l_proc varchar2(72) ;
167: --
168: Begin

Line 180: => hxc_tkgq_shd.g_old_rec.group_query_name

176: hxc_tkgq_rkd.after_delete
177: (p_tk_group_query_id
178: => p_rec.tk_group_query_id
179: ,p_group_query_name_o
180: => hxc_tkgq_shd.g_old_rec.group_query_name
181: ,p_tk_group_id_o
182: => hxc_tkgq_shd.g_old_rec.tk_group_id
183: ,p_include_exclude_o
184: => hxc_tkgq_shd.g_old_rec.include_exclude

Line 182: => hxc_tkgq_shd.g_old_rec.tk_group_id

178: => p_rec.tk_group_query_id
179: ,p_group_query_name_o
180: => hxc_tkgq_shd.g_old_rec.group_query_name
181: ,p_tk_group_id_o
182: => hxc_tkgq_shd.g_old_rec.tk_group_id
183: ,p_include_exclude_o
184: => hxc_tkgq_shd.g_old_rec.include_exclude
185: ,p_system_user_o
186: => hxc_tkgq_shd.g_old_rec.system_user

Line 184: => hxc_tkgq_shd.g_old_rec.include_exclude

180: => hxc_tkgq_shd.g_old_rec.group_query_name
181: ,p_tk_group_id_o
182: => hxc_tkgq_shd.g_old_rec.tk_group_id
183: ,p_include_exclude_o
184: => hxc_tkgq_shd.g_old_rec.include_exclude
185: ,p_system_user_o
186: => hxc_tkgq_shd.g_old_rec.system_user
187: ,p_object_version_number_o
188: => hxc_tkgq_shd.g_old_rec.object_version_number

Line 186: => hxc_tkgq_shd.g_old_rec.system_user

182: => hxc_tkgq_shd.g_old_rec.tk_group_id
183: ,p_include_exclude_o
184: => hxc_tkgq_shd.g_old_rec.include_exclude
185: ,p_system_user_o
186: => hxc_tkgq_shd.g_old_rec.system_user
187: ,p_object_version_number_o
188: => hxc_tkgq_shd.g_old_rec.object_version_number
189: );
190: --

Line 188: => hxc_tkgq_shd.g_old_rec.object_version_number

184: => hxc_tkgq_shd.g_old_rec.include_exclude
185: ,p_system_user_o
186: => hxc_tkgq_shd.g_old_rec.system_user
187: ,p_object_version_number_o
188: => hxc_tkgq_shd.g_old_rec.object_version_number
189: );
190: --
191: exception
192: --

Line 245: (p_rec in hxc_tkgq_shd.g_rec_type

241: -- Internal Development Use Only.
242: --
243: -- ----------------------------------------------------------------------------
244: Procedure del
245: (p_rec in hxc_tkgq_shd.g_rec_type
246: ) is
247: --
248: l_proc varchar2(72) ;
249: --

Line 259: hxc_tkgq_shd.lck

255: end if;
256: --
257: -- We must lock the row which we need to delete.
258: --
259: hxc_tkgq_shd.lck
260: (p_rec.tk_group_query_id
261: ,p_rec.object_version_number
262: );
263: --

Line 321: l_rec hxc_tkgq_shd.g_rec_type;

317: (p_tk_group_query_id in number
318: ,p_object_version_number in number
319: ) is
320: --
321: l_rec hxc_tkgq_shd.g_rec_type;
322: l_proc varchar2(72) ;
323: --
324: Begin
325: g_debug :=hr_utility.debug_enabled;