APPS.PQH_OPL_BUS dependencies on PQH_OPL_SHD

Line 194: ,p_rec in pqh_opl_shd.g_rec_type

190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure chk_non_updateable_args
193: (p_effective_date in date
194: ,p_rec in pqh_opl_shd.g_rec_type
195: ) IS
196: --
197: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
198:

Line 205: IF NOT pqh_opl_shd.api_updating

201: --
202: -- Only proceed with the validation if a row exists for the current
203: -- record in the HR Schema.
204: --
205: IF NOT pqh_opl_shd.api_updating
206: (p_operation_id => p_rec.operation_id
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 219: nvl(pqh_opl_shd.g_old_rec.OPERATION_NUMBER, hr_api.g_varchar2) THEN

215: -- EDIT_HERE: Add checks to ensure non-updateable args have
216: -- not been updated.
217: --
218: IF nvl(p_rec.OPERATION_NUMBER, hr_api.g_varchar2) <>
219: nvl(pqh_opl_shd.g_old_rec.OPERATION_NUMBER, hr_api.g_varchar2) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_OPERATION_NUMBER');
221: fnd_message.raise_error;
222: END IF;
223:

Line 230: (p_rec in pqh_opl_shd.g_rec_type) is

226: -- ----------------------------------------------------------------------------
227: -- |---------------------------< Chk_delete >---------------------------------|
228: -- ----------------------------------------------------------------------------
229: Procedure Chk_delete
230: (p_rec in pqh_opl_shd.g_rec_type) is
231: l_proc varchar2(72) := g_package||'Ckh_Delete';
232: Cursor Del is
233: select '1' from per_gen_hierarchy_nodes
234: where NODE_TYPE = 'OPR_OPTS'

Line 261: (p_rec in pqh_opl_shd.g_rec_type) is

257: -- ----------------------------------------------------------------------------
258: -- |-----------------------< Chk_Unique_Description >-------------------------|
259: -- ----------------------------------------------------------------------------
260: Procedure Chk_Unique_Description
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

Line 293: (p_rec in pqh_opl_shd.g_rec_type) is

289: -- ----------------------------------------------------------------------------
290: -- |-----------------------< Chk_Unique_OPERATION_NUMBER >--------------------|
291: -- ----------------------------------------------------------------------------
292: Procedure Chk_Unique_OPERATION_NUMBER
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

Line 326: ,p_rec in pqh_opl_shd.g_rec_type

322: -- |---------------------------< insert_validate >----------------------------|
323: -- ----------------------------------------------------------------------------
324: Procedure insert_validate
325: (p_effective_date in date
326: ,p_rec in pqh_opl_shd.g_rec_type
327: ) is
328: --
329: l_proc varchar2(72) := g_package||'insert_validate';
330: --

Line 358: ,p_rec in pqh_opl_shd.g_rec_type

354: -- |---------------------------< update_validate >----------------------------|
355: -- ----------------------------------------------------------------------------
356: Procedure update_validate
357: (p_effective_date in date
358: ,p_rec in pqh_opl_shd.g_rec_type
359: ) is
360: --
361: l_proc varchar2(72) := g_package||'update_validate';
362: --

Line 393: (p_rec in pqh_opl_shd.g_rec_type

389: -- ----------------------------------------------------------------------------
390: -- |---------------------------< delete_validate >----------------------------|
391: -- ----------------------------------------------------------------------------
392: Procedure delete_validate
393: (p_rec in pqh_opl_shd.g_rec_type
394: ) is
395: --
396: l_proc varchar2(72) := g_package||'delete_validate';
397: --