APPS.PQH_CGN_BUS dependencies on PQH_CGN_SHD

Line 182: ,p_rec in pqh_cgn_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_cgn_shd.g_rec_type
183: ) IS
184: --
185: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
186: --

Line 192: IF NOT pqh_cgn_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_cgn_shd.api_updating
193: (p_case_group_id => p_rec.case_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 208: nvl(pqh_cgn_shd.g_old_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) THEN

204:
205:
206:
207: IF nvl(p_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) <>
208: nvl(pqh_cgn_shd.g_old_rec.CASE_GROUP_NUMBER, hr_api.g_varchar2) THEN
209: hr_utility.set_message(8302, 'PQH_DE_CSGRP_NUMBER');
210: fnd_message.raise_error;
211: END IF;
212:

Line 222: (p_rec in pqh_cgn_shd.g_rec_type) is

218: -- |-----------------------< Chk_ADVANCEMENT_TO >--------------------------|
219: -- ----------------------------------------------------------------------------
220:
221: Procedure Chk_ADVANCEMENT_TO
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

Line 256: (p_rec in pqh_cgn_shd.g_rec_type) is

252: -- ----------------------------------------------------------------------------
253: -- |-----------------------< Chk_delete >--------------------------------------|
254: -- ----------------------------------------------------------------------------
255: Procedure Chk_delete
256: (p_rec in pqh_cgn_shd.g_rec_type) is
257: l_proc varchar2(72) := g_package||'Ckh_Delete';
258: Cursor Del is
259:
260: Select '1'

Line 291: (p_rec in pqh_cgn_shd.g_rec_type) is

287: -- |-----------------------< Chk_Unique_case_group_NUMBER >------------------|
288: -- ----------------------------------------------------------------------------
289:
290: Procedure Chk_Unique_case_group_NUMBER
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

Line 327: ,p_rec in pqh_cgn_shd.g_rec_type

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

Line 356: ,p_associated_column1 => pqh_cgn_shd.g_tab_nam

352:
353: If p_rec.business_group_id is not null then
354: hr_api.validate_bus_grp_id
355: (p_business_group_id => p_rec.business_group_id
356: ,p_associated_column1 => pqh_cgn_shd.g_tab_nam
357: || '.BUSINESS_GROUP_ID');
358: end if;
359:
360: --

Line 381: ,p_rec in pqh_cgn_shd.g_rec_type

377: -- |---------------------------< update_validate >----------------------------|
378: -- ----------------------------------------------------------------------------
379: Procedure update_validate
380: (p_effective_date in date
381: ,p_rec in pqh_cgn_shd.g_rec_type
382: ) is
383: --
384: l_proc varchar2(72) := g_package||'update_validate';
385: --

Line 409: ,p_associated_column1 => pqh_cgn_shd.g_tab_nam

405: -- Validate Important Attributes
406: If p_rec.business_group_id is not null then
407: hr_api.validate_bus_grp_id
408: (p_business_group_id => p_rec.business_group_id
409: ,p_associated_column1 => pqh_cgn_shd.g_tab_nam
410: || '.BUSINESS_GROUP_ID');
411: end if;
412:
413:

Line 443: (p_rec in pqh_cgn_shd.g_rec_type

439: -- ----------------------------------------------------------------------------
440: -- |---------------------------< delete_validate >----------------------------|
441: -- ----------------------------------------------------------------------------
442: Procedure delete_validate
443: (p_rec in pqh_cgn_shd.g_rec_type
444: ) is
445: --
446: l_proc varchar2(72) := g_package||'delete_validate';
447: --