APPS.BEN_DSQ_BUS dependencies on BEN_DSQ_SHD

Line 47: l_api_updating := ben_dsq_shd.api_updating

43: Begin
44: --
45: hr_utility.set_location('Entering:'||l_proc, 5);
46: --
47: l_api_updating := ben_dsq_shd.api_updating
48: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating

Line 53: <> ben_dsq_shd.g_old_rec.ded_sched_py_freq_id) then

49: p_object_version_number => p_object_version_number);
50: --
51: if (l_api_updating
52: and nvl(p_ded_sched_py_freq_id,hr_api.g_number)
53: <> ben_dsq_shd.g_old_rec.ded_sched_py_freq_id) then
54: --
55: -- raise error as PK has changed
56: --
57: ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_PK');

Line 57: ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_PK');

53: <> ben_dsq_shd.g_old_rec.ded_sched_py_freq_id) then
54: --
55: -- raise error as PK has changed
56: --
57: ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_PK');
58: --
59: elsif not l_api_updating then
60: --
61: -- check if PK is null

Line 67: ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_PK');

63: if p_ded_sched_py_freq_id is not null then
64: --
65: -- raise error as PK is not null
66: --
67: ben_dsq_shd.constraint_error('BEN_DED_SCHED_PY_FREQ_PK');
68: --
69: end if;
70: --
71: end if;

Line 115: l_api_updating := ben_dsq_shd.api_updating

111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: l_api_updating := ben_dsq_shd.api_updating
116: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating

Line 121: <> nvl(ben_dsq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

117: p_object_version_number => p_object_version_number);
118: --
119: if (l_api_updating
120: and p_dflt_flag
121: <> nvl(ben_dsq_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
122: or not l_api_updating)
123: and p_dflt_flag is not null then
124: --
125: -- check if value of lookup falls within lookup type.

Line 184: l_api_updating := ben_dsq_shd.api_updating

180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_dsq_shd.api_updating
185: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating

Line 190: <> nvl(ben_dsq_shd.g_old_rec.pymt_sched_cd,hr_api.g_varchar2)

186: p_object_version_number => p_object_version_number);
187: --
188: if (l_api_updating
189: and p_pymt_sched_cd
190: <> nvl(ben_dsq_shd.g_old_rec.pymt_sched_cd,hr_api.g_varchar2)
191: or not l_api_updating) then
192: --
193: -- check if value of lookup falls within lookup type.
194: --

Line 255: l_api_updating := ben_dsq_shd.api_updating

251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_dsq_shd.api_updating
256: (p_ded_sched_py_freq_id => p_ded_sched_py_freq_id,
257: p_object_version_number => p_object_version_number);
258: --
259: if (l_api_updating

Line 261: <> nvl(ben_dsq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)

257: p_object_version_number => p_object_version_number);
258: --
259: if (l_api_updating
260: and p_py_freq_cd
261: <> nvl(ben_dsq_shd.g_old_rec.py_freq_cd,hr_api.g_varchar2)
262: or not l_api_updating) then
263: --
264: -- check if value of lookup falls within lookup type.
265: --

Line 290: Procedure insert_validate(p_rec in ben_dsq_shd.g_rec_type

286: --
287: -- ----------------------------------------------------------------------------
288: -- |---------------------------< insert_validate >----------------------------|
289: -- ----------------------------------------------------------------------------
290: Procedure insert_validate(p_rec in ben_dsq_shd.g_rec_type
291: ,p_effective_date in date) is
292: --
293: l_proc varchar2(72) := g_package||'insert_validate';
294: --

Line 333: Procedure update_validate(p_rec in ben_dsq_shd.g_rec_type

329: --
330: -- ----------------------------------------------------------------------------
331: -- |---------------------------< update_validate >----------------------------|
332: -- ----------------------------------------------------------------------------
333: Procedure update_validate(p_rec in ben_dsq_shd.g_rec_type
334: ,p_effective_date in date) is
335: --
336: l_proc varchar2(72) := g_package||'update_validate';
337: --

Line 376: Procedure delete_validate(p_rec in ben_dsq_shd.g_rec_type

372: --
373: -- ----------------------------------------------------------------------------
374: -- |---------------------------< delete_validate >----------------------------|
375: -- ----------------------------------------------------------------------------
376: Procedure delete_validate(p_rec in ben_dsq_shd.g_rec_type
377: ,p_effective_date in date) is
378: --
379: l_proc varchar2(72) := g_package||'delete_validate';
380: --