APPS.HXC_RTR_INS dependencies on HXC_RTR_SHD

Line 56: (p_rec in out nocopy hxc_rtr_shd.g_rec_type

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

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

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

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

93: ,sysdate
94: ,fnd_global.login_id
95: );
96: --
97: hxc_rtr_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_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_rtr_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_rtr_shd.constraint_error

102: Exception
103: When hr_api.check_integrity_violated Then
104: -- A check constraint has been violated
105: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status

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

106: hxc_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_rtr_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_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status

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

111: hxc_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_rtr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status

Line 116: hxc_rtr_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_rtr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_rtr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
120: Raise;

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

115: hxc_rtr_shd.g_api_dml := false; -- Unset the api dml status
116: hxc_rtr_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When Others Then
119: hxc_rtr_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_rtr_shd.g_rec_type

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

Line 222: ,p_rec in hxc_rtr_shd.g_rec_type

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

Line 268: ,p_rec in out nocopy hxc_rtr_shd.g_rec_type

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

Line 319: l_rec hxc_rtr_shd.g_rec_type;

315: ,p_retrieval_rule_id out nocopy number
316: ,p_object_version_number out nocopy number
317: ) is
318: --
319: l_rec hxc_rtr_shd.g_rec_type;
320: l_proc varchar2(72);
321: --
322: Begin
323: g_debug := hr_utility.debug_enabled;

Line 334: hxc_rtr_shd.convert_args

330: -- Call conversion function to turn arguments into the
331: -- p_rec structure.
332: --
333: l_rec :=
334: hxc_rtr_shd.convert_args
335: (null
336: ,p_retrieval_process_id
337: ,null
338: ,p_name