APPS.PQH_TCD_UPD dependencies on PQH_TCD_SHD

Line 55: (p_rec in out nocopy pqh_tcd_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pqh_tcd_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 87: pqh_tcd_shd.constraint_error

83: Exception
84: When hr_api.check_integrity_violated Then
85: -- A check constraint has been violated
86: --
87: pqh_tcd_shd.constraint_error
88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --

Line 92: pqh_tcd_shd.constraint_error

88: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
89: When hr_api.parent_integrity_violated Then
90: -- Parent integrity has been violated
91: --
92: pqh_tcd_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --

Line 97: pqh_tcd_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.unique_integrity_violated Then
95: -- Unique integrity has been violated
96: --
97: pqh_tcd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When Others Then
100: --
101: Raise;

Line 137: (p_rec in pqh_tcd_shd.g_rec_type

133: --
134: -- {End Of Comments}
135: -- ----------------------------------------------------------------------------
136: Procedure pre_update
137: (p_rec in pqh_tcd_shd.g_rec_type
138: ) is
139: --
140: l_proc varchar2(72) := g_package||'pre_update';
141: --

Line 182: ,p_rec in pqh_tcd_shd.g_rec_type

178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure post_update
181: (p_effective_date in date
182: ,p_rec in pqh_tcd_shd.g_rec_type
183: ) is
184: --
185: l_proc varchar2(72) := g_package||'post_update';
186: --

Line 202: => pqh_tcd_shd.g_old_rec.type_code

198: => p_rec.type_code
199: ,p_object_version_number
200: => p_rec.object_version_number
201: ,p_type_code_o
202: => pqh_tcd_shd.g_old_rec.type_code
203: ,p_object_version_number_o
204: => pqh_tcd_shd.g_old_rec.object_version_number
205: );
206: --

Line 204: => pqh_tcd_shd.g_old_rec.object_version_number

200: => p_rec.object_version_number
201: ,p_type_code_o
202: => pqh_tcd_shd.g_old_rec.type_code
203: ,p_object_version_number_o
204: => pqh_tcd_shd.g_old_rec.object_version_number
205: );
206: --
207: exception
208: --

Line 264: (p_rec in out nocopy pqh_tcd_shd.g_rec_type

260: --
261: -- {End Of Comments}
262: -- ----------------------------------------------------------------------------
263: Procedure convert_defs
264: (p_rec in out nocopy pqh_tcd_shd.g_rec_type
265: ) is
266: --
267: Begin
268: --

Line 276: pqh_tcd_shd.g_old_rec.type_code;

272: -- is being used then we must set to the 'current' argument value.
273: --
274: If (p_rec.type_code = hr_api.g_varchar2) then
275: p_rec.type_code :=
276: pqh_tcd_shd.g_old_rec.type_code;
277: End If;
278: --
279: End convert_defs;
280: --

Line 286: ,p_rec in out nocopy pqh_tcd_shd.g_rec_type

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

Line 296: pqh_tcd_shd.lck

292: hr_utility.set_location('Entering:'||l_proc, 5);
293: --
294: -- We must lock the row which we need to update.
295: --
296: pqh_tcd_shd.lck
297: (p_rec.document_id
298: ,p_rec.transaction_category_id
299: ,p_rec.object_version_number
300: );

Line 347: l_rec pqh_tcd_shd.g_rec_type;

343: ,p_object_version_number in out nocopy number
344: ,p_type_code in varchar2 default hr_api.g_varchar2
345: ) is
346: --
347: l_rec pqh_tcd_shd.g_rec_type;
348: l_proc varchar2(72) := g_package||'upd';
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);

Line 357: pqh_tcd_shd.convert_args

353: -- Call conversion function to turn arguments into the
354: -- l_rec structure.
355: --
356: l_rec :=
357: pqh_tcd_shd.convert_args
358: (p_document_id
359: ,p_transaction_category_id
360: ,p_type_code
361: ,p_object_version_number