APPS.PAY_SBT_UPD dependencies on HR_API

Line 108: When hr_api.check_integrity_violated Then

104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 10);
106: --
107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pay_sbt_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then

Line 111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

107: Exception
108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pay_sbt_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pay_sbt_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 112: When hr_api.parent_integrity_violated Then

108: When hr_api.check_integrity_violated Then
109: -- A check constraint has been violated
110: pay_sbt_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pay_sbt_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then

Line 115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pay_sbt_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: pay_sbt_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 116: When hr_api.unique_integrity_violated Then

112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: pay_sbt_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: pay_sbt_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then

Line 119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.unique_integrity_violated Then
117: -- Unique integrity has been violated
118: pay_sbt_shd.constraint_error
119: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
120: When Others Then
121: Raise;
122: End update_dml;
123: --

Line 265: If (p_rec.template_id = hr_api.g_number) then

261: -- p_rec plsql record structure
262: -- to see if a system default is being used. If a system default
263: -- is being used then we must set to the 'current' argument value.
264: --
265: If (p_rec.template_id = hr_api.g_number) then
266: p_rec.template_id :=
267: pay_sbt_shd.g_old_rec.template_id;
268: End If;
269: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then

Line 269: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then

265: If (p_rec.template_id = hr_api.g_number) then
266: p_rec.template_id :=
267: pay_sbt_shd.g_old_rec.template_id;
268: End If;
269: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then
270: p_rec.assignment_remuneration_flag :=
271: pay_sbt_shd.g_old_rec.assignment_remuneration_flag;
272: End If;
273: If (p_rec.balance_name = hr_api.g_varchar2) then

Line 273: If (p_rec.balance_name = hr_api.g_varchar2) then

269: If (p_rec.assignment_remuneration_flag = hr_api.g_varchar2) then
270: p_rec.assignment_remuneration_flag :=
271: pay_sbt_shd.g_old_rec.assignment_remuneration_flag;
272: End If;
273: If (p_rec.balance_name = hr_api.g_varchar2) then
274: p_rec.balance_name :=
275: pay_sbt_shd.g_old_rec.balance_name;
276: End If;
277: If (p_rec.balance_uom = hr_api.g_varchar2) then

Line 277: If (p_rec.balance_uom = hr_api.g_varchar2) then

273: If (p_rec.balance_name = hr_api.g_varchar2) then
274: p_rec.balance_name :=
275: pay_sbt_shd.g_old_rec.balance_name;
276: End If;
277: If (p_rec.balance_uom = hr_api.g_varchar2) then
278: p_rec.balance_uom :=
279: pay_sbt_shd.g_old_rec.balance_uom;
280: End If;
281: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 281: If (p_rec.currency_code = hr_api.g_varchar2) then

277: If (p_rec.balance_uom = hr_api.g_varchar2) then
278: p_rec.balance_uom :=
279: pay_sbt_shd.g_old_rec.balance_uom;
280: End If;
281: If (p_rec.currency_code = hr_api.g_varchar2) then
282: p_rec.currency_code :=
283: pay_sbt_shd.g_old_rec.currency_code;
284: End If;
285: If (p_rec.comments = hr_api.g_varchar2) then

Line 285: If (p_rec.comments = hr_api.g_varchar2) then

281: If (p_rec.currency_code = hr_api.g_varchar2) then
282: p_rec.currency_code :=
283: pay_sbt_shd.g_old_rec.currency_code;
284: End If;
285: If (p_rec.comments = hr_api.g_varchar2) then
286: p_rec.comments :=
287: pay_sbt_shd.g_old_rec.comments;
288: End If;
289: If (p_rec.reporting_name = hr_api.g_varchar2) then

Line 289: If (p_rec.reporting_name = hr_api.g_varchar2) then

285: If (p_rec.comments = hr_api.g_varchar2) then
286: p_rec.comments :=
287: pay_sbt_shd.g_old_rec.comments;
288: End If;
289: If (p_rec.reporting_name = hr_api.g_varchar2) then
290: p_rec.reporting_name :=
291: pay_sbt_shd.g_old_rec.reporting_name;
292: End If;
293: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 293: If (p_rec.attribute_category = hr_api.g_varchar2) then

289: If (p_rec.reporting_name = hr_api.g_varchar2) then
290: p_rec.reporting_name :=
291: pay_sbt_shd.g_old_rec.reporting_name;
292: End If;
293: If (p_rec.attribute_category = hr_api.g_varchar2) then
294: p_rec.attribute_category :=
295: pay_sbt_shd.g_old_rec.attribute_category;
296: End If;
297: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 297: If (p_rec.attribute1 = hr_api.g_varchar2) then

