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_RTR_UPD dependencies on HXC_RTR_SHD

Line 57: (p_rec in out nocopy hxc_rtr_shd.g_rec_type

53: --
54: -- {End Of Comments}
55: -- ----------------------------------------------------------------------------
56: Procedure update_dml
57: (p_rec in out nocopy hxc_rtr_shd.g_rec_type
58: ) is
59: --
60: l_proc varchar2(72);
61: --

Line 73: hxc_rtr_shd.g_api_dml := true; -- Set the api dml status

69: --
70: -- Increment the object version
71: p_rec.object_version_number := p_rec.object_version_number + 1;
72: --
73: hxc_rtr_shd.g_api_dml := true; -- Set the api dml status
74: --
75: -- Update the hxc_retrieval_rules Row
76: --
77: update hxc_retrieval_rules

Line 89: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status

85: ,last_update_login = fnd_global.login_id
86:
87: where retrieval_rule_id = p_rec.retrieval_rule_id;
88: --
89: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
90: --
91: if g_debug then
92: hr_utility.set_location(' Leaving:'||l_proc, 10);
93: end if;

Line 98: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 99: hxc_rtr_shd.constraint_error

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

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

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

Line 104: hxc_rtr_shd.constraint_error

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

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

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

Line 109: hxc_rtr_shd.constraint_error

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

Line 112: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status

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

Line 149: (p_rec in hxc_rtr_shd.g_rec_type

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure pre_update
149: (p_rec in hxc_rtr_shd.g_rec_type
150: ) is
151: --
152: l_proc varchar2(72);
153: --

Line 199: ,p_rec in hxc_rtr_shd.g_rec_type

195: -- {End Of Comments}
196: -- ----------------------------------------------------------------------------
197: Procedure post_update
198: (p_effective_date in date
199: ,p_rec in hxc_rtr_shd.g_rec_type
200: ) is
201: --
202: l_proc varchar2(72);
203: --

Line 224: => hxc_rtr_shd.g_old_rec.retrieval_process_id

220: => p_rec.object_version_number
221: ,p_name
222: => p_rec.name
223: ,p_retrieval_process_id_o
224: => hxc_rtr_shd.g_old_rec.retrieval_process_id
225: ,p_object_version_number_o
226: => hxc_rtr_shd.g_old_rec.object_version_number
227: ,p_name_o
228: => hxc_rtr_shd.g_old_rec.name

Line 226: => hxc_rtr_shd.g_old_rec.object_version_number

222: => p_rec.name
223: ,p_retrieval_process_id_o
224: => hxc_rtr_shd.g_old_rec.retrieval_process_id
225: ,p_object_version_number_o
226: => hxc_rtr_shd.g_old_rec.object_version_number
227: ,p_name_o
228: => hxc_rtr_shd.g_old_rec.name
229: );
230: --

Line 228: => hxc_rtr_shd.g_old_rec.name

224: => hxc_rtr_shd.g_old_rec.retrieval_process_id
225: ,p_object_version_number_o
226: => hxc_rtr_shd.g_old_rec.object_version_number
227: ,p_name_o
228: => hxc_rtr_shd.g_old_rec.name
229: );
230: --
231: exception
232: --

Line 290: (p_rec in out nocopy hxc_rtr_shd.g_rec_type

286: --
287: -- {End Of Comments}
288: -- ----------------------------------------------------------------------------
289: Procedure convert_defs
290: (p_rec in out nocopy hxc_rtr_shd.g_rec_type
291: ) is
292: --
293: Begin
294: --

Line 302: hxc_rtr_shd.g_old_rec.retrieval_process_id;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.retrieval_process_id = hr_api.g_number) then
301: p_rec.retrieval_process_id :=
302: hxc_rtr_shd.g_old_rec.retrieval_process_id;
303: End If;
304: If (p_rec.name = hr_api.g_varchar2) then
305: p_rec.name :=
306: hxc_rtr_shd.g_old_rec.name;

Line 306: hxc_rtr_shd.g_old_rec.name;

302: hxc_rtr_shd.g_old_rec.retrieval_process_id;
303: End If;
304: If (p_rec.name = hr_api.g_varchar2) then
305: p_rec.name :=
306: hxc_rtr_shd.g_old_rec.name;
307: End If;
308: --
309: End convert_defs;
310: --

Line 316: ,p_rec in out nocopy hxc_rtr_shd.g_rec_type

312: -- |---------------------------------< upd >----------------------------------|
313: -- ----------------------------------------------------------------------------
314: Procedure upd
315: (p_effective_date in date
316: ,p_rec in out nocopy hxc_rtr_shd.g_rec_type
317: ) is
318: --
319: l_proc varchar2(72);
320: --

Line 331: hxc_rtr_shd.lck

327: end if;
328: --
329: -- We must lock the row which we need to update.
330: --
331: hxc_rtr_shd.lck
332: (p_rec.retrieval_rule_id
333: ,p_rec.object_version_number
334: );
335: --

Line 375: l_rec hxc_rtr_shd.g_rec_type;

371: ,p_retrieval_process_id in number default hr_api.g_number
372: ,p_name in varchar2 default hr_api.g_varchar2
373: ) is
374: --
375: l_rec hxc_rtr_shd.g_rec_type;
376: l_proc varchar2(72);
377: --
378: Begin
379: g_debug := hr_utility.debug_enabled;

Line 390: hxc_rtr_shd.convert_args

386: -- Call conversion function to turn arguments into the
387: -- l_rec structure.
388: --
389: l_rec :=
390: hxc_rtr_shd.convert_args
391: (p_retrieval_rule_id
392: ,p_retrieval_process_id
393: ,p_object_version_number
394: ,p_name