DBA Data[Home] [Help]

APPS.PQH_DEF_BUS dependencies on PQH_DEF_SHD

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

Line 192: IF NOT pqh_def_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_def_shd.api_updating
193: (p_wrkplc_vldtn_id => p_rec.wrkplc_vldtn_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 205: If p_rec.Employment_type <> pqh_def_shd.g_old_rec.Employment_type Then

201: --
202: -- EDIT_HERE: Add checks to ensure non-updateable args have
203: -- not been updated.
204: --
205: If p_rec.Employment_type <> pqh_def_shd.g_old_rec.Employment_type Then
206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_EMP');
207: fnd_message.raise_error;
208: End If;
209:

Line 210: If p_rec.Remuneration_Regulation <> pqh_def_shd.g_old_rec.Remuneration_Regulation Then

206: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_EMP');
207: fnd_message.raise_error;
208: End If;
209:
210: If p_rec.Remuneration_Regulation <> pqh_def_shd.g_old_rec.Remuneration_Regulation Then
211: hr_utility.set_message(8302, 'PQH_DE_NONUPD_VALDTN_RRN');
212: fnd_message.raise_error;
213: End If;
214: End chk_non_updateable_args;

Line 218: (p_rec in pqh_def_shd.g_rec_type) is

214: End chk_non_updateable_args;
215: --
216:
217: Procedure Chk_Unique_Validation_Name
218: (p_rec in pqh_def_shd.g_rec_type) is
219: --
220:
221: Cursor Vldtn_Name is
222: Select Validation_Name

Line 252: (p_rec in pqh_def_shd.g_rec_type) is

248: hr_utility.set_location(' Leaving:'||l_proc,70);
249: End Chk_Unique_Validation_Name;
250:
251: Procedure Ckh_Emp_Type
252: (p_rec in pqh_def_shd.g_rec_type) is
253: --
254: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
255: Begin
256: hr_utility.set_location(l_proc, 10);

Line 273: (p_rec in pqh_def_shd.g_rec_type) is

269: hr_utility.set_location(' Leaving:'||l_proc,70);
270: End Ckh_Emp_Type;
271:
272: Procedure Ckh_Remuneration
273: (p_rec in pqh_def_shd.g_rec_type) is
274: --
275: l_proc varchar2(72) := g_package||'Ckh_Emp_Type';
276: Begin
277: hr_utility.set_location(l_proc, 10);

Line 293: (p_rec in pqh_def_shd.g_rec_type) is

289: hr_utility.set_location(' Leaving:'||l_proc,70);
290: End Ckh_Remuneration;
291:
292: Procedure Chk_delete
293: (p_rec in pqh_def_shd.g_rec_type) is
294:
295: l_proc varchar2(72) := g_package||'Ckh_Delete';
296: Cursor Del is
297: Select '1' from

Line 327: ,p_rec in pqh_def_shd.g_rec_type

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

Line 339: ,p_associated_column1 => pqh_def_shd.g_tab_nam

335: -- Call all supporting business operations
336: --
337: hr_api.validate_bus_grp_id
338: (p_business_group_id => p_rec.business_group_id
339: ,p_associated_column1 => pqh_def_shd.g_tab_nam
340: || '.BUSINESS_GROUP_ID');
341: --
342: -- After validating the set of important attributes,
343: -- if Multiple Message detection is enabled and at least

Line 373: ,p_rec in pqh_def_shd.g_rec_type) is

369: -- |---------------------------< update_validate >----------------------------|
370: -- ----------------------------------------------------------------------------
371: Procedure update_validate
372: (p_effective_date in date
373: ,p_rec in pqh_def_shd.g_rec_type) is
374: --
375: l_proc varchar2(72) := g_package||'update_validate';
376: --
377: Begin

Line 384: ,p_associated_column1 => pqh_def_shd.g_tab_nam

380: -- Call all supporting business operations
381: --
382: hr_api.validate_bus_grp_id
383: (p_business_group_id => p_rec.business_group_id
384: ,p_associated_column1 => pqh_def_shd.g_tab_nam
385: || '.BUSINESS_GROUP_ID');
386: --
387: -- After validating the set of important attributes,
388: -- if Multiple Message detection is enabled and at least

Line 413: (p_rec in pqh_def_shd.g_rec_type

409: -- ----------------------------------------------------------------------------
410: -- |---------------------------< delete_validate >----------------------------|
411: -- ----------------------------------------------------------------------------
412: Procedure delete_validate
413: (p_rec in pqh_def_shd.g_rec_type
414: ) is
415: --
416: l_proc varchar2(72) := g_package||'delete_validate';
417: --