DBA Data[Home] [Help]

APPS.HXC_TBB_BUS dependencies on HXC_TBB_SHD

Line 48: ,p_rec in hxc_tbb_shd.g_rec_type

44: -- {end Of Comments}
45: -- --------------------------------------------------------------------------
46: procedure chk_non_updateable_args
47: (p_effective_date in date
48: ,p_rec in hxc_tbb_shd.g_rec_type
49: ) is
50:
51: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
52: l_error exception;

Line 60: if not hxc_tbb_shd.api_updating

56:
57: -- only proceed with the validation if a row exists for the current
58: -- record in the hr schema.
59:
60: if not hxc_tbb_shd.api_updating
61: (p_time_building_block_id => p_rec.time_building_block_id
62: ,p_object_version_number => p_rec.object_version_number
63: ) then
64: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 71: nvl(hxc_tbb_shd.g_old_rec.type, hr_api.g_varchar2)

67: fnd_message.raise_error;
68: end if;
69:
70: if nvl(p_rec.type, hr_api.g_varchar2) <>
71: nvl(hxc_tbb_shd.g_old_rec.type, hr_api.g_varchar2)
72: then
73: l_argument := 'p_type';
74: raise l_error;
75: end if;

Line 78: nvl(hxc_tbb_shd.g_old_rec.scope, hr_api.g_varchar2)

74: raise l_error;
75: end if;
76:
77: if nvl(p_rec.scope, hr_api.g_varchar2) <>
78: nvl(hxc_tbb_shd.g_old_rec.scope, hr_api.g_varchar2)
79: then
80: l_argument := 'p_scope';
81: raise l_error;
82: end if;

Line 85: nvl(hxc_tbb_shd.g_old_rec.resource_id, hr_api.g_number)

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

Line 92: nvl(hxc_tbb_shd.g_old_rec.resource_type, hr_api.g_varchar2)

88: raise l_error;
89: end if;
90:
91: if nvl(p_rec.resource_type, hr_api.g_varchar2) <>
92: nvl(hxc_tbb_shd.g_old_rec.resource_type, hr_api.g_varchar2)
93: then
94: l_argument := 'p_resource_type';
95: raise l_error;
96: end if;

Line 99: nvl(hxc_tbb_shd.g_old_rec.data_set_id, hr_api.g_varchar2)

95: raise l_error;
96: end if;
97:
98: if nvl(p_rec.data_set_id, hr_api.g_varchar2) <>
99: nvl(hxc_tbb_shd.g_old_rec.data_set_id, hr_api.g_varchar2)
100: then
101: l_argument := 'p_data_set_id';
102: raise l_error;
103: end if;

Line 607: (p_rec in hxc_tbb_shd.g_rec_type )

603: -- |------------------------< chk_data_set_offline >------------------------|
604: -- --------------------------------------------------------------------------
605:
606: procedure chk_data_set_offline
607: (p_rec in hxc_tbb_shd.g_rec_type )
608: is
609: cursor c_data_set(p_stop_time date) is
610: select 1
611: from hxc_data_sets d

Line 636: ,p_rec in hxc_tbb_shd.g_rec_type

632: -- |---------------------------< insert_validate >--------------------------|
633: -- --------------------------------------------------------------------------
634: procedure insert_validate
635: (p_effective_date in date
636: ,p_rec in hxc_tbb_shd.g_rec_type
637: ) is
638:
639: l_proc varchar2(72);
640:

Line 733: ,p_rec in hxc_tbb_shd.g_rec_type

729: -- |---------------------------< update_validate >--------------------------|
730: -- --------------------------------------------------------------------------
731: procedure update_validate
732: (p_effective_date in date
733: ,p_rec in hxc_tbb_shd.g_rec_type
734: ) is
735:
736: l_proc varchar2(72);
737:

Line 769: (p_rec in hxc_tbb_shd.g_rec_type

765: -- --------------------------------------------------------------------------
766: -- |---------------------------< delete_validate >--------------------------|
767: -- --------------------------------------------------------------------------
768: procedure delete_validate
769: (p_rec in hxc_tbb_shd.g_rec_type
770: ) is
771:
772: l_proc varchar2(72);
773: