APPS.PQH_OPL_BUS dependencies on PQH_DE_OPERATIONS

Line 28: -- pqh_de_operations and PER_BUSINESS_GROUPS

24: --
25: -- Declare cursor
26: --
27: -- EDIT_HERE In the following cursor statement add join(s) between
28: -- pqh_de_operations and PER_BUSINESS_GROUPS
29: -- so that the security_group_id for
30: -- the current business group context can be derived.
31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is

Line 35: , pqh_de_operations opl

31: -- Remove this comment when the edit has been completed.
32: cursor csr_sec_grp is
33: select pbg.security_group_id
34: from per_business_groups pbg
35: , pqh_de_operations opl
36: -- , EDIT_HERE table_name(s) 333
37: where opl.operation_id = p_operation_id;
38: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
39: --

Line 98: -- pqh_de_operations and PER_BUSINESS_GROUPS

94: --
95: -- Declare cursor
96: --
97: -- EDIT_HERE In the following cursor statement add join(s) between
98: -- pqh_de_operations and PER_BUSINESS_GROUPS
99: -- so that the legislation_code for
100: -- the current business group context can be derived.
101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is

Line 105: , pqh_de_operations opl

101: -- Remove this comment when the edit has been completed.
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups pbg
105: , pqh_de_operations opl
106: -- , EDIT_HERE table_name(s) 333
107: where opl.operation_id = p_operation_id;
108: -- and pbg.business_group_id = EDIT_HERE 333.business_group_id;
109: --

Line 249: (p_associated_column1 => 'PQH_DE_OPERATIONS.OPERATION_NUMBER'

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

Line 265: from PQH_DE_OPERATIONS

261: (p_rec in pqh_opl_shd.g_rec_type) is
262: --
263: Cursor c_Description is
264: Select Description
265: from PQH_DE_OPERATIONS
266: Where Description = p_rec.Description;
267: l_Description PQH_DE_OPERATIONS.Description%TYPE;
268: l_proc varchar2(72) := g_package || 'Unique_Description';
269: Begin

Line 267: l_Description PQH_DE_OPERATIONS.Description%TYPE;

263: Cursor c_Description is
264: Select Description
265: from PQH_DE_OPERATIONS
266: Where Description = p_rec.Description;
267: l_Description PQH_DE_OPERATIONS.Description%TYPE;
268: l_proc varchar2(72) := g_package || 'Unique_Description';
269: Begin
270: hr_utility.set_location(l_proc, 10);
271: Open c_Description;

Line 282: (p_associated_column1 => 'PQH_DE_OPERATIONS.Description'

278: Close c_Description;
279: Exception
280: when app_exception.application_exception then
281: if hr_multi_message.exception_add
282: (p_associated_column1 => 'PQH_DE_OPERATIONS.Description'
283: ) then
284: hr_utility.set_location(' Leaving:'||l_proc,60);
285: raise;
286: end if;

Line 297: from PQH_DE_OPERATIONS

293: (p_rec in pqh_opl_shd.g_rec_type) is
294: --
295: Cursor c_OPERATION_NUMBER is
296: Select OPERATION_NUMBER
297: from PQH_DE_OPERATIONS
298: Where OPERATION_NUMBER = p_rec.OPERATION_NUMBER;
299: l_OPERATION_NUMBER PQH_DE_OPERATIONS.OPERATION_NUMBER%TYPE;
300: l_proc varchar2(72) := g_package || 'Unique_OPERATION_NUMBER';
301: Begin

Line 299: l_OPERATION_NUMBER PQH_DE_OPERATIONS.OPERATION_NUMBER%TYPE;

295: Cursor c_OPERATION_NUMBER is
296: Select OPERATION_NUMBER
297: from PQH_DE_OPERATIONS
298: Where OPERATION_NUMBER = p_rec.OPERATION_NUMBER;
299: l_OPERATION_NUMBER PQH_DE_OPERATIONS.OPERATION_NUMBER%TYPE;
300: l_proc varchar2(72) := g_package || 'Unique_OPERATION_NUMBER';
301: Begin
302: hr_utility.set_location(l_proc, 10);
303: Open c_OPERATION_NUMBER;

Line 314: (p_associated_column1 => 'PQH_DE_OPERATIONS.OPERATION_NUMBER'

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