APPS.HXC_RTC_INS dependencies on HXC_RTC_SHD

Line 56: (p_rec in out nocopy hxc_rtc_shd.g_rec_type

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

Line 70: hxc_rtc_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_rtc_shd.g_api_dml := true; -- Set the api dml status
71: --
72: -- Insert the row into: hxc_retrieval_rule_comps
73: --
74: insert into hxc_retrieval_rule_comps

Line 99: hxc_rtc_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

Line 108: hxc_rtc_shd.constraint_error

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

Line 112: hxc_rtc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 113: hxc_rtc_shd.constraint_error

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

Line 117: hxc_rtc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 118: hxc_rtc_shd.constraint_error

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

Line 121: hxc_rtc_shd.g_api_dml := false; -- Unset the api dml status

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

Line 163: (p_rec in out nocopy hxc_rtc_shd.g_rec_type

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

Line 224: ,p_rec in hxc_rtc_shd.g_rec_type

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

Line 272: ,p_rec in out nocopy hxc_rtc_shd.g_rec_type

268: -- |---------------------------------< ins >----------------------------------|
269: -- ----------------------------------------------------------------------------
270: Procedure ins
271: (p_effective_date in date
272: ,p_rec in out nocopy hxc_rtc_shd.g_rec_type
273: ) is
274: --
275: l_proc varchar2(72);
276: --

Line 324: l_rec hxc_rtc_shd.g_rec_type;

320: ,p_retrieval_rule_comp_id out nocopy number
321: ,p_object_version_number out nocopy number
322: ) is
323: --
324: l_rec hxc_rtc_shd.g_rec_type;
325: l_proc varchar2(72);
326: --
327: Begin
328: g_debug := hr_utility.debug_enabled;

Line 339: hxc_rtc_shd.convert_args

335: -- Call conversion function to turn arguments into the
336: -- p_rec structure.
337: --
338: l_rec :=
339: hxc_rtc_shd.convert_args
340: (null
341: ,p_retrieval_rule_id
342: ,p_status
343: ,null