APPS.PQH_ETM_BUS dependencies on PQH_DE_ENT_MINUTES

Line 30: , pqh_de_ent_minutes etm

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_ent_minutes etm
31: where etm.ent_minutes_id = p_ent_minutes_id
32: and pbg.business_group_id = etm.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_ent_minutes etm

90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , pqh_de_ent_minutes etm
95: where etm.ent_minutes_id = p_ent_minutes_id
96: and pbg.business_group_id (+) = etm.business_group_id;
97: --
98: -- Declare local variables

Line 249: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.Tariff_group_CD'

245: Close c_TFF_CD_HR_LOOKUP;
246: Exception
247: when app_exception.application_exception then
248: if hr_multi_message.exception_add
249: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.Tariff_group_CD'
250: ) then
251: hr_utility.set_location(' Leaving:'||l_proc,60);
252: raise;
253: end if;

Line 266: from PQH_DE_ENT_MINUTES

262: (p_rec in pqh_ETM_shd.g_rec_type) is
263: --
264: Cursor c_unique_ENT_Desc is
265: Select '1'
266: from PQH_DE_ENT_MINUTES
267: Where DESCRIPTION = p_rec.DESCRIPTION
268: and Business_group_id = p_rec.Business_group_id ;
269:
270: L_status Varchar2(1);

Line 285: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.DESCRIPTION'

281: Close c_unique_ENT_Desc;
282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add
285: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.DESCRIPTION'
286: ) then
287: hr_utility.set_location(' Leaving:'||l_proc,60);
288: raise;
289: end if;

Line 302: from PQH_DE_ENT_MINUTES

298: (p_rec in pqh_ETM_shd.g_rec_type) is
299: --
300: Cursor c_ENT_MIN_TFF_CD is
301: Select '1'
302: from PQH_DE_ENT_MINUTES
303: Where ENT_MINUTES_CD = p_rec.ENT_MINUTES_CD
304: AND Tariff_group_CD = p_rec.Tariff_group_CD;
305:
306: L_status Varchar2(1);

Line 313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');

309: hr_utility.set_location(l_proc, 10);
310: Open c_ENT_MIN_TFF_CD;
311: Fetch c_ENT_MIN_TFF_CD into L_status;
312: If c_ENT_MIN_TFF_CD%found Then
313: hr_utility.set_message(8302, 'PQH_DE_ENT_MINUTES_DUP');
314: Close c_ENT_MIN_TFF_CD;
315: fnd_message.raise_error;
316: End If;
317: Close c_ENT_MIN_TFF_CD;

Line 321: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.ENT_MINUTES_CD'

317: Close c_ENT_MIN_TFF_CD;
318: Exception
319: when app_exception.application_exception then
320: if hr_multi_message.exception_add
321: (p_associated_column1 => 'PQH_DE_ENT_MINUTES.ENT_MINUTES_CD'
322: ) then
323: hr_utility.set_location(' Leaving:'||l_proc,60);
324: raise;
325: end if;