293: If (p_rec.attribute_category = hr_api.g_varchar2) then
294: p_rec.attribute_category :=
295: pay_sbt_shd.g_old_rec.attribute_category;
296: End If;
297: If (p_rec.attribute1 = hr_api.g_varchar2) then
298: p_rec.attribute1 :=
299: pay_sbt_shd.g_old_rec.attribute1;
300: End If;
301: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 301: If (p_rec.attribute2 = hr_api.g_varchar2) then

297: If (p_rec.attribute1 = hr_api.g_varchar2) then
298: p_rec.attribute1 :=
299: pay_sbt_shd.g_old_rec.attribute1;
300: End If;
301: If (p_rec.attribute2 = hr_api.g_varchar2) then
302: p_rec.attribute2 :=
303: pay_sbt_shd.g_old_rec.attribute2;
304: End If;
305: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 305: If (p_rec.attribute3 = hr_api.g_varchar2) then

301: If (p_rec.attribute2 = hr_api.g_varchar2) then
302: p_rec.attribute2 :=
303: pay_sbt_shd.g_old_rec.attribute2;
304: End If;
305: If (p_rec.attribute3 = hr_api.g_varchar2) then
306: p_rec.attribute3 :=
307: pay_sbt_shd.g_old_rec.attribute3;
308: End If;
309: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 309: If (p_rec.attribute4 = hr_api.g_varchar2) then

305: If (p_rec.attribute3 = hr_api.g_varchar2) then
306: p_rec.attribute3 :=
307: pay_sbt_shd.g_old_rec.attribute3;
308: End If;
309: If (p_rec.attribute4 = hr_api.g_varchar2) then
310: p_rec.attribute4 :=
311: pay_sbt_shd.g_old_rec.attribute4;
312: End If;
313: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 313: If (p_rec.attribute5 = hr_api.g_varchar2) then

309: If (p_rec.attribute4 = hr_api.g_varchar2) then
310: p_rec.attribute4 :=
311: pay_sbt_shd.g_old_rec.attribute4;
312: End If;
313: If (p_rec.attribute5 = hr_api.g_varchar2) then
314: p_rec.attribute5 :=
315: pay_sbt_shd.g_old_rec.attribute5;
316: End If;
317: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 317: If (p_rec.attribute6 = hr_api.g_varchar2) then

313: If (p_rec.attribute5 = hr_api.g_varchar2) then
314: p_rec.attribute5 :=
315: pay_sbt_shd.g_old_rec.attribute5;
316: End If;
317: If (p_rec.attribute6 = hr_api.g_varchar2) then
318: p_rec.attribute6 :=
319: pay_sbt_shd.g_old_rec.attribute6;
320: End If;
321: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 321: If (p_rec.attribute7 = hr_api.g_varchar2) then

317: If (p_rec.attribute6 = hr_api.g_varchar2) then
318: p_rec.attribute6 :=
319: pay_sbt_shd.g_old_rec.attribute6;
320: End If;
321: If (p_rec.attribute7 = hr_api.g_varchar2) then
322: p_rec.attribute7 :=
323: pay_sbt_shd.g_old_rec.attribute7;
324: End If;
325: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 325: If (p_rec.attribute8 = hr_api.g_varchar2) then

321: If (p_rec.attribute7 = hr_api.g_varchar2) then
322: p_rec.attribute7 :=
323: pay_sbt_shd.g_old_rec.attribute7;
324: End If;
325: If (p_rec.attribute8 = hr_api.g_varchar2) then
326: p_rec.attribute8 :=
327: pay_sbt_shd.g_old_rec.attribute8;
328: End If;
329: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 329: If (p_rec.attribute9 = hr_api.g_varchar2) then

325: If (p_rec.attribute8 = hr_api.g_varchar2) then
326: p_rec.attribute8 :=
327: pay_sbt_shd.g_old_rec.attribute8;
328: End If;
329: If (p_rec.attribute9 = hr_api.g_varchar2) then
330: p_rec.attribute9 :=
331: pay_sbt_shd.g_old_rec.attribute9;
332: End If;
333: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 333: If (p_rec.attribute10 = hr_api.g_varchar2) then

