DBA Data[Home] [Help]

APPS.PQH_PRE_BUS dependencies on PQH_PRE_SHD

Line 181: (p_rec in pqh_pre_shd.g_rec_type

177: --
178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure chk_non_updateable_args
181: (p_rec in pqh_pre_shd.g_rec_type
182: ) IS
183: --
184: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
185: --

Line 191: IF NOT pqh_pre_shd.api_updating

187: --
188: -- Only proceed with the validation if a row exists for the current
189: -- record in the HR Schema.
190: --
191: IF NOT pqh_pre_shd.api_updating
192: (p_ins_end_reason_id => p_rec.ins_end_reason_id
193: ,p_object_version_number => p_rec.object_version_number
194: ) THEN
195: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 209: (p_rec in pqh_pre_shd.g_rec_type) is

205: --
206: --------------------------------------------------------------------
207:
208: Procedure Chk_Unique_END_REASON_NUMBER
209: (p_rec in pqh_pre_shd.g_rec_type) is
210: --
211: Cursor c_END_REASON_NUMBER is
212: Select END_REASON_NUMBER
213: from pqh_de_ins_end_reasons

Line 246: (p_rec in pqh_pre_shd.g_rec_type

242: -- ----------------------------------------------------------------------------
243: -- |---------------------------< insert_validate >----------------------------|
244: -- ----------------------------------------------------------------------------
245: Procedure insert_validate
246: (p_rec in pqh_pre_shd.g_rec_type
247: ) is
248: --
249: l_proc varchar2(72) := g_package||'insert_validate';
250: --

Line 258: ,p_associated_column1 => pqh_pre_shd.g_tab_nam

254: -- Call all supporting business operations
255: --
256: hr_api.validate_bus_grp_id
257: (p_business_group_id => p_rec.business_group_id
258: ,p_associated_column1 => pqh_pre_shd.g_tab_nam
259: || '.BUSINESS_GROUP_ID');
260: --
261: -- After validating the set of important attributes,
262: -- if Multiple Message detection is enabled and at least

Line 278: (p_rec in pqh_pre_shd.g_rec_type

274: -- ----------------------------------------------------------------------------
275: -- |---------------------------< update_validate >----------------------------|
276: -- ----------------------------------------------------------------------------
277: Procedure update_validate
278: (p_rec in pqh_pre_shd.g_rec_type
279: ) is
280: --
281: l_proc varchar2(72) := g_package||'update_validate';
282: --

Line 290: ,p_associated_column1 => pqh_pre_shd.g_tab_nam

286: -- Call all supporting business operations
287: --
288: hr_api.validate_bus_grp_id
289: (p_business_group_id => p_rec.business_group_id
290: ,p_associated_column1 => pqh_pre_shd.g_tab_nam
291: || '.BUSINESS_GROUP_ID');
292: --
293: -- After validating the set of important attributes,
294: -- if Multiple Message detection is enabled and at least

Line 313: (p_rec in pqh_pre_shd.g_rec_type

309: -- ----------------------------------------------------------------------------
310: -- |---------------------------< delete_validate >----------------------------|
311: -- ----------------------------------------------------------------------------
312: Procedure delete_validate
313: (p_rec in pqh_pre_shd.g_rec_type
314: ) is
315: --
316: l_proc varchar2(72) := g_package||'delete_validate';
317: --