APPS.PQH_TKT_INS dependencies on PQH_TKT_SHD

Line 76: (p_rec in out nocopy pqh_tkt_shd.g_rec_type

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

Line 109: pqh_tkt_shd.constraint_error

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

Line 114: pqh_tkt_shd.constraint_error

110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When hr_api.parent_integrity_violated Then
112: -- Parent integrity has been violated
113: --
114: pqh_tkt_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --

Line 119: pqh_tkt_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: --
119: pqh_tkt_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When Others Then
122: --
123: Raise;

Line 164: (p_rec in out nocopy pqh_tkt_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_insert
164: (p_rec in out nocopy pqh_tkt_shd.g_rec_type
165: ) is
166: --
167: Cursor C_Sel1 is select pqh_de_tatigkeit_details_s.nextval from sys.dual;
168: --

Line 252: ,p_rec in pqh_tkt_shd.g_rec_type

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

Line 291: ,p_rec in out nocopy pqh_tkt_shd.g_rec_type

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

Line 341: l_rec pqh_tkt_shd.g_rec_type;

337: ,p_tatigkeit_detail_id out nocopy number
338: ,p_object_version_number out nocopy number
339: ) is
340: --
341: l_rec pqh_tkt_shd.g_rec_type;
342: l_proc varchar2(72) := g_package||'ins';
343: --
344: Begin
345: hr_utility.set_location('Entering:'||l_proc, 5);

Line 351: pqh_tkt_shd.convert_args

347: -- Call conversion function to turn arguments into the
348: -- p_rec structure.
349: --
350: l_rec :=
351: pqh_tkt_shd.convert_args
352: (null
353: ,p_tatigkeit_number
354: ,p_description
355: ,null