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_APS_UPD dependencies on HXC_APS_SHD

Line 56: (p_rec in out nocopy hxc_aps_shd.g_rec_type

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

Line 70: hxc_aps_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_aps_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Update the hxc_approval_period_sets Row
73: --
74: update hxc_approval_period_sets

Line 84: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

80: ,last_update_date = sysdate
81: ,last_update_login = fnd_global.login_id
82: where approval_period_set_id = p_rec.approval_period_set_id;
83: --
84: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status
85: --
86: if g_debug then
87: hr_utility.set_location(' Leaving:'||l_proc, 10);
88: end if;

Line 93: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

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

Line 94: hxc_aps_shd.constraint_error

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

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

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

Line 99: hxc_aps_shd.constraint_error

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

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

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

Line 104: hxc_aps_shd.constraint_error

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

Line 107: hxc_aps_shd.g_api_dml := false; -- Unset the api dml status

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

Line 144: (p_rec in hxc_aps_shd.g_rec_type

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

Line 191: (p_rec in hxc_aps_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure post_update
191: (p_rec in hxc_aps_shd.g_rec_type
192: ) is
193: --
194: l_proc varchar2(72);
195: --

Line 211: => hxc_aps_shd.g_old_rec.name

207: => p_rec.name
208: ,p_object_version_number
209: => p_rec.object_version_number
210: ,p_name_o
211: => hxc_aps_shd.g_old_rec.name
212: ,p_object_version_number_o
213: => hxc_aps_shd.g_old_rec.object_version_number
214: );
215: --

Line 213: => hxc_aps_shd.g_old_rec.object_version_number

209: => p_rec.object_version_number
210: ,p_name_o
211: => hxc_aps_shd.g_old_rec.name
212: ,p_object_version_number_o
213: => hxc_aps_shd.g_old_rec.object_version_number
214: );
215: --
216: exception
217: --

Line 275: (p_rec in out nocopy hxc_aps_shd.g_rec_type

271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure convert_defs
275: (p_rec in out nocopy hxc_aps_shd.g_rec_type
276: ) is
277: --
278: Begin
279: --

Line 287: hxc_aps_shd.g_old_rec.name;

283: -- is being used then we must set to the 'current' argument value.
284: --
285: If (p_rec.name = hr_api.g_varchar2) then
286: p_rec.name :=
287: hxc_aps_shd.g_old_rec.name;
288: End If;
289: --
290: End convert_defs;
291: --

Line 296: (p_rec in out nocopy hxc_aps_shd.g_rec_type

292: -- ----------------------------------------------------------------------------
293: -- |---------------------------------< upd >----------------------------------|
294: -- ----------------------------------------------------------------------------
295: Procedure upd
296: (p_rec in out nocopy hxc_aps_shd.g_rec_type
297: ) is
298: --
299: l_proc varchar2(72);
300: --

Line 310: hxc_aps_shd.lck

306: end if;
307: --
308: -- We must lock the row which we need to update.
309: --
310: hxc_aps_shd.lck
311: (p_rec.approval_period_set_id
312: ,p_rec.object_version_number
313: );
314: --

Line 350: l_rec hxc_aps_shd.g_rec_type;

346: ,p_object_version_number in out nocopy number
347: ,p_name in varchar2 default hr_api.g_varchar2
348: ) is
349: --
350: l_rec hxc_aps_shd.g_rec_type;
351: l_proc varchar2(72);
352: --
353: Begin
354: g_debug:=hr_utility.debug_enabled;

Line 364: hxc_aps_shd.convert_args

360: -- Call conversion function to turn arguments into the
361: -- l_rec structure.
362: --
363: l_rec :=
364: hxc_aps_shd.convert_args
365: (p_approval_period_set_id
366: ,p_name
367: ,p_object_version_number
368: );