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_RFE_BUS dependencies on PQH_RFE_SHD

Line 189: ,p_rec in pqh_rfe_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure chk_non_updateable_args
188: (p_effective_date in date
189: ,p_rec in pqh_rfe_shd.g_rec_type
190: ) IS
191: --
192: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
193: --

Line 199: IF NOT pqh_rfe_shd.api_updating

195: --
196: -- Only proceed with the validation if a row exists for the current
197: -- record in the HR Schema.
198: --
199: IF NOT pqh_rfe_shd.api_updating
200: (p_rate_factor_on_elmnt_id => p_rec.rate_factor_on_elmnt_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 214: nvl(pqh_rfe_shd.g_old_rec.business_group_id

210: -- not been updated.
211: --
212: --
213: if nvl(p_rec.business_group_id, hr_api.g_number) <>
214: nvl(pqh_rfe_shd.g_old_rec.business_group_id
215: ,hr_api.g_number
216: ) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc

Line 220: ,p_base_table => pqh_rfe_shd.g_tab_nam

216: ) then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'BUSINESS_GROUP_ID'
220: ,p_base_table => pqh_rfe_shd.g_tab_nam
221: );
222: end if;
223: --
224: End chk_non_updateable_args;

Line 287: l_api_updating := pqh_rfe_shd.api_updating

283: Begin
284: --
285: hr_utility.set_location('Entering:'||l_proc, 10);
286: --
287: l_api_updating := pqh_rfe_shd.api_updating
288: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating

Line 293: <> nvl(pqh_rfe_shd.g_old_rec.rate_factor_val_record_tbl,hr_api.g_varchar2)

289: p_object_version_number => p_object_version_number);
290: --
291: if (l_api_updating
292: and p_rate_factor_val_record_tbl
293: <> nvl(pqh_rfe_shd.g_old_rec.rate_factor_val_record_tbl,hr_api.g_varchar2)
294: or not l_api_updating)
295: and p_rate_factor_val_record_tbl is not null then
296: --
297: -- check if value of lookup falls within lookup type.

Line 361: l_api_updating := pqh_rfe_shd.api_updating

357: --
358: hr_utility.set_location('Entering:'||l_proc,10);
359: --
360:
361: l_api_updating := pqh_rfe_shd.api_updating
362: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
363: p_object_version_number => p_object_version_number);
364: --
365: if (l_api_updating

Line 367: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)

363: p_object_version_number => p_object_version_number);
364: --
365: if (l_api_updating
366: and nvl(p_criteria_rate_element_id,hr_api.g_number)
367: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
368: or not l_api_updating) then
369: --
370: -- check if criteria_rate_element_id value exists in
371: -- pqh_criteria_rate_elements table

Line 385: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK1');

381: --
382: -- raise error as FK does not relate to PK in pqh_criteria_rate_elements
383: -- table.
384: --
385: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK1');
386: --
387: end if;
388: --
389: close c1;

Line 444: l_api_updating := pqh_rfe_shd.api_updating

440: --
441: hr_utility.set_location('Entering:'||l_proc,10);
442: --
443:
444: l_api_updating := pqh_rfe_shd.api_updating
445: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
446: p_object_version_number => p_object_version_number);
447: --
448: if (l_api_updating

Line 450: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_factor_id,hr_api.g_number)

446: p_object_version_number => p_object_version_number);
447: --
448: if (l_api_updating
449: and nvl(p_criteria_rate_factor_id,hr_api.g_number)
450: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_factor_id,hr_api.g_number)
451: or not l_api_updating) then
452: --
453: -- check if criteria_rate_factor_id value exists in
454: -- pqh_criteria_rate_factors table

Line 468: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK2');

464: --
465: -- raise error as FK does not relate to PK in pqh_criteria_rate_factors
466: -- table.
467: --
468: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK2');
469: --
470: end if;
471: --
472: close c1;

Line 546: l_api_updating := pqh_rfe_shd.api_updating

542: --
543: hr_utility.set_location('Entering:'||l_proc,10);
544: --
545:
546: l_api_updating := pqh_rfe_shd.api_updating
547: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating

Line 552: <> nvl(pqh_rfe_shd.g_old_rec.rate_factor_val_record_col,hr_api.g_varchar2)

