APPS.HR_DTY_INS dependencies on HR_DTY_SHD

Line 70: (p_rec in out nocopy hr_dty_shd.g_rec_type

66: --
67: -- {End Of Comments}
68: -- ----------------------------------------------------------------------------
69: Procedure insert_dml
70: (p_rec in out nocopy hr_dty_shd.g_rec_type
71: ) is
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --

Line 123: hr_dty_shd.constraint_error

119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: --
123: hr_dty_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --

Line 128: hr_dty_shd.constraint_error

124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: --
128: hr_dty_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --

Line 133: hr_dty_shd.constraint_error

129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: --
133: hr_dty_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: --
137: Raise;

Line 178: (p_rec in out nocopy hr_dty_shd.g_rec_type

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure pre_insert
178: (p_rec in out nocopy hr_dty_shd.g_rec_type
179: ) is
180: --
181: Cursor C_Sel1 is select hr_document_types_s.nextval from sys.dual;
182: --

Line 266: ,p_rec in hr_dty_shd.g_rec_type

262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure post_insert
265: (p_effective_date in date
266: ,p_rec in hr_dty_shd.g_rec_type
267: ) is
268: --
269: l_proc varchar2(72) := g_package||'post_insert';
270: --

Line 323: ,p_rec in out nocopy hr_dty_shd.g_rec_type

319: -- |---------------------------------< ins >----------------------------------|
320: -- ----------------------------------------------------------------------------
321: Procedure ins
322: (p_effective_date in date
323: ,p_rec in out nocopy hr_dty_shd.g_rec_type
324: ) is
325: --
326: l_proc varchar2(72) := g_package||'ins';
327: --

Line 387: l_rec hr_dty_shd.g_rec_type;

383: ,p_object_version_number out nocopy number
384: ) is
385: --
386:
387: l_rec hr_dty_shd.g_rec_type;
388: l_proc varchar2(72) := g_package||'ins';
389:
390: --
391: Begin

Line 399: hr_dty_shd.convert_args

395: -- Call conversion function to turn arguments into the
396: -- p_rec structure.
397: --
398: l_rec :=
399: hr_dty_shd.convert_args
400: (null
401: ,p_system_document_type
402: ,p_category_code
403: ,p_sub_category_code