APPS.BEN_WYP_BUS dependencies on BEN_WYP_SHD

Line 46: l_api_updating := ben_wyp_shd.api_updating

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

Line 52: <> ben_wyp_shd.g_old_rec.wthn_yr_perd_id) then

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

Line 56: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');

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

Line 66: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_PK');

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

Line 118: l_api_updating := ben_wyp_shd.api_updating

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

Line 124: <> nvl(ben_wyp_shd.g_old_rec.yr_perd_id,hr_api.g_number)

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

Line 140: ben_wyp_shd.constraint_error('BEN_WTHN_YR_PERD_FK1');

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

Line 730: l_api_updating := ben_wyp_shd.api_updating

726: Begin
727: --
728: hr_utility.set_location('Entering:'||l_proc, 5);
729: --
730: l_api_updating := ben_wyp_shd.api_updating
731: (p_wthn_yr_perd_id => p_wthn_yr_perd_id,
732: p_object_version_number => p_object_version_number);
733: --
734: if (l_api_updating

Line 736: <> nvl(ben_wyp_shd.g_old_rec.tm_uom,hr_api.g_varchar2)

732: p_object_version_number => p_object_version_number);
733: --
734: if (l_api_updating
735: and p_tm_uom
736: <> nvl(ben_wyp_shd.g_old_rec.tm_uom,hr_api.g_varchar2)
737: or not l_api_updating)
738: and p_tm_uom is not null then
739: --
740: -- check if value of lookup falls within lookup type.

Line 865: Procedure insert_validate(p_rec in ben_wyp_shd.g_rec_type

861: --
862: -- ----------------------------------------------------------------------------
863: -- |---------------------------< insert_validate >----------------------------|
864: -- ----------------------------------------------------------------------------
865: Procedure insert_validate(p_rec in ben_wyp_shd.g_rec_type
866: ,p_effective_date in date) is
867: --
868: l_proc varchar2(72) := g_package||'insert_validate';
869: --

Line 953: Procedure update_validate(p_rec in ben_wyp_shd.g_rec_type

949: --
950: -- ----------------------------------------------------------------------------
951: -- |---------------------------< update_validate >----------------------------|
952: -- ----------------------------------------------------------------------------
953: Procedure update_validate(p_rec in ben_wyp_shd.g_rec_type
954: ,p_effective_date in date) is
955: --
956: l_proc varchar2(72) := g_package||'update_validate';
957: --

Line 1039: Procedure delete_validate(p_rec in ben_wyp_shd.g_rec_type

1035: --
1036: -- ----------------------------------------------------------------------------
1037: -- |---------------------------< delete_validate >----------------------------|
1038: -- ----------------------------------------------------------------------------
1039: Procedure delete_validate(p_rec in ben_wyp_shd.g_rec_type
1040: ,p_effective_date in date) is
1041: --
1042: l_proc varchar2(72) := g_package||'delete_validate';
1043: --