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_WST_BUS dependencies on HR_API

Line 51: and nvl(p_worksheet_budget_set_id,hr_api.g_number)

47: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_worksheet_budget_set_id,hr_api.g_number)
52: <> pqh_wst_shd.g_old_rec.worksheet_budget_set_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 123: and nvl(p_dflt_budget_set_id,hr_api.g_number)

119: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_dflt_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_wst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if dflt_budget_set_id value exists in pqh_dflt_budget_sets table

Line 124: <> nvl(pqh_wst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_dflt_budget_set_id,hr_api.g_number)
124: <> nvl(pqh_wst_shd.g_old_rec.dflt_budget_set_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if dflt_budget_set_id value exists in pqh_dflt_budget_sets table
128: --

Line 198: and nvl(p_worksheet_period_id,hr_api.g_number)

194: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_worksheet_period_id,hr_api.g_number)
199: <> nvl(pqh_wst_shd.g_old_rec.worksheet_period_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if worksheet_period_id value exists in pqh_worksheet_periods table

Line 199: <> nvl(pqh_wst_shd.g_old_rec.worksheet_period_id,hr_api.g_number)

195: p_object_version_number => p_object_version_number);
196: --
197: if (l_api_updating
198: and nvl(p_worksheet_period_id,hr_api.g_number)
199: <> nvl(pqh_wst_shd.g_old_rec.worksheet_period_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if worksheet_period_id value exists in pqh_worksheet_periods table
203: --

Line 270: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

266: p_object_version_number => p_object_version_number);
267: --
268: if (l_api_updating
269: and p_budget_unit3_value_type_cd
270: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
271: or not l_api_updating)
272: and p_budget_unit3_value_type_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.

Line 276: if hr_api.not_exists_in_hr_lookups

272: and p_budget_unit3_value_type_cd is not null then
273: --
274: -- check if value of lookup falls within lookup type.
275: --
276: if hr_api.not_exists_in_hr_lookups
277: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
278: p_lookup_code => p_budget_unit3_value_type_cd,
279: p_effective_date => p_effective_date) then
280: --

Line 338: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

334: p_object_version_number => p_object_version_number);
335: --
336: if (l_api_updating
337: and p_budget_unit2_value_type_cd
338: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
339: or not l_api_updating)
340: and p_budget_unit2_value_type_cd is not null then
341: --
342: -- check if value of lookup falls within lookup type.

Line 344: if hr_api.not_exists_in_hr_lookups

340: and p_budget_unit2_value_type_cd is not null then
341: --
342: -- check if value of lookup falls within lookup type.
343: --
344: if hr_api.not_exists_in_hr_lookups
345: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
346: p_lookup_code => p_budget_unit2_value_type_cd,
347: p_effective_date => p_effective_date) then
348: --

Line 406: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

402: p_object_version_number => p_object_version_number);
403: --
404: if (l_api_updating
405: and p_budget_unit1_value_type_cd
406: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
407: or not l_api_updating)
408: and p_budget_unit1_value_type_cd is not null then
409: --
410: -- check if value of lookup falls within lookup type.

Line 412: if hr_api.not_exists_in_hr_lookups

408: and p_budget_unit1_value_type_cd is not null then
409: --
410: -- check if value of lookup falls within lookup type.
411: --
412: if hr_api.not_exists_in_hr_lookups
413: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
414: p_lookup_code => p_budget_unit1_value_type_cd,
415: p_effective_date => p_effective_date) then
416: --

Line 456: and nvl(p_budget_unit1_percent,hr_api.g_number)

452: (p_worksheet_budget_set_id => p_worksheet_budget_set_id,
453: p_object_version_number => p_object_version_number);
454: --
455: if (l_api_updating
456: and nvl(p_budget_unit1_percent,hr_api.g_number)
457: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)
458: or not l_api_updating) and
459: p_budget_unit1_percent is not null then
460: --

Line 457: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)

453: p_object_version_number => p_object_version_number);
454: --
455: if (l_api_updating
456: and nvl(p_budget_unit1_percent,hr_api.g_number)
457: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)
458: or not l_api_updating) and
459: p_budget_unit1_percent is not null then
460: --
461: -- Raise error if the value is negative

Line 471: and nvl(p_budget_unit1_value,hr_api.g_number)

467: end if;
468: --
469: --
470: if (l_api_updating
471: and nvl(p_budget_unit1_value,hr_api.g_number)
472: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_value,hr_api.g_number)
473: or not l_api_updating) and
474: p_budget_unit1_value is not null then
475: --

Line 472: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_value,hr_api.g_number)

468: --
469: --
470: if (l_api_updating
471: and nvl(p_budget_unit1_value,hr_api.g_number)
472: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_value,hr_api.g_number)
473: or not l_api_updating) and
474: p_budget_unit1_value is not null then
475: --
476: -- Raise error if the value is negative

