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_APC_UPD dependencies on HXC_APC_SHD

Line 56: (p_rec in out nocopy hxc_apc_shd.g_rec_type

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

Line 70: hxc_apc_shd.g_api_dml := true; -- Set the api dml status

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

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

82: ,last_update_date = sysdate
83: ,last_update_login = fnd_global.login_id
84: where approval_period_comp_id = p_rec.approval_period_comp_id;
85: --
86: hxc_apc_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_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status
96: hxc_apc_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_apc_shd.constraint_error

92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
96: hxc_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status

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

96: hxc_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_apc_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_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status

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

101: hxc_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_apc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status

Line 106: hxc_apc_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_apc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_apc_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: hxc_apc_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;

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

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

Line 146: (p_rec in hxc_apc_shd.g_rec_type

142: --
143: -- {End Of Comments}
144: -- ----------------------------------------------------------------------------
145: Procedure pre_update
146: (p_rec in hxc_apc_shd.g_rec_type
147: ) is
148: --
149: l_proc varchar2(72) ;
150: --

Line 194: ,p_rec in hxc_apc_shd.g_rec_type

190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure post_update
193: (p_effective_date in date
194: ,p_rec in hxc_apc_shd.g_rec_type
195: ) is
196: --
197: l_proc varchar2(72);
198: --

Line 219: => hxc_apc_shd.g_old_rec.time_recipient_id

215: => p_rec.approval_period_set_id
216: ,p_object_version_number
217: => p_rec.object_version_number
218: ,p_time_recipient_id_o
219: => hxc_apc_shd.g_old_rec.time_recipient_id
220: ,p_recurring_period_id_o
221: => hxc_apc_shd.g_old_rec.recurring_period_id
222: ,p_approval_period_set_id_o
223: => hxc_apc_shd.g_old_rec.approval_period_set_id

Line 221: => hxc_apc_shd.g_old_rec.recurring_period_id

217: => p_rec.object_version_number
218: ,p_time_recipient_id_o
219: => hxc_apc_shd.g_old_rec.time_recipient_id
220: ,p_recurring_period_id_o
221: => hxc_apc_shd.g_old_rec.recurring_period_id
222: ,p_approval_period_set_id_o
223: => hxc_apc_shd.g_old_rec.approval_period_set_id
224: ,p_object_version_number_o
225: => hxc_apc_shd.g_old_rec.object_version_number

Line 223: => hxc_apc_shd.g_old_rec.approval_period_set_id

219: => hxc_apc_shd.g_old_rec.time_recipient_id
220: ,p_recurring_period_id_o
221: => hxc_apc_shd.g_old_rec.recurring_period_id
222: ,p_approval_period_set_id_o
223: => hxc_apc_shd.g_old_rec.approval_period_set_id
224: ,p_object_version_number_o
225: => hxc_apc_shd.g_old_rec.object_version_number
226: );
227: --

Line 225: => hxc_apc_shd.g_old_rec.object_version_number

221: => hxc_apc_shd.g_old_rec.recurring_period_id
222: ,p_approval_period_set_id_o
223: => hxc_apc_shd.g_old_rec.approval_period_set_id
224: ,p_object_version_number_o
225: => hxc_apc_shd.g_old_rec.object_version_number
226: );
227: --
228: exception
229: --

Line 287: (p_rec in out nocopy hxc_apc_shd.g_rec_type

283: --
284: -- {End Of Comments}
285: -- ----------------------------------------------------------------------------
286: Procedure convert_defs
287: (p_rec in out nocopy hxc_apc_shd.g_rec_type
288: ) is
289: --
290: Begin
291: --

Line 299: hxc_apc_shd.g_old_rec.time_recipient_id;

295: -- is being used then we must set to the 'current' argument value.
296: --
297: If (p_rec.time_recipient_id = hr_api.g_number) then
298: p_rec.time_recipient_id :=
299: hxc_apc_shd.g_old_rec.time_recipient_id;
300: End If;
301: If (p_rec.recurring_period_id = hr_api.g_number) then
302: p_rec.recurring_period_id :=
303: hxc_apc_shd.g_old_rec.recurring_period_id;

Line 303: hxc_apc_shd.g_old_rec.recurring_period_id;

299: hxc_apc_shd.g_old_rec.time_recipient_id;
300: End If;
301: If (p_rec.recurring_period_id = hr_api.g_number) then
302: p_rec.recurring_period_id :=
303: hxc_apc_shd.g_old_rec.recurring_period_id;
304: End If;
305: If (p_rec.approval_period_set_id = hr_api.g_number) then
306: p_rec.approval_period_set_id :=
307: hxc_apc_shd.g_old_rec.approval_period_set_id;

Line 307: hxc_apc_shd.g_old_rec.approval_period_set_id;

303: hxc_apc_shd.g_old_rec.recurring_period_id;
304: End If;
305: If (p_rec.approval_period_set_id = hr_api.g_number) then
306: p_rec.approval_period_set_id :=
307: hxc_apc_shd.g_old_rec.approval_period_set_id;
308: End If;
309: --
310: End convert_defs;
311: --

Line 317: ,p_rec in out nocopy hxc_apc_shd.g_rec_type

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

Line 331: hxc_apc_shd.lck

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

Line 376: l_rec hxc_apc_shd.g_rec_type;

372: ,p_recurring_period_id in number default hr_api.g_number
373: ,p_approval_period_set_id in number default hr_api.g_number
374: ) is
375: --
376: l_rec hxc_apc_shd.g_rec_type;
377: l_proc varchar2(72);
378: --
379: Begin
380: g_debug:=hr_utility.debug_enabled;

Line 390: hxc_apc_shd.convert_args

386: -- Call conversion function to turn arguments into the
387: -- l_rec structure.
388: --
389: l_rec :=
390: hxc_apc_shd.convert_args
391: (p_approval_period_comp_id
392: ,p_time_recipient_id
393: ,p_recurring_period_id
394: ,p_approval_period_set_id