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_BCE_UPD dependencies on PQH_BCE_SHD

Line 50: Procedure update_dml(p_rec in out nocopy pqh_bce_shd.g_rec_type) is

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

Line 86: pqh_bce_shd.constraint_error

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

Line 90: pqh_bce_shd.constraint_error

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

Line 94: pqh_bce_shd.constraint_error

90: pqh_bce_shd.constraint_error
91: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
92: When hr_api.unique_integrity_violated Then
93: -- Unique integrity has been violated
94: pqh_bce_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When Others Then
97: Raise;
98: End update_dml;

Line 132: Procedure pre_update(p_rec in pqh_bce_shd.g_rec_type) is

128: -- Internal Row Handler Use Only.
129: --
130: -- {End Of Comments}
131: -- ----------------------------------------------------------------------------
132: Procedure pre_update(p_rec in pqh_bce_shd.g_rec_type) is
133: --
134: l_proc varchar2(72) := g_package||'pre_update';
135: --
136: Begin

Line 175: p_effective_date in date,p_rec in pqh_bce_shd.g_rec_type) is

171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure post_update(
175: p_effective_date in date,p_rec in pqh_bce_shd.g_rec_type) is
176: --
177: l_proc varchar2(72) := g_package||'post_update';
178: --
179: Begin

Line 202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id

198: ,p_dflt_elmnt_frequency =>p_rec.dflt_elmnt_frequency
199: ,p_overhead_percentage =>p_rec.overhead_percentage
200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id

Line 203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type

199: ,p_overhead_percentage =>p_rec.overhead_percentage
200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id

Line 204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id

200: ,p_object_version_number =>p_rec.object_version_number
201: ,p_effective_date =>p_effective_date
202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id

Line 205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag

201: ,p_effective_date =>p_effective_date
202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id

Line 206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id

202: ,p_budget_id_o =>pqh_bce_shd.g_old_rec.budget_id
203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency

Line 207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id

203: ,p_actual_commitment_type_o =>pqh_bce_shd.g_old_rec.actual_commitment_type
204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage

Line 208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id

204: ,p_element_type_id_o =>pqh_bce_shd.g_old_rec.element_type_id
205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number

Line 209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id

205: ,p_salary_basis_flag_o =>pqh_bce_shd.g_old_rec.salary_basis_flag
206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
213: );

Line 210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency

206: ,p_element_input_value_id_o =>pqh_bce_shd.g_old_rec.element_input_value_id
207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
213: );
214: --

Line 211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage

207: ,p_balance_type_id_o =>pqh_bce_shd.g_old_rec.balance_type_id
208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
213: );
214: --
215: exception

Line 212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number

208: ,p_frequency_input_value_id_o =>pqh_bce_shd.g_old_rec.frequency_input_value_id
209: ,p_formula_id_o =>pqh_bce_shd.g_old_rec.formula_id
210: ,p_dflt_elmnt_frequency_o =>pqh_bce_shd.g_old_rec.dflt_elmnt_frequency
211: ,p_overhead_percentage_o =>pqh_bce_shd.g_old_rec.overhead_percentage
212: ,p_object_version_number_o =>pqh_bce_shd.g_old_rec.object_version_number
213: );
214: --
215: exception
216: --

Line 274: Procedure convert_defs(p_rec in out nocopy pqh_bce_shd.g_rec_type) is

270: -- Internal Row Handler Use Only.
271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure convert_defs(p_rec in out nocopy pqh_bce_shd.g_rec_type) is
275: --
276: l_proc varchar2(72) := g_package||'convert_defs';
277: --
278: Begin

Line 289: pqh_bce_shd.g_old_rec.budget_id;

285: -- is being used then we must set to the 'current' argument value.
286: --
287: If (p_rec.budget_id = hr_api.g_number) then
288: p_rec.budget_id :=
289: pqh_bce_shd.g_old_rec.budget_id;
290: End If;
291: If (p_rec.actual_commitment_type = hr_api.g_varchar2) then
292: p_rec.actual_commitment_type :=
293: pqh_bce_shd.g_old_rec.actual_commitment_type;

Line 293: pqh_bce_shd.g_old_rec.actual_commitment_type;

289: pqh_bce_shd.g_old_rec.budget_id;
290: End If;
291: If (p_rec.actual_commitment_type = hr_api.g_varchar2) then
292: p_rec.actual_commitment_type :=
293: pqh_bce_shd.g_old_rec.actual_commitment_type;
294: End If;
295: If (p_rec.element_type_id = hr_api.g_number) then
296: p_rec.element_type_id :=
297: pqh_bce_shd.g_old_rec.element_type_id;

Line 297: pqh_bce_shd.g_old_rec.element_type_id;

293: pqh_bce_shd.g_old_rec.actual_commitment_type;
294: End If;
295: If (p_rec.element_type_id = hr_api.g_number) then
296: p_rec.element_type_id :=
297: pqh_bce_shd.g_old_rec.element_type_id;
298: End If;
299: If (p_rec.salary_basis_flag = hr_api.g_varchar2) then
300: p_rec.salary_basis_flag :=
301: pqh_bce_shd.g_old_rec.salary_basis_flag;

