APPS.PQH_CGN_BUS dependencies on PQH_DE_CASE_GROUPS

Line 30: , pqh_de_case_groups cgn

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_case_groups cgn
31: where cgn.case_group_id = p_case_group_id
32: and pbg.business_group_id = cgn.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_case_groups cgn

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

Line 226: from PQH_DE_case_groupS

222: (p_rec in pqh_cgn_shd.g_rec_type) is
223: --
224: Cursor c_case_group_NUMBER is
225: Select case_group_NUMBER
226: from PQH_DE_case_groupS
227: Where case_group_NUMBER = p_rec.ADVANCEMENT_TO;
228:
229: l_case_group_NUMBER PQH_DE_case_groupS.case_group_NUMBER%TYPE;
230: l_proc varchar2(72) := g_package || 'Chk_case_group_NUMBER';

Line 229: l_case_group_NUMBER PQH_DE_case_groupS.case_group_NUMBER%TYPE;

225: Select case_group_NUMBER
226: from PQH_DE_case_groupS
227: Where case_group_NUMBER = p_rec.ADVANCEMENT_TO;
228:
229: l_case_group_NUMBER PQH_DE_case_groupS.case_group_NUMBER%TYPE;
230: l_proc varchar2(72) := g_package || 'Chk_case_group_NUMBER';
231: Begin
232: hr_utility.set_location(l_proc, 10);
233: Open c_case_group_NUMBER;

Line 244: (p_associated_column1 => 'PQH_DE_case_groupS.ADVANCEMENT_TO'

240: Close c_case_group_NUMBER;
241: Exception
242: when app_exception.application_exception then
243: if hr_multi_message.exception_add
244: (p_associated_column1 => 'PQH_DE_case_groupS.ADVANCEMENT_TO'
245: ) then
246: hr_utility.set_location(' Leaving:'||l_proc,60);
247: raise;
248: end if;

Line 261: from per_gen_hierarchy_nodes a, pqh_de_case_groups b

257: l_proc varchar2(72) := g_package||'Ckh_Delete';
258: Cursor Del is
259:
260: Select '1'
261: from per_gen_hierarchy_nodes a, pqh_de_case_groups b
262: where NODE_TYPE = 'CASE_GROUP'
263: and a. entity_id = b.CASE_GROUP_NUMBER
264: and b.CASE_GROUP_id= p_rec.CASE_GROUP_id;
265:

Line 279: (p_associated_column1 => 'PQH_DE_CASE_GROUPS.CASE_GROUP_NUMBER'

275: Close Del;
276: Exception
277: when app_exception.application_exception then
278: if hr_multi_message.exception_add
279: (p_associated_column1 => 'PQH_DE_CASE_GROUPS.CASE_GROUP_NUMBER'
280: ) then
281: hr_utility.set_location(' Leaving:'||l_proc,60);
282: raise;
283: end if;

Line 295: from PQH_DE_case_groupS

291: (p_rec in pqh_cgn_shd.g_rec_type) is
292: --
293: Cursor c_case_group_NUMBER is
294: Select '1'
295: from PQH_DE_case_groupS
296: Where case_group_NUMBER = p_rec.case_group_NUMBER
297: and description = p_rec.description;
298: L_status Varchar2(1);
299: l_proc varchar2(1000) := g_package || 'Unique_cg_NUMBER';

Line 313: (p_associated_column1 => 'PQH_DE_case_groupS.case_group_NUMBER'

309: Close c_case_group_NUMBER;
310: Exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'PQH_DE_case_groupS.case_group_NUMBER'
314: ) then
315: hr_utility.set_location(' Leaving:'||l_proc,60);
316: raise;
317: end if;