eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PGS_BUS dependencies on PER_PGS_SHD

Line 202: l_api_updating := per_pgs_shd.api_updating

198: --
199: Begin
200: hr_utility.set_location('Entering:'||l_proc, 10);
201: --
202: l_api_updating := per_pgs_shd.api_updating
203: (p_effective_date => p_effective_date
204: ,p_grade_spine_id => p_grade_spine_id
205: ,p_object_version_number => p_object_version_number
206: );

Line 210: <> per_pgs_shd.g_old_rec.grade_spine_id) then

206: );
207: --
208: if (l_api_updating
209: and nvl(p_grade_spine_id,hr_api.g_number)
210: <> per_pgs_shd.g_old_rec.grade_spine_id) then
211: --
212: -- raise error as PK has changed
213: --
214: per_pgs_shd.constraint_error('PER_GRADE_SPINES_F_PK');

Line 214: per_pgs_shd.constraint_error('PER_GRADE_SPINES_F_PK');

210: <> per_pgs_shd.g_old_rec.grade_spine_id) then
211: --
212: -- raise error as PK has changed
213: --
214: per_pgs_shd.constraint_error('PER_GRADE_SPINES_F_PK');
215: --
216: elsif not l_api_updating then
217: --
218: -- check if PK is null

Line 224: per_pgs_shd.constraint_error('PER_GRADE_SPINES_F_PK');

220: if p_grade_spine_id is not null then
221: --
222: -- raise error as PK is not null
223: --
224: per_pgs_shd.constraint_error('PER_GRADE_SPINES_F_PK');
225: --
226: end if;
227: --
228: end if;

Line 303: l_api_updating := per_pgs_shd.api_updating

299: -- Only proceed with validation if :
300: -- a) The current g_old_rec is current and
301: -- b) The value for parent_spine_id has changed
302: --
303: l_api_updating := per_pgs_shd.api_updating
304: (p_effective_date => p_effective_date
305: ,p_grade_spine_id => p_grade_spine_id
306: ,p_object_version_number => p_object_version_number);
307: --

Line 308: if (l_api_updating and nvl(per_pgs_shd.g_old_rec.parent_spine_id,

304: (p_effective_date => p_effective_date
305: ,p_grade_spine_id => p_grade_spine_id
306: ,p_object_version_number => p_object_version_number);
307: --
308: if (l_api_updating and nvl(per_pgs_shd.g_old_rec.parent_spine_id,
309: hr_api.g_number) = nvl(p_parent_spine_id, hr_api.g_number)) then
310: return;
311: end if;
312:

Line 317: per_pgs_shd.constraint_error(p_constraint_name => 'PER_GRADE_SPINES_F_FK2');

313: open csr_valid_parent_spines;
314: fetch csr_valid_parent_spines into l_exists;
315: if csr_valid_parent_spines%notfound then
316: --
317: per_pgs_shd.constraint_error(p_constraint_name => 'PER_GRADE_SPINES_F_FK2');
318: --
319: end if;
320: close csr_valid_parent_spines;
321:

Line 396: l_api_updating := per_pgs_shd.api_updating

392: -- Only proceed with validation if :
393: -- a) The current g_old_rec is current and
394: -- b) The value for grade_id has changed
395: --
396: l_api_updating := per_pgs_shd.api_updating
397: (p_effective_date => p_effective_date
398: ,p_grade_spine_id => p_grade_spine_id
399: ,p_object_version_number => p_object_version_number
400: );

