APPS.PQH_GVN_BUS dependencies on PQH_GVN_SHD

Line 194: ,p_rec in pqh_gvn_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_gvn_shd.g_rec_type
195: ) IS
196: --
197: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
198:

Line 205: IF NOT pqh_gvn_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_gvn_shd.api_updating
206: (p_level_number_id => p_rec.level_number_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 217: nvl(pqh_gvn_shd.g_old_rec.level_NUMBER, hr_api.g_varchar2) THEN

213: END IF;
214:
215:
216: IF nvl(p_rec.level_NUMBER, hr_api.g_varchar2) <>
217: nvl(pqh_gvn_shd.g_old_rec.level_NUMBER, hr_api.g_varchar2) THEN
218: hr_utility.set_message(8302, 'PQH_DE_NONUPD_LEVEL_NUMBER');
219: fnd_message.raise_error;
220:
221: END IF;

Line 232: (p_rec in pqh_gvn_shd.g_rec_type) is

228: -- ----------------------------------------------------------------------------
229: -- |---------------------------< Chk_Unique_level_NUMBER >---------------------|
230: -- ----------------------------------------------------------------------------
231: Procedure Chk_Unique_level_NUMBER
232: (p_rec in pqh_gvn_shd.g_rec_type) is
233: --
234: Cursor c_LEVEL_NUMBER is
235: Select LEVEL_NUMBER
236: from PQH_DE_LEVEL_NUMBERS

Line 270: (p_rec in pqh_gvn_shd.g_rec_type) is

266: -- ----------------------------------------------------------------------------
267: -- |---------------------------< Chk_WRKPLC_VLDTN_LVLNUMS >-------------------|
268: -- ----------------------------------------------------------------------------
269: Procedure Chk_WRKPLC_VLDTN_LVLNUMS
270: (p_rec in pqh_gvn_shd.g_rec_type) is
271: l_proc varchar2(72) := g_package||'Ckh_Delete';
272: Cursor Del is
273: select '1' from PQH_DE_WRKPLC_VLDTN_LVLNUMS
274: where LEVEL_NUMBER_ID = p_rec.LEVEL_NUMBER_ID ;

Line 300: (p_rec in pqh_gvn_shd.g_rec_type) is

296: -- ----------------------------------------------------------------------------
297: -- |---------------------------< Chk_delete >---------------------------------|
298: -- ----------------------------------------------------------------------------
299: Procedure Chk_delete
300: (p_rec in pqh_gvn_shd.g_rec_type) is
301: l_proc varchar2(72) := g_package||'Ckh_Delete';
302: Cursor Del is
303: select '1' from PQH_DE_LEVEL_CODES
304: where Level_number_id = p_rec.level_NUMBER;

Line 332: ,p_rec in pqh_gvn_shd.g_rec_type

328: -- |---------------------------< insert_validate >----------------------------|
329: -- ----------------------------------------------------------------------------
330: Procedure insert_validate
331: (p_effective_date in date
332: ,p_rec in pqh_gvn_shd.g_rec_type
333: ) is
334: --
335: l_proc varchar2(72) := g_package||'insert_validate';
336: --

Line 363: ,p_rec in pqh_gvn_shd.g_rec_type

359: -- |---------------------------< update_validate >----------------------------|
360: -- ----------------------------------------------------------------------------
361: Procedure update_validate
362: (p_effective_date in date
363: ,p_rec in pqh_gvn_shd.g_rec_type
364: ) is
365: --
366: l_proc varchar2(72) := g_package||'update_validate';
367: --

Line 401: (p_rec in pqh_gvn_shd.g_rec_type

397: -- ----------------------------------------------------------------------------
398: -- |---------------------------< delete_validate >----------------------------|
399: -- ----------------------------------------------------------------------------
400: Procedure delete_validate
401: (p_rec in pqh_gvn_shd.g_rec_type
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'delete_validate';
405: --