eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_DST_UPD dependencies on PQH_DST_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_dst_shd.g_rec_type) is

44: -- Internal Row Handler Use Only.
45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml(p_rec in out nocopy pqh_dst_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 76: pqh_dst_shd.constraint_error

72: --
73: Exception
74: When hr_api.check_integrity_violated Then
75: -- A check constraint has been violated
76: pqh_dst_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error

Line 80: pqh_dst_shd.constraint_error

76: pqh_dst_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When hr_api.parent_integrity_violated Then
79: -- Parent integrity has been violated
80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: pqh_dst_shd.constraint_error

Line 84: pqh_dst_shd.constraint_error

80: pqh_dst_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.unique_integrity_violated Then
83: -- Unique integrity has been violated
84: pqh_dst_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When Others Then
87: Raise;
88: End update_dml;

Line 122: Procedure pre_update(p_rec in pqh_dst_shd.g_rec_type) is

118: -- Internal Row Handler Use Only.
119: --
120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: Procedure pre_update(p_rec in pqh_dst_shd.g_rec_type) is
123: --
124: l_proc varchar2(72) := g_package||'pre_update';
125: --
126: Begin

Line 164: Procedure post_update(p_rec in pqh_dst_shd.g_rec_type) is

160: -- Internal Row Handler Use Only.
161: --
162: -- {End Of Comments}
163: -- ----------------------------------------------------------------------------
164: Procedure post_update(p_rec in pqh_dst_shd.g_rec_type) is
165: --
166: l_proc varchar2(72) := g_package||'post_update';
167: --
168: Begin

Line 182: ,p_dflt_budget_set_name_o =>pqh_dst_shd.g_old_rec.dflt_budget_set_name

178: p_dflt_budget_set_id =>p_rec.dflt_budget_set_id
179: ,p_dflt_budget_set_name =>p_rec.dflt_budget_set_name
180: ,p_business_group_id =>p_rec.business_group_id
181: ,p_object_version_number =>p_rec.object_version_number
182: ,p_dflt_budget_set_name_o =>pqh_dst_shd.g_old_rec.dflt_budget_set_name
183: ,p_business_group_id_o =>pqh_dst_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>pqh_dst_shd.g_old_rec.object_version_number
185: );
186: --

Line 183: ,p_business_group_id_o =>pqh_dst_shd.g_old_rec.business_group_id

179: ,p_dflt_budget_set_name =>p_rec.dflt_budget_set_name
180: ,p_business_group_id =>p_rec.business_group_id
181: ,p_object_version_number =>p_rec.object_version_number
182: ,p_dflt_budget_set_name_o =>pqh_dst_shd.g_old_rec.dflt_budget_set_name
183: ,p_business_group_id_o =>pqh_dst_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>pqh_dst_shd.g_old_rec.object_version_number
185: );
186: --
187: exception

Line 184: ,p_object_version_number_o =>pqh_dst_shd.g_old_rec.object_version_number

180: ,p_business_group_id =>p_rec.business_group_id
181: ,p_object_version_number =>p_rec.object_version_number
182: ,p_dflt_budget_set_name_o =>pqh_dst_shd.g_old_rec.dflt_budget_set_name
183: ,p_business_group_id_o =>pqh_dst_shd.g_old_rec.business_group_id
184: ,p_object_version_number_o =>pqh_dst_shd.g_old_rec.object_version_number
185: );
186: --
187: exception
188: --

Line 246: Procedure convert_defs(p_rec in out nocopy pqh_dst_shd.g_rec_type) is

242: -- Internal Row Handler Use Only.
243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure convert_defs(p_rec in out nocopy pqh_dst_shd.g_rec_type) is
247: --
248: l_proc varchar2(72) := g_package||'convert_defs';
249: --
250: Begin

Line 261: pqh_dst_shd.g_old_rec.dflt_budget_set_name;

257: -- is being used then we must set to the 'current' argument value.
258: --
259: If (p_rec.dflt_budget_set_name = hr_api.g_varchar2) then
260: p_rec.dflt_budget_set_name :=
261: pqh_dst_shd.g_old_rec.dflt_budget_set_name;
262: End If;
263: If (p_rec.business_group_id = hr_api.g_number) then
264: p_rec.business_group_id :=
265: pqh_dst_shd.g_old_rec.business_group_id;

Line 265: pqh_dst_shd.g_old_rec.business_group_id;

261: pqh_dst_shd.g_old_rec.dflt_budget_set_name;
262: End If;
263: If (p_rec.business_group_id = hr_api.g_number) then
264: p_rec.business_group_id :=
265: pqh_dst_shd.g_old_rec.business_group_id;
266: End If;
267:
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 278: p_rec in out nocopy pqh_dst_shd.g_rec_type

274: -- |---------------------------------< upd >----------------------------------|
275: -- ----------------------------------------------------------------------------
276: Procedure upd
277: (
278: p_rec in out nocopy pqh_dst_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) := g_package||'upd';
282: --

Line 288: pqh_dst_shd.lck

284: hr_utility.set_location('Entering:'||l_proc, 5);
285: --
286: -- We must lock the row which we need to update.
287: --
288: pqh_dst_shd.lck
289: (
290: p_rec.dflt_budget_set_id,
291: p_rec.object_version_number
292: );

Line 327: l_rec pqh_dst_shd.g_rec_type;

323: p_business_group_id in number default hr_api.g_number,
324: p_object_version_number in out nocopy number
325: ) is
326: --
327: l_rec pqh_dst_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'upd';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);

Line 337: pqh_dst_shd.convert_args

333: -- Call conversion function to turn arguments into the
334: -- l_rec structure.
335: --
336: l_rec :=
337: pqh_dst_shd.convert_args
338: (
339: p_dflt_budget_set_id,
340: p_dflt_budget_set_name,
341: p_business_group_id,