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.PAY_SIV_BUS dependencies on HR_API

Line 77: p_legislation_code := hr_api.return_legislation_code(p_business_group_id);

73:
74: close csr_get_template_info;
75:
76: if p_business_group_id is not null then
77: p_legislation_code := hr_api.return_legislation_code(p_business_group_id);
78: end if;
79:
80: hr_utility.set_location(' Leaving:'||l_proc, 15);
81: End get_template_info;

Line 143: if nvl(p_rec.element_type_id, hr_api.g_number) <>

139: -- Check the otherwise non-updateable arguments.
140: --
141: -- p_element_type_id
142: --
143: if nvl(p_rec.element_type_id, hr_api.g_number) <>
144: nvl(pay_siv_shd.g_old_rec.element_type_id, hr_api.g_number)
145: then
146: l_argument := 'p_element_type_id';
147: raise l_error;

Line 144: nvl(pay_siv_shd.g_old_rec.element_type_id, hr_api.g_number)

140: --
141: -- p_element_type_id
142: --
143: if nvl(p_rec.element_type_id, hr_api.g_number) <>
144: nvl(pay_siv_shd.g_old_rec.element_type_id, hr_api.g_number)
145: then
146: l_argument := 'p_element_type_id';
147: raise l_error;
148: end if;

Line 152: if nvl(p_rec.uom, hr_api.g_varchar2) <>

148: end if;
149: --
150: -- p_uom
151: --
152: if nvl(p_rec.uom, hr_api.g_varchar2) <>
153: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)
154: then
155: --
156: -- Check to see if the update is allowed.

Line 153: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)

149: --
150: -- p_uom
151: --
152: if nvl(p_rec.uom, hr_api.g_varchar2) <>
153: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)
154: then
155: --
156: -- Check to see if the update is allowed.
157: --

Line 171: hr_api.argument_changed_error

167: hr_utility.set_location('Leaving:'||l_proc, 25);
168: exception
169: when l_error then
170: hr_utility.set_location('Leaving:'||l_proc, 30);
171: hr_api.argument_changed_error
172: (p_api_name => l_proc
173: ,p_argument => l_argument);
174: when others then
175: hr_utility.set_location('Leaving:'||l_proc, 35);

Line 213: hr_api.mandatory_arg_error

209: hr_utility.set_location('Entering:'||l_proc, 5);
210: --
211: -- Check that the element type is not null.
212: --
213: hr_api.mandatory_arg_error
214: (p_api_name => l_proc
215: ,p_argument => 'p_element_type_id'
216: ,p_argument_value => p_element_type_id
217: );

Line 272: if (l_api_updating and nvl(p_display_sequence, hr_api.g_number) <>

268: l_api_updating := pay_siv_shd.api_updating
269: (p_input_value_id => p_input_value_id
270: ,p_object_version_number => p_object_version_number
271: );
272: if (l_api_updating and nvl(p_display_sequence, hr_api.g_number) <>
273: nvl(pay_siv_shd.g_old_rec.display_sequence, hr_api.g_number)) or
274: not l_api_updating
275: then
276: --

Line 273: nvl(pay_siv_shd.g_old_rec.display_sequence, hr_api.g_number)) or

269: (p_input_value_id => p_input_value_id
270: ,p_object_version_number => p_object_version_number
271: );
272: if (l_api_updating and nvl(p_display_sequence, hr_api.g_number) <>
273: nvl(pay_siv_shd.g_old_rec.display_sequence, hr_api.g_number)) or
274: not l_api_updating
275: then
276: --
277: -- Check that display_sequence is not null.

Line 279: hr_api.mandatory_arg_error

275: then
276: --
277: -- Check that display_sequence is not null.
278: --
279: hr_api.mandatory_arg_error
280: (p_api_name => l_proc
281: ,p_argument => 'p_display_sequence'
282: ,p_argument_value => p_display_sequence
283: );

Line 317: nvl(p_lookup_code, hr_api.g_varchar2) <>

