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_BST_UPD dependencies on PQH_BST_SHD

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

Line 88: pqh_bst_shd.constraint_error

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

Line 92: pqh_bst_shd.constraint_error

88: pqh_bst_shd.constraint_error
89: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
90: When hr_api.parent_integrity_violated Then
91: -- Parent integrity has been violated
92: pqh_bst_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: pqh_bst_shd.constraint_error

Line 96: pqh_bst_shd.constraint_error

92: pqh_bst_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: pqh_bst_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: Raise;
100: End update_dml;

Line 134: Procedure pre_update(p_rec in pqh_bst_shd.g_rec_type) is

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

Line 177: p_effective_date in date,p_rec in pqh_bst_shd.g_rec_type) is

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

Line 208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id

204: ,p_budget_unit1_value_type_cd =>p_rec.budget_unit1_value_type_cd
205: ,p_budget_unit2_value_type_cd =>p_rec.budget_unit2_value_type_cd
206: ,p_budget_unit3_value_type_cd =>p_rec.budget_unit3_value_type_cd
207: ,p_effective_date =>p_effective_date
208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent

Line 209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id

205: ,p_budget_unit2_value_type_cd =>p_rec.budget_unit2_value_type_cd
206: ,p_budget_unit3_value_type_cd =>p_rec.budget_unit3_value_type_cd
207: ,p_effective_date =>p_effective_date
208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value

Line 210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent

206: ,p_budget_unit3_value_type_cd =>p_rec.budget_unit3_value_type_cd
207: ,p_effective_date =>p_effective_date
208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value

Line 211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent

207: ,p_effective_date =>p_effective_date
208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value

Line 212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent

208: ,p_dflt_budget_set_id_o =>pqh_bst_shd.g_old_rec.dflt_budget_set_id
209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available

Line 213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value

209: ,p_budget_period_id_o =>pqh_bst_shd.g_old_rec.budget_period_id
210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available

Line 214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value

210: ,p_budget_unit1_percent_o =>pqh_bst_shd.g_old_rec.budget_unit1_percent
211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available

Line 215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value

211: ,p_budget_unit2_percent_o =>pqh_bst_shd.g_old_rec.budget_unit2_percent
212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
219: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number

Line 216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available

212: ,p_budget_unit3_percent_o =>pqh_bst_shd.g_old_rec.budget_unit3_percent
213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
219: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number
220: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd

Line 217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available

213: ,p_budget_unit1_value_o =>pqh_bst_shd.g_old_rec.budget_unit1_value
214: ,p_budget_unit2_value_o =>pqh_bst_shd.g_old_rec.budget_unit2_value
215: ,p_budget_unit3_value_o =>pqh_bst_shd.g_old_rec.budget_unit3_value
216: ,p_budget_unit1_available_o =>pqh_bst_shd.g_old_rec.budget_unit1_available
217: ,p_budget_unit2_available_o =>pqh_bst_shd.g_old_rec.budget_unit2_available
218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
219: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number
220: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit2_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd

Line 218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available

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

Line 219: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number

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

Line 220: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd

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

Line 221: ,p_budget_unit2_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd

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

Line 222: ,p_budget_unit3_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd

218: ,p_budget_unit3_available_o =>pqh_bst_shd.g_old_rec.budget_unit3_available
219: ,p_object_version_number_o =>pqh_bst_shd.g_old_rec.object_version_number
220: ,p_budget_unit1_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit2_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd
222: ,p_budget_unit3_value_type_cd_o =>pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd
223: );
224: --
225: exception
226: --

Line 284: Procedure convert_defs(p_rec in out nocopy pqh_bst_shd.g_rec_type) is

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

Line 299: pqh_bst_shd.g_old_rec.dflt_budget_set_id;

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

Line 303: pqh_bst_shd.g_old_rec.budget_period_id;

299: pqh_bst_shd.g_old_rec.dflt_budget_set_id;
300: End If;
301: If (p_rec.budget_period_id = hr_api.g_number) then
302: p_rec.budget_period_id :=
303: pqh_bst_shd.g_old_rec.budget_period_id;
304: End If;
305: If (p_rec.budget_unit1_percent = hr_api.g_number) then
306: p_rec.budget_unit1_percent :=
307: pqh_bst_shd.g_old_rec.budget_unit1_percent;

Line 307: pqh_bst_shd.g_old_rec.budget_unit1_percent;

303: pqh_bst_shd.g_old_rec.budget_period_id;
304: End If;
305: If (p_rec.budget_unit1_percent = hr_api.g_number) then
306: p_rec.budget_unit1_percent :=
307: pqh_bst_shd.g_old_rec.budget_unit1_percent;
308: End If;
309: If (p_rec.budget_unit2_percent = hr_api.g_number) then
310: p_rec.budget_unit2_percent :=
311: pqh_bst_shd.g_old_rec.budget_unit2_percent;

Line 311: pqh_bst_shd.g_old_rec.budget_unit2_percent;

307: pqh_bst_shd.g_old_rec.budget_unit1_percent;
308: End If;
309: If (p_rec.budget_unit2_percent = hr_api.g_number) then
310: p_rec.budget_unit2_percent :=
311: pqh_bst_shd.g_old_rec.budget_unit2_percent;
312: End If;
313: If (p_rec.budget_unit3_percent = hr_api.g_number) then
314: p_rec.budget_unit3_percent :=
315: pqh_bst_shd.g_old_rec.budget_unit3_percent;

Line 315: pqh_bst_shd.g_old_rec.budget_unit3_percent;