548: p_object_version_number => p_object_version_number);
549: --
550: if (l_api_updating
551: and p_rate_factor_val_record_col
552: <> nvl(pqh_rfe_shd.g_old_rec.rate_factor_val_record_col,hr_api.g_varchar2)
553: or not l_api_updating)
554: and p_rate_factor_val_record_col is not null then
555:
556:

Line 647: l_api_updating := pqh_rfe_shd.api_updating

643: --
644: hr_utility.set_location('Entering:'||l_proc,10);
645: --
646:
647: l_api_updating := pqh_rfe_shd.api_updating
648: (p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id,
649: p_object_version_number => p_object_version_number);
650: --
651: if (l_api_updating

Line 653: <> nvl(pqh_rfe_shd.g_old_rec.business_group_id,hr_api.g_number)

649: p_object_version_number => p_object_version_number);
650: --
651: if (l_api_updating
652: and nvl(p_business_group_id,hr_api.g_number)
653: <> nvl(pqh_rfe_shd.g_old_rec.business_group_id,hr_api.g_number)
654: or not l_api_updating) then
655: --
656: -- check if business_group_id value exists in
657: -- HR_ALL_ORGANIZATION_UNITS table

Line 671: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK3');

667: --
668: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
669: -- table.
670: --
671: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK3');
672: --
673: end if;
674: --
675: close c1;

Line 692: ,p_rec in pqh_rfe_shd.g_rec_type

688: -- |---------------------------< insert_validate >----------------------------|
689: -- ----------------------------------------------------------------------------
690: Procedure insert_validate
691: (p_effective_date in date
692: ,p_rec in pqh_rfe_shd.g_rec_type
693: ) is
694: --
695: l_proc varchar2(72) := g_package||'insert_validate';
696: --

Line 714: ,p_associated_column1 => pqh_rfe_shd.g_tab_nam

710: -- Validate Important Attributes
711: --
712: hr_api.validate_bus_grp_id
713: (p_business_group_id => p_rec.business_group_id
714: ,p_associated_column1 => pqh_rfe_shd.g_tab_nam
715: || '.BUSINESS_GROUP_ID');
716: --
717: -- after validating the set of important attributes,
718: -- if Multiple Message Detection is enabled and at least

Line 770: ,p_rec in pqh_rfe_shd.g_rec_type

766: -- |---------------------------< update_validate >----------------------------|
767: -- ----------------------------------------------------------------------------
768: Procedure update_validate
769: (p_effective_date in date
770: ,p_rec in pqh_rfe_shd.g_rec_type
771: ) is
772: --
773: l_proc varchar2(72) := g_package||'update_validate';
774: --

Line 792: ,p_associated_column1 => pqh_rfe_shd.g_tab_nam

788: -- Validate Important Attributes
789: --
790: hr_api.validate_bus_grp_id
791: (p_business_group_id => p_rec.business_group_id
792: ,p_associated_column1 => pqh_rfe_shd.g_tab_nam
793: || '.BUSINESS_GROUP_ID');
794: --
795: -- After validating the set of important attributes,
796: -- if Multiple Message Detection is enabled and at least

Line 851: (p_rec in pqh_rfe_shd.g_rec_type

847: -- ----------------------------------------------------------------------------
848: -- |---------------------------< delete_validate >----------------------------|
849: -- ----------------------------------------------------------------------------
850: Procedure delete_validate
851: (p_rec in pqh_rfe_shd.g_rec_type
852: ) is
853: --
854: l_proc varchar2(72) := g_package||'delete_validate';
855: --

Line 861: ,pqh_rfe_shd.g_old_rec.business_group_id

857: hr_utility.set_location('Entering:'||l_proc, 5);
858: --
859: --
860: chk_startup_action(false
861: ,pqh_rfe_shd.g_old_rec.business_group_id
862: ,pqh_rfe_shd.g_old_rec.legislation_code
863: );
864: IF hr_startup_data_api_support.g_startup_mode
865: NOT IN ('GENERIC','STARTUP') THEN

Line 862: ,pqh_rfe_shd.g_old_rec.legislation_code

858: --
859: --
860: chk_startup_action(false
861: ,pqh_rfe_shd.g_old_rec.business_group_id
862: ,pqh_rfe_shd.g_old_rec.legislation_code
863: );
864: IF hr_startup_data_api_support.g_startup_mode
865: NOT IN ('GENERIC','STARTUP') THEN
866: --