DBA Data[Home] [Help]

APPS.HXC_DTL_UPD dependencies on HXC_DTL_SHD

Line 56: (p_rec in out nocopy hxc_dtl_shd.g_rec_type

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

Line 97: hxc_dtl_shd.constraint_error

93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: hxc_dtl_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: --

Line 102: hxc_dtl_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: --
102: hxc_dtl_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: --

Line 107: hxc_dtl_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: --
107: hxc_dtl_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: --
111: Raise;

Line 147: (p_rec in hxc_dtl_shd.g_rec_type

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

Line 193: (p_rec in hxc_dtl_shd.g_rec_type

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

Line 219: => hxc_dtl_shd.g_old_rec.alias_definition_name

215: => p_rec.language
216: ,p_source_lang
217: => p_rec.source_lang
218: ,p_alias_definition_name_o
219: => hxc_dtl_shd.g_old_rec.alias_definition_name
220: ,p_description_o
221: => hxc_dtl_shd.g_old_rec.description
222: ,p_prompt_o
223: => hxc_dtl_shd.g_old_rec.prompt

Line 221: => hxc_dtl_shd.g_old_rec.description

217: => p_rec.source_lang
218: ,p_alias_definition_name_o
219: => hxc_dtl_shd.g_old_rec.alias_definition_name
220: ,p_description_o
221: => hxc_dtl_shd.g_old_rec.description
222: ,p_prompt_o
223: => hxc_dtl_shd.g_old_rec.prompt
224: ,p_source_lang_o
225: => hxc_dtl_shd.g_old_rec.source_lang

Line 223: => hxc_dtl_shd.g_old_rec.prompt

219: => hxc_dtl_shd.g_old_rec.alias_definition_name
220: ,p_description_o
221: => hxc_dtl_shd.g_old_rec.description
222: ,p_prompt_o
223: => hxc_dtl_shd.g_old_rec.prompt
224: ,p_source_lang_o
225: => hxc_dtl_shd.g_old_rec.source_lang
226: );
227: --

Line 225: => hxc_dtl_shd.g_old_rec.source_lang

221: => hxc_dtl_shd.g_old_rec.description
222: ,p_prompt_o
223: => hxc_dtl_shd.g_old_rec.prompt
224: ,p_source_lang_o
225: => hxc_dtl_shd.g_old_rec.source_lang
226: );
227: --
228: exception
229: --

Line 287: (p_rec in out nocopy hxc_dtl_shd.g_rec_type

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

Line 299: hxc_dtl_shd.g_old_rec.alias_definition_name;

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

Line 303: hxc_dtl_shd.g_old_rec.description;

299: hxc_dtl_shd.g_old_rec.alias_definition_name;
300: End If;
301: If (p_rec.description = hr_api.g_varchar2) then
302: p_rec.description :=
303: hxc_dtl_shd.g_old_rec.description;
304: End If;
305: If (p_rec.source_lang = hr_api.g_varchar2) then
306: p_rec.source_lang :=
307: hxc_dtl_shd.g_old_rec.source_lang;

Line 307: hxc_dtl_shd.g_old_rec.source_lang;

303: hxc_dtl_shd.g_old_rec.description;
304: End If;
305: If (p_rec.source_lang = hr_api.g_varchar2) then
306: p_rec.source_lang :=
307: hxc_dtl_shd.g_old_rec.source_lang;
308: End If;
309: --
310: End convert_defs;
311: --

Line 316: (p_rec in out nocopy hxc_dtl_shd.g_rec_type

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

Line 330: hxc_dtl_shd.lck

326: end if;
327: --
328: -- We must lock the row which we need to update.
329: --
330: hxc_dtl_shd.lck
331: (p_rec.alias_definition_id
332: ,p_rec.language
333: );
334: --

Line 373: l_rec hxc_dtl_shd.g_rec_type;

369: ,p_description in varchar2 default hr_api.g_varchar2
370: ,p_prompt in varchar2 default hr_api.g_varchar2
371: ) is
372: --
373: l_rec hxc_dtl_shd.g_rec_type;
374: l_proc varchar2(72);
375: --
376: Begin
377: g_debug:=hr_utility.debug_enabled;

Line 387: hxc_dtl_shd.convert_args

383: -- Call conversion function to turn arguments into the
384: -- l_rec structure.
385: --
386: l_rec :=
387: hxc_dtl_shd.convert_args
388: (p_alias_definition_id
389: ,p_alias_definition_name
390: ,p_description
391: ,p_prompt