DBA Data[Home] [Help]

APPS.HXC_HAS_UPD dependencies on HXC_HAS_SHD

Line 56: (p_rec in out nocopy hxc_has_shd.g_rec_type

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

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

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

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

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

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

Line 101: hxc_has_shd.constraint_error

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

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

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

Line 106: hxc_has_shd.constraint_error

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

Line 110: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 111: hxc_has_shd.constraint_error

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

Line 114: hxc_has_shd.g_api_dml := false; -- Unset the api dml status

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

Line 151: (p_rec in hxc_has_shd.g_rec_type

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

Line 198: (p_rec in hxc_has_shd.g_rec_type

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

Line 230: => hxc_has_shd.g_old_rec.object_version_number

226: => p_rec.admin_role
227: ,p_error_admin_role
228: => p_rec.error_admin_role
229: ,p_object_version_number_o
230: => hxc_has_shd.g_old_rec.object_version_number
231: ,p_name_o
232: => hxc_has_shd.g_old_rec.name
233: ,p_business_group_id_o
234: => hxc_has_shd.g_old_rec.business_group_id

Line 232: => hxc_has_shd.g_old_rec.name

228: => p_rec.error_admin_role
229: ,p_object_version_number_o
230: => hxc_has_shd.g_old_rec.object_version_number
231: ,p_name_o
232: => hxc_has_shd.g_old_rec.name
233: ,p_business_group_id_o
234: => hxc_has_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => hxc_has_shd.g_old_rec.legislation_code

Line 234: => hxc_has_shd.g_old_rec.business_group_id

230: => hxc_has_shd.g_old_rec.object_version_number
231: ,p_name_o
232: => hxc_has_shd.g_old_rec.name
233: ,p_business_group_id_o
234: => hxc_has_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => hxc_has_shd.g_old_rec.legislation_code
237: ,p_description_o
238: => hxc_has_shd.g_old_rec.description

Line 236: => hxc_has_shd.g_old_rec.legislation_code

232: => hxc_has_shd.g_old_rec.name
233: ,p_business_group_id_o
234: => hxc_has_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => hxc_has_shd.g_old_rec.legislation_code
237: ,p_description_o
238: => hxc_has_shd.g_old_rec.description
239: ,p_run_recipient_extensions_o
240: => hxc_has_shd.g_old_rec.run_recipient_extensions

Line 238: => hxc_has_shd.g_old_rec.description

234: => hxc_has_shd.g_old_rec.business_group_id
235: ,p_legislation_code_o
236: => hxc_has_shd.g_old_rec.legislation_code
237: ,p_description_o
238: => hxc_has_shd.g_old_rec.description
239: ,p_run_recipient_extensions_o
240: => hxc_has_shd.g_old_rec.run_recipient_extensions
241: ,p_admin_role_o
242: => hxc_has_shd.g_old_rec.admin_role

Line 240: => hxc_has_shd.g_old_rec.run_recipient_extensions

236: => hxc_has_shd.g_old_rec.legislation_code
237: ,p_description_o
238: => hxc_has_shd.g_old_rec.description
239: ,p_run_recipient_extensions_o
240: => hxc_has_shd.g_old_rec.run_recipient_extensions
241: ,p_admin_role_o
242: => hxc_has_shd.g_old_rec.admin_role
243: ,p_error_admin_role_o
244: => hxc_has_shd.g_old_rec.error_admin_role

Line 242: => hxc_has_shd.g_old_rec.admin_role

238: => hxc_has_shd.g_old_rec.description
239: ,p_run_recipient_extensions_o
240: => hxc_has_shd.g_old_rec.run_recipient_extensions
241: ,p_admin_role_o
242: => hxc_has_shd.g_old_rec.admin_role
243: ,p_error_admin_role_o
244: => hxc_has_shd.g_old_rec.error_admin_role
245: );
246: --

Line 244: => hxc_has_shd.g_old_rec.error_admin_role

240: => hxc_has_shd.g_old_rec.run_recipient_extensions
241: ,p_admin_role_o
242: => hxc_has_shd.g_old_rec.admin_role
243: ,p_error_admin_role_o
244: => hxc_has_shd.g_old_rec.error_admin_role
245: );
246: --
247: exception
248: --

Line 306: (p_rec in out nocopy hxc_has_shd.g_rec_type

302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: Procedure convert_defs
306: (p_rec in out nocopy hxc_has_shd.g_rec_type
307: ) is
308: --
309: Begin
310: --

Line 318: hxc_has_shd.g_old_rec.name;

314: -- is being used then we must set to the 'current' argument value.
315: --
316: If (p_rec.name = hr_api.g_varchar2) then
317: p_rec.name :=
318: hxc_has_shd.g_old_rec.name;
319: End If;
320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: hxc_has_shd.g_old_rec.business_group_id;

Line 322: hxc_has_shd.g_old_rec.business_group_id;

318: hxc_has_shd.g_old_rec.name;
319: End If;
320: If (p_rec.business_group_id = hr_api.g_number) then
321: p_rec.business_group_id :=
322: hxc_has_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.legislation_code = hr_api.g_varchar2) then
325: p_rec.legislation_code :=
326: hxc_has_shd.g_old_rec.legislation_code;

Line 326: hxc_has_shd.g_old_rec.legislation_code;

322: hxc_has_shd.g_old_rec.business_group_id;
323: End If;
324: If (p_rec.legislation_code = hr_api.g_varchar2) then
325: p_rec.legislation_code :=
326: hxc_has_shd.g_old_rec.legislation_code;
327: End If;
328: If (p_rec.description = hr_api.g_varchar2) then
329: p_rec.description :=
330: hxc_has_shd.g_old_rec.description;

Line 330: hxc_has_shd.g_old_rec.description;

326: hxc_has_shd.g_old_rec.legislation_code;
327: End If;
328: If (p_rec.description = hr_api.g_varchar2) then
329: p_rec.description :=
330: hxc_has_shd.g_old_rec.description;
331: End If;
332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then
333: p_rec.run_recipient_extensions :=
334: hxc_has_shd.g_old_rec.run_recipient_extensions;

Line 334: hxc_has_shd.g_old_rec.run_recipient_extensions;

330: hxc_has_shd.g_old_rec.description;
331: End If;
332: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then
333: p_rec.run_recipient_extensions :=
334: hxc_has_shd.g_old_rec.run_recipient_extensions;
335: End If;
336: If (p_rec.admin_role = hr_api.g_varchar2) then
337: p_rec.admin_role :=
338: hxc_has_shd.g_old_rec.admin_role;

Line 338: hxc_has_shd.g_old_rec.admin_role;

334: hxc_has_shd.g_old_rec.run_recipient_extensions;
335: End If;
336: If (p_rec.admin_role = hr_api.g_varchar2) then
337: p_rec.admin_role :=
338: hxc_has_shd.g_old_rec.admin_role;
339: End If;
340: If (p_rec.error_admin_role = hr_api.g_varchar2) then
341: p_rec.error_admin_role :=
342: hxc_has_shd.g_old_rec.error_admin_role;

Line 342: hxc_has_shd.g_old_rec.error_admin_role;

338: hxc_has_shd.g_old_rec.admin_role;
339: End If;
340: If (p_rec.error_admin_role = hr_api.g_varchar2) then
341: p_rec.error_admin_role :=
342: hxc_has_shd.g_old_rec.error_admin_role;
343: End If;
344: --
345: End convert_defs;
346: --

Line 351: (p_rec in out nocopy hxc_has_shd.g_rec_type

347: -- ----------------------------------------------------------------------------
348: -- |---------------------------------< upd >----------------------------------|
349: -- ----------------------------------------------------------------------------
350: Procedure upd
351: (p_rec in out nocopy hxc_has_shd.g_rec_type
352: ) is
353: --
354: l_proc varchar2(72);
355: --

Line 365: hxc_has_shd.lck

361: end if;
362: --
363: -- We must lock the row which we need to update.
364: --
365: hxc_has_shd.lck
366: (p_rec.approval_style_id
367: ,p_rec.object_version_number
368: );
369: --

Line 411: l_rec hxc_has_shd.g_rec_type;

407: ,p_admin_role in varchar2 default hr_api.g_varchar2
408: ,p_error_admin_role in varchar2 default hr_api.g_varchar2
409: ) is
410: --
411: l_rec hxc_has_shd.g_rec_type;
412: l_proc varchar2(72);
413: --
414: Begin
415: g_debug:=hr_utility.debug_enabled;

Line 425: hxc_has_shd.convert_args

421: -- Call conversion function to turn arguments into the
422: -- l_rec structure.
423: --
424: l_rec :=
425: hxc_has_shd.convert_args
426: (p_approval_style_id
427: ,p_object_version_number
428: ,p_name
429: ,p_business_group_id