DBA Data[Home] [Help]

APPS.PER_CPA_BUS dependencies on PER_CPA_SHD

Line 312: (per_cpa_shd.g_old_rec.display_name <> p_display_name))) THEN

308: -- b) The value for consultation type has changed
309: --
310: IF ( (p_cagr_api_param_id IS NULL) OR
311: ((p_cagr_api_param_id IS NOT NULL) AND
312: (per_cpa_shd.g_old_rec.display_name <> p_display_name))) THEN
313: --
314: --
315: -- Check Display Name is unique within the API.
316: --

Line 409: (per_cpa_shd.g_old_rec.parameter_name <> p_parameter_name))) THEN

405: -- b) The value for consultation type has changed
406: --
407: IF ( (p_cagr_api_param_id IS NULL) OR
408: ((p_cagr_api_param_id IS NOT NULL) AND
409: (per_cpa_shd.g_old_rec.parameter_name <> p_parameter_name))) THEN
410: --
411: hr_utility.set_location(l_proc,30);
412: --
413: -- Check parameter_name is unique within the API.

Line 492: (per_cpa_shd.g_old_rec.hidden <> p_hidden))) THEN

488: -- b) The value for consultation type has changed
489: --
490: IF ( (p_cagr_api_param_id IS NULL) OR
491: ((p_cagr_api_param_id IS NOT NULL) AND
492: (per_cpa_shd.g_old_rec.hidden <> p_hidden))) THEN
493: --
494: hr_utility.set_location(l_proc, 20);
495: --
496: -- Check that the type exists in HR_LOOKUPS

Line 569: (per_cpa_shd.g_old_rec.column_type <> p_column_type))) THEN

565: -- b) The value for consultation type has changed
566: --
567: IF ( (p_cagr_api_param_id IS NULL) OR
568: ((p_cagr_api_param_id IS NOT NULL) AND
569: (per_cpa_shd.g_old_rec.column_type <> p_column_type))) THEN
570: --
571: hr_utility.set_location(l_proc, 20);
572: --
573: -- Check that the type exists in HR_LOOKUPS

Line 699: (per_cpa_shd.g_old_rec.uom_parameter <> p_uom_parameter))) THEN

695: -- b) The value for consultation type has changed
696: --
697: IF ( (p_cagr_api_param_id IS NULL) OR
698: ((p_cagr_api_param_id IS NOT NULL) AND
699: (per_cpa_shd.g_old_rec.uom_parameter <> p_uom_parameter))) THEN
700: --
701: hr_utility.set_location(l_proc, 20);
702: --
703: OPEN csr_get_uom_parameter;

Line 787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>

783: -- b) The value for consultation type has changed
784: --
785: IF ( (p_cagr_api_param_id IS NULL) OR
786: ((p_cagr_api_param_id IS NOT NULL) AND
787: (NVL(per_cpa_shd.g_old_rec.uom_lookup,hr_api.g_varchar2) <>
788: NVL(p_uom_lookup,hr_api.g_varchar2)))) THEN
789: --
790: hr_utility.set_location(l_proc, 20);
791: --

Line 887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>

883: -- b) The value for consultation type has changed
884: --
885: IF ( (p_cagr_api_param_id IS NULL) OR
886: ((p_cagr_api_param_id IS NOT NULL) AND
887: (NVL(per_cpa_shd.g_old_rec.default_uom,hr_api.g_varchar2) <>
888: NVL(p_default_uom,hr_api.g_varchar2)))) THEN
889: --
890: hr_utility.set_location(l_proc, 20);
891: --

Line 1024: ,p_rec in per_cpa_shd.g_rec_type

1020: -- {End Of Comments}
1021: -- ----------------------------------------------------------------------------
1022: Procedure chk_non_updateable_args
1023: (p_effective_date in date
1024: ,p_rec in per_cpa_shd.g_rec_type
1025: ) IS
1026: --
1027: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
1028: l_error EXCEPTION;

Line 1036: IF NOT per_cpa_shd.api_updating

1032: --
1033: -- Only proceed with the validation if a row exists for the current
1034: -- record in the HR Schema.
1035: --
1036: IF NOT per_cpa_shd.api_updating
1037: (p_cagr_api_param_id => p_rec.cagr_api_param_id
1038: ,p_object_version_number => p_rec.object_version_number
1039: ) THEN
1040: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN

1043: fnd_message.raise_error;
1044: END IF;
1045: --
1046: IF nvl(p_rec.cagr_api_param_id, hr_api.g_number) <>
1047: nvl(per_cpa_shd.g_old_rec.cagr_api_param_id,hr_api.g_number) THEN
1048: --
1049: l_argument := 'cagr_api_params_id';
1050: RAISE l_error;
1051: --

Line 1055: nvl(per_cpa_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN

1051: --
1052: END IF;
1053: --
1054: IF nvl(p_rec.cagr_api_id, hr_api.g_number) <>
1055: nvl(per_cpa_shd.g_old_rec.cagr_api_id,hr_api.g_number) THEN
1056: --
1057: l_argument := 'cagr_api_id';
1058: RAISE l_error;
1059: --

Line 1063: nvl(per_cpa_shd.g_old_rec.parameter_name,hr_api.g_varchar2) THEN

1059: --
1060: END IF;
1061: --
1062: IF nvl(p_rec.parameter_name, hr_api.g_varchar2) <>
1063: nvl(per_cpa_shd.g_old_rec.parameter_name,hr_api.g_varchar2) THEN
1064: --
1065: l_argument := 'parameter_name';
1066: RAISE l_error;
1067: --

Line 1084: ,p_rec in per_cpa_shd.g_rec_type

1080: -- |---------------------------< insert_validate >----------------------------|
1081: -- ----------------------------------------------------------------------------
1082: Procedure insert_validate
1083: (p_effective_date in date
1084: ,p_rec in per_cpa_shd.g_rec_type
1085: ) is
1086: --
1087: l_proc varchar2(72) := g_package||'insert_validate';
1088: --

Line 1184: ,p_rec in per_cpa_shd.g_rec_type

1180: -- |---------------------------< update_validate >----------------------------|
1181: -- ----------------------------------------------------------------------------
1182: Procedure update_validate
1183: (p_effective_date in date
1184: ,p_rec in per_cpa_shd.g_rec_type
1185: ) is
1186: --
1187: l_proc varchar2(72) := g_package||'update_validate';
1188: --

Line 1275: (p_rec in per_cpa_shd.g_rec_type

1271: -- ----------------------------------------------------------------------------
1272: -- |---------------------------< delete_validate >----------------------------|
1273: -- ----------------------------------------------------------------------------
1274: Procedure delete_validate
1275: (p_rec in per_cpa_shd.g_rec_type
1276: ) is
1277: --
1278: l_proc varchar2(72) := g_package||'delete_validate';
1279: --