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 HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'rate_element_relation_id'
50: ,p_argument_value => p_rate_element_relation_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'rate_element_relation_id'
119: ,p_argument_value => p_rate_element_relation_id
120: );

Line 122: if ( nvl(pqh_rer_bus.g_rate_element_relation_id, hr_api.g_number)

118: ,p_argument => 'rate_element_relation_id'
119: ,p_argument_value => p_rate_element_relation_id
120: );
121: --
122: if ( nvl(pqh_rer_bus.g_rate_element_relation_id, hr_api.g_number)
123: = p_rate_element_relation_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 213: if nvl(p_rec.business_group_id, hr_api.g_number) <>

209: -- EDIT_HERE: Add checks to ensure non-updateable args have
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

Line 215: ,hr_api.g_number

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
219: ,p_argument => 'BUSINESS_GROUP_ID'

Line 217: hr_api.argument_changed_error

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
219: ,p_argument => 'BUSINESS_GROUP_ID'
220: ,p_base_table => pqh_rer_shd.g_tab_nam
221: );

Line 321: and nvl(p_criteria_rate_element_id,hr_api.g_number)

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
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

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 410: and nvl(p_rel_element_type_id,hr_api.g_number)

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
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

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 493: and nvl(p_rel_input_value_id,hr_api.g_number)

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
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

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 575: and nvl(p_business_group_id ,hr_api.g_number)

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
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

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 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 637: if hr_api.not_exists_in_hr_lookups

633: and p_relation_type_cd is not null then
634:
635: -- check if value of lookup falls within lookup type.
636:
637: if hr_api.not_exists_in_hr_lookups
638: (p_lookup_type => 'PQH_RBC_ELMNT_RELATION_TYPE',
639: p_lookup_code => p_relation_type_cd,
640: p_effective_date => p_effective_date) then
641: --

Line 683: hr_api.validate_bus_grp_id

679: NOT IN ('GENERIC','STARTUP') THEN
680: --
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: --

Line 759: hr_api.validate_bus_grp_id

755: NOT IN ('GENERIC','STARTUP') THEN
756: --
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: --