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_BDT_UPD dependencies on PQH_BDT_SHD

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

Line 92: pqh_bdt_shd.constraint_error

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

Line 96: pqh_bdt_shd.constraint_error

92: pqh_bdt_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqh_bdt_shd.constraint_error

Line 100: pqh_bdt_shd.constraint_error

96: pqh_bdt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.unique_integrity_violated Then
99: -- Unique integrity has been violated
100: pqh_bdt_shd.constraint_error
101: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
102: When Others Then
103: Raise;
104: End update_dml;

Line 138: Procedure pre_update(p_rec in pqh_bdt_shd.g_rec_type) is

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

Line 180: Procedure post_update(p_rec in pqh_bdt_shd.g_rec_type) is

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

Line 214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id

210: ,p_budget_unit3_value =>p_rec.budget_unit3_value
211: ,p_budget_unit3_available =>p_rec.budget_unit3_available
212: ,p_gl_status =>p_rec.gl_status
213: ,p_object_version_number =>p_rec.object_version_number
214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id

Line 215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id

211: ,p_budget_unit3_available =>p_rec.budget_unit3_available
212: ,p_gl_status =>p_rec.gl_status
213: ,p_object_version_number =>p_rec.object_version_number
214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent

Line 216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id

212: ,p_gl_status =>p_rec.gl_status
213: ,p_object_version_number =>p_rec.object_version_number
214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd

Line 217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id

213: ,p_object_version_number =>p_rec.object_version_number
214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value

Line 218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id

214: ,p_organization_id_o =>pqh_bdt_shd.g_old_rec.organization_id
215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available

Line 219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent

215: ,p_job_id_o =>pqh_bdt_shd.g_old_rec.job_id
216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent

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

216: ,p_position_id_o =>pqh_bdt_shd.g_old_rec.position_id
217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd

Line 221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value

217: ,p_grade_id_o =>pqh_bdt_shd.g_old_rec.grade_id
218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value

Line 222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available

218: ,p_budget_version_id_o =>pqh_bdt_shd.g_old_rec.budget_version_id
219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available

Line 223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent

219: ,p_budget_unit1_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit1_percent
220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent

Line 224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd

220: ,p_budget_unit1_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd
221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd

Line 225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value

221: ,p_budget_unit1_value_o =>pqh_bdt_shd.g_old_rec.budget_unit1_value
222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value

Line 226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available

222: ,p_budget_unit1_available_o =>pqh_bdt_shd.g_old_rec.budget_unit1_available
223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available

Line 227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent

223: ,p_budget_unit2_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit2_percent
224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status

Line 228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd

224: ,p_budget_unit2_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd
225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number

Line 229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value

225: ,p_budget_unit2_value_o =>pqh_bdt_shd.g_old_rec.budget_unit2_value
226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
233: );

Line 230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available

226: ,p_budget_unit2_available_o =>pqh_bdt_shd.g_old_rec.budget_unit2_available
227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
233: );
234: --

Line 231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status

227: ,p_budget_unit3_percent_o =>pqh_bdt_shd.g_old_rec.budget_unit3_percent
228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
233: );
234: --
235: exception

Line 232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number

228: ,p_budget_unit3_value_type_cd_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd
229: ,p_budget_unit3_value_o =>pqh_bdt_shd.g_old_rec.budget_unit3_value
230: ,p_budget_unit3_available_o =>pqh_bdt_shd.g_old_rec.budget_unit3_available
231: ,p_gl_status_o =>pqh_bdt_shd.g_old_rec.gl_status
232: ,p_object_version_number_o =>pqh_bdt_shd.g_old_rec.object_version_number
233: );
234: --
235: exception
236: --

Line 294: Procedure convert_defs(p_rec in out nocopy pqh_bdt_shd.g_rec_type) is

290: -- Internal Row Handler Use Only.
291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure convert_defs(p_rec in out nocopy pqh_bdt_shd.g_rec_type) is
295: --
296: l_proc varchar2(72) := g_package||'convert_defs';
297: --
298: Begin

Line 309: pqh_bdt_shd.g_old_rec.organization_id;

305: -- is being used then we must set to the 'current' argument value.
306: --
307: If (p_rec.organization_id = hr_api.g_number) then
308: p_rec.organization_id :=
309: pqh_bdt_shd.g_old_rec.organization_id;
310: End If;
311: If (p_rec.job_id = hr_api.g_number) then
312: p_rec.job_id :=
313: pqh_bdt_shd.g_old_rec.job_id;

