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_BPR_UPD dependencies on PQH_BPR_SHD

Line 48: Procedure update_dml(p_rec in out nocopy pqh_bpr_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_bpr_shd.g_rec_type) is
49: --
50: l_proc varchar2(72) := g_package||'update_dml';
51: --
52: Begin

Line 89: pqh_bpr_shd.constraint_error

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

Line 93: pqh_bpr_shd.constraint_error

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

Line 97: pqh_bpr_shd.constraint_error

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

Line 135: Procedure pre_update(p_rec in pqh_bpr_shd.g_rec_type) is

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

Line 177: Procedure post_update(p_rec in pqh_bpr_shd.g_rec_type) is

173: -- Internal Row Handler Use Only.
174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: Procedure post_update(p_rec in pqh_bpr_shd.g_rec_type) is
178: --
179: l_proc varchar2(72) := g_package||'post_update';
180: --
181: Begin

Line 208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id

204: ,p_budget_unit1_available =>p_rec.budget_unit1_available
205: ,p_budget_unit2_available =>p_rec.budget_unit2_available
206: ,p_budget_unit3_available =>p_rec.budget_unit3_available
207: ,p_object_version_number =>p_rec.object_version_number
208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent

Line 209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id

205: ,p_budget_unit2_available =>p_rec.budget_unit2_available
206: ,p_budget_unit3_available =>p_rec.budget_unit3_available
207: ,p_object_version_number =>p_rec.object_version_number
208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent

Line 210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id

206: ,p_budget_unit3_available =>p_rec.budget_unit3_available
207: ,p_object_version_number =>p_rec.object_version_number
208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value

Line 211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent

207: ,p_object_version_number =>p_rec.object_version_number
208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value

Line 212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent

208: ,p_budget_detail_id_o =>pqh_bpr_shd.g_old_rec.budget_detail_id
209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value

Line 213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent

209: ,p_start_time_period_id_o =>pqh_bpr_shd.g_old_rec.start_time_period_id
210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd

Line 214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value

210: ,p_end_time_period_id_o =>pqh_bpr_shd.g_old_rec.end_time_period_id
211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd

Line 215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value

211: ,p_budget_unit1_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit1_percent
212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd

Line 216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value

212: ,p_budget_unit2_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit2_percent
213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available

Line 217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd

213: ,p_budget_unit3_percent_o =>pqh_bpr_shd.g_old_rec.budget_unit3_percent
214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available

Line 218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd

214: ,p_budget_unit1_value_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value
215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available

Line 219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd

215: ,p_budget_unit2_value_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value
216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number

Line 220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available

216: ,p_budget_unit3_value_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value
217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
224: );

Line 221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available

217: ,p_budget_unit1_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd
218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
224: );
225: --

Line 222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available

218: ,p_budget_unit2_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd
219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
224: );
225: --
226: exception

Line 223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number

219: ,p_budget_unit3_value_type_cd_o =>pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd
220: ,p_budget_unit1_available_o =>pqh_bpr_shd.g_old_rec.budget_unit1_available
221: ,p_budget_unit2_available_o =>pqh_bpr_shd.g_old_rec.budget_unit2_available
222: ,p_budget_unit3_available_o =>pqh_bpr_shd.g_old_rec.budget_unit3_available
223: ,p_object_version_number_o =>pqh_bpr_shd.g_old_rec.object_version_number
224: );
225: --
226: exception
227: --

Line 285: Procedure convert_defs(p_rec in out nocopy pqh_bpr_shd.g_rec_type) is

281: -- Internal Row Handler Use Only.
282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure convert_defs(p_rec in out nocopy pqh_bpr_shd.g_rec_type) is
286: --
287: l_proc varchar2(72) := g_package||'convert_defs';
288: --
289: Begin

Line 300: pqh_bpr_shd.g_old_rec.budget_detail_id;