329: If (p_rec.attribute9 = hr_api.g_varchar2) then
330: p_rec.attribute9 :=
331: pay_sbt_shd.g_old_rec.attribute9;
332: End If;
333: If (p_rec.attribute10 = hr_api.g_varchar2) then
334: p_rec.attribute10 :=
335: pay_sbt_shd.g_old_rec.attribute10;
336: End If;
337: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 337: If (p_rec.attribute11 = hr_api.g_varchar2) then

333: If (p_rec.attribute10 = hr_api.g_varchar2) then
334: p_rec.attribute10 :=
335: pay_sbt_shd.g_old_rec.attribute10;
336: End If;
337: If (p_rec.attribute11 = hr_api.g_varchar2) then
338: p_rec.attribute11 :=
339: pay_sbt_shd.g_old_rec.attribute11;
340: End If;
341: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 341: If (p_rec.attribute12 = hr_api.g_varchar2) then

337: If (p_rec.attribute11 = hr_api.g_varchar2) then
338: p_rec.attribute11 :=
339: pay_sbt_shd.g_old_rec.attribute11;
340: End If;
341: If (p_rec.attribute12 = hr_api.g_varchar2) then
342: p_rec.attribute12 :=
343: pay_sbt_shd.g_old_rec.attribute12;
344: End If;
345: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 345: If (p_rec.attribute13 = hr_api.g_varchar2) then

341: If (p_rec.attribute12 = hr_api.g_varchar2) then
342: p_rec.attribute12 :=
343: pay_sbt_shd.g_old_rec.attribute12;
344: End If;
345: If (p_rec.attribute13 = hr_api.g_varchar2) then
346: p_rec.attribute13 :=
347: pay_sbt_shd.g_old_rec.attribute13;
348: End If;
349: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 349: If (p_rec.attribute14 = hr_api.g_varchar2) then

345: If (p_rec.attribute13 = hr_api.g_varchar2) then
346: p_rec.attribute13 :=
347: pay_sbt_shd.g_old_rec.attribute13;
348: End If;
349: If (p_rec.attribute14 = hr_api.g_varchar2) then
350: p_rec.attribute14 :=
351: pay_sbt_shd.g_old_rec.attribute14;
352: End If;
353: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 353: If (p_rec.attribute15 = hr_api.g_varchar2) then

349: If (p_rec.attribute14 = hr_api.g_varchar2) then
350: p_rec.attribute14 :=
351: pay_sbt_shd.g_old_rec.attribute14;
352: End If;
353: If (p_rec.attribute15 = hr_api.g_varchar2) then
354: p_rec.attribute15 :=
355: pay_sbt_shd.g_old_rec.attribute15;
356: End If;
357: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 357: If (p_rec.attribute16 = hr_api.g_varchar2) then

353: If (p_rec.attribute15 = hr_api.g_varchar2) then
354: p_rec.attribute15 :=
355: pay_sbt_shd.g_old_rec.attribute15;
356: End If;
357: If (p_rec.attribute16 = hr_api.g_varchar2) then
358: p_rec.attribute16 :=
359: pay_sbt_shd.g_old_rec.attribute16;
360: End If;
361: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 361: If (p_rec.attribute17 = hr_api.g_varchar2) then

357: If (p_rec.attribute16 = hr_api.g_varchar2) then
358: p_rec.attribute16 :=
359: pay_sbt_shd.g_old_rec.attribute16;
360: End If;
361: If (p_rec.attribute17 = hr_api.g_varchar2) then
362: p_rec.attribute17 :=
363: pay_sbt_shd.g_old_rec.attribute17;
364: End If;
365: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 365: If (p_rec.attribute18 = hr_api.g_varchar2) then

361: If (p_rec.attribute17 = hr_api.g_varchar2) then
362: p_rec.attribute17 :=
363: pay_sbt_shd.g_old_rec.attribute17;
364: End If;
365: If (p_rec.attribute18 = hr_api.g_varchar2) then
366: p_rec.attribute18 :=
367: pay_sbt_shd.g_old_rec.attribute18;
368: End If;
369: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 369: If (p_rec.attribute19 = hr_api.g_varchar2) then

365: If (p_rec.attribute18 = hr_api.g_varchar2) then
366: p_rec.attribute18 :=
367: pay_sbt_shd.g_old_rec.attribute18;
368: End If;
369: If (p_rec.attribute19 = hr_api.g_varchar2) then
370: p_rec.attribute19 :=
371: pay_sbt_shd.g_old_rec.attribute19;
372: End If;
373: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 373: If (p_rec.attribute20 = hr_api.g_varchar2) then

