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

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

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

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

119: (p_worksheet_period_id => p_worksheet_period_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_end_time_period_id,hr_api.g_number)
124: <> nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
125: or not l_api_updating) then
126: --
127: -- check if end_time_period_id value exists in per_time_periods table

Line 124: <> nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)

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

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

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

Line 199: <> nvl(pqh_wpr_shd.g_old_rec.start_time_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_start_time_period_id,hr_api.g_number)
199: <> nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
200: or not l_api_updating) then
201: --
202: -- check if start_time_period_id value exists in per_time_periods table
203: --

Line 273: and nvl(p_worksheet_detail_id,hr_api.g_number)

269: (p_worksheet_period_id => p_worksheet_period_id,
270: p_object_version_number => p_object_version_number);
271: --
272: if (l_api_updating
273: and nvl(p_worksheet_detail_id,hr_api.g_number)
274: <> nvl(pqh_wpr_shd.g_old_rec.worksheet_detail_id,hr_api.g_number)
275: or not l_api_updating) then
276: --
277: -- check if worksheet_detail_id value exists in pqh_worksheet_details table

Line 274: <> nvl(pqh_wpr_shd.g_old_rec.worksheet_detail_id,hr_api.g_number)

270: p_object_version_number => p_object_version_number);
271: --
272: if (l_api_updating
273: and nvl(p_worksheet_detail_id,hr_api.g_number)
274: <> nvl(pqh_wpr_shd.g_old_rec.worksheet_detail_id,hr_api.g_number)
275: or not l_api_updating) then
276: --
277: -- check if worksheet_detail_id value exists in pqh_worksheet_details table
278: --

Line 346: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)

342: p_object_version_number => p_object_version_number);
343: --
344: if (l_api_updating
345: and p_budget_unit3_value_type_cd
346: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_value_type_cd,hr_api.g_varchar2)
347: or not l_api_updating)
348: and p_budget_unit3_value_type_cd is not null then
349: --
350: -- check if value of lookup falls within lookup type.

Line 352: if hr_api.not_exists_in_hr_lookups

348: and p_budget_unit3_value_type_cd is not null then
349: --
350: -- check if value of lookup falls within lookup type.
351: --
352: if hr_api.not_exists_in_hr_lookups
353: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
354: p_lookup_code => p_budget_unit3_value_type_cd,
355: p_effective_date => p_effective_date) then
356: --

Line 414: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)

410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating
413: and p_budget_unit2_value_type_cd
414: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_value_type_cd,hr_api.g_varchar2)
415: or not l_api_updating)
416: and p_budget_unit2_value_type_cd is not null then
417: --
418: -- check if value of lookup falls within lookup type.

Line 420: if hr_api.not_exists_in_hr_lookups

416: and p_budget_unit2_value_type_cd is not null then
417: --
418: -- check if value of lookup falls within lookup type.
419: --
420: if hr_api.not_exists_in_hr_lookups
421: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
422: p_lookup_code => p_budget_unit2_value_type_cd,
423: p_effective_date => p_effective_date) then
424: --

Line 482: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)

478: p_object_version_number => p_object_version_number);
479: --
480: if (l_api_updating
481: and p_budget_unit1_value_type_cd
482: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_value_type_cd,hr_api.g_varchar2)
483: or not l_api_updating)
484: and p_budget_unit1_value_type_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.

Line 488: if hr_api.not_exists_in_hr_lookups

484: and p_budget_unit1_value_type_cd is not null then
485: --
486: -- check if value of lookup falls within lookup type.
487: --
488: if hr_api.not_exists_in_hr_lookups
489: (p_lookup_type => 'PQH_BUDGET_UNIT_VALUE_TYPE',
490: p_lookup_code => p_budget_unit1_value_type_cd,
491: p_effective_date => p_effective_date) then
492: --

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

528: (p_worksheet_period_id => p_worksheet_period_id,
529: p_object_version_number => p_object_version_number);
530: --
531: if (l_api_updating
532: and nvl(p_budget_unit1_percent,hr_api.g_number)
533: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)
534: or not l_api_updating) and
535: p_budget_unit1_percent is not null then
536: --

Line 533: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)

529: p_object_version_number => p_object_version_number);
530: --
531: if (l_api_updating
532: and nvl(p_budget_unit1_percent,hr_api.g_number)
533: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_percent,hr_api.g_number)
534: or not l_api_updating) and
535: p_budget_unit1_percent is not null then
536: --
537: -- Raise error if the value is negative

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

543: end if;
544: --
545: --
546: if (l_api_updating
547: and nvl(p_budget_unit1_value,hr_api.g_number)
548: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_value,hr_api.g_number)
549: or not l_api_updating) and
550: p_budget_unit1_value is not null then
551: --

Line 548: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_value,hr_api.g_number)

544: --
545: --
546: if (l_api_updating
547: and nvl(p_budget_unit1_value,hr_api.g_number)
548: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_value,hr_api.g_number)
549: or not l_api_updating) and
550: p_budget_unit1_value is not null then
551: --
552: -- Raise error if the value is negative

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

