APPS.PQH_OPG_BUS dependencies on PQH_OPG_SHD

Line 182: ,p_rec in pqh_opg_shd.g_rec_type

178: -- {End Of Comments}
179: -- ----------------------------------------------------------------------------
180: Procedure chk_non_updateable_args
181: (p_effective_date in date
182: ,p_rec in pqh_opg_shd.g_rec_type
183: ) IS
184: --
185: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
186: --

Line 192: IF NOT pqh_opg_shd.api_updating

188: --
189: -- Only proceed with the validation if a row exists for the current
190: -- record in the HR Schema.
191: --
192: IF NOT pqh_opg_shd.api_updating
193: (p_operation_group_id => p_rec.operation_group_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 203: nvl(pqh_opg_shd.g_old_rec.operation_Group_CODE, hr_api.g_varchar2) THEN

199: fnd_message.raise_error;
200: END IF;
201:
202: IF nvl(p_rec.operation_Group_CODE, hr_api.g_varchar2) <>
203: nvl(pqh_opg_shd.g_old_rec.operation_Group_CODE, hr_api.g_varchar2) THEN
204: hr_utility.set_message(8302, 'PQH_DE_NONUPD_OPGRP_CODE');
205: fnd_message.raise_error;
206: END IF;
207:

Line 219: (p_rec in pqh_opg_shd.g_rec_type) is

215: -- ----------------------------------------------------------------------------
216: -- |-----------------------< Chk_Unique_Description >-------------------------|
217: -- ----------------------------------------------------------------------------
218: Procedure Chk_Unique_Description
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

Line 254: (p_rec in pqh_opg_shd.g_rec_type) is

250: -- |-----------------------< Chk_Unique_opg_Group_CODE >-----------------------|
251: -- ----------------------------------------------------------------------------
252:
253: Procedure Chk_Unique_opg_Group_CODE
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

Line 290: ,p_rec in pqh_opg_shd.g_rec_type

286: -- |---------------------------< insert_validate >----------------------------|
287: -- ----------------------------------------------------------------------------
288: Procedure insert_validate
289: (p_effective_date in date
290: ,p_rec in pqh_opg_shd.g_rec_type
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'insert_validate';
294: --

Line 320: ,p_associated_column1 => pqh_opg_shd.g_tab_nam

316:
317: If p_rec.business_group_id is not null then
318: hr_api.validate_bus_grp_id
319: (p_business_group_id => p_rec.business_group_id
320: ,p_associated_column1 => pqh_opg_shd.g_tab_nam
321: || '.BUSINESS_GROUP_ID');
322: end if ;
323: --
324: -- After validating the set of important attributes,

Line 347: ,p_rec in pqh_opg_shd.g_rec_type

343: -- |---------------------------< update_validate >----------------------------|
344: -- ----------------------------------------------------------------------------
345: Procedure update_validate
346: (p_effective_date in date
347: ,p_rec in pqh_opg_shd.g_rec_type
348: ) is
349: --
350: l_proc varchar2(72) := g_package||'update_validate';
351: --

Line 375: ,p_associated_column1 => pqh_opg_shd.g_tab_nam

371: -- Validate Important Attributes
372: If p_rec.business_group_id is not null then
373: hr_api.validate_bus_grp_id
374: (p_business_group_id => p_rec.business_group_id
375: ,p_associated_column1 => pqh_opg_shd.g_tab_nam
376: || '.BUSINESS_GROUP_ID');
377: end if ;
378:
379: --

Line 404: (p_rec in pqh_opg_shd.g_rec_type

400: -- ----------------------------------------------------------------------------
401: -- |---------------------------< delete_validate >----------------------------|
402: -- ----------------------------------------------------------------------------
403: Procedure delete_validate
404: (p_rec in pqh_opg_shd.g_rec_type
405: ) is
406: --
407: l_proc varchar2(72) := g_package||'delete_validate';
408: --