369: If (p_rec.attribute19 = hr_api.g_varchar2) then
370: p_rec.attribute19 :=
371: pay_sbt_shd.g_old_rec.attribute19;
372: End If;
373: If (p_rec.attribute20 = hr_api.g_varchar2) then
374: p_rec.attribute20 :=
375: pay_sbt_shd.g_old_rec.attribute20;
376: End If;
377: If (p_rec.jurisdiction_level = hr_api.g_number) then

Line 377: If (p_rec.jurisdiction_level = hr_api.g_number) then

373: If (p_rec.attribute20 = hr_api.g_varchar2) then
374: p_rec.attribute20 :=
375: pay_sbt_shd.g_old_rec.attribute20;
376: End If;
377: If (p_rec.jurisdiction_level = hr_api.g_number) then
378: p_rec.jurisdiction_level :=
379: pay_sbt_shd.g_old_rec.jurisdiction_level;
380: End If;
381: If (p_rec.tax_type = hr_api.g_varchar2) then

Line 381: If (p_rec.tax_type = hr_api.g_varchar2) then

377: If (p_rec.jurisdiction_level = hr_api.g_number) then
378: p_rec.jurisdiction_level :=
379: pay_sbt_shd.g_old_rec.jurisdiction_level;
380: End If;
381: If (p_rec.tax_type = hr_api.g_varchar2) then
382: p_rec.tax_type :=
383: pay_sbt_shd.g_old_rec.tax_type;
384: End If;
385: If (p_rec.exclusion_rule_id = hr_api.g_number) then

Line 385: If (p_rec.exclusion_rule_id = hr_api.g_number) then

381: If (p_rec.tax_type = hr_api.g_varchar2) then
382: p_rec.tax_type :=
383: pay_sbt_shd.g_old_rec.tax_type;
384: End If;
385: If (p_rec.exclusion_rule_id = hr_api.g_number) then
386: p_rec.exclusion_rule_id :=
387: pay_sbt_shd.g_old_rec.exclusion_rule_id;
388: End If;
389: If (p_rec.category_name = hr_api.g_varchar2) then

Line 389: If (p_rec.category_name = hr_api.g_varchar2) then

385: If (p_rec.exclusion_rule_id = hr_api.g_number) then
386: p_rec.exclusion_rule_id :=
387: pay_sbt_shd.g_old_rec.exclusion_rule_id;
388: End If;
389: If (p_rec.category_name = hr_api.g_varchar2) then
390: p_rec.category_name :=
391: pay_sbt_shd.g_old_rec.category_name;
392: End If;
393: If (p_rec.base_balance_type_id = hr_api.g_number) then

Line 393: If (p_rec.base_balance_type_id = hr_api.g_number) then

389: If (p_rec.category_name = hr_api.g_varchar2) then
390: p_rec.category_name :=
391: pay_sbt_shd.g_old_rec.category_name;
392: End If;
393: If (p_rec.base_balance_type_id = hr_api.g_number) then
394: p_rec.base_balance_type_id :=
395: pay_sbt_shd.g_old_rec.base_balance_type_id;
396: End If;
397: If (p_rec.base_balance_name = hr_api.g_varchar2) then

Line 397: If (p_rec.base_balance_name = hr_api.g_varchar2) then

393: If (p_rec.base_balance_type_id = hr_api.g_number) then
394: p_rec.base_balance_type_id :=
395: pay_sbt_shd.g_old_rec.base_balance_type_id;
396: End If;
397: If (p_rec.base_balance_name = hr_api.g_varchar2) then
398: p_rec.base_balance_name :=
399: pay_sbt_shd.g_old_rec.base_balance_name;
400: End If;
401: If (p_rec.input_value_id = hr_api.g_number) then

Line 401: If (p_rec.input_value_id = hr_api.g_number) then

397: If (p_rec.base_balance_name = hr_api.g_varchar2) then
398: p_rec.base_balance_name :=
399: pay_sbt_shd.g_old_rec.base_balance_name;
400: End If;
401: If (p_rec.input_value_id = hr_api.g_number) then
402: p_rec.input_value_id :=
403: pay_sbt_shd.g_old_rec.input_value_id;
404: End If;
405: --

Line 461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,

