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_UPD dependencies on HXC_TKGQ_SHD

Line 49: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

45: -- Internal Row Handler Use Only.
46: --
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml
49: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type
50: ) is
51: --
52: l_proc varchar2(72) ;
53: --

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

60: --
61: -- Increment the object version
62: p_rec.object_version_number := p_rec.object_version_number + 1;
63: --
64: hxc_tkgq_shd.g_api_dml := true; -- Set the api dml status
65: --
66: -- Update the hxc_tk_group_queries Row
67: --
68: update hxc_tk_group_queries

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

78: ,last_update_login = fnd_global.login_id
79:
80: where tk_group_query_id = p_rec.tk_group_query_id;
81: --
82: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
83: --
84: if g_debug then
85: hr_utility.set_location(' Leaving:'||l_proc, 10);
86: end if;

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

87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
92: hxc_tkgq_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated

Line 92: hxc_tkgq_shd.constraint_error

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

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

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

Line 97: hxc_tkgq_shd.constraint_error

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

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

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

Line 102: hxc_tkgq_shd.constraint_error

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

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

101: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
102: hxc_tkgq_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: hxc_tkgq_shd.g_api_dml := false; -- Unset the api dml status
106: Raise;
107: End update_dml;
108: --
109: -- ----------------------------------------------------------------------------

Line 140: (p_rec in hxc_tkgq_shd.g_rec_type

136: -- Internal Row Handler Use Only.
137: --
138: -- ----------------------------------------------------------------------------
139: Procedure pre_update
140: (p_rec in hxc_tkgq_shd.g_rec_type
141: ) is
142: --
143: l_proc varchar2(72) ;
144: --

Line 185: (p_rec in hxc_tkgq_shd.g_rec_type

181: -- Internal Row Handler Use Only.
182: --
183: -- ----------------------------------------------------------------------------
184: Procedure post_update
185: (p_rec in hxc_tkgq_shd.g_rec_type
186: ) is
187: --
188: l_proc varchar2(72) ;
189: --

Line 212: => hxc_tkgq_shd.g_old_rec.tk_group_id

208: => p_rec.system_user
209: ,p_object_version_number
210: => p_rec.object_version_number
211: ,p_tk_group_id_o
212: => hxc_tkgq_shd.g_old_rec.tk_group_id
213: ,p_group_query_name_o
214: => hxc_tkgq_shd.g_old_rec.group_query_name
215: ,p_include_exclude_o
216: => hxc_tkgq_shd.g_old_rec.include_exclude

Line 214: => hxc_tkgq_shd.g_old_rec.group_query_name

210: => p_rec.object_version_number
211: ,p_tk_group_id_o
212: => hxc_tkgq_shd.g_old_rec.tk_group_id
213: ,p_group_query_name_o
214: => hxc_tkgq_shd.g_old_rec.group_query_name
215: ,p_include_exclude_o
216: => hxc_tkgq_shd.g_old_rec.include_exclude
217: ,p_system_user_o
218: => hxc_tkgq_shd.g_old_rec.system_user

Line 216: => hxc_tkgq_shd.g_old_rec.include_exclude

212: => hxc_tkgq_shd.g_old_rec.tk_group_id
213: ,p_group_query_name_o
214: => hxc_tkgq_shd.g_old_rec.group_query_name
215: ,p_include_exclude_o
216: => hxc_tkgq_shd.g_old_rec.include_exclude
217: ,p_system_user_o
218: => hxc_tkgq_shd.g_old_rec.system_user
219: ,p_object_version_number_o
220: => hxc_tkgq_shd.g_old_rec.object_version_number

Line 218: => hxc_tkgq_shd.g_old_rec.system_user

214: => hxc_tkgq_shd.g_old_rec.group_query_name
215: ,p_include_exclude_o
216: => hxc_tkgq_shd.g_old_rec.include_exclude
217: ,p_system_user_o
218: => hxc_tkgq_shd.g_old_rec.system_user
219: ,p_object_version_number_o
220: => hxc_tkgq_shd.g_old_rec.object_version_number
221: );
222: --

Line 220: => hxc_tkgq_shd.g_old_rec.object_version_number

216: => hxc_tkgq_shd.g_old_rec.include_exclude
217: ,p_system_user_o
218: => hxc_tkgq_shd.g_old_rec.system_user
219: ,p_object_version_number_o
220: => hxc_tkgq_shd.g_old_rec.object_version_number
221: );
222: --
223: exception
224: --

Line 280: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

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

Line 292: hxc_tkgq_shd.g_old_rec.group_query_name;

288: -- is being used then we must set to the 'current' argument value.
289: --
290: If (p_rec.group_query_name = hr_api.g_varchar2) then
291: p_rec.group_query_name :=
292: hxc_tkgq_shd.g_old_rec.group_query_name;
293: End If;
294: If (p_rec.tk_group_id = hr_api.g_number) then
295: p_rec.tk_group_id :=
296: hxc_tkgq_shd.g_old_rec.tk_group_id;

Line 296: hxc_tkgq_shd.g_old_rec.tk_group_id;

292: hxc_tkgq_shd.g_old_rec.group_query_name;
293: End If;
294: If (p_rec.tk_group_id = hr_api.g_number) then
295: p_rec.tk_group_id :=
296: hxc_tkgq_shd.g_old_rec.tk_group_id;
297: End If;
298: If (p_rec.include_exclude = hr_api.g_varchar2) then
299: p_rec.include_exclude :=
300: hxc_tkgq_shd.g_old_rec.include_exclude;

Line 300: hxc_tkgq_shd.g_old_rec.include_exclude;

296: hxc_tkgq_shd.g_old_rec.tk_group_id;
297: End If;
298: If (p_rec.include_exclude = hr_api.g_varchar2) then
299: p_rec.include_exclude :=
300: hxc_tkgq_shd.g_old_rec.include_exclude;
301: End If;
302: If (p_rec.system_user = hr_api.g_varchar2) then
303: p_rec.system_user :=
304: hxc_tkgq_shd.g_old_rec.system_user;

Line 304: hxc_tkgq_shd.g_old_rec.system_user;

300: hxc_tkgq_shd.g_old_rec.include_exclude;
301: End If;
302: If (p_rec.system_user = hr_api.g_varchar2) then
303: p_rec.system_user :=
304: hxc_tkgq_shd.g_old_rec.system_user;
305: End If;
306:
307: --
308: End convert_defs;

Line 358: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type

354: -- Internal Development Use Only.
355: --
356: -- ----------------------------------------------------------------------------
357: Procedure upd
358: (p_rec in out nocopy hxc_tkgq_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) ;
362: --

Line 372: hxc_tkgq_shd.lck

368: end if;
369: --
370: -- We must lock the row which we need to update.
371: --
372: hxc_tkgq_shd.lck
373: (p_rec.tk_group_query_id
374: ,p_rec.object_version_number
375: );
376: --

Line 447: l_rec hxc_tkgq_shd.g_rec_type;

443: ,p_include_exclude in varchar2
444: ,p_system_user in varchar2
445: ) is
446: --
447: l_rec hxc_tkgq_shd.g_rec_type;
448: l_proc varchar2(72) ;
449: --
450: Begin
451: g_debug :=hr_utility.debug_enabled;

Line 461: hxc_tkgq_shd.convert_args

457: -- Call conversion function to turn arguments into the
458: -- l_rec structure.
459: --
460: l_rec :=
461: hxc_tkgq_shd.convert_args
462: (p_tk_group_query_id
463: ,p_tk_group_id
464: ,p_group_query_name
465: ,p_include_exclude