311: pqh_bst_shd.g_old_rec.budget_unit2_percent;
312: End If;
313: If (p_rec.budget_unit3_percent = hr_api.g_number) then
314: p_rec.budget_unit3_percent :=
315: pqh_bst_shd.g_old_rec.budget_unit3_percent;
316: End If;
317: If (p_rec.budget_unit1_value = hr_api.g_number) then
318: p_rec.budget_unit1_value :=
319: pqh_bst_shd.g_old_rec.budget_unit1_value;

Line 319: pqh_bst_shd.g_old_rec.budget_unit1_value;

315: pqh_bst_shd.g_old_rec.budget_unit3_percent;
316: End If;
317: If (p_rec.budget_unit1_value = hr_api.g_number) then
318: p_rec.budget_unit1_value :=
319: pqh_bst_shd.g_old_rec.budget_unit1_value;
320: End If;
321: If (p_rec.budget_unit2_value = hr_api.g_number) then
322: p_rec.budget_unit2_value :=
323: pqh_bst_shd.g_old_rec.budget_unit2_value;

Line 323: pqh_bst_shd.g_old_rec.budget_unit2_value;

319: pqh_bst_shd.g_old_rec.budget_unit1_value;
320: End If;
321: If (p_rec.budget_unit2_value = hr_api.g_number) then
322: p_rec.budget_unit2_value :=
323: pqh_bst_shd.g_old_rec.budget_unit2_value;
324: End If;
325: If (p_rec.budget_unit3_value = hr_api.g_number) then
326: p_rec.budget_unit3_value :=
327: pqh_bst_shd.g_old_rec.budget_unit3_value;

Line 327: pqh_bst_shd.g_old_rec.budget_unit3_value;

323: pqh_bst_shd.g_old_rec.budget_unit2_value;
324: End If;
325: If (p_rec.budget_unit3_value = hr_api.g_number) then
326: p_rec.budget_unit3_value :=
327: pqh_bst_shd.g_old_rec.budget_unit3_value;
328: End If;
329: If (p_rec.budget_unit1_available = hr_api.g_number) then
330: p_rec.budget_unit1_available :=
331: pqh_bst_shd.g_old_rec.budget_unit1_available;

Line 331: pqh_bst_shd.g_old_rec.budget_unit1_available;

327: pqh_bst_shd.g_old_rec.budget_unit3_value;
328: End If;
329: If (p_rec.budget_unit1_available = hr_api.g_number) then
330: p_rec.budget_unit1_available :=
331: pqh_bst_shd.g_old_rec.budget_unit1_available;
332: End If;
333: If (p_rec.budget_unit2_available = hr_api.g_number) then
334: p_rec.budget_unit2_available :=
335: pqh_bst_shd.g_old_rec.budget_unit2_available;

Line 335: pqh_bst_shd.g_old_rec.budget_unit2_available;

331: pqh_bst_shd.g_old_rec.budget_unit1_available;
332: End If;
333: If (p_rec.budget_unit2_available = hr_api.g_number) then
334: p_rec.budget_unit2_available :=
335: pqh_bst_shd.g_old_rec.budget_unit2_available;
336: End If;
337: If (p_rec.budget_unit3_available = hr_api.g_number) then
338: p_rec.budget_unit3_available :=
339: pqh_bst_shd.g_old_rec.budget_unit3_available;

Line 339: pqh_bst_shd.g_old_rec.budget_unit3_available;

335: pqh_bst_shd.g_old_rec.budget_unit2_available;
336: End If;
337: If (p_rec.budget_unit3_available = hr_api.g_number) then
338: p_rec.budget_unit3_available :=
339: pqh_bst_shd.g_old_rec.budget_unit3_available;
340: End If;
341: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
342: p_rec.budget_unit1_value_type_cd :=
343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;

Line 343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;

339: pqh_bst_shd.g_old_rec.budget_unit3_available;
340: End If;
341: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
342: p_rec.budget_unit1_value_type_cd :=
343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;
344: End If;
345: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
346: p_rec.budget_unit2_value_type_cd :=
347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;

Line 347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;

343: pqh_bst_shd.g_old_rec.budget_unit1_value_type_cd;
344: End If;
345: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
346: p_rec.budget_unit2_value_type_cd :=
347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;
348: End If;
349: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
350: p_rec.budget_unit3_value_type_cd :=
351: pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd;

Line 351: pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd;

347: pqh_bst_shd.g_old_rec.budget_unit2_value_type_cd;
348: End If;
349: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
350: p_rec.budget_unit3_value_type_cd :=
351: pqh_bst_shd.g_old_rec.budget_unit3_value_type_cd;
352: End If;
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: --

Line 364: p_rec in out nocopy pqh_bst_shd.g_rec_type

360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (
363: p_effective_date in date,
364: p_rec in out nocopy pqh_bst_shd.g_rec_type
365: ) is
366: --
367: l_proc varchar2(72) := g_package||'upd';
368: --

Line 374: pqh_bst_shd.lck

370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: -- We must lock the row which we need to update.
373: --
374: pqh_bst_shd.lck
375: (
376: p_rec.budget_set_id,
377: p_rec.object_version_number
378: );

Line 428: l_rec pqh_bst_shd.g_rec_type;

424: p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2,
425: p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
426: ) is
427: --
428: l_rec pqh_bst_shd.g_rec_type;
429: l_proc varchar2(72) := g_package||'upd';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);

Line 438: pqh_bst_shd.convert_args

434: -- Call conversion function to turn arguments into the
435: -- l_rec structure.
436: --
437: l_rec :=
438: pqh_bst_shd.convert_args
439: (
440: p_budget_set_id,
441: p_dflt_budget_set_id,
442: p_budget_period_id,