DBA Data[Home] [Help]

APPS.PQH_LCD_BUS dependencies on PQH_DE_WRKPLC_VLDTN_LVLNUMS

Line 235: select '1' from PQH_DE_WRKPLC_VLDTN_LVLNUMS

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
237: and LEVEL_CODE_ID = pqh_lcd_shd.g_old_rec.LEVEL_CODE_ID;
238: l_Status Varchar2(1);
239: Begin

Line 251: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'

247: Close Del;
248: Exception
249: when app_exception.application_exception then
250: if hr_multi_message.exception_add
251: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_LVLNUMS.LEVEL_CODE_ID'
252: ) then
253: hr_utility.set_location(' Leaving:'||l_proc,60);
254: raise;
255: end if;