296: -- is being used then we must set to the 'current' argument value.
297: --
298: If (p_rec.budget_detail_id = hr_api.g_number) then
299: p_rec.budget_detail_id :=
300: pqh_bpr_shd.g_old_rec.budget_detail_id;
301: End If;
302: If (p_rec.start_time_period_id = hr_api.g_number) then
303: p_rec.start_time_period_id :=
304: pqh_bpr_shd.g_old_rec.start_time_period_id;

Line 304: pqh_bpr_shd.g_old_rec.start_time_period_id;

300: pqh_bpr_shd.g_old_rec.budget_detail_id;
301: End If;
302: If (p_rec.start_time_period_id = hr_api.g_number) then
303: p_rec.start_time_period_id :=
304: pqh_bpr_shd.g_old_rec.start_time_period_id;
305: End If;
306: If (p_rec.end_time_period_id = hr_api.g_number) then
307: p_rec.end_time_period_id :=
308: pqh_bpr_shd.g_old_rec.end_time_period_id;

Line 308: pqh_bpr_shd.g_old_rec.end_time_period_id;

304: pqh_bpr_shd.g_old_rec.start_time_period_id;
305: End If;
306: If (p_rec.end_time_period_id = hr_api.g_number) then
307: p_rec.end_time_period_id :=
308: pqh_bpr_shd.g_old_rec.end_time_period_id;
309: End If;
310: If (p_rec.budget_unit1_percent = hr_api.g_number) then
311: p_rec.budget_unit1_percent :=
312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;

Line 312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;

308: pqh_bpr_shd.g_old_rec.end_time_period_id;
309: End If;
310: If (p_rec.budget_unit1_percent = hr_api.g_number) then
311: p_rec.budget_unit1_percent :=
312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;
313: End If;
314: If (p_rec.budget_unit2_percent = hr_api.g_number) then
315: p_rec.budget_unit2_percent :=
316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;

Line 316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;

312: pqh_bpr_shd.g_old_rec.budget_unit1_percent;
313: End If;
314: If (p_rec.budget_unit2_percent = hr_api.g_number) then
315: p_rec.budget_unit2_percent :=
316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;
317: End If;
318: If (p_rec.budget_unit3_percent = hr_api.g_number) then
319: p_rec.budget_unit3_percent :=
320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;

Line 320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;

316: pqh_bpr_shd.g_old_rec.budget_unit2_percent;
317: End If;
318: If (p_rec.budget_unit3_percent = hr_api.g_number) then
319: p_rec.budget_unit3_percent :=
320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;
321: End If;
322: If (p_rec.budget_unit1_value = hr_api.g_number) then
323: p_rec.budget_unit1_value :=
324: pqh_bpr_shd.g_old_rec.budget_unit1_value;

Line 324: pqh_bpr_shd.g_old_rec.budget_unit1_value;

320: pqh_bpr_shd.g_old_rec.budget_unit3_percent;
321: End If;
322: If (p_rec.budget_unit1_value = hr_api.g_number) then
323: p_rec.budget_unit1_value :=
324: pqh_bpr_shd.g_old_rec.budget_unit1_value;
325: End If;
326: If (p_rec.budget_unit2_value = hr_api.g_number) then
327: p_rec.budget_unit2_value :=
328: pqh_bpr_shd.g_old_rec.budget_unit2_value;

Line 328: pqh_bpr_shd.g_old_rec.budget_unit2_value;

324: pqh_bpr_shd.g_old_rec.budget_unit1_value;
325: End If;
326: If (p_rec.budget_unit2_value = hr_api.g_number) then
327: p_rec.budget_unit2_value :=
328: pqh_bpr_shd.g_old_rec.budget_unit2_value;
329: End If;
330: If (p_rec.budget_unit3_value = hr_api.g_number) then
331: p_rec.budget_unit3_value :=
332: pqh_bpr_shd.g_old_rec.budget_unit3_value;

Line 332: pqh_bpr_shd.g_old_rec.budget_unit3_value;

