DBA Data[Home] [Help]

APPS.HXC_MPC_UPD dependencies on HXC_MPC_SHD

Line 57: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

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

Line 73: hxc_mpc_shd.g_api_dml := true; -- Set the api dml status

69: --
70: -- Increment the object version
71: p_rec.object_version_number := p_rec.object_version_number + 1;
72: --
73: hxc_mpc_shd.g_api_dml := true; -- Set the api dml status
74: --
75: -- Update the hxc_mapping_components Row
76: --
77: update hxc_mapping_components

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

87: ,last_update_login = fnd_global.login_id
88:
89: where mapping_component_id = p_rec.mapping_component_id;
90: --
91: hxc_mpc_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_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_mpc_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_mpc_shd.constraint_error

97: Exception
98: When hr_api.check_integrity_violated Then
99: -- A check constraint has been violated
100: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
101: hxc_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status

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

101: hxc_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_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_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status
106: hxc_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status

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

106: hxc_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_mpc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status

Line 111: hxc_mpc_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_mpc_shd.g_api_dml := false; -- Unset the api dml status
111: hxc_mpc_shd.constraint_error
112: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When Others Then
114: hxc_mpc_shd.g_api_dml := false; -- Unset the api dml status
115: Raise;

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

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

Line 151: (p_rec in hxc_mpc_shd.g_rec_type

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

Line 200: (p_rec in hxc_mpc_shd.g_rec_type

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

Line 228: => hxc_mpc_shd.g_old_rec.field_name

224: => p_rec.segment
225: ,p_object_version_number
226: => p_rec.object_version_number
227: ,p_field_name_o
228: => hxc_mpc_shd.g_old_rec.field_name
229: ,p_name_o
230: => hxc_mpc_shd.g_old_rec.name
231: ,p_bld_blk_info_type_id_o
232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id

Line 230: => hxc_mpc_shd.g_old_rec.name

226: => p_rec.object_version_number
227: ,p_field_name_o
228: => hxc_mpc_shd.g_old_rec.field_name
229: ,p_name_o
230: => hxc_mpc_shd.g_old_rec.name
231: ,p_bld_blk_info_type_id_o
232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id
233: ,p_segment_o
234: => hxc_mpc_shd.g_old_rec.segment

Line 232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id

228: => hxc_mpc_shd.g_old_rec.field_name
229: ,p_name_o
230: => hxc_mpc_shd.g_old_rec.name
231: ,p_bld_blk_info_type_id_o
232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id
233: ,p_segment_o
234: => hxc_mpc_shd.g_old_rec.segment
235: ,p_object_version_number_o
236: => hxc_mpc_shd.g_old_rec.object_version_number

Line 234: => hxc_mpc_shd.g_old_rec.segment

230: => hxc_mpc_shd.g_old_rec.name
231: ,p_bld_blk_info_type_id_o
232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id
233: ,p_segment_o
234: => hxc_mpc_shd.g_old_rec.segment
235: ,p_object_version_number_o
236: => hxc_mpc_shd.g_old_rec.object_version_number
237: );
238: --

Line 236: => hxc_mpc_shd.g_old_rec.object_version_number

232: => hxc_mpc_shd.g_old_rec.bld_blk_info_type_id
233: ,p_segment_o
234: => hxc_mpc_shd.g_old_rec.segment
235: ,p_object_version_number_o
236: => hxc_mpc_shd.g_old_rec.object_version_number
237: );
238: --
239: exception
240: --

Line 298: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

294: --
295: -- {End Of Comments}
296: -- ----------------------------------------------------------------------------
297: Procedure convert_defs
298: (p_rec in out nocopy hxc_mpc_shd.g_rec_type
299: ) is
300: --
301: Begin
302: --

Line 310: hxc_mpc_shd.g_old_rec.field_name;

306: -- is being used then we must set to the 'current' argument value.
307: --
308: If (p_rec.field_name = hr_api.g_varchar2) then
309: p_rec.field_name :=
310: hxc_mpc_shd.g_old_rec.field_name;
311: End If;
312: If (p_rec.name = hr_api.g_varchar2) then
313: p_rec.name :=
314: hxc_mpc_shd.g_old_rec.name;

Line 314: hxc_mpc_shd.g_old_rec.name;

310: hxc_mpc_shd.g_old_rec.field_name;
311: End If;
312: If (p_rec.name = hr_api.g_varchar2) then
313: p_rec.name :=
314: hxc_mpc_shd.g_old_rec.name;
315: End If;
316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then
317: p_rec.bld_blk_info_type_id :=
318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;

Line 318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;

314: hxc_mpc_shd.g_old_rec.name;
315: End If;
316: If (p_rec.bld_blk_info_type_id = hr_api.g_number) then
317: p_rec.bld_blk_info_type_id :=
318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;
319: End If;
320: If (p_rec.segment = hr_api.g_varchar2) then
321: p_rec.segment :=
322: hxc_mpc_shd.g_old_rec.segment;

Line 322: hxc_mpc_shd.g_old_rec.segment;

318: hxc_mpc_shd.g_old_rec.bld_blk_info_type_id;
319: End If;
320: If (p_rec.segment = hr_api.g_varchar2) then
321: p_rec.segment :=
322: hxc_mpc_shd.g_old_rec.segment;
323: End If;
324: --
325: End convert_defs;
326: --

Line 331: (p_rec in out nocopy hxc_mpc_shd.g_rec_type

327: -- ----------------------------------------------------------------------------
328: -- |---------------------------------< upd >----------------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure upd
331: (p_rec in out nocopy hxc_mpc_shd.g_rec_type
332: ) is
333: --
334: l_proc varchar2(72);
335: --

Line 346: hxc_mpc_shd.lck

342: end if;
343: --
344: -- We must lock the row which we need to update.
345: --
346: hxc_mpc_shd.lck
347: (p_rec.mapping_component_id
348: ,p_rec.object_version_number
349: );
350: --

Line 389: l_rec hxc_mpc_shd.g_rec_type;

385: ,p_bld_blk_info_type_id in number default hr_api.g_varchar2
386: ,p_segment in varchar2 default hr_api.g_varchar2
387: ) is
388: --
389: l_rec hxc_mpc_shd.g_rec_type;
390: l_proc varchar2(72);
391: --
392: Begin
393: g_debug := hr_utility.debug_enabled;

Line 404: hxc_mpc_shd.convert_args

400: -- Call conversion function to turn arguments into the
401: -- l_rec structure.
402: --
403: l_rec :=
404: hxc_mpc_shd.convert_args
405: (p_mapping_component_id
406: ,p_field_name
407: ,p_name
408: ,p_bld_blk_info_type_id