APPS.PQH_RSS_BUS dependencies on PQH_RSS_SHD

Line 194: ,p_rec in pqh_rss_shd.g_rec_type

190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure chk_non_updateable_args
193: (p_effective_date in date
194: ,p_rec in pqh_rss_shd.g_rec_type
195: ) IS
196: --
197: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
198:

Line 205: IF NOT pqh_rss_shd.api_updating

201: --
202: -- Only proceed with the validation if a row exists for the current
203: -- record in the HR Schema.
204: --
205: IF NOT pqh_rss_shd.api_updating
206: (p_result_set_id => p_rec.result_set_id
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 219: nvl(pqh_RSS_shd.g_old_rec.Grade_id, hr_api.g_number) THEN

215: -- EDIT_HERE: Add checks to ensure non-updateable args have
216: -- not been updated.
217: --
218: IF nvl(p_rec.Grade_id, hr_api.g_number) <>
219: nvl(pqh_RSS_shd.g_old_rec.Grade_id, hr_api.g_number) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_GRADE_ID');
221: fnd_message.raise_error;
222:
223: END IF;

Line 231: (p_rec in pqh_rss_shd.g_rec_type) is

227: -- ----------------------------------------------------------------------------
228: -- |---------------------------< Chk_Grade_id >-------------------------------|
229: -- ----------------------------------------------------------------------------
230: Procedure Chk_Grade_id
231: (p_rec in pqh_rss_shd.g_rec_type) is
232: --
233: Cursor c_Grade_id is
234: Select Grade_id
235: from per_grades

Line 266: p_rec in pqh_rss_shd.g_rec_type) is

262: -- ----------------------------------------------------------------------------
263:
264: Procedure Chk_CIVIL_SERVANTS_Grade_id
265: (p_effective_date in date ,
266: p_rec in pqh_rss_shd.g_rec_type) is
267: --
268: Cursor c_CIVIL_SERVANTS_Grade_id is
269: SELECT
270: pg.NAME

Line 353: (p_rec in pqh_rss_shd.g_rec_type) is

349: -- ----------------------------------------------------------------------------
350: -- |---------------------------< Chk_gradual_value_numbers >------------------|
351: -- ----------------------------------------------------------------------------
352: Procedure Chk_gradual_value_numbers
353: (p_rec in pqh_rss_shd.g_rec_type) is
354: --
355: Cursor c_gradual_value_numbers is
356: Select '1'
357: from pqh_de_result_sets

Line 410: ,p_rec in pqh_rss_shd.g_rec_type

406: -- |---------------------------< insert_validate >----------------------------|
407: -- ----------------------------------------------------------------------------
408: Procedure insert_validate
409: (p_effective_date in date
410: ,p_rec in pqh_rss_shd.g_rec_type
411: ) is
412: --
413: l_proc varchar2(72) := g_package||'insert_validate';
414: --

Line 444: ,p_rec in pqh_rss_shd.g_rec_type

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

Line 479: (p_rec in pqh_rss_shd.g_rec_type

475: -- ----------------------------------------------------------------------------
476: -- |---------------------------< delete_validate >----------------------------|
477: -- ----------------------------------------------------------------------------
478: Procedure delete_validate
479: (p_rec in pqh_rss_shd.g_rec_type
480: ) is
481: --
482: l_proc varchar2(72) := g_package||'delete_validate';
483: --