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_RER_BUS dependencies on PQH_RER_SHD

Line 189: ,p_rec in pqh_rer_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_rer_shd.g_rec_type
190: ) IS
191: --
192: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
193: --

Line 199: IF NOT pqh_rer_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_rer_shd.api_updating
200: (p_rate_element_relation_id => p_rec.rate_element_relation_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_rer_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_rer_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_rer_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_rer_shd.g_tab_nam
221: );
222: end if;
223: --
224: End chk_non_updateable_args;

Line 316: l_api_updating := pqh_rer_shd.api_updating

312: --
313: hr_utility.set_location('Entering:'||l_proc,10);
314: --
315:
316: l_api_updating := pqh_rer_shd.api_updating
317: (p_rate_element_relation_id => p_rate_element_relation_id,
318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating

Line 322: <> nvl(pqh_rer_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)

318: p_object_version_number => p_object_version_number);
319: --
320: if (l_api_updating
321: and nvl(p_criteria_rate_element_id,hr_api.g_number)
322: <> nvl(pqh_rer_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
323: or not l_api_updating) then
324: --
325: -- check if criteria_rate_element_id value exists in
326: -- PQH_CRITERIA_RATE_ELEMENTS table

Line 341: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK1');

337: --
338: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_ELEMENTS
339: -- table.
340: --
341: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK1');
342: --
343: end if;
344: --
345: close c1;

Line 405: l_api_updating := pqh_rer_shd.api_updating

401: --
402: hr_utility.set_location('Entering:'||l_proc,10);
403: --
404:
405: l_api_updating := pqh_rer_shd.api_updating
406: (p_rate_element_relation_id => p_rate_element_relation_id,
407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating

Line 411: <> nvl(pqh_rer_shd.g_old_rec.rel_element_type_id,hr_api.g_number)

407: p_object_version_number => p_object_version_number);
408: --
409: if (l_api_updating
410: and nvl(p_rel_element_type_id,hr_api.g_number)
411: <> nvl(pqh_rer_shd.g_old_rec.rel_element_type_id,hr_api.g_number)
412: or not l_api_updating) then
413: --
414: -- check if rel_element_type_id value exists in
415: -- PAY_ELEMENT_TYPES_F table

Line 430: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK4');

426: --
427: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
428: -- table.
429: --
430: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK4');
431: --
432: end if;
433: --
434: close c1;

Line 488: l_api_updating := pqh_rer_shd.api_updating

484: --
485: hr_utility.set_location('Entering:'||l_proc,10);
486: --
487:
488: l_api_updating := pqh_rer_shd.api_updating
489: (p_rate_element_relation_id => p_rate_element_relation_id,
490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating

Line 494: <> nvl(pqh_rer_shd.g_old_rec.rel_input_value_id,hr_api.g_number)

490: p_object_version_number => p_object_version_number);
491: --
492: if (l_api_updating
493: and nvl(p_rel_input_value_id,hr_api.g_number)
494: <> nvl(pqh_rer_shd.g_old_rec.rel_input_value_id,hr_api.g_number)
495: or not l_api_updating) then
496: --
497: -- check if rel_input_value_id value exists in
498: -- PAY_INPUT_VALUE_F table

Line 513: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK5');

509: --
510: -- raise error as FK does not relate to PK in PAY_INPUT_VALUE_F
511: -- table.
512: --
513: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK5');
514: --
515: end if;
516: --
517: close c1;

Line 570: l_api_updating := pqh_rer_shd.api_updating

566: --
567: hr_utility.set_location('Entering:'||l_proc,10);
568: --
569:
570: l_api_updating := pqh_rer_shd.api_updating
571: (p_rate_element_relation_id => p_rate_element_relation_id,
572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating

Line 576: <> nvl(pqh_rer_shd.g_old_rec.business_group_id ,hr_api.g_number)

572: p_object_version_number => p_object_version_number);
573: --
574: if (l_api_updating
575: and nvl(p_business_group_id ,hr_api.g_number)
576: <> nvl(pqh_rer_shd.g_old_rec.business_group_id ,hr_api.g_number)
577: or not l_api_updating) then
578: --
579: -- check if business_group_id value exists in
580: -- HR_ALL_ORGANIZATION_UNITS table

Line 595: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK3');

591: --
592: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
593: -- table.
594: --
595: pqh_rer_shd.constraint_error('PQH_RATE_ELEMENT_RELATIONS_FK3');
596: --
597: end if;
598: --
599: close c1;

Line 625: l_api_updating := pqh_rer_shd.api_updating

621: Begin
622: --
623: hr_utility.set_location('Entering:'||l_proc, 10);
624: --
625: l_api_updating := pqh_rer_shd.api_updating
626: (p_rate_element_relation_id => p_rate_element_relation_id,
627: p_object_version_number => p_object_version_number);
628: --
629: if (l_api_updating

Line 631: <> nvl(pqh_rer_shd.g_old_rec.relation_type_cd,hr_api.g_varchar2)

627: p_object_version_number => p_object_version_number);
628: --
629: if (l_api_updating
630: and p_relation_type_cd
631: <> nvl(pqh_rer_shd.g_old_rec.relation_type_cd,hr_api.g_varchar2)
632: or not l_api_updating)
633: and p_relation_type_cd is not null then
634:
635: -- check if value of lookup falls within lookup type.

Line 663: ,p_rec in pqh_rer_shd.g_rec_type

659: -- |---------------------------< insert_validate >----------------------------|
660: -- ----------------------------------------------------------------------------
661: Procedure insert_validate
662: (p_effective_date in date
663: ,p_rec in pqh_rer_shd.g_rec_type
664: ) is
665: --
666: l_proc varchar2(72) := g_package||'insert_validate';
667: --

Line 685: ,p_associated_column1 => pqh_rer_shd.g_tab_nam

681: -- Validate Important Attributes
682: --
683: hr_api.validate_bus_grp_id
684: (p_business_group_id => p_rec.business_group_id
685: ,p_associated_column1 => pqh_rer_shd.g_tab_nam
686: || '.BUSINESS_GROUP_ID');
687: --
688: -- after validating the set of important attributes,
689: -- if Multiple Message Detection is enabled and at least

Line 739: ,p_rec in pqh_rer_shd.g_rec_type

735: -- |---------------------------< update_validate >----------------------------|
736: -- ----------------------------------------------------------------------------
737: Procedure update_validate
738: (p_effective_date in date
739: ,p_rec in pqh_rer_shd.g_rec_type
740: ) is
741: --
742: l_proc varchar2(72) := g_package||'update_validate';
743: --

Line 761: ,p_associated_column1 => pqh_rer_shd.g_tab_nam

757: -- Validate Important Attributes
758: --
759: hr_api.validate_bus_grp_id
760: (p_business_group_id => p_rec.business_group_id
761: ,p_associated_column1 => pqh_rer_shd.g_tab_nam
762: || '.BUSINESS_GROUP_ID');
763: --
764: -- After validating the set of important attributes,
765: -- if Multiple Message Detection is enabled and at least

Line 818: (p_rec in pqh_rer_shd.g_rec_type

814: -- ----------------------------------------------------------------------------
815: -- |---------------------------< delete_validate >----------------------------|
816: -- ----------------------------------------------------------------------------
817: Procedure delete_validate
818: (p_rec in pqh_rer_shd.g_rec_type
819: ) is
820: --
821: l_proc varchar2(72) := g_package||'delete_validate';
822: --

Line 828: ,pqh_rer_shd.g_old_rec.business_group_id

824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: --
827: chk_startup_action(false
828: ,pqh_rer_shd.g_old_rec.business_group_id
829: ,pqh_rer_shd.g_old_rec.legislation_code
830: );
831: IF hr_startup_data_api_support.g_startup_mode
832: NOT IN ('GENERIC','STARTUP') THEN

Line 829: ,pqh_rer_shd.g_old_rec.legislation_code

825: --
826: --
827: chk_startup_action(false
828: ,pqh_rer_shd.g_old_rec.business_group_id
829: ,pqh_rer_shd.g_old_rec.legislation_code
830: );
831: IF hr_startup_data_api_support.g_startup_mode
832: NOT IN ('GENERIC','STARTUP') THEN
833: --