APPS.PQH_ETM_BUS dependencies on PQH_ETM_SHD

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

Line 192: IF NOT pqh_etm_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_etm_shd.api_updating
193: (p_ent_minutes_id => p_rec.ent_minutes_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_etm_shd.g_old_rec.ENT_MINUTES_CD, hr_api.g_varchar2) THEN

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

Line 209: nvl(pqh_etm_shd.g_old_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) THEN

205: fnd_message.raise_error;
206: END IF;
207:
208: IF nvl(p_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) <>
209: nvl(pqh_etm_shd.g_old_rec.TARIFF_GROUP_CD, hr_api.g_varchar2) THEN
210: hr_utility.set_message(8302, 'DE_PQH_NONUPD_TARIFF_CD');
211: fnd_message.raise_error;
212: END IF;
213:

Line 226: (p_rec in pqh_ETM_shd.g_rec_type) is

222: -- |-----------------------< Chk_TFF_CD_HR_LOOKUP >---------------------------|
223: -- ----------------------------------------------------------------------------
224:
225: Procedure Chk_TFF_CD_HR_LOOKUP
226: (p_rec in pqh_ETM_shd.g_rec_type) is
227: --
228: Cursor c_TFF_CD_HR_LOOKUP is
229: Select '1'
230: from hr_lookups

Line 262: (p_rec in pqh_ETM_shd.g_rec_type) is

258: -- |-----------------------< Chk_unique_ENT_Desc >-----------------------------|
259: -- ----------------------------------------------------------------------------
260:
261: Procedure Chk_unique_ENT_Desc
262: (p_rec in pqh_ETM_shd.g_rec_type) is
263: --
264: Cursor c_unique_ENT_Desc is
265: Select '1'
266: from PQH_DE_ENT_MINUTES

Line 298: (p_rec in pqh_ETM_shd.g_rec_type) is

294: -- |-----------------------< Chk_ENT_MIN_TFF_CD >------------------------------|
295: -- ----------------------------------------------------------------------------
296:
297: Procedure Chk_ENT_MIN_TFF_CD
298: (p_rec in pqh_ETM_shd.g_rec_type) is
299: --
300: Cursor c_ENT_MIN_TFF_CD is
301: Select '1'
302: from PQH_DE_ENT_MINUTES

Line 334: ,p_rec in pqh_etm_shd.g_rec_type

330: -- |---------------------------< insert_validate >----------------------------|
331: -- ----------------------------------------------------------------------------
332: Procedure insert_validate
333: (p_effective_date in date
334: ,p_rec in pqh_etm_shd.g_rec_type
335: ) is
336: --
337: l_proc varchar2(72) := g_package||'insert_validate';
338: --

Line 363: ,p_associated_column1 => pqh_etm_shd.g_tab_nam

359:
360: If p_rec.business_group_id is not null then
361: hr_api.validate_bus_grp_id
362: (p_business_group_id => p_rec.business_group_id
363: ,p_associated_column1 => pqh_etm_shd.g_tab_nam
364: || '.BUSINESS_GROUP_ID');
365: end if;
366:
367: --

Line 388: ,p_rec in pqh_etm_shd.g_rec_type

384: -- |---------------------------< update_validate >----------------------------|
385: -- ----------------------------------------------------------------------------
386: Procedure update_validate
387: (p_effective_date in date
388: ,p_rec in pqh_etm_shd.g_rec_type
389: ) is
390: --
391: l_proc varchar2(72) := g_package||'update_validate';
392: --

Line 416: ,p_associated_column1 => pqh_etm_shd.g_tab_nam

412: -- Validate Important Attributes
413: If p_rec.business_group_id is not null then
414: hr_api.validate_bus_grp_id
415: (p_business_group_id => p_rec.business_group_id
416: ,p_associated_column1 => pqh_etm_shd.g_tab_nam
417: || '.BUSINESS_GROUP_ID');
418: end if;
419:
420: --

Line 446: (p_rec in pqh_etm_shd.g_rec_type

442: -- ----------------------------------------------------------------------------
443: -- |---------------------------< delete_validate >----------------------------|
444: -- ----------------------------------------------------------------------------
445: Procedure delete_validate
446: (p_rec in pqh_etm_shd.g_rec_type
447: ) is
448: --
449: l_proc varchar2(72) := g_package||'delete_validate';
450: --