313: ,p_api_updating in boolean
314: ) is
315: begin
316: if (p_updatable and p_api_updating and
317: nvl(p_lookup_code, hr_api.g_varchar2) <>
318: nvl(p_old_lookup_code, hr_api.g_varchar2)) or not p_api_updating
319: then
320: --
321: -- Check that mandatory argument is not null.

Line 318: nvl(p_old_lookup_code, hr_api.g_varchar2)) or not p_api_updating

314: ) is
315: begin
316: if (p_updatable and p_api_updating and
317: nvl(p_lookup_code, hr_api.g_varchar2) <>
318: nvl(p_old_lookup_code, hr_api.g_varchar2)) or not p_api_updating
319: then
320: --
321: -- Check that mandatory argument is not null.
322: --

Line 324: hr_api.mandatory_arg_error

320: --
321: -- Check that mandatory argument is not null.
322: --
323: if p_mandatory then
324: hr_api.mandatory_arg_error
325: (p_api_name => p_caller
326: ,p_argument => p_argument_name
327: ,p_argument_value => p_lookup_code
328: );

Line 339: if hr_api.not_exists_in_hr_lookups

335: end if;
336: --
337: -- Do the lookup check.
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_effective_date => p_effective_date
341: ,p_lookup_type => p_lookup_type
342: ,p_lookup_code => p_lookup_code
343: )

Line 463: if (l_api_updating and nvl(p_name, hr_api.g_varchar2) <>

459: l_api_updating := pay_siv_shd.api_updating
460: (p_input_value_id => p_input_value_id
461: ,p_object_version_number => p_object_version_number
462: );
463: if (l_api_updating and nvl(p_name, hr_api.g_varchar2) <>
464: nvl(pay_siv_shd.g_old_rec.name, hr_api.g_varchar2)) or
465: not l_api_updating
466: then
467: --

Line 464: nvl(pay_siv_shd.g_old_rec.name, hr_api.g_varchar2)) or

460: (p_input_value_id => p_input_value_id
461: ,p_object_version_number => p_object_version_number
462: );
463: if (l_api_updating and nvl(p_name, hr_api.g_varchar2) <>
464: nvl(pay_siv_shd.g_old_rec.name, hr_api.g_varchar2)) or
465: not l_api_updating
466: then
467: --
468: -- Check that the name is not already in use.

Line 535: l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>

531: --
532: -- Has the UOM changed ?
533: --
534: l_uom_changed :=
535: l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>
536: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2);
537: --
538: -- Check the lookup type.
539: --

Line 536: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2);

532: -- Has the UOM changed ?
533: --
534: l_uom_changed :=
535: l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>
536: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2);
537: --
538: -- Check the lookup type.
539: --
540: l_chk_default := false;

Line 541: if (l_api_updating and nvl(p_lookup_type, hr_api.g_varchar2) <>

537: --
538: -- Check the lookup type.
539: --
540: l_chk_default := false;
541: if (l_api_updating and nvl(p_lookup_type, hr_api.g_varchar2) <>
542: nvl(pay_siv_shd.g_old_rec.lookup_type, hr_api.g_varchar2)) or
543: not l_api_updating or
544: l_uom_changed
545: then

Line 542: nvl(pay_siv_shd.g_old_rec.lookup_type, hr_api.g_varchar2)) or

538: -- Check the lookup type.
539: --
540: l_chk_default := false;
541: if (l_api_updating and nvl(p_lookup_type, hr_api.g_varchar2) <>
542: nvl(pay_siv_shd.g_old_rec.lookup_type, hr_api.g_varchar2)) or
543: not l_api_updating or
544: l_uom_changed
545: then
546: if p_lookup_type is not null then

Line 578: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>

574: end if;
575: --
576: -- Check the default value.
577: --
578: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>
579: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or
580: not l_api_updating or
581: l_chk_default
582: then

Line 579: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or

575: --
576: -- Check the default value.
577: --
578: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>
579: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or
580: not l_api_updating or
581: l_chk_default
582: then
583: if p_default_value is not null and p_lookup_type is not null and

