DBA Data[Home] [Help]

APPS.PQH_BGM_UPD dependencies on PQH_BGM_SHD

Line 51: Procedure update_dml(p_rec in out nocopy pqh_bgm_shd.g_rec_type) is

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

Line 80: pqh_bgm_shd.constraint_error

76: --
77: Exception
78: When hr_api.check_integrity_violated Then
79: -- A check constraint has been violated
80: pqh_bgm_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: pqh_bgm_shd.constraint_error

Line 84: pqh_bgm_shd.constraint_error

80: pqh_bgm_shd.constraint_error
81: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
82: When hr_api.parent_integrity_violated Then
83: -- Parent integrity has been violated
84: pqh_bgm_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.unique_integrity_violated Then
87: -- Unique integrity has been violated
88: pqh_bgm_shd.constraint_error

Line 88: pqh_bgm_shd.constraint_error

84: pqh_bgm_shd.constraint_error
85: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
86: When hr_api.unique_integrity_violated Then
87: -- Unique integrity has been violated
88: pqh_bgm_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When Others Then
91: Raise;
92: End update_dml;

Line 126: Procedure pre_update(p_rec in pqh_bgm_shd.g_rec_type) is

122: -- Internal Row Handler Use Only.
123: --
124: -- {End Of Comments}
125: -- ----------------------------------------------------------------------------
126: Procedure pre_update(p_rec in pqh_bgm_shd.g_rec_type) is
127: --
128: l_proc varchar2(72) := g_package||'pre_update';
129: --
130: Begin

Line 168: Procedure post_update(p_rec in pqh_bgm_shd.g_rec_type) is

164: -- Internal Row Handler Use Only.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168: Procedure post_update(p_rec in pqh_bgm_shd.g_rec_type) is
169: --
170: l_proc varchar2(72) := g_package||'post_update';
171: --
172: Begin

Line 187: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id

183: ,p_budget_id =>p_rec.budget_id
184: ,p_gl_account_segment =>p_rec.gl_account_segment
185: ,p_payroll_cost_segment =>p_rec.payroll_cost_segment
186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
188: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
189: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
190: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
191: );

Line 188: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment

184: ,p_gl_account_segment =>p_rec.gl_account_segment
185: ,p_payroll_cost_segment =>p_rec.payroll_cost_segment
186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
188: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
189: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
190: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
191: );
192: --

Line 189: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment

185: ,p_payroll_cost_segment =>p_rec.payroll_cost_segment
186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
188: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
189: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
190: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
191: );
192: --
193: exception

Line 190: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number

186: ,p_object_version_number =>p_rec.object_version_number
187: ,p_budget_id_o =>pqh_bgm_shd.g_old_rec.budget_id
188: ,p_gl_account_segment_o =>pqh_bgm_shd.g_old_rec.gl_account_segment
189: ,p_payroll_cost_segment_o =>pqh_bgm_shd.g_old_rec.payroll_cost_segment
190: ,p_object_version_number_o =>pqh_bgm_shd.g_old_rec.object_version_number
191: );
192: --
193: exception
194: --

Line 252: Procedure convert_defs(p_rec in out nocopy pqh_bgm_shd.g_rec_type) is

248: -- Internal Row Handler Use Only.
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure convert_defs(p_rec in out nocopy pqh_bgm_shd.g_rec_type) is
253: --
254: l_proc varchar2(72) := g_package||'convert_defs';
255: --
256: Begin

Line 267: pqh_bgm_shd.g_old_rec.budget_id;

263: -- is being used then we must set to the 'current' argument value.
264: --
265: If (p_rec.budget_id = hr_api.g_number) then
266: p_rec.budget_id :=
267: pqh_bgm_shd.g_old_rec.budget_id;
268: End If;
269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then
270: p_rec.gl_account_segment :=
271: pqh_bgm_shd.g_old_rec.gl_account_segment;

Line 271: pqh_bgm_shd.g_old_rec.gl_account_segment;

267: pqh_bgm_shd.g_old_rec.budget_id;
268: End If;
269: If (p_rec.gl_account_segment = hr_api.g_varchar2) then
270: p_rec.gl_account_segment :=
271: pqh_bgm_shd.g_old_rec.gl_account_segment;
272: End If;
273: If (p_rec.payroll_cost_segment = hr_api.g_varchar2) then
274: p_rec.payroll_cost_segment :=
275: pqh_bgm_shd.g_old_rec.payroll_cost_segment;

Line 275: pqh_bgm_shd.g_old_rec.payroll_cost_segment;

271: pqh_bgm_shd.g_old_rec.gl_account_segment;
272: End If;
273: If (p_rec.payroll_cost_segment = hr_api.g_varchar2) then
274: p_rec.payroll_cost_segment :=
275: pqh_bgm_shd.g_old_rec.payroll_cost_segment;
276: End If;
277:
278: --
279: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 288: p_rec in out nocopy pqh_bgm_shd.g_rec_type

284: -- |---------------------------------< upd >----------------------------------|
285: -- ----------------------------------------------------------------------------
286: Procedure upd
287: (
288: p_rec in out nocopy pqh_bgm_shd.g_rec_type
289: ) is
290: --
291: l_proc varchar2(72) := g_package||'upd';
292: --

Line 298: pqh_bgm_shd.lck

294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: -- We must lock the row which we need to update.
297: --
298: pqh_bgm_shd.lck
299: (
300: p_rec.budget_gl_flex_map_id,
301: p_rec.object_version_number
302: );

Line 338: l_rec pqh_bgm_shd.g_rec_type;

334: p_payroll_cost_segment in varchar2 default hr_api.g_varchar2,
335: p_object_version_number in out nocopy number
336: ) is
337: --
338: l_rec pqh_bgm_shd.g_rec_type;
339: l_proc varchar2(72) := g_package||'upd';
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);

Line 348: pqh_bgm_shd.convert_args

344: -- Call conversion function to turn arguments into the
345: -- l_rec structure.
346: --
347: l_rec :=
348: pqh_bgm_shd.convert_args
349: (
350: p_budget_gl_flex_map_id,
351: p_budget_id,
352: p_gl_account_segment,