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_WPR_UPD dependencies on PQH_WPR_SHD

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

Line 89: pqh_wpr_shd.constraint_error

85: --
86: Exception
87: When hr_api.check_integrity_violated Then
88: -- A check constraint has been violated
89: pqh_wpr_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_wpr_shd.constraint_error

Line 93: pqh_wpr_shd.constraint_error

89: pqh_wpr_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_wpr_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_wpr_shd.constraint_error

Line 97: pqh_wpr_shd.constraint_error

93: pqh_wpr_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_wpr_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_wpr_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_wpr_shd.g_rec_type) is
136: --
137: l_proc varchar2(72) := g_package||'pre_update';
138: --
139: Begin

Line 178: p_effective_date in date,p_rec in pqh_wpr_shd.g_rec_type) is

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

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

206: ,p_budget_unit3_available =>p_rec.budget_unit3_available
207: ,p_budget_unit2_available =>p_rec.budget_unit2_available
208: ,p_budget_unit1_available =>p_rec.budget_unit1_available
209: ,p_effective_date =>p_effective_date
210: ,p_end_time_period_id_o =>pqh_wpr_shd.g_old_rec.end_time_period_id
211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent

Line 211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id

207: ,p_budget_unit2_available =>p_rec.budget_unit2_available
208: ,p_budget_unit1_available =>p_rec.budget_unit1_available
209: ,p_effective_date =>p_effective_date
210: ,p_end_time_period_id_o =>pqh_wpr_shd.g_old_rec.end_time_period_id
211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value

Line 212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent

208: ,p_budget_unit1_available =>p_rec.budget_unit1_available
209: ,p_effective_date =>p_effective_date
210: ,p_end_time_period_id_o =>pqh_wpr_shd.g_old_rec.end_time_period_id
211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value

Line 213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent

209: ,p_effective_date =>p_effective_date
210: ,p_end_time_period_id_o =>pqh_wpr_shd.g_old_rec.end_time_period_id
211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value

Line 214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent

210: ,p_end_time_period_id_o =>pqh_wpr_shd.g_old_rec.end_time_period_id
211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number

Line 215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value

211: ,p_worksheet_detail_id_o =>pqh_wpr_shd.g_old_rec.worksheet_detail_id
212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd

Line 216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value

212: ,p_budget_unit1_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit1_percent
213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd

Line 217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value

213: ,p_budget_unit2_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit2_percent
214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd

Line 218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number

214: ,p_budget_unit3_percent_o =>pqh_wpr_shd.g_old_rec.budget_unit3_percent
215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id

Line 219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd

215: ,p_budget_unit1_value_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value
216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available

Line 220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd

216: ,p_budget_unit2_value_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value
217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available
224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available

Line 221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd

217: ,p_budget_unit3_value_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value
218: ,p_object_version_number_o =>pqh_wpr_shd.g_old_rec.object_version_number
219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available
224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available
225: ,p_budget_unit1_available_o =>pqh_wpr_shd.g_old_rec.budget_unit1_available

Line 222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id

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

Line 223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available

219: ,p_budget_unit1_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd
220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available
224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available
225: ,p_budget_unit1_available_o =>pqh_wpr_shd.g_old_rec.budget_unit1_available
226: );
227: --

Line 224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available

220: ,p_budget_unit2_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd
221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available
224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available
225: ,p_budget_unit1_available_o =>pqh_wpr_shd.g_old_rec.budget_unit1_available
226: );
227: --
228: exception

Line 225: ,p_budget_unit1_available_o =>pqh_wpr_shd.g_old_rec.budget_unit1_available

221: ,p_budget_unit3_value_type_cd_o =>pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd
222: ,p_start_time_period_id_o =>pqh_wpr_shd.g_old_rec.start_time_period_id
223: ,p_budget_unit3_available_o =>pqh_wpr_shd.g_old_rec.budget_unit3_available
224: ,p_budget_unit2_available_o =>pqh_wpr_shd.g_old_rec.budget_unit2_available
225: ,p_budget_unit1_available_o =>pqh_wpr_shd.g_old_rec.budget_unit1_available
226: );
227: --
228: exception
229: --

