APPS.HXC_DRU_INS dependencies on HXC_DRU_SHD

Line 55: (p_rec in out nocopy hxc_dru_shd.g_rec_type

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

Line 67: hxc_dru_shd.g_api_dml := true; -- Set the api dml status

63: hr_utility.set_location('Entering:'||l_proc, 5);
64: end if;
65: p_rec.object_version_number := 1; -- Initialise the object version
66: --
67: hxc_dru_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Insert the row into: hxc_data_app_rule_usages
70: --
71: insert into hxc_data_app_rule_usages

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

93: ,fnd_global.login_id
94:
95: );
96: --
97: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
98: --
99: if g_debug then
100: hr_utility.set_location(' Leaving:'||l_proc, 10);
101: end if;

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

101: end if;
102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_dru_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When hr_api.parent_integrity_violated Then
109: -- Parent integrity has been violated

Line 106: hxc_dru_shd.constraint_error

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

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

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

Line 111: hxc_dru_shd.constraint_error

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

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

111: hxc_dru_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_dru_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status

Line 116: hxc_dru_shd.constraint_error

112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.unique_integrity_violated Then
114: -- Unique integrity has been violated
115: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_dru_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;

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

115: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_dru_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_dru_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;
121: End insert_dml;
122: --
123: -- ----------------------------------------------------------------------------

Line 161: (p_rec in out nocopy hxc_dru_shd.g_rec_type

157: --
158: -- {End Of Comments}
159: -- ----------------------------------------------------------------------------
160: Procedure pre_insert
161: (p_rec in out nocopy hxc_dru_shd.g_rec_type
162: ) is
163: --
164: l_proc varchar2(72);
165: --

Line 220: ,p_rec in hxc_dru_shd.g_rec_type

216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure post_insert
219: (p_effective_date in date
220: ,p_rec in hxc_dru_shd.g_rec_type
221: ) is
222: --
223: l_proc varchar2(72);
224: --

Line 266: ,p_rec in out nocopy hxc_dru_shd.g_rec_type

262: -- |---------------------------------< ins >----------------------------------|
263: -- ----------------------------------------------------------------------------
264: Procedure ins
265: (p_effective_date in date
266: ,p_rec in out nocopy hxc_dru_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72);
270: --

Line 317: l_rec hxc_dru_shd.g_rec_type;

313: ,p_data_app_rule_usage_id out nocopy number
314: ,p_object_version_number out nocopy number
315: ) is
316: --
317: l_rec hxc_dru_shd.g_rec_type;
318: l_proc varchar2(72);
319: --
320: Begin
321: g_debug:=hr_utility.debug_enabled;

Line 331: hxc_dru_shd.convert_args

327: -- Call conversion function to turn arguments into the
328: -- p_rec structure.
329: --
330: l_rec :=
331: hxc_dru_shd.convert_args
332: (null
333: ,p_approval_style_id
334: ,p_time_entry_rule_id
335: ,p_time_recipient_id