Line 402: if (l_api_updating and nvl(per_pgs_shd.g_old_rec.grade_id,

398: ,p_grade_spine_id => p_grade_spine_id
399: ,p_object_version_number => p_object_version_number
400: );
401: --
402: if (l_api_updating and nvl(per_pgs_shd.g_old_rec.grade_id,
403: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)) then
404: return;
405: end if;
406:

Line 416: per_pgs_shd.constraint_error(p_constraint_name => 'PER_GRADE_SPINES_F_FK3');

412: open csr_valid_grade_id;
413: fetch csr_valid_grade_id into l_exists;
414: if csr_valid_grade_id%notfound then
415: close csr_valid_grade_id;
416: per_pgs_shd.constraint_error(p_constraint_name => 'PER_GRADE_SPINES_F_FK3');
417: hr_utility.raise_error;
418: end if;
419: close csr_valid_grade_id;
420: --

Line 501: l_api_updating := per_pgs_shd.api_updating

497: -- Only proceed with validation if :
498: -- a) The current g_old_rec is current and
499: -- b) The value for ceiling_step_id has changed
500: --
501: l_api_updating := per_pgs_shd.api_updating
502: (p_effective_date => p_effective_date
503: ,p_grade_spine_id => p_grade_spine_id
504: ,p_object_version_number => p_object_version_number);
505: --

Line 507: if nvl(per_pgs_shd.g_old_rec.ceiling_step_id, hr_api.g_number)

503: ,p_grade_spine_id => p_grade_spine_id
504: ,p_object_version_number => p_object_version_number);
505: --
506: if (l_api_updating) then
507: if nvl(per_pgs_shd.g_old_rec.ceiling_step_id, hr_api.g_number)
508: = nvl(p_ceiling_step_id, hr_api.g_number) then
509: return;
510: else
511:

Line 658: l_api_updating := per_pgs_shd.api_updating

654: -- Only proceed with validation if :
655: -- a) The current g_old_rec is current and
656: -- b) The value for grade_id and parent_spine_id have changed
657: --
658: l_api_updating := per_pgs_shd.api_updating
659: (p_effective_date => p_effective_date
660: ,p_grade_spine_id => p_grade_spine_id
661: ,p_object_version_number => p_object_version_number);
662: --

Line 664: and nvl(per_pgs_shd.g_old_rec.grade_id,

660: ,p_grade_spine_id => p_grade_spine_id
661: ,p_object_version_number => p_object_version_number);
662: --
663: if (l_api_updating
664: and nvl(per_pgs_shd.g_old_rec.grade_id,
665: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)
666: and nvl(per_pgs_shd.g_old_rec.parent_spine_id,hr_api.g_number)
667: = nvl(p_parent_spine_id, hr_api.g_number)
668: ) then

Line 666: and nvl(per_pgs_shd.g_old_rec.parent_spine_id,hr_api.g_number)

662: --
663: if (l_api_updating
664: and nvl(per_pgs_shd.g_old_rec.grade_id,
665: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)
666: and nvl(per_pgs_shd.g_old_rec.parent_spine_id,hr_api.g_number)
667: = nvl(p_parent_spine_id, hr_api.g_number)
668: ) then
669: return;
670: end if;

Line 828: ,p_rec in per_pgs_shd.g_rec_type

824: -- {End Of Comments}
825: -- ----------------------------------------------------------------------------
826: Procedure chk_non_updateable_args
827: (p_effective_date in date
828: ,p_rec in per_pgs_shd.g_rec_type
829: ) IS
830: --
831: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
832: --

Line 838: IF NOT per_pgs_shd.api_updating

834: --
835: -- Only proceed with the validation if a row exists for the current
836: -- record in the HR Schema.
837: --
838: IF NOT per_pgs_shd.api_updating
839: (p_grade_spine_id => p_rec.grade_spine_id
840: ,p_effective_date => p_effective_date
841: ,p_object_version_number => p_rec.object_version_number
842: ) THEN

Line 853: per_pgs_shd.g_old_rec.business_group_id then