Line 287: Procedure convert_defs(p_rec in out nocopy pqh_wpr_shd.g_rec_type) is

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

Line 302: pqh_wpr_shd.g_old_rec.end_time_period_id;

298: -- is being used then we must set to the 'current' argument value.
299: --
300: If (p_rec.end_time_period_id = hr_api.g_number) then
301: p_rec.end_time_period_id :=
302: pqh_wpr_shd.g_old_rec.end_time_period_id;
303: End If;
304: If (p_rec.worksheet_detail_id = hr_api.g_number) then
305: p_rec.worksheet_detail_id :=
306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;

Line 306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;

302: pqh_wpr_shd.g_old_rec.end_time_period_id;
303: End If;
304: If (p_rec.worksheet_detail_id = hr_api.g_number) then
305: p_rec.worksheet_detail_id :=
306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;
307: End If;
308: If (p_rec.budget_unit1_percent = hr_api.g_number) then
309: p_rec.budget_unit1_percent :=
310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;

Line 310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;

306: pqh_wpr_shd.g_old_rec.worksheet_detail_id;
307: End If;
308: If (p_rec.budget_unit1_percent = hr_api.g_number) then
309: p_rec.budget_unit1_percent :=
310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;
311: End If;
312: If (p_rec.budget_unit2_percent = hr_api.g_number) then
313: p_rec.budget_unit2_percent :=
314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;

Line 314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;

310: pqh_wpr_shd.g_old_rec.budget_unit1_percent;
311: End If;
312: If (p_rec.budget_unit2_percent = hr_api.g_number) then
313: p_rec.budget_unit2_percent :=
314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;
315: End If;
316: If (p_rec.budget_unit3_percent = hr_api.g_number) then
317: p_rec.budget_unit3_percent :=
318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;

Line 318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;

314: pqh_wpr_shd.g_old_rec.budget_unit2_percent;
315: End If;
316: If (p_rec.budget_unit3_percent = hr_api.g_number) then
317: p_rec.budget_unit3_percent :=
318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;
319: End If;
320: If (p_rec.budget_unit1_value = hr_api.g_number) then
321: p_rec.budget_unit1_value :=
322: pqh_wpr_shd.g_old_rec.budget_unit1_value;

Line 322: pqh_wpr_shd.g_old_rec.budget_unit1_value;

318: pqh_wpr_shd.g_old_rec.budget_unit3_percent;
319: End If;
320: If (p_rec.budget_unit1_value = hr_api.g_number) then
321: p_rec.budget_unit1_value :=
322: pqh_wpr_shd.g_old_rec.budget_unit1_value;
323: End If;
324: If (p_rec.budget_unit2_value = hr_api.g_number) then
325: p_rec.budget_unit2_value :=
326: pqh_wpr_shd.g_old_rec.budget_unit2_value;

Line 326: pqh_wpr_shd.g_old_rec.budget_unit2_value;

322: pqh_wpr_shd.g_old_rec.budget_unit1_value;
323: End If;
324: If (p_rec.budget_unit2_value = hr_api.g_number) then
325: p_rec.budget_unit2_value :=
326: pqh_wpr_shd.g_old_rec.budget_unit2_value;
327: End If;
328: If (p_rec.budget_unit3_value = hr_api.g_number) then
329: p_rec.budget_unit3_value :=
330: pqh_wpr_shd.g_old_rec.budget_unit3_value;

Line 330: pqh_wpr_shd.g_old_rec.budget_unit3_value;

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

Line 334: pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd;