Line 313: pqh_bdt_shd.g_old_rec.job_id;

309: pqh_bdt_shd.g_old_rec.organization_id;
310: End If;
311: If (p_rec.job_id = hr_api.g_number) then
312: p_rec.job_id :=
313: pqh_bdt_shd.g_old_rec.job_id;
314: End If;
315: If (p_rec.position_id = hr_api.g_number) then
316: p_rec.position_id :=
317: pqh_bdt_shd.g_old_rec.position_id;

Line 317: pqh_bdt_shd.g_old_rec.position_id;

313: pqh_bdt_shd.g_old_rec.job_id;
314: End If;
315: If (p_rec.position_id = hr_api.g_number) then
316: p_rec.position_id :=
317: pqh_bdt_shd.g_old_rec.position_id;
318: End If;
319: If (p_rec.grade_id = hr_api.g_number) then
320: p_rec.grade_id :=
321: pqh_bdt_shd.g_old_rec.grade_id;

Line 321: pqh_bdt_shd.g_old_rec.grade_id;

317: pqh_bdt_shd.g_old_rec.position_id;
318: End If;
319: If (p_rec.grade_id = hr_api.g_number) then
320: p_rec.grade_id :=
321: pqh_bdt_shd.g_old_rec.grade_id;
322: End If;
323: If (p_rec.budget_version_id = hr_api.g_number) then
324: p_rec.budget_version_id :=
325: pqh_bdt_shd.g_old_rec.budget_version_id;

Line 325: pqh_bdt_shd.g_old_rec.budget_version_id;

321: pqh_bdt_shd.g_old_rec.grade_id;
322: End If;
323: If (p_rec.budget_version_id = hr_api.g_number) then
324: p_rec.budget_version_id :=
325: pqh_bdt_shd.g_old_rec.budget_version_id;
326: End If;
327: If (p_rec.budget_unit1_percent = hr_api.g_number) then
328: p_rec.budget_unit1_percent :=
329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;

Line 329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;

325: pqh_bdt_shd.g_old_rec.budget_version_id;
326: End If;
327: If (p_rec.budget_unit1_percent = hr_api.g_number) then
328: p_rec.budget_unit1_percent :=
329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;
330: End If;
331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
332: p_rec.budget_unit1_value_type_cd :=
333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;

Line 333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;

329: pqh_bdt_shd.g_old_rec.budget_unit1_percent;
330: End If;
331: If (p_rec.budget_unit1_value_type_cd = hr_api.g_varchar2) then
332: p_rec.budget_unit1_value_type_cd :=
333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;
334: End If;
335: If (p_rec.budget_unit1_value = hr_api.g_number) then
336: p_rec.budget_unit1_value :=
337: pqh_bdt_shd.g_old_rec.budget_unit1_value;

Line 337: pqh_bdt_shd.g_old_rec.budget_unit1_value;

333: pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd;
334: End If;
335: If (p_rec.budget_unit1_value = hr_api.g_number) then
336: p_rec.budget_unit1_value :=
337: pqh_bdt_shd.g_old_rec.budget_unit1_value;
338: End If;
339: If (p_rec.budget_unit1_available = hr_api.g_number) then
340: p_rec.budget_unit1_available :=
341: pqh_bdt_shd.g_old_rec.budget_unit1_available;

Line 341: pqh_bdt_shd.g_old_rec.budget_unit1_available;

337: pqh_bdt_shd.g_old_rec.budget_unit1_value;
338: End If;
339: If (p_rec.budget_unit1_available = hr_api.g_number) then
340: p_rec.budget_unit1_available :=
341: pqh_bdt_shd.g_old_rec.budget_unit1_available;
342: End If;
343: If (p_rec.budget_unit2_percent = hr_api.g_number) then
344: p_rec.budget_unit2_percent :=
345: pqh_bdt_shd.g_old_rec.budget_unit2_percent;

Line 345: pqh_bdt_shd.g_old_rec.budget_unit2_percent;

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

Line 349: pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd;

345: pqh_bdt_shd.g_old_rec.budget_unit2_percent;
346: End If;
347: If (p_rec.budget_unit2_value_type_cd = hr_api.g_varchar2) then
348: p_rec.budget_unit2_value_type_cd :=
349: pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd;
350: End If;
351: If (p_rec.budget_unit2_value = hr_api.g_number) then
352: p_rec.budget_unit2_value :=
353: pqh_bdt_shd.g_old_rec.budget_unit2_value;

