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_CRF_BUS dependencies on PQH_CRF_SHD

Line 188: (p_rec in pqh_crf_shd.g_rec_type

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

Line 198: IF NOT pqh_crf_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_crf_shd.api_updating
199: (p_criteria_rate_factor_id => p_rec.criteria_rate_factor_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_crf_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_crf_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_crf_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_crf_shd.g_tab_nam
220: );
221: end if;
222: --
223: End chk_non_updateable_args;

Line 311: l_api_updating := pqh_crf_shd.api_updating

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

Line 317: <> nvl(pqh_crf_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_crf_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_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK1');

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

Line 395: l_api_updating := pqh_crf_shd.api_updating

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

Line 401: <> nvl(pqh_crf_shd.g_old_rec.parent_rate_matrix_id,hr_api.g_number)

397: p_object_version_number => p_object_version_number);
398: --
399: if (l_api_updating
400: and nvl(p_parent_rate_matrix_id,hr_api.g_number)
401: <> nvl(pqh_crf_shd.g_old_rec.parent_rate_matrix_id,hr_api.g_number)
402: or not l_api_updating) then
403: --
404: -- check if PL_ID value exists in
405: -- BEN_PL_F table

Line 418: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK4');

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

Line 480: l_api_updating := pqh_crf_shd.api_updating

476: --
477: hr_utility.set_location('Entering:'||l_proc,10);
478: --
479:
480: l_api_updating := pqh_crf_shd.api_updating
481: (p_criteria_rate_factor_id => p_criteria_rate_factor_id,
482: p_object_version_number => p_object_version_number);
483: --
484: if (l_api_updating

Line 486: <> nvl(pqh_crf_shd.g_old_rec.business_group_id,hr_api.g_number)

482: p_object_version_number => p_object_version_number);
483: --
484: if (l_api_updating
485: and nvl(p_business_group_id,hr_api.g_number)
486: <> nvl(pqh_crf_shd.g_old_rec.business_group_id,hr_api.g_number)
487: or not l_api_updating) then
488: --
489: -- check if business_group_id value exists in
490: -- HR_ALL_ORGANIZATION_UNITS table

Line 504: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK3');

500: --
501: -- raise error as FK does not relate to PK in HR_ALL_ORGANIZATION_UNITS
502: -- table.
503: --
504: pqh_crf_shd.constraint_error('PQH_CRITERIA_RATE_FACTORS_FK3');
505: --
506: end if;
507: --
508: close c1;

Line 542: (p_rec in pqh_crf_shd.g_rec_type

538: -- ----------------------------------------------------------------------------
539: -- |---------------------------< insert_validate >----------------------------|
540: -- ----------------------------------------------------------------------------
541: Procedure insert_validate
542: (p_rec in pqh_crf_shd.g_rec_type
543: ) is
544: --
545: l_proc varchar2(72) := g_package||'insert_validate';
546: --

Line 564: ,p_associated_column1 => pqh_crf_shd.g_tab_nam

560: -- Validate Important Attributes
561: --
562: hr_api.validate_bus_grp_id
563: (p_business_group_id => p_rec.business_group_id
564: ,p_associated_column1 => pqh_crf_shd.g_tab_nam
565: || '.BUSINESS_GROUP_ID');
566: --
567: -- after validating the set of important attributes,
568: -- if Multiple Message Detection is enabled and at least

Line 617: (p_rec in pqh_crf_shd.g_rec_type

613: -- ----------------------------------------------------------------------------
614: -- |---------------------------< update_validate >----------------------------|
615: -- ----------------------------------------------------------------------------
616: Procedure update_validate
617: (p_rec in pqh_crf_shd.g_rec_type
618: ) is
619: --
620: l_proc varchar2(72) := g_package||'update_validate';
621: --

Line 639: ,p_associated_column1 => pqh_crf_shd.g_tab_nam

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

Line 695: (p_rec in pqh_crf_shd.g_rec_type

691: -- ----------------------------------------------------------------------------
692: -- |---------------------------< delete_validate >----------------------------|
693: -- ----------------------------------------------------------------------------
694: Procedure delete_validate
695: (p_rec in pqh_crf_shd.g_rec_type
696: ) is
697: --
698: l_proc varchar2(72) := g_package||'delete_validate';
699: --

Line 705: ,pqh_crf_shd.g_old_rec.business_group_id

701: hr_utility.set_location('Entering:'||l_proc, 5);
702: --
703: --
704: chk_startup_action(false
705: ,pqh_crf_shd.g_old_rec.business_group_id
706: ,pqh_crf_shd.g_old_rec.legislation_code
707: );
708: IF hr_startup_data_api_support.g_startup_mode
709: NOT IN ('GENERIC','STARTUP') THEN

Line 706: ,pqh_crf_shd.g_old_rec.legislation_code

702: --
703: --
704: chk_startup_action(false
705: ,pqh_crf_shd.g_old_rec.business_group_id
706: ,pqh_crf_shd.g_old_rec.legislation_code
707: );
708: IF hr_startup_data_api_support.g_startup_mode
709: NOT IN ('GENERIC','STARTUP') THEN
710: --