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_WKS_UPD dependencies on PQH_WKS_SHD

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

Line 85: pqh_wks_shd.constraint_error

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

Line 89: pqh_wks_shd.constraint_error

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

Line 93: pqh_wks_shd.constraint_error

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

Line 131: Procedure pre_update(p_rec in pqh_wks_shd.g_rec_type) is

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

Line 174: p_effective_date in date,p_rec in pqh_wks_shd.g_rec_type) is

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

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

198: ,p_budget_version_id =>p_rec.budget_version_id
199: ,p_propagation_method =>p_rec.propagation_method
200: ,p_effective_date =>p_effective_date
201: ,p_wf_transaction_category_id =>p_rec.wf_transaction_category_id
202: ,p_budget_id_o =>pqh_wks_shd.g_old_rec.budget_id
203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from

Line 203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name

199: ,p_propagation_method =>p_rec.propagation_method
200: ,p_effective_date =>p_effective_date
201: ,p_wf_transaction_category_id =>p_rec.wf_transaction_category_id
202: ,p_budget_id_o =>pqh_wks_shd.g_old_rec.budget_id
203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to

Line 204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number

200: ,p_effective_date =>p_effective_date
201: ,p_wf_transaction_category_id =>p_rec.wf_transaction_category_id
202: ,p_budget_id_o =>pqh_wks_shd.g_old_rec.budget_id
203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd

Line 205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date

201: ,p_wf_transaction_category_id =>p_rec.wf_transaction_category_id
202: ,p_budget_id_o =>pqh_wks_shd.g_old_rec.budget_id
203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status

Line 206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from

202: ,p_budget_id_o =>pqh_wks_shd.g_old_rec.budget_id
203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number

Line 207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to

203: ,p_worksheet_name_o =>pqh_wks_shd.g_old_rec.worksheet_name
204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id

Line 208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd

204: ,p_version_number_o =>pqh_wks_shd.g_old_rec.version_number
205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method

Line 209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status

205: ,p_action_date_o =>pqh_wks_shd.g_old_rec.action_date
206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method
213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id

Line 210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number

206: ,p_date_from_o =>pqh_wks_shd.g_old_rec.date_from
207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method
213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id
214: );

Line 211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id

207: ,p_date_to_o =>pqh_wks_shd.g_old_rec.date_to
208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method
213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id
214: );
215: --

Line 212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method

208: ,p_worksheet_mode_cd_o =>pqh_wks_shd.g_old_rec.worksheet_mode_cd
209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method
213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id
214: );
215: --
216: exception

Line 213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id

209: ,p_transaction_status_o =>pqh_wks_shd.g_old_rec.transaction_status
210: ,p_object_version_number_o =>pqh_wks_shd.g_old_rec.object_version_number
211: ,p_budget_version_id_o =>pqh_wks_shd.g_old_rec.budget_version_id
212: ,p_propagation_method_o =>pqh_wks_shd.g_old_rec.propagation_method
213: ,p_wf_transaction_category_id_o =>pqh_wks_shd.g_old_rec.wf_transaction_category_id
214: );
215: --
216: exception
217: --

Line 275: Procedure convert_defs(p_rec in out nocopy pqh_wks_shd.g_rec_type) is

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

Line 290: pqh_wks_shd.g_old_rec.budget_id;

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

Line 294: pqh_wks_shd.g_old_rec.worksheet_name;

290: pqh_wks_shd.g_old_rec.budget_id;
291: End If;
292: If (p_rec.worksheet_name = hr_api.g_varchar2) then
293: p_rec.worksheet_name :=
294: pqh_wks_shd.g_old_rec.worksheet_name;
295: End If;
296: If (p_rec.version_number = hr_api.g_number) then
297: p_rec.version_number :=
298: pqh_wks_shd.g_old_rec.version_number;

Line 298: pqh_wks_shd.g_old_rec.version_number;

294: pqh_wks_shd.g_old_rec.worksheet_name;
295: End If;
296: If (p_rec.version_number = hr_api.g_number) then
297: p_rec.version_number :=
298: pqh_wks_shd.g_old_rec.version_number;
299: End If;
300: If (p_rec.action_date = hr_api.g_date) then
301: p_rec.action_date :=
302: pqh_wks_shd.g_old_rec.action_date;

Line 302: pqh_wks_shd.g_old_rec.action_date;

298: pqh_wks_shd.g_old_rec.version_number;
299: End If;
300: If (p_rec.action_date = hr_api.g_date) then
301: p_rec.action_date :=
302: pqh_wks_shd.g_old_rec.action_date;
303: End If;
304: If (p_rec.date_from = hr_api.g_date) then
305: p_rec.date_from :=
306: pqh_wks_shd.g_old_rec.date_from;

Line 306: pqh_wks_shd.g_old_rec.date_from;

