DBA Data[Home] [Help]

APPS.PQH_LVL_BUS dependencies on PQH_LVL_SHD

Line 182: ,p_rec in pqh_lvl_shd.g_rec_type

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

Line 192: IF NOT pqh_lvl_shd.api_updating

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

Line 238: (p_rec in pqh_lvl_shd.g_rec_type) IS

234: hr_utility.set_location(' Leaving:'||l_proc,70);
235: End chk_Lvl_Num;
236:
237: Procedure chk_Lvl_Code
238: (p_rec in pqh_lvl_shd.g_rec_type) IS
239: --
240: l_proc varchar2(72) := g_package || 'chk_Lvl_Code';
241: --
242: Cursor Lvlcode is

Line 274: ,p_rec in pqh_lvl_shd.g_rec_type

270: -- |---------------------------< insert_validate >----------------------------|
271: -- ----------------------------------------------------------------------------
272: Procedure insert_validate
273: (p_effective_date in date
274: ,p_rec in pqh_lvl_shd.g_rec_type
275: ) is
276: --
277: l_proc varchar2(72) := g_package||'insert_validate';
278: --

Line 286: ,p_associated_column1 => pqh_lvl_shd.g_tab_nam

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

Line 309: ,p_rec in pqh_lvl_shd.g_rec_type

305: -- |---------------------------< update_validate >----------------------------|
306: -- ----------------------------------------------------------------------------
307: Procedure update_validate
308: (p_effective_date in date
309: ,p_rec in pqh_lvl_shd.g_rec_type
310: ) is
311: --
312: l_proc varchar2(72) := g_package||'update_validate';
313: --

Line 321: ,p_associated_column1 => pqh_lvl_shd.g_tab_nam

317: -- Call all supporting business operations
318: --
319: hr_api.validate_bus_grp_id
320: (p_business_group_id => p_rec.business_group_id
321: ,p_associated_column1 => pqh_lvl_shd.g_tab_nam
322: || '.BUSINESS_GROUP_ID');
323: --
324: -- After validating the set of important attributes,
325: -- if Multiple Message detection is enabled and at least

Line 349: (p_rec in pqh_lvl_shd.g_rec_type

345: -- ----------------------------------------------------------------------------
346: -- |---------------------------< delete_validate >----------------------------|
347: -- ----------------------------------------------------------------------------
348: Procedure delete_validate
349: (p_rec in pqh_lvl_shd.g_rec_type
350: ) is
351: --
352: l_proc varchar2(72) := g_package||'delete_validate';
353: --