DBA Data[Home] [Help]

APPS.BEN_BCI_BUS dependencies on BEN_BCI_SHD

Line 123: l_api_updating := ben_bci_shd.api_updating

119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc, 5);
122: --
123: l_api_updating := ben_bci_shd.api_updating
124: (p_batch_benft_cert_id => p_batch_benft_cert_id,
125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating

Line 129: <> ben_bci_shd.g_old_rec.batch_benft_cert_id) then

125: p_object_version_number => p_object_version_number);
126: --
127: if (l_api_updating
128: and nvl(p_batch_benft_cert_id,hr_api.g_number)
129: <> ben_bci_shd.g_old_rec.batch_benft_cert_id) then
130: --
131: -- raise error as PK has changed
132: --
133: ben_bci_shd.constraint_error('BATCH_BNFT_CERT_INFO_PK');

Line 133: ben_bci_shd.constraint_error('BATCH_BNFT_CERT_INFO_PK');

129: <> ben_bci_shd.g_old_rec.batch_benft_cert_id) then
130: --
131: -- raise error as PK has changed
132: --
133: ben_bci_shd.constraint_error('BATCH_BNFT_CERT_INFO_PK');
134: --
135: elsif not l_api_updating then
136: --
137: -- check if PK is null

Line 143: ben_bci_shd.constraint_error('BATCH_BNFT_CERT_INFO_PK');

139: if p_batch_benft_cert_id is not null then
140: --
141: -- raise error as PK is not null
142: --
143: ben_bci_shd.constraint_error('BATCH_BNFT_CERT_INFO_PK');
144: --
145: end if;
146: --
147: end if;

Line 191: l_api_updating := ben_bci_shd.api_updating

187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_bci_shd.api_updating
192: (p_batch_benft_cert_id => p_batch_benft_cert_id,
193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating

Line 197: <> nvl(ben_bci_shd.g_old_rec.typ_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_typ_cd
197: <> nvl(ben_bci_shd.g_old_rec.typ_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_typ_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.

Line 224: Procedure insert_validate(p_rec in ben_bci_shd.g_rec_type

220: --
221: -- ----------------------------------------------------------------------------
222: -- |---------------------------< insert_validate >----------------------------|
223: -- ----------------------------------------------------------------------------
224: Procedure insert_validate(p_rec in ben_bci_shd.g_rec_type
225: ,p_effective_date in date) is
226: --
227: l_proc varchar2(72) := g_package||'insert_validate';
228: --

Line 256: Procedure update_validate(p_rec in ben_bci_shd.g_rec_type

252: --
253: -- ----------------------------------------------------------------------------
254: -- |---------------------------< update_validate >----------------------------|
255: -- ----------------------------------------------------------------------------
256: Procedure update_validate(p_rec in ben_bci_shd.g_rec_type
257: ,p_effective_date in date) is
258: --
259: l_proc varchar2(72) := g_package||'update_validate';
260: --

Line 288: Procedure delete_validate(p_rec in ben_bci_shd.g_rec_type

284: --
285: -- ----------------------------------------------------------------------------
286: -- |---------------------------< delete_validate >----------------------------|
287: -- ----------------------------------------------------------------------------
288: Procedure delete_validate(p_rec in ben_bci_shd.g_rec_type
289: ,p_effective_date in date) is
290: --
291: l_proc varchar2(72) := g_package||'delete_validate';
292: --