DBA Data[Home] [Help]

APPS.PAY_SET_BUS dependencies on PAY_SET_SHD

Line 54: (p_rec in pay_set_shd.g_rec_type

50: -- ----------------------------------------------------------------------------
51: -- |-----------------------< chk_non_updateable_args >------------------------|
52: -- ----------------------------------------------------------------------------
53: Procedure chk_non_updateable_args
54: (p_rec in pay_set_shd.g_rec_type
55: ) is
56: --
57: -- Cursor to disallow update if a core element has been generated from
58: -- this shadow element.

Line 75: l_api_updating := pay_set_shd.api_updating

71: l_disallow varchar2(1);
72: --
73: Begin
74: hr_utility.set_location('Entering:'||l_proc, 5);
75: l_api_updating := pay_set_shd.api_updating
76: (p_element_type_id => p_rec.element_type_id
77: ,p_object_version_number => p_rec.object_version_number
78: );
79: if not l_api_updating then

Line 105: nvl(pay_set_shd.g_old_rec.template_id, hr_api.g_number)

101: --
102: -- p_template_id
103: --
104: if nvl(p_rec.template_id, hr_api.g_number) <>
105: nvl(pay_set_shd.g_old_rec.template_id, hr_api.g_number)
106: then
107: l_argument := 'p_template_id';
108: raise l_error;
109: end if;

Line 176: l_api_updating := pay_set_shd.api_updating

172: l_api_updating boolean;
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: l_api_updating := pay_set_shd.api_updating
177: (p_element_type_id => p_element_type_id
178: ,p_object_version_number => p_object_version_number
179: );
180: if (l_api_updating and nvl(p_classification_name, hr_api.g_varchar2) <>

Line 181: nvl(pay_set_shd.g_old_rec.classification_name, hr_api.g_varchar2)) or

177: (p_element_type_id => p_element_type_id
178: ,p_object_version_number => p_object_version_number
179: );
180: if (l_api_updating and nvl(p_classification_name, hr_api.g_varchar2) <>
181: nvl(pay_set_shd.g_old_rec.classification_name, hr_api.g_varchar2)) or
182: not l_api_updating
183: then
184: --
185: -- Check that the classification name is not null.

Line 277: l_api_updating := pay_set_shd.api_updating

273: end chk_lookup;
274: --
275: Begin
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: l_api_updating := pay_set_shd.api_updating
278: (p_element_type_id => p_element_type_id
279: ,p_object_version_number => p_object_version_number
280: );
281: --

Line 288: ,p_old_lookup_code => pay_set_shd.g_old_rec.additional_entry_allowed_flag

284: chk_lookup
285: (p_effective_date => p_effective_date
286: ,p_caller => l_proc
287: ,p_argument_name => 'additional_entry_allowed_flag'
288: ,p_old_lookup_code => pay_set_shd.g_old_rec.additional_entry_allowed_flag
289: ,p_lookup_code => p_additional_entry_allowed_fla
290: ,p_lookup_type => 'YES_NO'
291: ,p_mandatory => true
292: ,p_updatable => true

Line 302: ,p_old_lookup_code => pay_set_shd.g_old_rec.adjustment_only_flag

298: chk_lookup
299: (p_effective_date => p_effective_date
300: ,p_caller => l_proc
301: ,p_argument_name => 'adjustment_only_flag'
302: ,p_old_lookup_code => pay_set_shd.g_old_rec.adjustment_only_flag
303: ,p_lookup_code => p_adjustment_only_flag
304: ,p_lookup_type => 'YES_NO'
305: ,p_mandatory => true
306: ,p_updatable => true

Line 316: ,p_old_lookup_code => pay_set_shd.g_old_rec.closed_for_entry_flag

312: chk_lookup
313: (p_effective_date => p_effective_date
314: ,p_caller => l_proc
315: ,p_argument_name => 'closed_for_entry_flag'
316: ,p_old_lookup_code => pay_set_shd.g_old_rec.closed_for_entry_flag
317: ,p_lookup_code => p_closed_for_entry_flag
318: ,p_lookup_type => 'YES_NO'
319: ,p_mandatory => true
320: ,p_updatable => true

Line 330: ,p_old_lookup_code => pay_set_shd.g_old_rec.indirect_only_flag

326: chk_lookup
327: (p_effective_date => p_effective_date
328: ,p_caller => l_proc
329: ,p_argument_name => 'indirect_only_flag'
330: ,p_old_lookup_code => pay_set_shd.g_old_rec.indirect_only_flag
331: ,p_lookup_code => p_indirect_only_flag
332: ,p_lookup_type => 'YES_NO'
333: ,p_mandatory => true
334: ,p_updatable => true

Line 344: ,p_old_lookup_code => pay_set_shd.g_old_rec.multiple_entries_allowed_flag

340: chk_lookup
341: (p_effective_date => p_effective_date
342: ,p_caller => l_proc
343: ,p_argument_name => 'multiple_entries_allowed_flag'
344: ,p_old_lookup_code => pay_set_shd.g_old_rec.multiple_entries_allowed_flag
345: ,p_lookup_code => p_multiple_entries_allowed_fla
346: ,p_lookup_type => 'YES_NO'
347: ,p_mandatory => true
348: ,p_updatable => true

Line 358: ,p_old_lookup_code => pay_set_shd.g_old_rec.multiply_value_flag

354: chk_lookup
355: (p_effective_date => p_effective_date
356: ,p_caller => l_proc
357: ,p_argument_name => 'multiply_value_flag'
358: ,p_old_lookup_code => pay_set_shd.g_old_rec.multiply_value_flag
359: ,p_lookup_code => p_multiply_value_flag
360: ,p_lookup_type => 'YES_NO'
361: ,p_mandatory => true
362: ,p_updatable => true

Line 372: ,p_old_lookup_code => pay_set_shd.g_old_rec.post_termination_rule

368: chk_lookup
369: (p_effective_date => p_effective_date
370: ,p_caller => l_proc
371: ,p_argument_name => 'post_termination_rule'
372: ,p_old_lookup_code => pay_set_shd.g_old_rec.post_termination_rule
373: ,p_lookup_code => p_post_termination_rule
374: ,p_lookup_type => 'TERMINATION_RULE'
375: ,p_mandatory => true
376: ,p_updatable => true

Line 386: ,p_old_lookup_code => pay_set_shd.g_old_rec.process_in_run_flag

382: chk_lookup
383: (p_effective_date => p_effective_date
384: ,p_caller => l_proc
385: ,p_argument_name => 'process_in_run_flag'
386: ,p_old_lookup_code => pay_set_shd.g_old_rec.process_in_run_flag
387: ,p_lookup_code => p_process_in_run_flag
388: ,p_lookup_type => 'YES_NO'
389: ,p_mandatory => true
390: ,p_updatable => true

Line 400: ,p_old_lookup_code => pay_set_shd.g_old_rec.processing_type

396: chk_lookup
397: (p_effective_date => p_effective_date
398: ,p_caller => l_proc
399: ,p_argument_name => 'processing_type'
400: ,p_old_lookup_code => pay_set_shd.g_old_rec.processing_type
401: ,p_lookup_code => p_processing_type
402: ,p_lookup_type => 'PROCESSING_TYPE'
403: ,p_mandatory => true
404: ,p_updatable => true

Line 414: ,p_old_lookup_code => pay_set_shd.g_old_rec.standard_link_flag

410: chk_lookup
411: (p_effective_date => p_effective_date
412: ,p_caller => l_proc
413: ,p_argument_name => 'standard_link_flag'
414: ,p_old_lookup_code => pay_set_shd.g_old_rec.standard_link_flag
415: ,p_lookup_code => p_standard_link_flag
416: ,p_lookup_type => 'YES_NO'
417: ,p_mandatory => true
418: ,p_updatable => true

Line 428: ,p_old_lookup_code => pay_set_shd.g_old_rec.qualifying_units

424: chk_lookup
425: (p_effective_date => p_effective_date
426: ,p_caller => l_proc
427: ,p_argument_name => 'qualifying_units'
428: ,p_old_lookup_code => pay_set_shd.g_old_rec.qualifying_units
429: ,p_lookup_code => p_qualifying_units
430: ,p_lookup_type => 'QUALIFYING_UNITS'
431: ,p_mandatory => false
432: ,p_updatable => true

Line 442: ,p_old_lookup_code => pay_set_shd.g_old_rec.third_party_pay_only_flag

438: chk_lookup
439: (p_effective_date => p_effective_date
440: ,p_caller => l_proc
441: ,p_argument_name => 'third_party_only_flag'
442: ,p_old_lookup_code => pay_set_shd.g_old_rec.third_party_pay_only_flag
443: ,p_lookup_code => p_third_party_pay_only_flag
444: ,p_lookup_type => 'YES_NO'
445: ,p_mandatory => false
446: ,p_updatable => true

Line 456: ,p_old_lookup_code => pay_set_shd.g_old_rec.iterative_flag

452: chk_lookup
453: (p_effective_date => p_effective_date
454: ,p_caller => l_proc
455: ,p_argument_name => 'iterative_flag'
456: ,p_old_lookup_code => pay_set_shd.g_old_rec.iterative_flag
457: ,p_lookup_code => p_iterative_flag
458: ,p_lookup_type => 'YES_NO'
459: ,p_mandatory => false
460: ,p_updatable => true

Line 470: ,p_old_lookup_code => pay_set_shd.g_old_rec.grossup_flag

466: chk_lookup
467: (p_effective_date => p_effective_date
468: ,p_caller => l_proc
469: ,p_argument_name => 'grossup_flag'
470: ,p_old_lookup_code => pay_set_shd.g_old_rec.grossup_flag
471: ,p_lookup_code => p_grossup_flag
472: ,p_lookup_type => 'YES_NO'
473: ,p_mandatory => false
474: ,p_updatable => true

Line 484: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_indicator

480: chk_lookup
481: (p_effective_date => p_effective_date
482: ,p_caller => l_proc
483: ,p_argument_name => 'advance_indicator'
484: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_indicator
485: ,p_lookup_code => p_advance_indicator
486: ,p_lookup_type => 'YES_NO'
487: ,p_mandatory => false
488: ,p_updatable => true

Line 498: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_payable

494: chk_lookup
495: (p_effective_date => p_effective_date
496: ,p_caller => l_proc
497: ,p_argument_name => 'advance_payable'
498: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_payable
499: ,p_lookup_code => p_advance_payable
500: ,p_lookup_type => 'YES_NO'
501: ,p_mandatory => false
502: ,p_updatable => true

Line 512: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_deduction

508: chk_lookup
509: (p_effective_date => p_effective_date
510: ,p_caller => l_proc
511: ,p_argument_name => 'advance_deduction'
512: ,p_old_lookup_code => pay_set_shd.g_old_rec.advance_deduction
513: ,p_lookup_code => p_advance_deduction
514: ,p_lookup_type => 'YES_NO'
515: ,p_mandatory => false
516: ,p_updatable => true

Line 526: ,p_old_lookup_code => pay_set_shd.g_old_rec.process_advance_entry

522: chk_lookup
523: (p_effective_date => p_effective_date
524: ,p_caller => l_proc
525: ,p_argument_name => 'process_advance_entry'
526: ,p_old_lookup_code => pay_set_shd.g_old_rec.process_advance_entry
527: ,p_lookup_code => p_process_advance_entry
528: ,p_lookup_type => 'YES_NO'
529: ,p_mandatory => false
530: ,p_updatable => true

Line 540: ,p_old_lookup_code => pay_set_shd.g_old_rec.once_each_period_flag

536: chk_lookup
537: (p_effective_date => p_effective_date
538: ,p_caller => l_proc
539: ,p_argument_name => 'once_each_period_flag'
540: ,p_old_lookup_code => pay_set_shd.g_old_rec.once_each_period_flag
541: ,p_lookup_code => p_once_each_period_flag
542: ,p_lookup_type => 'YES_NO'
543: ,p_mandatory => false
544: ,p_updatable => true

Line 594: l_api_updating := pay_set_shd.api_updating

590: l_api_updating boolean;
591: --
592: Begin
593: hr_utility.set_location('Entering:'||l_proc, 5);
594: l_api_updating := pay_set_shd.api_updating
595: (p_element_type_id => p_element_type_id
596: ,p_object_version_number => p_object_version_number
597: );
598: if (l_api_updating and nvl(p_element_name, hr_api.g_varchar2) <>

Line 599: nvl(pay_set_shd.g_old_rec.element_name, hr_api.g_varchar2)) or

595: (p_element_type_id => p_element_type_id
596: ,p_object_version_number => p_object_version_number
597: );
598: if (l_api_updating and nvl(p_element_name, hr_api.g_varchar2) <>
599: nvl(pay_set_shd.g_old_rec.element_name, hr_api.g_varchar2)) or
600: not l_api_updating
601: then
602: --
603: -- Name cannot be null if the template type is 'U'.

Line 684: l_api_updating := pay_set_shd.api_updating

680: l_too_large varchar2(1);
681: --
682: Begin
683: hr_utility.set_location('Entering:'||l_proc, 5);
684: l_api_updating := pay_set_shd.api_updating
685: (p_element_type_id => p_element_type_id
686: ,p_object_version_number => p_object_version_number
687: );
688: --

Line 690: nvl(pay_set_shd.g_old_rec.relative_processing_priority, hr_api.g_number)

686: ,p_object_version_number => p_object_version_number
687: );
688: --
689: if (l_api_updating and
690: nvl(pay_set_shd.g_old_rec.relative_processing_priority, hr_api.g_number)
691: <> nvl(p_relative_processing_priority, hr_api.g_number)) or
692: not l_api_updating
693: then
694: --

Line 742: l_api_updating := pay_set_shd.api_updating

738: l_valid varchar2(1);
739: --
740: Begin
741: hr_utility.set_location('Entering:'||l_proc, 5);
742: l_api_updating := pay_set_shd.api_updating
743: (p_element_type_id => p_element_type_id
744: ,p_object_version_number => p_object_version_number
745: );
746: if (l_api_updating and nvl(p_input_currency_code, hr_api.g_varchar2) <>

Line 747: nvl(pay_set_shd.g_old_rec.input_currency_code, hr_api.g_varchar2)) or

743: (p_element_type_id => p_element_type_id
744: ,p_object_version_number => p_object_version_number
745: );
746: if (l_api_updating and nvl(p_input_currency_code, hr_api.g_varchar2) <>
747: nvl(pay_set_shd.g_old_rec.input_currency_code, hr_api.g_varchar2)) or
748: not l_api_updating
749: then
750: if p_input_currency_code is not null then
751: open csr_valid_currency_code;

Line 788: l_api_updating := pay_set_shd.api_updating

784: l_valid varchar2(1);
785: --
786: Begin
787: hr_utility.set_location('Entering:'||l_proc, 5);
788: l_api_updating := pay_set_shd.api_updating
789: (p_element_type_id => p_element_type_id
790: ,p_object_version_number => p_object_version_number
791: );
792: if (l_api_updating and nvl(p_output_currency_code, hr_api.g_varchar2) <>

Line 793: nvl(pay_set_shd.g_old_rec.output_currency_code, hr_api.g_varchar2)) or

789: (p_element_type_id => p_element_type_id
790: ,p_object_version_number => p_object_version_number
791: );
792: if (l_api_updating and nvl(p_output_currency_code, hr_api.g_varchar2) <>
793: nvl(pay_set_shd.g_old_rec.output_currency_code, hr_api.g_varchar2)) or
794: not l_api_updating
795: then
796: if p_output_currency_code is not null then
797: open csr_valid_currency_code;

Line 861: l_api_updating := pay_set_shd.api_updating

857: l_valid varchar2(1);
858: --
859: Begin
860: hr_utility.set_location('Entering:'||l_proc, 5);
861: l_api_updating := pay_set_shd.api_updating
862: (p_element_type_id => p_element_type_id
863: ,p_object_version_number => p_object_version_number
864: );
865: if (l_api_updating and nvl(p_payroll_formula_id, hr_api.g_number) <>

Line 866: nvl(pay_set_shd.g_old_rec.payroll_formula_id, hr_api.g_number)) or

862: (p_element_type_id => p_element_type_id
863: ,p_object_version_number => p_object_version_number
864: );
865: if (l_api_updating and nvl(p_payroll_formula_id, hr_api.g_number) <>
866: nvl(pay_set_shd.g_old_rec.payroll_formula_id, hr_api.g_number)) or
867: not l_api_updating
868: then
869: if p_payroll_formula_id is not null then
870: if p_template_type = 'T' then

Line 919: l_api_updating := pay_set_shd.api_updating

915: l_valid varchar2(1);
916: --
917: Begin
918: hr_utility.set_location('Entering:'||l_proc, 5);
919: l_api_updating := pay_set_shd.api_updating
920: (p_element_type_id => p_element_type_id
921: ,p_object_version_number => p_object_version_number
922: );
923: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>

Line 924: nvl(pay_set_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or

920: (p_element_type_id => p_element_type_id
921: ,p_object_version_number => p_object_version_number
922: );
923: if (l_api_updating and nvl(p_exclusion_rule_id, hr_api.g_number) <>
924: nvl(pay_set_shd.g_old_rec.exclusion_rule_id, hr_api.g_number)) or
925: not l_api_updating
926: then
927: if p_exclusion_rule_id is not null then
928: open csr_exclusion_rule_id_valid;

Line 1173: ,p_rec in pay_set_shd.g_rec_type

1169: -- |---------------------------< insert_validate >----------------------------|
1170: -- ----------------------------------------------------------------------------
1171: Procedure insert_validate
1172: (p_effective_date in date
1173: ,p_rec in pay_set_shd.g_rec_type
1174: ) is
1175: --
1176: l_proc varchar2(72) := g_package||'insert_validate';
1177: l_business_group_id number;

Line 1300: ,p_rec in pay_set_shd.g_rec_type

1296: -- |---------------------------< update_validate >----------------------------|
1297: -- ----------------------------------------------------------------------------
1298: Procedure update_validate
1299: (p_effective_date in date
1300: ,p_rec in pay_set_shd.g_rec_type
1301: ) is
1302: --
1303: l_proc varchar2(72) := g_package||'update_validate';
1304: l_business_group_id number;

Line 1425: Procedure delete_validate(p_rec in pay_set_shd.g_rec_type) is

1421: --
1422: -- ----------------------------------------------------------------------------
1423: -- |---------------------------< delete_validate >----------------------------|
1424: -- ----------------------------------------------------------------------------
1425: Procedure delete_validate(p_rec in pay_set_shd.g_rec_type) is
1426: --
1427: l_proc varchar2(72) := g_package||'delete_validate';
1428: --
1429: Begin