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_TCO_BUS dependencies on PAY_TCO_SHD

Line 41: (p_rec in pay_tco_shd.g_rec_type

37: -- ----------------------------------------------------------------------------
38: -- |-----------------------< chk_non_updateable_args >------------------------|
39: -- ----------------------------------------------------------------------------
40: Procedure chk_non_updateable_args
41: (p_rec in pay_tco_shd.g_rec_type
42: ) is
43: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
44: l_updating boolean;
45: l_error exception;

Line 51: l_api_updating := pay_tco_shd.api_updating

47: l_api_updating boolean;
48: --
49: Begin
50: hr_utility.set_location('Entering:'||l_proc, 5);
51: l_api_updating := pay_tco_shd.api_updating
52: (p_template_core_object_id => p_rec.template_core_object_id
53: ,p_object_version_number => p_rec.object_version_number
54: );
55: if not l_api_updating then

Line 67: nvl(pay_tco_shd.g_old_rec.template_id, hr_api.g_number)

63: --
64: -- p_template_id
65: --
66: if nvl(p_rec.template_id, hr_api.g_number) <>
67: nvl(pay_tco_shd.g_old_rec.template_id, hr_api.g_number)
68: then
69: l_argument := 'p_template_id';
70: raise l_error;
71: end if;

Line 76: nvl(pay_tco_shd.g_old_rec.core_object_type, hr_api.g_varchar2)

72: --
73: -- p_core_object_type
74: --
75: if nvl(p_rec.core_object_type, hr_api.g_varchar2) <>
76: nvl(pay_tco_shd.g_old_rec.core_object_type, hr_api.g_varchar2)
77: then
78: l_argument := 'p_core_object_type';
79: raise l_error;
80: end if;

Line 85: nvl(pay_tco_shd.g_old_rec.shadow_object_id, hr_api.g_number)

81: --
82: -- p_shadow_object_id
83: --
84: if nvl(p_rec.shadow_object_id, hr_api.g_number) <>
85: nvl(pay_tco_shd.g_old_rec.shadow_object_id, hr_api.g_number)
86: then
87: l_argument := 'p_shadow_object_id';
88: raise l_error;
89: end if;

Line 114: l_api_updating := pay_tco_shd.api_updating

110: l_api_updating boolean;
111: --
112: Begin
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: l_api_updating := pay_tco_shd.api_updating
115: (p_template_core_object_id => p_template_core_object_id
116: ,p_object_version_number => p_object_version_number
117: );
118: if (l_api_updating and nvl(p_effective_date, hr_api.g_date) <>

Line 119: nvl(pay_tco_shd.g_old_rec.effective_date, hr_api.g_date)) or

115: (p_template_core_object_id => p_template_core_object_id
116: ,p_object_version_number => p_object_version_number
117: );
118: if (l_api_updating and nvl(p_effective_date, hr_api.g_date) <>
119: nvl(pay_tco_shd.g_old_rec.effective_date, hr_api.g_date)) or
120: not l_api_updating
121: then
122: --
123: -- Check that the effective date is not null.

Line 375: if p_core_object_type = pay_tco_shd.g_sf_lookup_type then

371: --
372: -- Check that the shadow_object_id belongs to the template.
373: --
374:
375: if p_core_object_type = pay_tco_shd.g_sf_lookup_type then
376: l_table := 'PAY_SHADOW_FORMULAS';
377: --
378: -- Look for element type payroll formula.
379: --

Line 399: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then

395:
396: if csr_sf_belongs%isopen then
397: close csr_sf_belongs;
398: end if;
399: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then
400: l_table := 'PAY_SHADOW_BALANCE_TYPES';
401: open csr_sbt_belongs;
402: fetch csr_sbt_belongs into l_exists;
403: if csr_sbt_belongs%notfound then

Line 408: elsif p_core_object_type = pay_tco_shd.g_sdb_lookup_type then

404: close csr_sbt_belongs;
405: raise l_error;
406: end if;
407: close csr_sbt_belongs;
408: elsif p_core_object_type = pay_tco_shd.g_sdb_lookup_type then
409: l_table := 'PAY_SHADOW_DEFINED_BALANCES';
410: open csr_sdb_belongs;
411: fetch csr_sdb_belongs into l_exists;
412: if csr_sdb_belongs%notfound then

Line 417: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type or

413: close csr_sdb_belongs;
414: raise l_error;
415: end if;
416: close csr_sdb_belongs;
417: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type or
418: p_core_object_type = pay_tco_shd.g_spr_lookup_type
419: then
420: l_table := 'PAY_SHADOW_ELEMENT_TYPES';
421: open csr_set_belongs;

Line 418: p_core_object_type = pay_tco_shd.g_spr_lookup_type

414: raise l_error;
415: end if;
416: close csr_sdb_belongs;
417: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type or
418: p_core_object_type = pay_tco_shd.g_spr_lookup_type
419: then
420: l_table := 'PAY_SHADOW_ELEMENT_TYPES';
421: open csr_set_belongs;
422: fetch csr_set_belongs into l_exists;

Line 428: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then

424: close csr_set_belongs;
425: raise l_error;
426: end if;
427: close csr_set_belongs;
428: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then
429: l_table := 'PAY_SHADOW_SUB_CLASSI_RULES';
430: open csr_ssr_belongs;
431: fetch csr_ssr_belongs into l_exists;
432: if csr_ssr_belongs%notfound then

Line 437: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then

433: close csr_ssr_belongs;
434: raise l_error;
435: end if;
436: close csr_ssr_belongs;
437: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then
438: l_table := 'PAY_SHADOW_BALANCE_CLASSI';
439: open csr_sbc_belongs;
440: fetch csr_sbc_belongs into l_exists;
441: if csr_sbc_belongs%notfound then

Line 446: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then

442: close csr_sbc_belongs;
443: raise l_error;
444: end if;
445: close csr_sbc_belongs;
446: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then
447: l_table := 'PAY_SHADOW_INPUT_VALUES';
448: open csr_siv_belongs;
449: fetch csr_siv_belongs into l_exists;
450: if csr_siv_belongs%notfound then

Line 455: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then

451: close csr_siv_belongs;
452: raise l_error;
453: end if;
454: close csr_siv_belongs;
455: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then
456: l_table := 'PAY_SHADOW_BALANCE_FEEDS';
457: open csr_sbf_belongs;
458: fetch csr_sbf_belongs into l_exists;
459: if csr_sbf_belongs%notfound then

Line 464: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then

460: close csr_sbf_belongs;
461: raise l_error;
462: end if;
463: close csr_sbf_belongs;
464: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then
465: l_table := 'PAY_SHADOW_FORMULA_RULES';
466: open csr_sfr_belongs;
467: fetch csr_sfr_belongs into l_exists;
468: if csr_sfr_belongs%notfound then

Line 473: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then

469: close csr_sfr_belongs;
470: raise l_error;
471: end if;
472: close csr_sfr_belongs;
473: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then
474: l_table := 'PAY_SHADOW_ITERATIVE_RULES';
475: open csr_sir_belongs;
476: fetch csr_sir_belongs into l_exists;
477: if csr_sir_belongs%notfound then

Line 482: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then

478: close csr_sir_belongs;
479: raise l_error;
480: end if;
481: close csr_sir_belongs;
482: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then
483: l_table := 'PAY_SHADOW_ELE_TYPE_USAGES';
484: open csr_seu_belongs;
485: fetch csr_seu_belongs into l_exists;
486: if csr_seu_belongs%notfound then

Line 491: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then

487: close csr_seu_belongs;
488: raise l_error;
489: end if;
490: close csr_seu_belongs;
491: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then
492: l_table := 'PAY_SHADOW_GU_BAL_EXCLUSIONS';
493: open csr_sgb_belongs;
494: fetch csr_sgb_belongs into l_exists;
495: if csr_sgb_belongs%notfound then

Line 500: elsif p_core_object_type = pay_tco_shd.g_sba_lookup_type then

496: close csr_sgb_belongs;
497: raise l_error;
498: end if;
499: close csr_sgb_belongs;
500: elsif p_core_object_type = pay_tco_shd.g_sba_lookup_type then
501: l_table := 'PAY_SHADOW_BAL_ATTRIBUTES';
502: open csr_sba_belongs;
503: fetch csr_sba_belongs into l_exists;
504: if csr_sba_belongs%notfound then

Line 659: l_api_updating := pay_tco_shd.api_updating

655: l_api_updating boolean;
656: --
657: Begin
658: hr_utility.set_location('Entering:'||l_proc, 5);
659: l_api_updating := pay_tco_shd.api_updating
660: (p_template_core_object_id => p_template_core_object_id
661: ,p_object_version_number => p_object_version_number
662: );
663: if (l_api_updating and nvl(p_core_object_id, hr_api.g_number) <>

Line 664: nvl(pay_tco_shd.g_old_rec.core_object_id, hr_api.g_number)) or

660: (p_template_core_object_id => p_template_core_object_id
661: ,p_object_version_number => p_object_version_number
662: );
663: if (l_api_updating and nvl(p_core_object_id, hr_api.g_number) <>
664: nvl(pay_tco_shd.g_old_rec.core_object_id, hr_api.g_number)) or
665: not l_api_updating
666: then
667: --
668: -- Check that core_object_id is not null.

Line 691: if p_core_object_type = pay_tco_shd.g_sf_lookup_type then

687: close csr_comb_exists;
688: --
689: -- Check that the core_object_id exists to the template.
690: --
691: if p_core_object_type = pay_tco_shd.g_sf_lookup_type then
692: l_table := 'FF_FORMULAS_F';
693: open csr_sf_exists;
694: fetch csr_sf_exists into l_exists;
695: if csr_sf_exists%notfound then

Line 700: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then

696: close csr_sf_exists;
697: raise l_error;
698: end if;
699: close csr_sf_exists;
700: elsif p_core_object_type = pay_tco_shd.g_sbt_lookup_type then
701: l_table := 'PAY_BALANCE_TYPES';
702: open csr_sbt_exists;
703: fetch csr_sbt_exists into l_exists;
704: if csr_sbt_exists%notfound then

Line 709: elsif p_core_object_type = pay_tco_shd.g_sdb_lookup_type then

705: close csr_sbt_exists;
706: raise l_error;
707: end if;
708: close csr_sbt_exists;
709: elsif p_core_object_type = pay_tco_shd.g_sdb_lookup_type then
710: l_table := 'PAY_DEFINED_BALANCES';
711: open csr_sdb_exists;
712: fetch csr_sdb_exists into l_exists;
713: if csr_sdb_exists%notfound then

Line 718: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type

714: close csr_sdb_exists;
715: raise l_error;
716: end if;
717: close csr_sdb_exists;
718: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type
719: then
720: l_table := 'PAY_ELEMENT_TYPES_F';
721: open csr_set_exists;
722: fetch csr_set_exists into l_exists;

Line 728: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then

724: close csr_set_exists;
725: raise l_error;
726: end if;
727: close csr_set_exists;
728: elsif p_core_object_type = pay_tco_shd.g_ssr_lookup_type then
729: l_table := 'PAY_SUB_CLASSIFICATION_RULES_F';
730: open csr_ssr_exists;
731: fetch csr_ssr_exists into l_exists;
732: if csr_ssr_exists%notfound then

Line 737: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then

733: close csr_ssr_exists;
734: raise l_error;
735: end if;
736: close csr_ssr_exists;
737: elsif p_core_object_type = pay_tco_shd.g_sbc_lookup_type then
738: l_table := 'PAY_BALANCE_CLASSIFICATIONS';
739: open csr_sbc_exists;
740: fetch csr_sbc_exists into l_exists;
741: if csr_sbc_exists%notfound then

Line 746: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then

742: close csr_sbc_exists;
743: raise l_error;
744: end if;
745: close csr_sbc_exists;
746: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then
747: l_table := 'PAY_INPUT_VALUES_F';
748: open csr_siv_exists;
749: fetch csr_siv_exists into l_exists;
750: if csr_siv_exists%notfound then

Line 755: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then

751: close csr_siv_exists;
752: raise l_error;
753: end if;
754: close csr_siv_exists;
755: elsif p_core_object_type = pay_tco_shd.g_sbf_lookup_type then
756: l_table := 'PAY_BALANCE_FEEDS_F';
757: open csr_sbf_exists;
758: fetch csr_sbf_exists into l_exists;
759: if csr_sbf_exists%notfound then

Line 764: elsif p_core_object_type = pay_tco_shd.g_spr_lookup_type then

760: close csr_sbf_exists;
761: raise l_error;
762: end if;
763: close csr_sbf_exists;
764: elsif p_core_object_type = pay_tco_shd.g_spr_lookup_type then
765: l_table := 'PAY_STATUS_PROCESSING_RULES_F';
766: open csr_spr_exists;
767: fetch csr_spr_exists into l_exists;
768: if csr_spr_exists%notfound then

Line 773: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then

769: close csr_spr_exists;
770: raise l_error;
771: end if;
772: close csr_spr_exists;
773: elsif p_core_object_type = pay_tco_shd.g_sfr_lookup_type then
774: l_table := 'PAY_FORMULA_RESULT_RULES_F';
775: open csr_sfr_exists;
776: fetch csr_sfr_exists into l_exists;
777: if csr_sfr_exists%notfound then

Line 782: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then

778: close csr_sfr_exists;
779: raise l_error;
780: end if;
781: close csr_sfr_exists;
782: elsif p_core_object_type = pay_tco_shd.g_sir_lookup_type then
783: l_table := 'PAY_ITERATIVE_RULES_F';
784: open csr_sir_exists;
785: fetch csr_sir_exists into l_exists;
786: if csr_sir_exists%notfound then

Line 791: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then

787: close csr_sir_exists;
788: raise l_error;
789: end if;
790: close csr_sir_exists;
791: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then
792: l_table := 'PAY_GROSSUP_BAL_EXCLUSIONS';
793: open csr_sgb_exists;
794: fetch csr_sgb_exists into l_exists;
795: if csr_sgb_exists%notfound then

Line 800: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then

796: close csr_sgb_exists;
797: raise l_error;
798: end if;
799: close csr_sgb_exists;
800: elsif p_core_object_type = pay_tco_shd.g_seu_lookup_type then
801: l_table := 'PAY_ELEMENT_TYPE_USAGES_F';
802: open csr_seu_exists;
803: fetch csr_seu_exists into l_exists;
804: if csr_seu_exists%notfound then

Line 809: elsif p_core_object_type = pay_tco_shd.g_sba_lookup_type then

805: close csr_seu_exists;
806: raise l_error;
807: end if;
808: close csr_seu_exists;
809: elsif p_core_object_type = pay_tco_shd.g_sba_lookup_type then
810: l_table := 'PAY_BALANCE_ATTRIBUTES';
811: open csr_sba_exists;
812: fetch csr_sba_exists into l_exists;
813: if csr_sba_exists%notfound then

Line 836: Procedure insert_validate(p_rec in pay_tco_shd.g_rec_type) is

832: End chk_core_object_id;
833: -- ----------------------------------------------------------------------------
834: -- |---------------------------< insert_validate >----------------------------|
835: -- ----------------------------------------------------------------------------
836: Procedure insert_validate(p_rec in pay_tco_shd.g_rec_type) is
837: --
838: l_proc varchar2(72) := g_package||'insert_validate';
839: l_business_group_id number;
840: --

Line 884: Procedure update_validate(p_rec in pay_tco_shd.g_rec_type) is

880: --
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< update_validate >----------------------------|
883: -- ----------------------------------------------------------------------------
884: Procedure update_validate(p_rec in pay_tco_shd.g_rec_type) is
885: --
886: l_proc varchar2(72) := g_package||'update_validate';
887: l_business_group_id number;
888: --

Line 921: Procedure delete_validate(p_rec in pay_tco_shd.g_rec_type) is

917: --
918: -- ----------------------------------------------------------------------------
919: -- |---------------------------< delete_validate >----------------------------|
920: -- ----------------------------------------------------------------------------
921: Procedure delete_validate(p_rec in pay_tco_shd.g_rec_type) is
922: --
923: l_proc varchar2(72) := g_package||'delete_validate';
924: --
925: Begin