APPS.PQH_FTR_INS dependencies on PQH_FTR_SHD

Line 76: (p_rec in out nocopy pqh_ftr_shd.g_rec_type

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

Line 113: pqh_ftr_shd.constraint_error

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

Line 118: pqh_ftr_shd.constraint_error

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

Line 123: pqh_ftr_shd.constraint_error

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

Line 168: (p_rec in out nocopy pqh_ftr_shd.g_rec_type

164: --
165: -- {End Of Comments}
166: -- ----------------------------------------------------------------------------
167: Procedure pre_insert
168: (p_rec in out nocopy pqh_ftr_shd.g_rec_type
169: ) is
170: --
171: Cursor C_Sel1 is select pqh_de_wrkplc_vldtn_jobftrs_s.nextval from sys.dual;
172: --

Line 256: ,p_rec in pqh_ftr_shd.g_rec_type

252: -- {End Of Comments}
253: -- ----------------------------------------------------------------------------
254: Procedure post_insert
255: (p_effective_date in date
256: ,p_rec in pqh_ftr_shd.g_rec_type
257: ) is
258: --
259: l_proc varchar2(72) := g_package||'post_insert';
260: --

Line 299: ,p_rec in out nocopy pqh_ftr_shd.g_rec_type

295: -- |---------------------------------< ins >----------------------------------|
296: -- ----------------------------------------------------------------------------
297: Procedure ins
298: (p_effective_date in date
299: ,p_rec in out nocopy pqh_ftr_shd.g_rec_type
300: ) is
301: --
302: l_proc varchar2(72) := g_package||'ins';
303: --

Line 351: l_rec pqh_ftr_shd.g_rec_type;

347: ,p_wrkplc_vldtn_jobftr_id out nocopy number
348: ,p_object_version_number out nocopy number
349: ) is
350: --
351: l_rec pqh_ftr_shd.g_rec_type;
352: l_proc varchar2(72) := g_package||'ins';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);

Line 361: pqh_ftr_shd.convert_args

357: -- Call conversion function to turn arguments into the
358: -- p_rec structure.
359: --
360: l_rec :=
361: pqh_ftr_shd.convert_args
362: (null
363: ,p_wrkplc_vldtn_opr_job_id
364: ,p_job_feature_code
365: ,p_wrkplc_vldtn_opr_job_type