Line 584: hr_api.not_exists_in_hr_lookups

580: not l_api_updating or
581: l_chk_default
582: then
583: if p_default_value is not null and p_lookup_type is not null and
584: hr_api.not_exists_in_hr_lookups
585: (p_effective_date => p_effective_date
586: ,p_lookup_type => p_lookup_type
587: ,p_lookup_code => p_default_value
588: )

Line 731: if (l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>

727: --
728: -- Did the UOM get updated ? Note: it should have already been checked
729: -- for validity.
730: --
731: if (l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>
732: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)) or
733: not l_api_updating
734: then
735: l_uom_updated := true;

Line 732: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)) or

728: -- Did the UOM get updated ? Note: it should have already been checked
729: -- for validity.
730: --
731: if (l_api_updating and nvl(p_uom, hr_api.g_varchar2) <>
732: nvl(pay_siv_shd.g_old_rec.uom, hr_api.g_varchar2)) or
733: not l_api_updating
734: then
735: l_uom_updated := true;
736: l_uom := p_uom;

Line 743: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>

739: end if;
740: --
741: -- Decide what needs checking.
742: --
743: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>
744: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or
745: not l_api_updating
746: then
747: l_chk_def := true;

Line 744: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or

740: --
741: -- Decide what needs checking.
742: --
743: if (l_api_updating and nvl(p_default_value, hr_api.g_varchar2) <>
744: nvl(pay_siv_shd.g_old_rec.default_value, hr_api.g_varchar2)) or
745: not l_api_updating
746: then
747: l_chk_def := true;
748: l_def := p_default_value;

Line 753: if (l_api_updating and nvl(p_max_value, hr_api.g_varchar2) <>

749: else
750: l_def := pay_siv_shd.g_old_rec.default_value;
751: end if;
752: --
753: if (l_api_updating and nvl(p_max_value, hr_api.g_varchar2) <>
754: nvl(pay_siv_shd.g_old_rec.max_value, hr_api.g_varchar2)) or
755: not l_api_updating
756: then
757: l_chk_max := true;

Line 754: nvl(pay_siv_shd.g_old_rec.max_value, hr_api.g_varchar2)) or

750: l_def := pay_siv_shd.g_old_rec.default_value;
751: end if;
752: --
753: if (l_api_updating and nvl(p_max_value, hr_api.g_varchar2) <>
754: nvl(pay_siv_shd.g_old_rec.max_value, hr_api.g_varchar2)) or
755: not l_api_updating
756: then
757: l_chk_max := true;
758: l_max := p_max_value;

Line 763: if (l_api_updating and nvl(p_min_value, hr_api.g_varchar2) <>

759: else
760: l_max := pay_siv_shd.g_old_rec.max_value;
761: end if;
762: --
763: if (l_api_updating and nvl(p_min_value, hr_api.g_varchar2) <>
764: nvl(pay_siv_shd.g_old_rec.min_value, hr_api.g_varchar2)) or
765: not l_api_updating
766: then
767: l_chk_min := true;

Line 764: nvl(pay_siv_shd.g_old_rec.min_value, hr_api.g_varchar2)) or

760: l_max := pay_siv_shd.g_old_rec.max_value;
761: end if;
762: --
763: if (l_api_updating and nvl(p_min_value, hr_api.g_varchar2) <>
764: nvl(pay_siv_shd.g_old_rec.min_value, hr_api.g_varchar2)) or
765: not l_api_updating
766: then
767: l_chk_min := true;
768: l_min := p_min_value;

Line 901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =

897: from pay_shadow_element_types pset
898: , pay_shadow_input_values psiv
899: where pset.template_id = p_template_id
900: and psiv.element_type_id = pset.element_type_id
901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
902: upper(p_default_value_column)
903: and (psiv.uom <> p_uom or nvl(psiv.lookup_type, hr_api.g_varchar2) <>
904: nvl(p_lookup_type, hr_api.g_varchar2));
905: --

