APPS.PQH_OPG_BUS dependencies on PQH_DE_OPERATION_GROUPS

Line 30: , pqh_de_operation_groups opg

26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_de_operation_groups opg
31: where opg.operation_group_id = p_operation_group_id
32: and pbg.business_group_id = opg.business_group_id;
33: --
34: -- Declare local variables

Line 94: , pqh_de_operation_groups opg

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

Line 223: from PQH_DE_OPERATION_groups

219: (p_rec in pqh_opg_shd.g_rec_type) is
220: --
221: Cursor c_Description is
222: Select Description
223: from PQH_DE_OPERATION_groups
224: Where Description = p_rec.Description;
225: l_Description pqh_de_operation_groups.Description%TYPE;
226: l_proc varchar2(72) := g_package || 'Unique_Description';
227: Begin

Line 225: l_Description pqh_de_operation_groups.Description%TYPE;

221: Cursor c_Description is
222: Select Description
223: from PQH_DE_OPERATION_groups
224: Where Description = p_rec.Description;
225: l_Description pqh_de_operation_groups.Description%TYPE;
226: l_proc varchar2(72) := g_package || 'Unique_Description';
227: Begin
228: hr_utility.set_location(l_proc, 10);
229: Open c_Description;

Line 240: (p_associated_column1 => 'pqh_de_operation_groups.Description'

236: Close c_Description;
237: Exception
238: when app_exception.application_exception then
239: if hr_multi_message.exception_add
240: (p_associated_column1 => 'pqh_de_operation_groups.Description'
241: ) then
242: hr_utility.set_location(' Leaving:'||l_proc,60);
243: raise;
244: end if;

Line 258: from PQH_DE_OPERATION_groupS

254: (p_rec in pqh_opg_shd.g_rec_type) is
255: --
256: Cursor c_operation_Group_CODE is
257: Select '1'
258: from PQH_DE_OPERATION_groupS
259: Where operation_Group_CODE = p_rec.operation_Group_CODE;
260: L_status Varchar2(1);
261: l_proc varchar2(1000) := g_package || 'Unique_OPG_NUMBER';
262: Begin

Line 275: (p_associated_column1 => 'PQH_DE_OPERATION_groupS.operation_Group_CODE'

271: Close c_operation_Group_CODE;
272: Exception
273: when app_exception.application_exception then
274: if hr_multi_message.exception_add
275: (p_associated_column1 => 'PQH_DE_OPERATION_groupS.operation_Group_CODE'
276: ) then
277: hr_utility.set_location(' Leaving:'||l_proc,60);
278: raise;
279: end if;