330: pqh_wpr_shd.g_old_rec.budget_unit3_value;
331: End If;
332: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
333: p_rec.budget_unit1_value_type_cd :=
334: pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd;
335: End If;
336: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
337: p_rec.budget_unit2_value_type_cd :=
338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;

Line 338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;

334: pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd;
335: End If;
336: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
337: p_rec.budget_unit2_value_type_cd :=
338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;
339: End If;
340: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
341: p_rec.budget_unit3_value_type_cd :=
342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;

Line 342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;

338: pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd;
339: End If;
340: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
341: p_rec.budget_unit3_value_type_cd :=
342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;
343: End If;
344: If (p_rec.start_time_period_id = hr_api.g_number) then
345: p_rec.start_time_period_id :=
346: pqh_wpr_shd.g_old_rec.start_time_period_id;

Line 346: pqh_wpr_shd.g_old_rec.start_time_period_id;

342: pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd;
343: End If;
344: If (p_rec.start_time_period_id = hr_api.g_number) then
345: p_rec.start_time_period_id :=
346: pqh_wpr_shd.g_old_rec.start_time_period_id;
347: End If;
348: If (p_rec.budget_unit3_available = hr_api.g_number) then
349: p_rec.budget_unit3_available :=
350: pqh_wpr_shd.g_old_rec.budget_unit3_available;

Line 350: pqh_wpr_shd.g_old_rec.budget_unit3_available;

346: pqh_wpr_shd.g_old_rec.start_time_period_id;
347: End If;
348: If (p_rec.budget_unit3_available = hr_api.g_number) then
349: p_rec.budget_unit3_available :=
350: pqh_wpr_shd.g_old_rec.budget_unit3_available;
351: End If;
352: If (p_rec.budget_unit2_available = hr_api.g_number) then
353: p_rec.budget_unit2_available :=
354: pqh_wpr_shd.g_old_rec.budget_unit2_available;

Line 354: pqh_wpr_shd.g_old_rec.budget_unit2_available;

350: pqh_wpr_shd.g_old_rec.budget_unit3_available;
351: End If;
352: If (p_rec.budget_unit2_available = hr_api.g_number) then
353: p_rec.budget_unit2_available :=
354: pqh_wpr_shd.g_old_rec.budget_unit2_available;
355: End If;
356: If (p_rec.budget_unit1_available = hr_api.g_number) then
357: p_rec.budget_unit1_available :=
358: pqh_wpr_shd.g_old_rec.budget_unit1_available;

Line 358: pqh_wpr_shd.g_old_rec.budget_unit1_available;

354: pqh_wpr_shd.g_old_rec.budget_unit2_available;
355: End If;
356: If (p_rec.budget_unit1_available = hr_api.g_number) then
357: p_rec.budget_unit1_available :=
358: pqh_wpr_shd.g_old_rec.budget_unit1_available;
359: End If;
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 10);
362: --

Line 371: p_rec in out nocopy pqh_wpr_shd.g_rec_type

367: -- ----------------------------------------------------------------------------
368: Procedure upd
369: (
370: p_effective_date in date,
371: p_rec in out nocopy pqh_wpr_shd.g_rec_type
372: ) is
373: --
374: l_proc varchar2(72) := g_package||'upd';
375: --

Line 381: pqh_wpr_shd.lck

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

Line 436: l_rec pqh_wpr_shd.g_rec_type;

432: p_budget_unit2_available in number default hr_api.g_number,
433: p_budget_unit1_available in number default hr_api.g_number
434: ) is
435: --
436: l_rec pqh_wpr_shd.g_rec_type;
437: l_proc varchar2(72) := g_package||'upd';
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);

Line 446: pqh_wpr_shd.convert_args

442: -- Call conversion function to turn arguments into the
443: -- l_rec structure.
444: --
445: l_rec :=
446: pqh_wpr_shd.convert_args
447: (
448: p_worksheet_period_id,
449: p_end_time_period_id,
450: p_worksheet_detail_id,