APPS.PQH_STR_INS dependencies on PQH_STR_SHD

Line 91: (p_rec in out nocopy pqh_str_shd.g_rec_type

87: --
88: -- {End Of Comments}
89: -- ----------------------------------------------------------------------------
90: Procedure insert_dml
91: (p_rec in out nocopy pqh_str_shd.g_rec_type
92: ) is
93: --
94: l_proc varchar2(72) := g_package||'insert_dml';
95: g_debug boolean := hr_utility.debug_enabled;

Line 144: pqh_str_shd.constraint_error

140: Exception
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
144: pqh_str_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.parent_integrity_violated Then
147: -- Parent integrity has been violated
148: --

Line 149: pqh_str_shd.constraint_error

145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.parent_integrity_violated Then
147: -- Parent integrity has been violated
148: --
149: pqh_str_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: --

Line 154: pqh_str_shd.constraint_error

150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: --
154: pqh_str_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When Others Then
157: --
158: Raise;

Line 199: (p_rec in out nocopy pqh_str_shd.g_rec_type

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure pre_insert
199: (p_rec in out nocopy pqh_str_shd.g_rec_type
200: ) is
201: --
202: Cursor C_Sel1 is select pqh_fr_stat_situation_rules_s.nextval from sys.dual;
203: --

Line 297: ,p_rec in pqh_str_shd.g_rec_type

293: -- {End Of Comments}
294: -- ----------------------------------------------------------------------------
295: Procedure post_insert
296: (p_effective_date in date
297: ,p_rec in pqh_str_shd.g_rec_type
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'post_insert';
301: --

Line 357: ,p_rec in out nocopy pqh_str_shd.g_rec_type

353: -- |---------------------------------< ins >----------------------------------|
354: -- ----------------------------------------------------------------------------
355: Procedure ins
356: (p_effective_date in date
357: ,p_rec in out nocopy pqh_str_shd.g_rec_type
358: ) is
359: --
360: l_proc varchar2(72) := g_package||'ins';
361: --

Line 426: l_rec pqh_str_shd.g_rec_type;

422: ,p_stat_situation_rule_id out nocopy number
423: ,p_object_version_number out nocopy number
424: ) is
425: --
426: l_rec pqh_str_shd.g_rec_type;
427: l_proc varchar2(72) := g_package||'ins';
428: --
429: Begin
430:

Line 443: pqh_str_shd.convert_args

439: -- Call conversion function to turn arguments into the
440: -- p_rec structure.
441: --
442: l_rec :=
443: pqh_str_shd.convert_args
444: (null
445: ,p_statutory_situation_id
446: ,p_processing_sequence
447: ,p_txn_category_attribute_id