DBA Data[Home] [Help]

APPS.HXC_DRU_UPD dependencies on HXC_DRU_SHD

Line 56: (p_rec in out nocopy hxc_dru_shd.g_rec_type

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

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

Line 87: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 97: hxc_dru_shd.constraint_error

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

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

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

Line 102: hxc_dru_shd.constraint_error

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

Line 106: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status

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

Line 107: hxc_dru_shd.constraint_error

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

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

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

Line 147: (p_rec in hxc_dru_shd.g_rec_type

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

Line 194: ,p_rec in hxc_dru_shd.g_rec_type

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

Line 219: => hxc_dru_shd.g_old_rec.approval_style_id

215: => p_rec.time_recipient_id
216: ,p_object_version_number
217: => p_rec.object_version_number
218: ,p_approval_style_id_o
219: => hxc_dru_shd.g_old_rec.approval_style_id
220: ,p_time_entry_rule_id_o
221: => hxc_dru_shd.g_old_rec.time_entry_rule_id
222: ,p_time_recipient_id_o
223: => hxc_dru_shd.g_old_rec.time_recipient_id

Line 221: => hxc_dru_shd.g_old_rec.time_entry_rule_id

217: => p_rec.object_version_number
218: ,p_approval_style_id_o
219: => hxc_dru_shd.g_old_rec.approval_style_id
220: ,p_time_entry_rule_id_o
221: => hxc_dru_shd.g_old_rec.time_entry_rule_id
222: ,p_time_recipient_id_o
223: => hxc_dru_shd.g_old_rec.time_recipient_id
224: ,p_object_version_number_o
225: => hxc_dru_shd.g_old_rec.object_version_number

Line 223: => hxc_dru_shd.g_old_rec.time_recipient_id

219: => hxc_dru_shd.g_old_rec.approval_style_id
220: ,p_time_entry_rule_id_o
221: => hxc_dru_shd.g_old_rec.time_entry_rule_id
222: ,p_time_recipient_id_o
223: => hxc_dru_shd.g_old_rec.time_recipient_id
224: ,p_object_version_number_o
225: => hxc_dru_shd.g_old_rec.object_version_number
226: );
227: --

Line 225: => hxc_dru_shd.g_old_rec.object_version_number

221: => hxc_dru_shd.g_old_rec.time_entry_rule_id
222: ,p_time_recipient_id_o
223: => hxc_dru_shd.g_old_rec.time_recipient_id
224: ,p_object_version_number_o
225: => hxc_dru_shd.g_old_rec.object_version_number
226: );
227: --
228: exception
229: --

Line 287: (p_rec in out nocopy hxc_dru_shd.g_rec_type

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

Line 299: hxc_dru_shd.g_old_rec.approval_style_id;

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

Line 303: hxc_dru_shd.g_old_rec.time_entry_rule_id;

299: hxc_dru_shd.g_old_rec.approval_style_id;
300: End If;
301: If (p_rec.time_entry_rule_id = hr_api.g_number) then
302: p_rec.time_entry_rule_id :=
303: hxc_dru_shd.g_old_rec.time_entry_rule_id;
304: End If;
305: If (p_rec.time_recipient_id = hr_api.g_number) then
306: p_rec.time_recipient_id :=
307: hxc_dru_shd.g_old_rec.time_recipient_id;

Line 307: hxc_dru_shd.g_old_rec.time_recipient_id;

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

Line 317: ,p_rec in out nocopy hxc_dru_shd.g_rec_type

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

Line 331: hxc_dru_shd.lck

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

Line 376: l_rec hxc_dru_shd.g_rec_type;

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

Line 390: hxc_dru_shd.convert_args

386: -- Call conversion function to turn arguments into the
387: -- l_rec structure.
388: --
389: l_rec :=
390: hxc_dru_shd.convert_args
391: (p_data_app_rule_usage_id
392: ,p_approval_style_id
393: ,p_time_entry_rule_id
394: ,p_time_recipient_id