559: --
560: /**
561: --
562: if (l_api_updating
563: and nvl(p_budget_unit1_available,hr_api.g_number)
564: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_available,hr_api.g_number)
565: or not l_api_updating) and
566: p_budget_unit1_available is not null then
567: --

Line 564: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_available,hr_api.g_number)

560: /**
561: --
562: if (l_api_updating
563: and nvl(p_budget_unit1_available,hr_api.g_number)
564: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit1_available,hr_api.g_number)
565: or not l_api_updating) and
566: p_budget_unit1_available is not null then
567: --
568: -- Raise error if the value is negative

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

576: **/
577: --
578: --
579: if (l_api_updating
580: and nvl(p_budget_unit2_percent,hr_api.g_number)
581: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)
582: or not l_api_updating) and
583: p_budget_unit2_percent is not null then
584: --

Line 581: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)

577: --
578: --
579: if (l_api_updating
580: and nvl(p_budget_unit2_percent,hr_api.g_number)
581: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_percent,hr_api.g_number)
582: or not l_api_updating) and
583: p_budget_unit2_percent is not null then
584: --
585: -- Raise error if the value is negative

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

591: end if;
592: --
593: --
594: if (l_api_updating
595: and nvl(p_budget_unit2_value,hr_api.g_number)
596: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_value,hr_api.g_number)
597: or not l_api_updating) and
598: p_budget_unit2_value is not null then
599: --

Line 596: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_value,hr_api.g_number)

592: --
593: --
594: if (l_api_updating
595: and nvl(p_budget_unit2_value,hr_api.g_number)
596: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_value,hr_api.g_number)
597: or not l_api_updating) and
598: p_budget_unit2_value is not null then
599: --
600: -- Raise error if the value is negative

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

607: --
608: --
609: /**
610: if (l_api_updating
611: and nvl(p_budget_unit2_available,hr_api.g_number)
612: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_available,hr_api.g_number)
613: or not l_api_updating) and
614: p_budget_unit2_available is not null then
615: --

Line 612: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_available,hr_api.g_number)

608: --
609: /**
610: if (l_api_updating
611: and nvl(p_budget_unit2_available,hr_api.g_number)
612: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit2_available,hr_api.g_number)
613: or not l_api_updating) and
614: p_budget_unit2_available is not null then
615: --
616: -- Raise error if the value is negative

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

623: **/
624: --
625: --
626: if (l_api_updating
627: and nvl(p_budget_unit3_percent,hr_api.g_number)
628: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)
629: or not l_api_updating) and
630: p_budget_unit3_percent is not null then
631: --

Line 628: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)

624: --
625: --
626: if (l_api_updating
627: and nvl(p_budget_unit3_percent,hr_api.g_number)
628: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_percent,hr_api.g_number)
629: or not l_api_updating) and
630: p_budget_unit3_percent is not null then
631: --
632: -- Raise error if the value is negative

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

638: end if;
639: --
640: --
641: if (l_api_updating
642: and nvl(p_budget_unit3_value,hr_api.g_number)
643: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_value,hr_api.g_number)
644: or not l_api_updating) and
645: p_budget_unit3_value is not null then
646: --

Line 643: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_value,hr_api.g_number)

639: --
640: --
641: if (l_api_updating
642: and nvl(p_budget_unit3_value,hr_api.g_number)
643: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_value,hr_api.g_number)
644: or not l_api_updating) and
645: p_budget_unit3_value is not null then
646: --
647: -- Raise error if the value is negative

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

654: --
655: --
656: /**
657: if (l_api_updating
658: and nvl(p_budget_unit3_available,hr_api.g_number)
659: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_available,hr_api.g_number)
660: or not l_api_updating) and
661: p_budget_unit3_available is not null then
662: --

Line 659: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_available,hr_api.g_number)

655: --
656: /**
657: if (l_api_updating
658: and nvl(p_budget_unit3_available,hr_api.g_number)
659: <> nvl(pqh_wpr_shd.g_old_rec.budget_unit3_available,hr_api.g_number)
660: or not l_api_updating) and
661: p_budget_unit3_available is not null then
662: --
663: -- Raise error if the value is negative

Line 751: and ( nvl(p_start_time_period_id,hr_api.g_number) <>

747: (p_worksheet_period_id => p_worksheet_period_id,
748: p_object_version_number => p_object_version_number);
749: --
750: if (l_api_updating
751: and ( nvl(p_start_time_period_id,hr_api.g_number) <>
752: nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
753: OR
754: nvl(p_end_time_period_id,hr_api.g_number) <>
755: nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)

Line 752: nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)

748: p_object_version_number => p_object_version_number);
749: --
750: if (l_api_updating
751: and ( nvl(p_start_time_period_id,hr_api.g_number) <>
752: nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
753: OR
754: nvl(p_end_time_period_id,hr_api.g_number) <>
755: nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
756: )

Line 754: nvl(p_end_time_period_id,hr_api.g_number) <>

750: if (l_api_updating
751: and ( nvl(p_start_time_period_id,hr_api.g_number) <>
752: nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
753: OR
754: nvl(p_end_time_period_id,hr_api.g_number) <>
755: nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
756: )
757: or not l_api_updating) then
758: --

Line 755: nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)

751: and ( nvl(p_start_time_period_id,hr_api.g_number) <>
752: nvl(pqh_wpr_shd.g_old_rec.start_time_period_id,hr_api.g_number)
753: OR
754: nvl(p_end_time_period_id,hr_api.g_number) <>
755: nvl(pqh_wpr_shd.g_old_rec.end_time_period_id,hr_api.g_number)
756: )
757: or not l_api_updating) then
758: --
759: If l_start_date > l_end_date then