DBA Data[Home] [Help]

APPS.PQH_TCD_INS dependencies on PQH_TCD_SHD

Line 79: (p_rec in out nocopy pqh_tcd_shd.g_rec_type

75: --
76: -- {End Of Comments}
77: -- ----------------------------------------------------------------------------
78: Procedure insert_dml
79: (p_rec in out nocopy pqh_tcd_shd.g_rec_type
80: ) is
81: --
82: l_proc varchar2(72) := g_package||'insert_dml';
83: --

Line 112: pqh_tcd_shd.constraint_error

108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: pqh_tcd_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --

Line 117: pqh_tcd_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
117: pqh_tcd_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --

Line 122: pqh_tcd_shd.constraint_error

118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: pqh_tcd_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;

Line 167: (p_rec in out nocopy pqh_tcd_shd.g_rec_type

163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_insert
167: (p_rec in out nocopy pqh_tcd_shd.g_rec_type
168: ) is
169: --
170: Cursor C_Sel2 is
171: Select null

Line 249: ,p_rec in pqh_tcd_shd.g_rec_type

245: -- {End Of Comments}
246: -- ----------------------------------------------------------------------------
247: Procedure post_insert
248: (p_effective_date in date
249: ,p_rec in pqh_tcd_shd.g_rec_type
250: ) is
251: --
252: l_proc varchar2(72) := g_package||'post_insert';
253: --

Line 288: ,p_rec in out nocopy pqh_tcd_shd.g_rec_type

284: -- |---------------------------------< ins >----------------------------------|
285: -- ----------------------------------------------------------------------------
286: Procedure ins
287: (p_effective_date in date
288: ,p_rec in out nocopy pqh_tcd_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'ins';
292: --

Line 338: l_rec pqh_tcd_shd.g_rec_type;

334: ,p_transaction_category_id in number
335: ,p_object_version_number out nocopy number
336: ) is
337: --
338: l_rec pqh_tcd_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'ins';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);

Line 348: pqh_tcd_shd.convert_args

344: -- Call conversion function to turn arguments into the
345: -- p_rec structure.
346: --
347: l_rec :=
348: pqh_tcd_shd.convert_args
349: (p_document_id
350: ,p_transaction_category_id
351: ,p_type_code
352: ,null