Line 353: pqh_bdt_shd.g_old_rec.budget_unit2_value;

349: pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd;
350: End If;
351: If (p_rec.budget_unit2_value = hr_api.g_number) then
352: p_rec.budget_unit2_value :=
353: pqh_bdt_shd.g_old_rec.budget_unit2_value;
354: End If;
355: If (p_rec.budget_unit2_available = hr_api.g_number) then
356: p_rec.budget_unit2_available :=
357: pqh_bdt_shd.g_old_rec.budget_unit2_available;

Line 357: pqh_bdt_shd.g_old_rec.budget_unit2_available;

353: pqh_bdt_shd.g_old_rec.budget_unit2_value;
354: End If;
355: If (p_rec.budget_unit2_available = hr_api.g_number) then
356: p_rec.budget_unit2_available :=
357: pqh_bdt_shd.g_old_rec.budget_unit2_available;
358: End If;
359: If (p_rec.budget_unit3_percent = hr_api.g_number) then
360: p_rec.budget_unit3_percent :=
361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;

Line 361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;

357: pqh_bdt_shd.g_old_rec.budget_unit2_available;
358: End If;
359: If (p_rec.budget_unit3_percent = hr_api.g_number) then
360: p_rec.budget_unit3_percent :=
361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;
362: End If;
363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
364: p_rec.budget_unit3_value_type_cd :=
365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;

Line 365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;

361: pqh_bdt_shd.g_old_rec.budget_unit3_percent;
362: End If;
363: If (p_rec.budget_unit3_value_type_cd = hr_api.g_varchar2) then
364: p_rec.budget_unit3_value_type_cd :=
365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;
366: End If;
367: If (p_rec.budget_unit3_value = hr_api.g_number) then
368: p_rec.budget_unit3_value :=
369: pqh_bdt_shd.g_old_rec.budget_unit3_value;

Line 369: pqh_bdt_shd.g_old_rec.budget_unit3_value;

365: pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd;
366: End If;
367: If (p_rec.budget_unit3_value = hr_api.g_number) then
368: p_rec.budget_unit3_value :=
369: pqh_bdt_shd.g_old_rec.budget_unit3_value;
370: End If;
371: If (p_rec.budget_unit3_available = hr_api.g_number) then
372: p_rec.budget_unit3_available :=
373: pqh_bdt_shd.g_old_rec.budget_unit3_available;

Line 373: pqh_bdt_shd.g_old_rec.budget_unit3_available;

369: pqh_bdt_shd.g_old_rec.budget_unit3_value;
370: End If;
371: If (p_rec.budget_unit3_available = hr_api.g_number) then
372: p_rec.budget_unit3_available :=
373: pqh_bdt_shd.g_old_rec.budget_unit3_available;
374: End If;
375: If (p_rec.gl_status = hr_api.g_varchar2) then
376: p_rec.gl_status :=
377: pqh_bdt_shd.g_old_rec.gl_status;

Line 377: pqh_bdt_shd.g_old_rec.gl_status;

373: pqh_bdt_shd.g_old_rec.budget_unit3_available;
374: End If;
375: If (p_rec.gl_status = hr_api.g_varchar2) then
376: p_rec.gl_status :=
377: pqh_bdt_shd.g_old_rec.gl_status;
378: End If;
379:
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 390: p_rec in out nocopy pqh_bdt_shd.g_rec_type

386: -- |---------------------------------< upd >----------------------------------|
387: -- ----------------------------------------------------------------------------
388: Procedure upd
389: (
390: p_rec in out nocopy pqh_bdt_shd.g_rec_type
391: ) is
392: --
393: l_proc varchar2(72) := g_package||'upd';
394: --

Line 400: pqh_bdt_shd.lck

396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- We must lock the row which we need to update.
399: --
400: pqh_bdt_shd.lck
401: (
402: p_rec.budget_detail_id,
403: p_rec.object_version_number
404: );

Line 455: l_rec pqh_bdt_shd.g_rec_type;

451: p_gl_status in varchar2 default hr_api.g_varchar2,
452: p_object_version_number in out nocopy number
453: ) is
454: --
455: l_rec pqh_bdt_shd.g_rec_type;
456: l_proc varchar2(72) := g_package||'upd';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);

Line 465: pqh_bdt_shd.convert_args

461: -- Call conversion function to turn arguments into the
462: -- l_rec structure.
463: --
464: l_rec :=
465: pqh_bdt_shd.convert_args
466: (
467: p_budget_detail_id,
468: p_organization_id,
469: p_job_id,