328: pqh_bpr_shd.g_old_rec.budget_unit2_value;
329: End If;
330: If (p_rec.budget_unit3_value = hr_api.g_number) then
331: p_rec.budget_unit3_value :=
332: pqh_bpr_shd.g_old_rec.budget_unit3_value;
333: End If;
334: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
335: p_rec.budget_unit1_value_type_cd :=
336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;

Line 336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;

332: pqh_bpr_shd.g_old_rec.budget_unit3_value;
333: End If;
334: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
335: p_rec.budget_unit1_value_type_cd :=
336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;
337: End If;
338: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
339: p_rec.budget_unit2_value_type_cd :=
340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;

Line 340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;

336: pqh_bpr_shd.g_old_rec.budget_unit1_value_type_cd;
337: End If;
338: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
339: p_rec.budget_unit2_value_type_cd :=
340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;
341: End If;
342: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
343: p_rec.budget_unit3_value_type_cd :=
344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;

Line 344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;

340: pqh_bpr_shd.g_old_rec.budget_unit2_value_type_cd;
341: End If;
342: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
343: p_rec.budget_unit3_value_type_cd :=
344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;
345: End If;
346: If (p_rec.budget_unit1_available = hr_api.g_number) then
347: p_rec.budget_unit1_available :=
348: pqh_bpr_shd.g_old_rec.budget_unit1_available;

Line 348: pqh_bpr_shd.g_old_rec.budget_unit1_available;

344: pqh_bpr_shd.g_old_rec.budget_unit3_value_type_cd;
345: End If;
346: If (p_rec.budget_unit1_available = hr_api.g_number) then
347: p_rec.budget_unit1_available :=
348: pqh_bpr_shd.g_old_rec.budget_unit1_available;
349: End If;
350: If (p_rec.budget_unit2_available = hr_api.g_number) then
351: p_rec.budget_unit2_available :=
352: pqh_bpr_shd.g_old_rec.budget_unit2_available;

Line 352: pqh_bpr_shd.g_old_rec.budget_unit2_available;

348: pqh_bpr_shd.g_old_rec.budget_unit1_available;
349: End If;
350: If (p_rec.budget_unit2_available = hr_api.g_number) then
351: p_rec.budget_unit2_available :=
352: pqh_bpr_shd.g_old_rec.budget_unit2_available;
353: End If;
354: If (p_rec.budget_unit3_available = hr_api.g_number) then
355: p_rec.budget_unit3_available :=
356: pqh_bpr_shd.g_old_rec.budget_unit3_available;

Line 356: pqh_bpr_shd.g_old_rec.budget_unit3_available;

352: pqh_bpr_shd.g_old_rec.budget_unit2_available;
353: End If;
354: If (p_rec.budget_unit3_available = hr_api.g_number) then
355: p_rec.budget_unit3_available :=
356: pqh_bpr_shd.g_old_rec.budget_unit3_available;
357: End If;
358:
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 369: p_rec in out nocopy pqh_bpr_shd.g_rec_type

365: -- |---------------------------------< upd >----------------------------------|
366: -- ----------------------------------------------------------------------------
367: Procedure upd
368: (
369: p_rec in out nocopy pqh_bpr_shd.g_rec_type
370: ) is
371: --
372: l_proc varchar2(72) := g_package||'upd';
373: --

Line 379: pqh_bpr_shd.lck

375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- We must lock the row which we need to update.
378: --
379: pqh_bpr_shd.lck
380: (
381: p_rec.budget_period_id,
382: p_rec.object_version_number
383: );

Line 431: l_rec pqh_bpr_shd.g_rec_type;

427: p_budget_unit3_available in number default hr_api.g_number,
428: p_object_version_number in out nocopy number
429: ) is
430: --
431: l_rec pqh_bpr_shd.g_rec_type;
432: l_proc varchar2(72) := g_package||'upd';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);

Line 441: pqh_bpr_shd.convert_args

437: -- Call conversion function to turn arguments into the
438: -- l_rec structure.
439: --
440: l_rec :=
441: pqh_bpr_shd.convert_args
442: (
443: p_budget_period_id,
444: p_budget_detail_id,
445: p_start_time_period_id,