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_CRE_BUS dependencies on PQH_CRE_SHD

Line 188: (p_rec in pqh_cre_shd.g_rec_type

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

Line 198: IF NOT pqh_cre_shd.api_updating

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

Line 213: nvl(pqh_cre_shd.g_old_rec.business_group_id

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

Line 219: ,p_base_table => pqh_cre_shd.g_tab_nam

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

Line 311: l_api_updating := pqh_cre_shd.api_updating

307: --
308: hr_utility.set_location('Entering:'||l_proc,10);
309: --
310:
311: l_api_updating := pqh_cre_shd.api_updating
312: (p_criteria_rate_element_id => p_criteria_rate_element_id,
313: p_object_version_number => p_object_version_number);
314: --
315: if (l_api_updating

Line 317: <> nvl(pqh_cre_shd.g_old_rec.criteria_rate_defn_id,hr_api.g_number)

313: p_object_version_number => p_object_version_number);
314: --
315: if (l_api_updating
316: and nvl(p_criteria_rate_defn_id,hr_api.g_number)
317: <> nvl(pqh_cre_shd.g_old_rec.criteria_rate_defn_id,hr_api.g_number)
318: or not l_api_updating) then
319: --
320: -- check if criteria_rate_defn_id value exists in
321: -- PQH_CRITERIA_RATE_DEFN table

Line 335: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK1');

331: --
332: -- raise error as FK does not relate to PK in PQH_CRITERIA_RATE_DEFN
333: -- table.
334: --
335: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK1');
336: --
337: end if;
338: --
339: close c1;

Line 394: l_api_updating := pqh_cre_shd.api_updating

390: --
391: hr_utility.set_location('Entering:'||l_proc,10);
392: --
393:
394: l_api_updating := pqh_cre_shd.api_updating
395: (p_criteria_rate_element_id => p_criteria_rate_element_id,
396: p_object_version_number => p_object_version_number);
397: --
398: if (l_api_updating

Line 400: <> nvl(pqh_cre_shd.g_old_rec.business_group_id,hr_api.g_number)

396: p_object_version_number => p_object_version_number);
397: --
398: if (l_api_updating
399: and nvl(p_business_group_id,hr_api.g_number)
400: <> nvl(pqh_cre_shd.g_old_rec.business_group_id,hr_api.g_number)
401: or not l_api_updating) then
402: --
403: -- check if business_group_id value exists in
404: -- HR_ALL_ORGANIZATION_UNITS table

Line 418: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK3');

414: --
415: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
416: -- table.
417: --
418: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK3');
419: --
420: end if;
421: --
422: close c1;

Line 478: l_api_updating := pqh_cre_shd.api_updating

474: --
475: hr_utility.set_location('Entering:'||l_proc,10);
476: --
477:
478: l_api_updating := pqh_cre_shd.api_updating
479: (p_criteria_rate_element_id => p_criteria_rate_element_id,
480: p_object_version_number => p_object_version_number);
481: --
482: if (l_api_updating

Line 484: <> nvl(pqh_cre_shd.g_old_rec.element_type_id,hr_api.g_number)

480: p_object_version_number => p_object_version_number);
481: --
482: if (l_api_updating
483: and nvl(p_element_type_id,hr_api.g_number)
484: <> nvl(pqh_cre_shd.g_old_rec.element_type_id,hr_api.g_number)
485: or not l_api_updating) then
486: --
487: -- check if element_type_id value exists in
488: -- PAY_ELEMENT_TYPES_F table

Line 501: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK4');

497: --
498: -- raise error as FK does not relate to PK in PAY_ELEMENT_TYPES_F
499: -- table.
500: --
501: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK4');
502: --
503: end if;
504: --
505: close c1;

Line 562: l_api_updating := pqh_cre_shd.api_updating

558: --
559: hr_utility.set_location('Entering:'||l_proc,10);
560: --
561:
562: l_api_updating := pqh_cre_shd.api_updating
563: (p_criteria_rate_element_id => p_criteria_rate_element_id,
564: p_object_version_number => p_object_version_number);
565: --
566: if (l_api_updating

Line 568: <> nvl(pqh_cre_shd.g_old_rec.input_value_id,hr_api.g_number)

564: p_object_version_number => p_object_version_number);
565: --
566: if (l_api_updating
567: and nvl(p_input_value_id,hr_api.g_number)
568: <> nvl(pqh_cre_shd.g_old_rec.input_value_id,hr_api.g_number)
569: or not l_api_updating) then
570: --
571: -- check if input_value_id value exists in
572: -- PAY_INPUT_VALUES_F table

Line 585: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK5');

581: --
582: -- raise error as FK does not relate to PK in PAY_INPUT_VALUES_F
583: -- table.
584: --
585: pqh_cre_shd.constraint_error('PQH_CRITERIA_RATE_ELEMENTS_FK5');
586: --
587: end if;
588: --
589: close c1;

Line 620: (p_rec in pqh_cre_shd.g_rec_type

616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< insert_validate >----------------------------|
618: -- ----------------------------------------------------------------------------
619: Procedure insert_validate
620: (p_rec in pqh_cre_shd.g_rec_type
621: ) is
622: --
623: l_proc varchar2(72) := g_package||'insert_validate';
624: --

Line 642: ,p_associated_column1 => pqh_cre_shd.g_tab_nam

638: -- Validate Important Attributes
639: --
640: hr_api.validate_bus_grp_id
641: (p_business_group_id => p_rec.business_group_id
642: ,p_associated_column1 => pqh_cre_shd.g_tab_nam
643: || '.BUSINESS_GROUP_ID');
644: --
645: -- after validating the set of important attributes,
646: -- if Multiple Message Detection is enabled and at least

Line 690: (p_rec in pqh_cre_shd.g_rec_type

686: -- ----------------------------------------------------------------------------
687: -- |---------------------------< update_validate >----------------------------|
688: -- ----------------------------------------------------------------------------
689: Procedure update_validate
690: (p_rec in pqh_cre_shd.g_rec_type
691: ) is
692: --
693: l_proc varchar2(72) := g_package||'update_validate';
694: --

Line 712: ,p_associated_column1 => pqh_cre_shd.g_tab_nam

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

Line 764: (p_rec in pqh_cre_shd.g_rec_type

760: -- ----------------------------------------------------------------------------
761: -- |---------------------------< delete_validate >----------------------------|
762: -- ----------------------------------------------------------------------------
763: Procedure delete_validate
764: (p_rec in pqh_cre_shd.g_rec_type
765: ) is
766: --
767: l_proc varchar2(72) := g_package||'delete_validate';
768: --

Line 774: ,pqh_cre_shd.g_old_rec.business_group_id

770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: --
773: chk_startup_action(false
774: ,pqh_cre_shd.g_old_rec.business_group_id
775: ,pqh_cre_shd.g_old_rec.legislation_code
776: );
777: IF hr_startup_data_api_support.g_startup_mode
778: NOT IN ('GENERIC','STARTUP') THEN

Line 775: ,pqh_cre_shd.g_old_rec.legislation_code

771: --
772: --
773: chk_startup_action(false
774: ,pqh_cre_shd.g_old_rec.business_group_id
775: ,pqh_cre_shd.g_old_rec.legislation_code
776: );
777: IF hr_startup_data_api_support.g_startup_mode
778: NOT IN ('GENERIC','STARTUP') THEN
779: --