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.BEN_CMD_BUS dependencies on BEN_CMD_SHD

Line 46: l_api_updating := ben_cmd_shd.api_updating

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

Line 52: <> ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_cm_dlvry_med_typ_id,hr_api.g_number)
52: <> ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_id) then
53: --
54: -- raise error as PK has changed
55: --
56: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');

Line 56: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');

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

Line 66: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');

62: if p_cm_dlvry_med_typ_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := ben_cmd_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := ben_cmd_shd.api_updating
119: ( p_cm_dlvry_med_typ_id => p_cm_dlvry_med_typ_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_mthd_typ_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_cm_dlvry_mthd_typ_id,hr_api.g_number)
124: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_mthd_typ_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_cm_dlvry_mthd_typ_id is not null then
127: --
128: -- check if cm_dlvry_mthd_typ_id value exists in ben_cm_dlvry_mthd_typ table

Line 140: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_FK3');

136: --
137: -- raise error as FK does not relate to PK in ben_cm_dlvry_mthd_typ
138: -- table.
139: --
140: ben_cmd_shd.constraint_error('BEN_CM_DLVRY_MED_TYP_FK3');
141: --
142: end if;
143: --
144: close c1;

Line 190: l_api_updating := ben_cmd_shd.api_updating

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

Line 196: <> nvl(ben_cmd_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)

192: p_object_version_number => p_object_version_number);
193: --
194: if (l_api_updating
195: and p_dflt_flag
196: <> nvl(ben_cmd_shd.g_old_rec.dflt_flag,hr_api.g_varchar2)
197: or not l_api_updating) then
198: --
199: -- check if value of lookup falls within lookup type.
200: --

Line 258: l_api_updating := ben_cmd_shd.api_updating

254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := ben_cmd_shd.api_updating
259: (p_cm_dlvry_med_typ_id => p_cm_dlvry_med_typ_id,
260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating

Line 264: <> nvl(ben_cmd_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)

260: p_object_version_number => p_object_version_number);
261: --
262: if (l_api_updating
263: and p_rqd_flag
264: <> nvl(ben_cmd_shd.g_old_rec.rqd_flag,hr_api.g_varchar2)
265: or not l_api_updating) then
266: --
267: -- check if value of lookup falls within lookup type.
268: --

Line 326: l_api_updating := ben_cmd_shd.api_updating

322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_cmd_shd.api_updating
327: (p_cm_dlvry_med_typ_id => p_cm_dlvry_med_typ_id,
328: p_object_version_number => p_object_version_number);
329: --
330: if (l_api_updating

Line 332: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd,hr_api.g_varchar2)

328: p_object_version_number => p_object_version_number);
329: --
330: if (l_api_updating
331: and p_cm_dlvry_med_typ_cd
332: <> nvl(ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd,hr_api.g_varchar2)
333: or not l_api_updating) then
334: --
335: -- check if value of lookup falls within lookup type.
336: --

Line 408: l_api_updating := ben_cmd_shd.api_updating

404: Begin
405: --
406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: l_api_updating := ben_cmd_shd.api_updating
409: ( p_cm_dlvry_med_typ_id => p_cm_dlvry_med_typ_id,
410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating

Line 413: and p_cm_dlvry_med_typ_cd <> ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd) or

409: ( p_cm_dlvry_med_typ_id => p_cm_dlvry_med_typ_id,
410: p_object_version_number => p_object_version_number);
411: --
412: if (l_api_updating
413: and p_cm_dlvry_med_typ_cd <> ben_cmd_shd.g_old_rec.cm_dlvry_med_typ_cd) or
414: not l_api_updating then
415: --
416: hr_utility.set_location('Entering:'||l_proc, 10);
417: --

Line 427: -- ben_cmd_shd.constraint_error('BEN_REGN_UK1');

423: close crs_cm_dlvry_med;
424: --
425: -- raise error as UK1 is violated
426: --
427: -- ben_cmd_shd.constraint_error('BEN_REGN_UK1');
428: fnd_message.set_name('BEN','BEN_91408_DUP_CM_MED_CD');
429: fnd_message.raise_error;
430: --
431: end if;

Line 444: Procedure insert_validate(p_rec in ben_cmd_shd.g_rec_type

440:
441: -- ----------------------------------------------------------------------------
442: -- |---------------------------< insert_validate >----------------------------|
443: -- ----------------------------------------------------------------------------
444: Procedure insert_validate(p_rec in ben_cmd_shd.g_rec_type
445: ,p_effective_date in date) is
446: --
447: l_proc varchar2(72) := g_package||'insert_validate';
448: --

Line 499: Procedure update_validate(p_rec in ben_cmd_shd.g_rec_type

495: --
496: -- ----------------------------------------------------------------------------
497: -- |---------------------------< update_validate >----------------------------|
498: -- ----------------------------------------------------------------------------
499: Procedure update_validate(p_rec in ben_cmd_shd.g_rec_type
500: ,p_effective_date in date) is
501: --
502: l_proc varchar2(72) := g_package||'update_validate';
503: --

Line 554: Procedure delete_validate(p_rec in ben_cmd_shd.g_rec_type

550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< delete_validate >----------------------------|
553: -- ----------------------------------------------------------------------------
554: Procedure delete_validate(p_rec in ben_cmd_shd.g_rec_type
555: ,p_effective_date in date) is
556: --
557: l_proc varchar2(72) := g_package||'delete_validate';
558: --