457: Procedure upd
458: (
459: p_effective_date in date,
460: p_balance_type_id in number,
461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,
462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,

Line 462: p_balance_name in varchar2 default hr_api.g_varchar2,

458: (
459: p_effective_date in date,
460: p_balance_type_id in number,
461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,
462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,

Line 463: p_balance_uom in varchar2 default hr_api.g_varchar2,

459: p_effective_date in date,
460: p_balance_type_id in number,
461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,
462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 464: p_currency_code in varchar2 default hr_api.g_varchar2,

460: p_balance_type_id in number,
461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,
462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 465: p_comments in varchar2 default hr_api.g_varchar2,

461: p_assignment_remuneration_flag in varchar2 default hr_api.g_varchar2,
462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 466: p_reporting_name in varchar2 default hr_api.g_varchar2,

462: p_balance_name in varchar2 default hr_api.g_varchar2,
463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 467: p_attribute_category in varchar2 default hr_api.g_varchar2,

463: p_balance_uom in varchar2 default hr_api.g_varchar2,
464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 468: p_attribute1 in varchar2 default hr_api.g_varchar2,

464: p_currency_code in varchar2 default hr_api.g_varchar2,
465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 469: p_attribute2 in varchar2 default hr_api.g_varchar2,

465: p_comments in varchar2 default hr_api.g_varchar2,
466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 470: p_attribute3 in varchar2 default hr_api.g_varchar2,

466: p_reporting_name in varchar2 default hr_api.g_varchar2,
467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 471: p_attribute4 in varchar2 default hr_api.g_varchar2,

467: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 472: p_attribute5 in varchar2 default hr_api.g_varchar2,

468: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 473: p_attribute6 in varchar2 default hr_api.g_varchar2,

469: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 474: p_attribute7 in varchar2 default hr_api.g_varchar2,

470: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 475: p_attribute8 in varchar2 default hr_api.g_varchar2,

471: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 476: p_attribute9 in varchar2 default hr_api.g_varchar2,

472: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 477: p_attribute10 in varchar2 default hr_api.g_varchar2,

473: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 478: p_attribute11 in varchar2 default hr_api.g_varchar2,

474: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 479: p_attribute12 in varchar2 default hr_api.g_varchar2,

475: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 480: p_attribute13 in varchar2 default hr_api.g_varchar2,

476: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 481: p_attribute14 in varchar2 default hr_api.g_varchar2,

477: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 482: p_attribute15 in varchar2 default hr_api.g_varchar2,

478: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 483: p_attribute16 in varchar2 default hr_api.g_varchar2,

479: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 484: p_attribute17 in varchar2 default hr_api.g_varchar2,

480: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,

Line 485: p_attribute18 in varchar2 default hr_api.g_varchar2,

481: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,

Line 486: p_attribute19 in varchar2 default hr_api.g_varchar2,

482: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,

Line 487: p_attribute20 in varchar2 default hr_api.g_varchar2,

483: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,

Line 488: p_jurisdiction_level in number default hr_api.g_number,

484: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,

Line 489: p_tax_type in varchar2 default hr_api.g_varchar2,

485: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,

Line 490: p_exclusion_rule_id in number default hr_api.g_number,

486: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,
494: p_input_value_id in number default hr_api.g_number,

Line 491: p_category_name in varchar2 default hr_api.g_varchar2,

487: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,
494: p_input_value_id in number default hr_api.g_number,
495: p_object_version_number in out nocopy number

Line 492: p_base_balance_type_id in number default hr_api.g_number,

488: p_jurisdiction_level in number default hr_api.g_number,
489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,
494: p_input_value_id in number default hr_api.g_number,
495: p_object_version_number in out nocopy number
496: ) is

Line 493: p_base_balance_name in varchar2 default hr_api.g_varchar2,

489: p_tax_type in varchar2 default hr_api.g_varchar2,
490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,
494: p_input_value_id in number default hr_api.g_number,
495: p_object_version_number in out nocopy number
496: ) is
497: --

Line 494: p_input_value_id in number default hr_api.g_number,

490: p_exclusion_rule_id in number default hr_api.g_number,
491: p_category_name in varchar2 default hr_api.g_varchar2,
492: p_base_balance_type_id in number default hr_api.g_number,
493: p_base_balance_name in varchar2 default hr_api.g_varchar2,
494: p_input_value_id in number default hr_api.g_number,
495: p_object_version_number in out nocopy number
496: ) is
497: --
498: l_rec pay_sbt_shd.g_rec_type;

Line 511: hr_api.g_number,

507: l_rec :=
508: pay_sbt_shd.convert_args
509: (
510: p_balance_type_id,
511: hr_api.g_number,
512: p_assignment_remuneration_flag,
513: p_balance_name,
514: p_balance_uom,
515: p_currency_code,