APPS.PQH_ATT_BUS dependencies on PQH_ATT_SHD

Line 46: l_api_updating := pqh_att_shd.api_updating

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

Line 52: <> pqh_att_shd.g_old_rec.attribute_id) then

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

Line 56: pqh_att_shd.constraint_error('PQH_ATTRIBUTES_PK');

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

Line 66: pqh_att_shd.constraint_error('PQH_ATTRIBUTES_PK');

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

Line 118: l_api_updating := pqh_att_shd.api_updating

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

Line 124: <> nvl(pqh_att_shd.g_old_rec.master_attribute_id,hr_api.g_number)

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

Line 140: pqh_att_shd.constraint_error('PQH_ATTRIBUTES_FK2');

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

Line 190: l_api_updating := pqh_att_shd.api_updating

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

Line 196: <> nvl(pqh_att_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

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

Line 223: Procedure insert_validate(p_rec in pqh_att_shd.g_rec_type

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

Line 256: Procedure update_validate(p_rec in pqh_att_shd.g_rec_type

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

Line 289: Procedure delete_validate(p_rec in pqh_att_shd.g_rec_type

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