Line 301: pqh_bce_shd.g_old_rec.salary_basis_flag;

297: pqh_bce_shd.g_old_rec.element_type_id;
298: End If;
299: If (p_rec.salary_basis_flag = hr_api.g_varchar2) then
300: p_rec.salary_basis_flag :=
301: pqh_bce_shd.g_old_rec.salary_basis_flag;
302: End If;
303: If (p_rec.element_input_value_id = hr_api.g_number) then
304: p_rec.element_input_value_id :=
305: pqh_bce_shd.g_old_rec.element_input_value_id;

Line 305: pqh_bce_shd.g_old_rec.element_input_value_id;

301: pqh_bce_shd.g_old_rec.salary_basis_flag;
302: End If;
303: If (p_rec.element_input_value_id = hr_api.g_number) then
304: p_rec.element_input_value_id :=
305: pqh_bce_shd.g_old_rec.element_input_value_id;
306: End If;
307: If (p_rec.balance_type_id = hr_api.g_number) then
308: p_rec.balance_type_id :=
309: pqh_bce_shd.g_old_rec.balance_type_id;

Line 309: pqh_bce_shd.g_old_rec.balance_type_id;

305: pqh_bce_shd.g_old_rec.element_input_value_id;
306: End If;
307: If (p_rec.balance_type_id = hr_api.g_number) then
308: p_rec.balance_type_id :=
309: pqh_bce_shd.g_old_rec.balance_type_id;
310: End If;
311: If (p_rec.frequency_input_value_id = hr_api.g_number) then
312: p_rec.frequency_input_value_id :=
313: pqh_bce_shd.g_old_rec.frequency_input_value_id;

Line 313: pqh_bce_shd.g_old_rec.frequency_input_value_id;

309: pqh_bce_shd.g_old_rec.balance_type_id;
310: End If;
311: If (p_rec.frequency_input_value_id = hr_api.g_number) then
312: p_rec.frequency_input_value_id :=
313: pqh_bce_shd.g_old_rec.frequency_input_value_id;
314: End If;
315: If (p_rec.formula_id = hr_api.g_number) then
316: p_rec.formula_id :=
317: pqh_bce_shd.g_old_rec.formula_id;

Line 317: pqh_bce_shd.g_old_rec.formula_id;

313: pqh_bce_shd.g_old_rec.frequency_input_value_id;
314: End If;
315: If (p_rec.formula_id = hr_api.g_number) then
316: p_rec.formula_id :=
317: pqh_bce_shd.g_old_rec.formula_id;
318: End If;
319: If (p_rec.dflt_elmnt_frequency = hr_api.g_varchar2) then
320: p_rec.dflt_elmnt_frequency :=
321: pqh_bce_shd.g_old_rec.dflt_elmnt_frequency;

Line 321: pqh_bce_shd.g_old_rec.dflt_elmnt_frequency;

317: pqh_bce_shd.g_old_rec.formula_id;
318: End If;
319: If (p_rec.dflt_elmnt_frequency = hr_api.g_varchar2) then
320: p_rec.dflt_elmnt_frequency :=
321: pqh_bce_shd.g_old_rec.dflt_elmnt_frequency;
322: End If;
323: If (p_rec.overhead_percentage = hr_api.g_number) then
324: p_rec.overhead_percentage :=
325: pqh_bce_shd.g_old_rec.overhead_percentage;

Line 325: pqh_bce_shd.g_old_rec.overhead_percentage;

321: pqh_bce_shd.g_old_rec.dflt_elmnt_frequency;
322: End If;
323: If (p_rec.overhead_percentage = hr_api.g_number) then
324: p_rec.overhead_percentage :=
325: pqh_bce_shd.g_old_rec.overhead_percentage;
326: End If;
327:
328: --
329: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 339: p_rec in out nocopy pqh_bce_shd.g_rec_type

335: -- ----------------------------------------------------------------------------
336: Procedure upd
337: (
338: p_effective_date in date,
339: p_rec in out nocopy pqh_bce_shd.g_rec_type
340: ) is
341: --
342: l_proc varchar2(72) := g_package||'upd';
343: --

Line 349: pqh_bce_shd.lck

345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: -- We must lock the row which we need to update.
348: --
349: pqh_bce_shd.lck
350: (
351: p_rec.bdgt_cmmtmnt_elmnt_id,
352: p_rec.object_version_number
353: );

Line 399: l_rec pqh_bce_shd.g_rec_type;

395: p_overhead_percentage in number default hr_api.g_number,
396: p_object_version_number in out nocopy number
397: ) is
398: --
399: l_rec pqh_bce_shd.g_rec_type;
400: l_proc varchar2(72) := g_package||'upd';
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);

Line 409: pqh_bce_shd.convert_args

405: -- Call conversion function to turn arguments into the
406: -- l_rec structure.
407: --
408: l_rec :=
409: pqh_bce_shd.convert_args
410: (
411: p_bdgt_cmmtmnt_elmnt_id,
412: p_budget_id,
413: p_actual_commitment_type,