APPS.PAY_SBT_BUS dependencies on HR_API

Line 101: if nvl(p_rec.template_id, hr_api.g_number) <>

97: -- Check the otherwise non-updateable arguments.
98: --
99: -- p_template_id
100: --
101: if nvl(p_rec.template_id, hr_api.g_number) <>
102: nvl(pay_sbt_shd.g_old_rec.template_id, hr_api.g_number)
103: then
104: l_argument := 'p_template_id';
105: raise l_error;

Line 102: nvl(pay_sbt_shd.g_old_rec.template_id, hr_api.g_number)

98: --
99: -- p_template_id
100: --
101: if nvl(p_rec.template_id, hr_api.g_number) <>
102: nvl(pay_sbt_shd.g_old_rec.template_id, hr_api.g_number)
103: then
104: l_argument := 'p_template_id';
105: raise l_error;
106: end if;

Line 110: if nvl(p_rec.balance_uom, hr_api.g_varchar2) <>

106: end if;
107: --
108: -- p_balance_uom
109: --
110: if nvl(p_rec.balance_uom, hr_api.g_varchar2) <>
111: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)
112: then
113: --
114: -- Check to see if the update is allowed.

Line 111: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)

107: --
108: -- p_balance_uom
109: --
110: if nvl(p_rec.balance_uom, hr_api.g_varchar2) <>
111: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)
112: then
113: --
114: -- Check to see if the update is allowed.
115: --

Line 128: if nvl(p_rec.input_value_id, hr_api.g_number) <>

124: end if;
125: --
126: -- p_input_value_id
127: --
128: if nvl(p_rec.input_value_id, hr_api.g_number) <>
129: nvl(pay_sbt_shd.g_old_rec.input_value_id, hr_api.g_number)
130: then
131: l_argument := 'input_value_id';
132: raise l_error;

Line 129: nvl(pay_sbt_shd.g_old_rec.input_value_id, hr_api.g_number)

125: --
126: -- p_input_value_id
127: --
128: if nvl(p_rec.input_value_id, hr_api.g_number) <>
129: nvl(pay_sbt_shd.g_old_rec.input_value_id, hr_api.g_number)
130: then
131: l_argument := 'input_value_id';
132: raise l_error;
133: end if;

Line 139: hr_api.argument_changed_error

135: hr_utility.set_location('Leaving:'||l_proc, 25);
136: exception
137: when l_error then
138: hr_utility.set_location('Leaving:'||l_proc, 30);
139: hr_api.argument_changed_error
140: (p_api_name => l_proc
141: ,p_argument => l_argument);
142: when others then
143: hr_utility.set_location('Leaving:'||l_proc, 35);

Line 168: hr_api.mandatory_arg_error

164: hr_utility.set_location('Entering:'||l_proc, 5);
165: --
166: -- Check that template_id is not null.
167: --
168: hr_api.mandatory_arg_error
169: (p_api_name => l_proc
170: ,p_argument => 'p_template_id'
171: ,p_argument_value => p_template_id
172: );

Line 206: and upper(nvl(sbt.balance_name, hr_api.g_varchar2)) =

202: cursor csr_T_balance_name_exists is
203: select null
204: from pay_shadow_balance_types sbt
205: where sbt.template_id = p_template_id
206: and upper(nvl(sbt.balance_name, hr_api.g_varchar2)) =
207: upper(nvl(p_balance_name, hr_api.g_varchar2));
208: --
209: -- Cursor to check that the balance name is unique for a business group
210: -- (template type = 'U').

Line 207: upper(nvl(p_balance_name, hr_api.g_varchar2));

203: select null
204: from pay_shadow_balance_types sbt
205: where sbt.template_id = p_template_id
206: and upper(nvl(sbt.balance_name, hr_api.g_varchar2)) =
207: upper(nvl(p_balance_name, hr_api.g_varchar2));
208: --
209: -- Cursor to check that the balance name is unique for a business group
210: -- (template type = 'U').
211: --

Line 235: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>

231: l_api_updating := pay_sbt_shd.api_updating
232: (p_balance_type_id => p_balance_type_id
233: ,p_object_version_number => p_object_version_number
234: );
235: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>
236: nvl(pay_sbt_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or
237: not l_api_updating
238: then
239: --

Line 236: nvl(pay_sbt_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or

232: (p_balance_type_id => p_balance_type_id
233: ,p_object_version_number => p_object_version_number
234: );
235: if (l_api_updating and nvl(p_balance_name, hr_api.g_varchar2) <>
236: nvl(pay_sbt_shd.g_old_rec.balance_name, hr_api.g_varchar2)) or
237: not l_api_updating
238: then
239: --
240: -- The name cannot be null if the template type is 'U'.

Line 323: nvl(p_assignment_remuneration_flag, hr_api.g_varchar2) <>

319: (p_balance_type_id => p_balance_type_id
320: ,p_object_version_number => p_object_version_number
321: );
322: if (l_api_updating and
323: nvl(p_assignment_remuneration_flag, hr_api.g_varchar2) <>
324: nvl(pay_sbt_shd.g_old_rec.assignment_remuneration_flag,
325: hr_api.g_varchar2)) or
326: not l_api_updating
327: then

Line 325: hr_api.g_varchar2)) or

