APPS.PQH_LCD_BUS dependencies on PQH_LCD_SHD

Line 193: (p_rec in pqh_lcd_shd.g_rec_type

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

Line 204: IF NOT pqh_lcd_shd.api_updating

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

Line 218: nvl(pqh_lcd_shd.g_old_rec.level_code, hr_api.g_varchar2) THEN

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

Line 232: (p_rec in pqh_lcd_shd.g_rec_type) is

228: -- |-----------------------< Chk_delete >-------------------------------------|
229: -- ----------------------------------------------------------------------------
230:
231: Procedure Chk_delete
232: (p_rec in pqh_lcd_shd.g_rec_type) is
233: l_proc varchar2(72) := g_package||'Ckh_Delete';
234: Cursor Del is
235: select '1' from PQH_DE_WRKPLC_VLDTN_LVLNUMS
236: where LEVEL_NUMBER_ID = pqh_lcd_shd.g_old_rec.LEVEL_NUMBER_ID

Line 236: where LEVEL_NUMBER_ID = pqh_lcd_shd.g_old_rec.LEVEL_NUMBER_ID

232: (p_rec in pqh_lcd_shd.g_rec_type) is
233: l_proc varchar2(72) := g_package||'Ckh_Delete';
234: Cursor Del is
235: select '1' from PQH_DE_WRKPLC_VLDTN_LVLNUMS
236: where LEVEL_NUMBER_ID = pqh_lcd_shd.g_old_rec.LEVEL_NUMBER_ID
237: and LEVEL_CODE_ID = pqh_lcd_shd.g_old_rec.LEVEL_CODE_ID;
238: l_Status Varchar2(1);
239: Begin
240: Open Del;

Line 237: and LEVEL_CODE_ID = pqh_lcd_shd.g_old_rec.LEVEL_CODE_ID;

233: l_proc varchar2(72) := g_package||'Ckh_Delete';
234: Cursor Del is
235: select '1' from PQH_DE_WRKPLC_VLDTN_LVLNUMS
236: where LEVEL_NUMBER_ID = pqh_lcd_shd.g_old_rec.LEVEL_NUMBER_ID
237: and LEVEL_CODE_ID = pqh_lcd_shd.g_old_rec.LEVEL_CODE_ID;
238: l_Status Varchar2(1);
239: Begin
240: Open Del;
241: Fetch Del into l_Status;

Line 263: (p_rec in pqh_lcd_shd.g_rec_type) is

259: -- |-----------------------< Chk_LEVEL_NUMBER_ID >----------------------------|
260: -- ----------------------------------------------------------------------------
261:
262: Procedure Chk_LEVEL_NUMBER_ID
263: (p_rec in pqh_lcd_shd.g_rec_type) is
264: l_proc varchar2(72) := g_package||'Ckh_LEVEL_NUMBER_ID';
265: Cursor c_LEVEL_NUMBER_ID is
266: select '1' from PQH_DE_LEVEL_NUMBERS a, PQH_DE_LEVEL_codes b
267: where a.LEVEL_NUMBER_ID = p_rec.LEVEL_NUMBER_ID

Line 298: (p_rec in pqh_lcd_shd.g_rec_type) is

294: -- |-----------------------< Chk_Unique_Level_Code >--------------------------|
295: -- ----------------------------------------------------------------------------
296:
297: Procedure Chk_Unique_Level_Code
298: (p_rec in pqh_lcd_shd.g_rec_type) is
299: --
300: Cursor c_Level_Code is
301: Select Level_Code
302: from PQH_DE_Level_Codes

Line 331: (p_rec in pqh_lcd_shd.g_rec_type

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

Line 361: (p_rec in pqh_lcd_shd.g_rec_type

357: -- ----------------------------------------------------------------------------
358: -- |---------------------------< update_validate >----------------------------|
359: -- ----------------------------------------------------------------------------
360: Procedure update_validate
361: (p_rec in pqh_lcd_shd.g_rec_type
362: ) is
363: --
364: l_proc varchar2(72) := g_package||'update_validate';
365: --

Line 393: (p_rec in pqh_lcd_shd.g_rec_type

389: -- ----------------------------------------------------------------------------
390: -- |---------------------------< delete_validate >----------------------------|
391: -- ----------------------------------------------------------------------------
392: Procedure delete_validate
393: (p_rec in pqh_lcd_shd.g_rec_type
394: ) is
395: --
396: l_proc varchar2(72) := g_package||'delete_validate';
397: --