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

Line 46: l_api_updating := pqh_bdt_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_bdt_shd.api_updating
47: (p_budget_detail_id => p_budget_detail_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_bdt_shd.g_old_rec.budget_detail_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_budget_detail_id,hr_api.g_number)
52: <> pqh_bdt_shd.g_old_rec.budget_detail_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_PK');

Line 56: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_PK');

52: <> pqh_bdt_shd.g_old_rec.budget_detail_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_PK');

62: if p_budget_detail_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := pqh_bdt_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_bdt_shd.api_updating
119: (p_budget_detail_id => p_budget_detail_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(pqh_bdt_shd.g_old_rec.grade_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_grade_id,hr_api.g_number)
124: <> nvl(pqh_bdt_shd.g_old_rec.grade_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_grade_id is not null then
127: --
128: -- check if grade_id value exists in per_grades table

Line 140: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK5');

136: --
137: -- raise error as FK does not relate to PK in per_grades
138: -- table.
139: --
140: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK5');
141: --
142: end if;
143: --
144: close c1;

Line 194: l_api_updating := pqh_bdt_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_bdt_shd.api_updating
195: (p_budget_detail_id => p_budget_detail_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

Line 200: <> nvl(pqh_bdt_shd.g_old_rec.job_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_job_id,hr_api.g_number)
200: <> nvl(pqh_bdt_shd.g_old_rec.job_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_job_id is not null then
203: --
204: -- check if job_id value exists in per_jobs table

Line 216: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK4');

212: --
213: -- raise error as FK does not relate to PK in per_jobs
214: -- table.
215: --
216: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK4');
217: --
218: end if;
219: --
220: close c1;

Line 270: l_api_updating := pqh_bdt_shd.api_updating

266: Begin
267: --
268: hr_utility.set_location('Entering:'||l_proc,5);
269: --
270: l_api_updating := pqh_bdt_shd.api_updating
271: (p_budget_detail_id => p_budget_detail_id,
272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating

Line 276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)

272: p_object_version_number => p_object_version_number);
273: --
274: if (l_api_updating
275: and nvl(p_budget_version_id,hr_api.g_number)
276: <> nvl(pqh_bdt_shd.g_old_rec.budget_version_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_budget_version_id is not null then
279: --
280: -- check if budget_version_id value exists in pqh_budget_versions table

Line 292: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK3');

288: --
289: -- raise error as FK does not relate to PK in pqh_budget_versions
290: -- table.
291: --
292: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK3');
293: --
294: end if;
295: --
296: close c1;

Line 346: l_api_updating := pqh_bdt_shd.api_updating

342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc,5);
345: --
346: l_api_updating := pqh_bdt_shd.api_updating
347: (p_budget_detail_id => p_budget_detail_id,
348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating

Line 352: <> nvl(pqh_bdt_shd.g_old_rec.organization_id,hr_api.g_number)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and nvl(p_organization_id,hr_api.g_number)
352: <> nvl(pqh_bdt_shd.g_old_rec.organization_id,hr_api.g_number)
353: or not l_api_updating) and
354: p_organization_id is not null then
355: --
356: -- check if organization_id value exists in hr_organization_units table

Line 368: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK2');

364: --
365: -- raise error as FK does not relate to PK in hr_organization_units
366: -- table.
367: --
368: pqh_bdt_shd.constraint_error('PQH_BUDGET_DETAILS_FK2');
369: --
370: end if;
371: --
372: close c1;

Line 419: l_api_updating := pqh_bdt_shd.api_updating

415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: l_api_updating := pqh_bdt_shd.api_updating
420: (p_budget_detail_id => p_budget_detail_id,
421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating

Line 425: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

421: p_object_version_number => p_object_version_number);
422: --
423: if (l_api_updating
424: and p_budget_unit3_value_type_cd
425: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
426: or not l_api_updating)
427: and p_budget_unit3_value_type_cd is not null then
428: --
429: -- check if value of lookup falls within lookup type.

Line 487: l_api_updating := pqh_bdt_shd.api_updating

483: Begin
484: --
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: l_api_updating := pqh_bdt_shd.api_updating
488: (p_budget_detail_id => p_budget_detail_id,
489: p_object_version_number => p_object_version_number);
490: --
491: if (l_api_updating

Line 493: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

489: p_object_version_number => p_object_version_number);
490: --
491: if (l_api_updating
492: and p_budget_unit2_value_type_cd
493: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
494: or not l_api_updating)
495: and p_budget_unit2_value_type_cd is not null then
496: --
497: -- check if value of lookup falls within lookup type.

Line 555: l_api_updating := pqh_bdt_shd.api_updating

551: Begin
552: --
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: l_api_updating := pqh_bdt_shd.api_updating
556: (p_budget_detail_id => p_budget_detail_id,
557: p_object_version_number => p_object_version_number);
558: --
559: if (l_api_updating

Line 561: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

557: p_object_version_number => p_object_version_number);
558: --
559: if (l_api_updating
560: and p_budget_unit1_value_type_cd
561: <> nvl(pqh_bdt_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
562: or not l_api_updating)
563: and p_budget_unit1_value_type_cd is not null then
564: --
565: -- check if value of lookup falls within lookup type.

Line 588: Procedure insert_validate(p_rec in pqh_bdt_shd.g_rec_type) is

584: --
585: -- ----------------------------------------------------------------------------
586: -- |---------------------------< insert_validate >----------------------------|
587: -- ----------------------------------------------------------------------------
588: Procedure insert_validate(p_rec in pqh_bdt_shd.g_rec_type) is
589: --
590: l_proc varchar2(72) := g_package||'insert_validate';
591: --
592: Begin

Line 648: Procedure update_validate(p_rec in pqh_bdt_shd.g_rec_type) is

644: --
645: -- ----------------------------------------------------------------------------
646: -- |---------------------------< update_validate >----------------------------|
647: -- ----------------------------------------------------------------------------
648: Procedure update_validate(p_rec in pqh_bdt_shd.g_rec_type) is
649: --
650: l_proc varchar2(72) := g_package||'update_validate';
651: --
652: Begin

Line 708: Procedure delete_validate(p_rec in pqh_bdt_shd.g_rec_type) is

704: --
705: -- ----------------------------------------------------------------------------
706: -- |---------------------------< delete_validate >----------------------------|
707: -- ----------------------------------------------------------------------------
708: Procedure delete_validate(p_rec in pqh_bdt_shd.g_rec_type) is
709: --
710: l_proc varchar2(72) := g_package||'delete_validate';
711: --
712: Begin