321: );
322: if (l_api_updating and
323: nvl(p_assignment_remuneration_flag, hr_api.g_varchar2) <>
324: nvl(pay_sbt_shd.g_old_rec.assignment_remuneration_flag,
325: hr_api.g_varchar2)) or
326: not l_api_updating
327: then
328: --
329: -- Check that the core object type is not null.

Line 331: hr_api.mandatory_arg_error

327: then
328: --
329: -- Check that the core object type is not null.
330: --
331: hr_api.mandatory_arg_error
332: (p_api_name => l_proc
333: ,p_argument => 'p_assignment_remuneration_flag'
334: ,p_argument_value => p_assignment_remuneration_flag
335: );

Line 339: if hr_api.not_exists_in_hr_lookups

335: );
336: --
337: -- Validate against hr_lookups.
338: --
339: if hr_api.not_exists_in_hr_lookups
340: (p_effective_date => p_effective_date
341: ,p_lookup_type => 'YES_NO'
342: ,p_lookup_code => p_assignment_remuneration_flag
343: )

Line 383: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>

379: l_api_updating := pay_sbt_shd.api_updating
380: (p_balance_type_id => p_balance_type_id
381: ,p_object_version_number => p_object_version_number
382: );
383: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
384: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) or
385: not l_api_updating
386: then
387: --

Line 384: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) or

380: (p_balance_type_id => p_balance_type_id
381: ,p_object_version_number => p_object_version_number
382: );
383: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
384: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) or
385: not l_api_updating
386: then
387: --
388: -- Check that the core object type is not null.

Line 390: hr_api.mandatory_arg_error

386: then
387: --
388: -- Check that the core object type is not null.
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc
392: ,p_argument => 'p_balance_uom'
393: ,p_argument_value => p_balance_uom
394: );

Line 398: if hr_api.not_exists_in_hr_lookups

394: );
395: --
396: -- Validate against hr_lookups.
397: --
398: if hr_api.not_exists_in_hr_lookups
399: (p_effective_date => p_effective_date
400: ,p_lookup_type => 'UNITS'
401: ,p_lookup_code => p_balance_uom
402: )

Line 412: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>

408: fnd_message.raise_error;
409: end if;
410: end if;
411: --
412: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
413: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) and
414: (p_input_value_id is not null) then
415: --
416: -- Check that the UOMs are compatible

Line 413: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) and

409: end if;
410: end if;
411: --
412: if (l_api_updating and nvl(p_balance_uom, hr_api.g_varchar2) <>
413: nvl(pay_sbt_shd.g_old_rec.balance_uom, hr_api.g_varchar2)) and
414: (p_input_value_id is not null) then
415: --
416: -- Check that the UOMs are compatible
417: --

Line 459: if (l_api_updating and nvl(p_currency_code, hr_api.g_varchar2) <>

455: l_api_updating := pay_sbt_shd.api_updating
456: (p_balance_type_id => p_balance_type_id
457: ,p_object_version_number => p_object_version_number
458: );
459: if (l_api_updating and nvl(p_currency_code, hr_api.g_varchar2) <>
460: nvl(pay_sbt_shd.g_old_rec.currency_code, hr_api.g_varchar2)) or
461: not l_api_updating
462: then
463: if p_currency_code is not null then

Line 460: nvl(pay_sbt_shd.g_old_rec.currency_code, hr_api.g_varchar2)) or

456: (p_balance_type_id => p_balance_type_id
457: ,p_object_version_number => p_object_version_number
458: );
459: if (l_api_updating and nvl(p_currency_code, hr_api.g_varchar2) <>
460: nvl(pay_sbt_shd.g_old_rec.currency_code, hr_api.g_varchar2)) or
461: not l_api_updating
462: then
463: if p_currency_code is not null then
464: open csr_valid_currency_code;

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

501: l_api_updating := pay_sbt_shd.api_updating
502: (p_balance_type_id => p_balance_type_id
503: ,p_object_version_number => p_object_version_number
504: );
505: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
506: nvl(pay_sbt_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
507: not l_api_updating
508: then
509: if p_exclusion_rule_id is not null then

Line 506: nvl(pay_sbt_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

502: (p_balance_type_id => p_balance_type_id
503: ,p_object_version_number => p_object_version_number
504: );
505: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
506: nvl(pay_sbt_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
507: not l_api_updating
508: then
509: if p_exclusion_rule_id is not null then
510: open csr_exclusion_rule_id_valid;

Line 558: if (l_api_updating and nvl(p_base_balance_type_id, hr_api.g_number) <>

554: (p_balance_type_id => p_balance_type_id
555: ,p_object_version_number => p_object_version_number
556: );
557:
558: if (l_api_updating and nvl(p_base_balance_type_id, hr_api.g_number) <>
559: nvl(pay_sbt_shd.g_old_rec.base_balance_type_id, hr_api.g_number)) or
560: not l_api_updating
561: then
562: --

Line 559: nvl(pay_sbt_shd.g_old_rec.base_balance_type_id, hr_api.g_number)) or

555: ,p_object_version_number => p_object_version_number
556: );
557:
558: if (l_api_updating and nvl(p_base_balance_type_id, hr_api.g_number) <>
559: nvl(pay_sbt_shd.g_old_rec.base_balance_type_id, hr_api.g_number)) or
560: not l_api_updating
561: then
562: --
563: -- Only one of the base_balance_name and base_balance_type_id may be