Line 903: and (psiv.uom <> p_uom or nvl(psiv.lookup_type, hr_api.g_varchar2) <>

899: where pset.template_id = p_template_id
900: and psiv.element_type_id = pset.element_type_id
901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
902: upper(p_default_value_column)
903: and (psiv.uom <> p_uom or nvl(psiv.lookup_type, hr_api.g_varchar2) <>
904: nvl(p_lookup_type, hr_api.g_varchar2));
905: --
906: l_proc varchar2(72) := g_package||'chk_default_value_column';
907: l_len number;

Line 904: nvl(p_lookup_type, hr_api.g_varchar2));

900: and psiv.element_type_id = pset.element_type_id
901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
902: upper(p_default_value_column)
903: and (psiv.uom <> p_uom or nvl(psiv.lookup_type, hr_api.g_varchar2) <>
904: nvl(p_lookup_type, hr_api.g_varchar2));
905: --
906: l_proc varchar2(72) := g_package||'chk_default_value_column';
907: l_len number;
908: l_prefix varchar2(2000);

Line 921: if (l_api_updating and nvl(p_default_value_column, hr_api.g_varchar2) <>

917: l_api_updating := pay_siv_shd.api_updating
918: (p_input_value_id => p_input_value_id
919: ,p_object_version_number => p_object_version_number
920: );
921: if (l_api_updating and nvl(p_default_value_column, hr_api.g_varchar2) <>
922: nvl(pay_siv_shd.g_old_rec.default_value_column, hr_api.g_varchar2)) or
923: not l_api_updating
924: then
925: if p_default_value_column is not null then

Line 922: nvl(pay_siv_shd.g_old_rec.default_value_column, hr_api.g_varchar2)) or

918: (p_input_value_id => p_input_value_id
919: ,p_object_version_number => p_object_version_number
920: );
921: if (l_api_updating and nvl(p_default_value_column, hr_api.g_varchar2) <>
922: nvl(pay_siv_shd.g_old_rec.default_value_column, hr_api.g_varchar2)) or
923: not l_api_updating
924: then
925: if p_default_value_column is not null then
926: --

Line 1011: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

1007: l_api_updating := pay_siv_shd.api_updating
1008: (p_input_value_id => p_input_value_id
1009: ,p_object_version_number => p_object_version_number
1010: );
1011: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
1012: nvl(pay_siv_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
1013: not l_api_updating
1014: then
1015: if p_exclusion_rule_id is not null then

Line 1012: nvl(pay_siv_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

1008: (p_input_value_id => p_input_value_id
1009: ,p_object_version_number => p_object_version_number
1010: );
1011: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
1012: nvl(pay_siv_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
1013: not l_api_updating
1014: then
1015: if p_exclusion_rule_id is not null then
1016: open csr_exclusion_rule_id_valid;

Line 1052: where nvl(sfr.input_value_id, hr_api.g_number) = p_input_value_id;

1048: --
1049: cursor csr_formula_rules is
1050: select null
1051: from pay_shadow_formula_rules sfr
1052: where nvl(sfr.input_value_id, hr_api.g_number) = p_input_value_id;
1053: --
1054: cursor csr_iterative_rules is
1055: select null
1056: from pay_shadow_iterative_rules sir

Line 1170: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>

1166: (p_input_value_id => p_input_value_id
1167: ,p_object_version_number => p_object_version_number
1168: );
1169:
1170: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>
1171: nvl(pay_siv_shd.g_old_rec.formula_id, hr_api.g_number)) or
1172: not l_api_updating
1173: then
1174:

Line 1171: nvl(pay_siv_shd.g_old_rec.formula_id, hr_api.g_number)) or

1167: ,p_object_version_number => p_object_version_number
1168: );
1169:
1170: if (l_api_updating and nvl(p_formula_id, hr_api.g_number) <>
1171: nvl(pay_siv_shd.g_old_rec.formula_id, hr_api.g_number)) or
1172: not l_api_updating
1173: then
1174:
1175: if p_formula_id is not null then