Line 487: and nvl(p_budget_unit1_available,hr_api.g_number)

483: --
484: --
485: /**
486: if (l_api_updating
487: and nvl(p_budget_unit1_available,hr_api.g_number)
488: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_available,hr_api.g_number)
489: or not l_api_updating) and
490: p_budget_unit1_available is not null then
491: --

Line 488: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_available,hr_api.g_number)

484: --
485: /**
486: if (l_api_updating
487: and nvl(p_budget_unit1_available,hr_api.g_number)
488: <> nvl(pqh_wst_shd.g_old_rec.budget_unit1_available,hr_api.g_number)
489: or not l_api_updating) and
490: p_budget_unit1_available is not null then
491: --
492: -- Raise error if the value is negative

Line 504: and nvl(p_budget_unit2_percent,hr_api.g_number)

500: --
501: --
502: --
503: if (l_api_updating
504: and nvl(p_budget_unit2_percent,hr_api.g_number)
505: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)
506: or not l_api_updating) and
507: p_budget_unit2_percent is not null then
508: --

Line 505: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)

501: --
502: --
503: if (l_api_updating
504: and nvl(p_budget_unit2_percent,hr_api.g_number)
505: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)
506: or not l_api_updating) and
507: p_budget_unit2_percent is not null then
508: --
509: -- Raise error if the value is negative

Line 519: and nvl(p_budget_unit2_value,hr_api.g_number)

515: end if;
516: --
517: --
518: if (l_api_updating
519: and nvl(p_budget_unit2_value,hr_api.g_number)
520: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_value,hr_api.g_number)
521: or not l_api_updating) and
522: p_budget_unit2_value is not null then
523: --

Line 520: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_value,hr_api.g_number)

516: --
517: --
518: if (l_api_updating
519: and nvl(p_budget_unit2_value,hr_api.g_number)
520: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_value,hr_api.g_number)
521: or not l_api_updating) and
522: p_budget_unit2_value is not null then
523: --
524: -- Raise error if the value is negative

Line 535: and nvl(p_budget_unit2_available,hr_api.g_number)

531: --
532: --
533: /**
534: if (l_api_updating
535: and nvl(p_budget_unit2_available,hr_api.g_number)
536: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_available,hr_api.g_number)
537: or not l_api_updating) and
538: p_budget_unit2_available is not null then
539: --

Line 536: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_available,hr_api.g_number)

532: --
533: /**
534: if (l_api_updating
535: and nvl(p_budget_unit2_available,hr_api.g_number)
536: <> nvl(pqh_wst_shd.g_old_rec.budget_unit2_available,hr_api.g_number)
537: or not l_api_updating) and
538: p_budget_unit2_available is not null then
539: --
540: -- Raise error if the value is negative

Line 551: and nvl(p_budget_unit3_percent,hr_api.g_number)

547: **/
548: --
549: --
550: if (l_api_updating
551: and nvl(p_budget_unit3_percent,hr_api.g_number)
552: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)
553: or not l_api_updating) and
554: p_budget_unit3_percent is not null then
555: --

Line 552: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)

548: --
549: --
550: if (l_api_updating
551: and nvl(p_budget_unit3_percent,hr_api.g_number)
552: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)
553: or not l_api_updating) and
554: p_budget_unit3_percent is not null then
555: --
556: -- Raise error if the value is negative

Line 566: and nvl(p_budget_unit3_value,hr_api.g_number)

562: end if;
563: --
564: --
565: if (l_api_updating
566: and nvl(p_budget_unit3_value,hr_api.g_number)
567: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_value,hr_api.g_number)
568: or not l_api_updating) and
569: p_budget_unit3_value is not null then
570: --

Line 567: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_value,hr_api.g_number)

563: --
564: --
565: if (l_api_updating
566: and nvl(p_budget_unit3_value,hr_api.g_number)
567: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_value,hr_api.g_number)
568: or not l_api_updating) and
569: p_budget_unit3_value is not null then
570: --
571: -- Raise error if the value is negative

Line 582: and nvl(p_budget_unit3_available,hr_api.g_number)

578: --
579: --
580: /**
581: if (l_api_updating
582: and nvl(p_budget_unit3_available,hr_api.g_number)
583: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_available,hr_api.g_number)
584: or not l_api_updating) and
585: p_budget_unit3_available is not null then
586: --

Line 583: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_available,hr_api.g_number)

579: --
580: /**
581: if (l_api_updating
582: and nvl(p_budget_unit3_available,hr_api.g_number)
583: <> nvl(pqh_wst_shd.g_old_rec.budget_unit3_available,hr_api.g_number)
584: or not l_api_updating) and
585: p_budget_unit3_available is not null then
586: --
587: -- Raise error if the value is negative