APPS.PQH_RAP_INS dependencies on PQH_RAP_SHD

Line 77: (p_rec in out nocopy pqh_rap_shd.g_rec_type

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

Line 119: pqh_rap_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: pqh_rap_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --

Line 124: pqh_rap_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.parent_integrity_violated Then
122: -- Parent integrity has been violated
123: --
124: pqh_rap_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --

Line 129: pqh_rap_shd.constraint_error

125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.unique_integrity_violated Then
127: -- Unique integrity has been violated
128: --
129: pqh_rap_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When Others Then
132: --
133: Raise;

Line 174: (p_rec in out nocopy pqh_rap_shd.g_rec_type

170: --
171: -- {End Of Comments}
172: -- ----------------------------------------------------------------------------
173: Procedure pre_insert
174: (p_rec in out nocopy pqh_rap_shd.g_rec_type
175: ) is
176: --
177: Cursor C_Sel1 is select pqh_rank_process_approvals_s.nextval from sys.dual;
178: --

Line 263: ,p_rec in pqh_rap_shd.g_rec_type

259: -- {End Of Comments}
260: -- ----------------------------------------------------------------------------
261: Procedure post_insert
262: (p_effective_date in date
263: ,p_rec in pqh_rap_shd.g_rec_type
264: ) is
265: --
266: l_proc constant varchar2(72):= g_package||'post_insert';
267: --

Line 311: ,p_rec in out nocopy pqh_rap_shd.g_rec_type

307: -- |---------------------------------< ins >----------------------------------|
308: -- ----------------------------------------------------------------------------
309: Procedure ins
310: (p_effective_date in date
311: ,p_rec in out nocopy pqh_rap_shd.g_rec_type
312: ) is
313: --
314: l_proc constant varchar2(72):= g_package||'ins';
315: --

Line 366: l_rec pqh_rap_shd.g_rec_type;

362: ,p_rank_process_approval_id out nocopy number
363: ,p_object_version_number out nocopy number
364: ) is
365: --
366: l_rec pqh_rap_shd.g_rec_type;
367: l_proc constant varchar2(72):= g_package||'ins';
368: --
369: Begin
370:

Line 377: pqh_rap_shd.convert_args

373: -- Call conversion function to turn arguments into the
374: -- p_rec structure.
375: --
376: l_rec :=
377: pqh_rap_shd.convert_args
378: (null
379: ,p_rank_process_id
380: ,p_approval_date
381: ,p_supervisor_id