302: pqh_wks_shd.g_old_rec.action_date;
303: End If;
304: If (p_rec.date_from = hr_api.g_date) then
305: p_rec.date_from :=
306: pqh_wks_shd.g_old_rec.date_from;
307: End If;
308: If (p_rec.date_to = hr_api.g_date) then
309: p_rec.date_to :=
310: pqh_wks_shd.g_old_rec.date_to;

Line 310: pqh_wks_shd.g_old_rec.date_to;

306: pqh_wks_shd.g_old_rec.date_from;
307: End If;
308: If (p_rec.date_to = hr_api.g_date) then
309: p_rec.date_to :=
310: pqh_wks_shd.g_old_rec.date_to;
311: End If;
312: If (p_rec.worksheet_mode_cd = hr_api.g_varchar2) then
313: p_rec.worksheet_mode_cd :=
314: pqh_wks_shd.g_old_rec.worksheet_mode_cd;

Line 314: pqh_wks_shd.g_old_rec.worksheet_mode_cd;

310: pqh_wks_shd.g_old_rec.date_to;
311: End If;
312: If (p_rec.worksheet_mode_cd = hr_api.g_varchar2) then
313: p_rec.worksheet_mode_cd :=
314: pqh_wks_shd.g_old_rec.worksheet_mode_cd;
315: End If;
316: If (p_rec.transaction_status = hr_api.g_varchar2) then
317: p_rec.transaction_status :=
318: pqh_wks_shd.g_old_rec.transaction_status;

Line 318: pqh_wks_shd.g_old_rec.transaction_status;

314: pqh_wks_shd.g_old_rec.worksheet_mode_cd;
315: End If;
316: If (p_rec.transaction_status = hr_api.g_varchar2) then
317: p_rec.transaction_status :=
318: pqh_wks_shd.g_old_rec.transaction_status;
319: End If;
320: If (p_rec.budget_version_id = hr_api.g_number) then
321: p_rec.budget_version_id :=
322: pqh_wks_shd.g_old_rec.budget_version_id;

Line 322: pqh_wks_shd.g_old_rec.budget_version_id;

318: pqh_wks_shd.g_old_rec.transaction_status;
319: End If;
320: If (p_rec.budget_version_id = hr_api.g_number) then
321: p_rec.budget_version_id :=
322: pqh_wks_shd.g_old_rec.budget_version_id;
323: End If;
324: If (p_rec.propagation_method = hr_api.g_varchar2) then
325: p_rec.propagation_method :=
326: pqh_wks_shd.g_old_rec.propagation_method;

Line 326: pqh_wks_shd.g_old_rec.propagation_method;

322: pqh_wks_shd.g_old_rec.budget_version_id;
323: End If;
324: If (p_rec.propagation_method = hr_api.g_varchar2) then
325: p_rec.propagation_method :=
326: pqh_wks_shd.g_old_rec.propagation_method;
327: End If;
328: If (p_rec.wf_transaction_category_id = hr_api.g_number) then
329: p_rec.wf_transaction_category_id :=
330: pqh_wks_shd.g_old_rec.wf_transaction_category_id;

Line 330: pqh_wks_shd.g_old_rec.wf_transaction_category_id;

326: pqh_wks_shd.g_old_rec.propagation_method;
327: End If;
328: If (p_rec.wf_transaction_category_id = hr_api.g_number) then
329: p_rec.wf_transaction_category_id :=
330: pqh_wks_shd.g_old_rec.wf_transaction_category_id;
331: End If;
332: --
333: hr_utility.set_location(' Leaving:'||l_proc, 10);
334: --

Line 343: p_rec in out nocopy pqh_wks_shd.g_rec_type

339: -- ----------------------------------------------------------------------------
340: Procedure upd
341: (
342: p_effective_date in date,
343: p_rec in out nocopy pqh_wks_shd.g_rec_type
344: ) is
345: --
346: l_proc varchar2(72) := g_package||'upd';
347: --

Line 353: pqh_wks_shd.lck

349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- We must lock the row which we need to update.
352: --
353: pqh_wks_shd.lck
354: (
355: p_rec.worksheet_id,
356: p_rec.object_version_number
357: );

Line 404: l_rec pqh_wks_shd.g_rec_type;

400: p_propagation_method in varchar2 default hr_api.g_varchar2,
401: p_wf_transaction_category_id in number
402: ) is
403: --
404: l_rec pqh_wks_shd.g_rec_type;
405: l_proc varchar2(72) := g_package||'upd';
406: --
407: Begin
408: hr_utility.set_location('Entering:'||l_proc, 5);

Line 414: pqh_wks_shd.convert_args

410: -- Call conversion function to turn arguments into the
411: -- l_rec structure.
412: --
413: l_rec :=
414: pqh_wks_shd.convert_args
415: (
416: p_worksheet_id,
417: p_budget_id,
418: p_worksheet_name,