849: --
850: -- Check business_group_id is not updated
851: --
852: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
853: per_pgs_shd.g_old_rec.business_group_id then
854: hr_api.argument_changed_error
855: (p_api_name => l_proc
856: ,p_argument => 'BUSINESS_GROUP_ID'
857: ,p_base_table => per_pgs_shd.g_tab_nam

Line 857: ,p_base_table => per_pgs_shd.g_tab_nam

853: per_pgs_shd.g_old_rec.business_group_id then
854: hr_api.argument_changed_error
855: (p_api_name => l_proc
856: ,p_argument => 'BUSINESS_GROUP_ID'
857: ,p_base_table => per_pgs_shd.g_tab_nam
858: );
859: END IF;
860:
861: --

Line 865: per_pgs_shd.g_old_rec.parent_spine_id then

861: --
862: -- Check parent_spine_id is not updated
863: --
864: IF nvl(p_rec.parent_spine_id, hr_api.g_number) <>
865: per_pgs_shd.g_old_rec.parent_spine_id then
866: hr_api.argument_changed_error
867: (p_api_name => l_proc
868: ,p_argument => 'PARENT_SPINE_ID'
869: ,p_base_table => per_pgs_shd.g_tab_nam

Line 869: ,p_base_table => per_pgs_shd.g_tab_nam

865: per_pgs_shd.g_old_rec.parent_spine_id then
866: hr_api.argument_changed_error
867: (p_api_name => l_proc
868: ,p_argument => 'PARENT_SPINE_ID'
869: ,p_base_table => per_pgs_shd.g_tab_nam
870: );
871: END IF;
872:
873: --

Line 877: per_pgs_shd.g_old_rec.grade_id then

873: --
874: -- Check grade_id is not updated
875: --
876: IF nvl(p_rec.grade_id, hr_api.g_number) <>
877: per_pgs_shd.g_old_rec.grade_id then
878: hr_api.argument_changed_error
879: (p_api_name => l_proc
880: ,p_argument => 'GRADE_ID'
881: ,p_base_table => per_pgs_shd.g_tab_nam

Line 881: ,p_base_table => per_pgs_shd.g_tab_nam

877: per_pgs_shd.g_old_rec.grade_id then
878: hr_api.argument_changed_error
879: (p_api_name => l_proc
880: ,p_argument => 'GRADE_ID'
881: ,p_base_table => per_pgs_shd.g_tab_nam
882: );
883: end if;
884:
885: End chk_non_updateable_args;

Line 1092: (p_rec in out nocopy per_pgs_shd.g_rec_type

1088: -- ----------------------------------------------------------------------------
1089: -- |---------------------------< insert_validate >----------------------------|
1090: -- ----------------------------------------------------------------------------
1091: Procedure insert_validate
1092: (p_rec in out nocopy per_pgs_shd.g_rec_type
1093: ,p_effective_date in date
1094: ,p_datetrack_mode in varchar2
1095: ,p_validation_start_date in date
1096: ,p_validation_end_date in date

Line 1108: ,p_associated_column1 => per_pgs_shd.g_tab_nam

1104: -- Call all supporting business operations
1105: --
1106: hr_api.validate_bus_grp_id
1107: (p_business_group_id => p_rec.business_group_id
1108: ,p_associated_column1 => per_pgs_shd.g_tab_nam
1109: || '.BUSINESS_GROUP_ID');
1110:
1111: --
1112: -- Validate grade spine id

Line 1193: (p_rec in out nocopy per_pgs_shd.g_rec_type

1189: -- ----------------------------------------------------------------------------
1190: -- |---------------------------< update_validate >----------------------------|
1191: -- ----------------------------------------------------------------------------
1192: Procedure update_validate
1193: (p_rec in out nocopy per_pgs_shd.g_rec_type
1194: ,p_effective_date in date
1195: ,p_datetrack_mode in varchar2
1196: ,p_validation_start_date in date
1197: ,p_validation_end_date in date

Line 1209: ,p_associated_column1 => per_pgs_shd.g_tab_nam

1205: -- Call all supporting business operations
1206: --
1207: hr_api.validate_bus_grp_id
1208: (p_business_group_id => p_rec.business_group_id
1209: ,p_associated_column1 => per_pgs_shd.g_tab_nam
1210: || '.BUSINESS_GROUP_ID');
1211:
1212: --
1213: -- Validate grade spine id

Line 1318: (p_rec in per_pgs_shd.g_rec_type

1314: -- ----------------------------------------------------------------------------
1315: -- |---------------------------< delete_validate >----------------------------|
1316: -- ----------------------------------------------------------------------------
1317: Procedure delete_validate
1318: (p_rec in per_pgs_shd.g_rec_type
1319: ,p_effective_date in date
1320: ,p_datetrack_mode in varchar2
1321: ,p_validation_start_date in date
1322: ,p_validation_end_date in date