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 HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'grade_spine_id'
50: ,p_argument_value => p_grade_spine_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'grade_spine_id'
119: ,p_argument_value => p_grade_spine_id
120: );

Line 122: if ( nvl(per_pgs_bus.g_grade_spine_id, hr_api.g_number)

118: ,p_argument => 'grade_spine_id'
119: ,p_argument_value => p_grade_spine_id
120: );
121: --
122: if ( nvl(per_pgs_bus.g_grade_spine_id, hr_api.g_number)
123: = p_grade_spine_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 209: and nvl(p_grade_spine_id,hr_api.g_number)

205: ,p_object_version_number => p_object_version_number
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: --

Line 292: hr_api.mandatory_arg_error

288: hr_utility.set_location('Entering:'|| l_proc, 10);
289: --
290: -- Check mandatory parameters have been set
291: --
292: hr_api.mandatory_arg_error
293: (p_api_name => l_proc
294: ,p_argument => 'parent_spine_id'
295: ,p_argument_value => p_parent_spine_id
296: );

Line 309: hr_api.g_number) = nvl(p_parent_spine_id, hr_api.g_number)) then

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:
313: open csr_valid_parent_spines;

Line 376: and nvl(pg.date_to, hr_api.g_eot);

372: from per_grades pg
373: where pg.grade_id = p_grade_id
374: and business_group_id = p_business_group_id
375: and p_effective_date between pg.date_from
376: and nvl(pg.date_to, hr_api.g_eot);
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 10);

Line 386: hr_api.mandatory_arg_error

382: --
383: --
384: -- Check mandatory parameters have been set
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'grade_id'
389: ,p_argument_value => p_grade_id
390: );

Line 403: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)) then

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:
407: hr_utility.set_location(l_proc, 20);

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 508: = nvl(p_ceiling_step_id, hr_api.g_number) then

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:
512: hr_utility.set_location(l_proc, 20);

Line 518: hr_api.mandatory_arg_error

514: /* skip mandatory parameter check BUG3389808
515: --
516: -- Check mandatory parameters have been set
517: --
518: hr_api.mandatory_arg_error
519: (p_api_name => l_proc
520: ,p_argument => 'ceiling_step_id'
521: ,p_argument_value => p_ceiling_step_id
522: );

Line 665: hr_api.g_number) = nvl(p_grade_id, hr_api.g_number)

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
669: return;

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 667: = nvl(p_parent_spine_id, hr_api.g_number)

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;
671:

Line 852: IF nvl(p_rec.business_group_id, hr_api.g_number) <>

848:
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'

Line 854: hr_api.argument_changed_error

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
858: );

Line 864: IF nvl(p_rec.parent_spine_id, hr_api.g_number) <>

860:
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'

Line 866: hr_api.argument_changed_error

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
870: );

Line 876: IF nvl(p_rec.grade_id, hr_api.g_number) <>

872:
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'

Line 878: hr_api.argument_changed_error

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
882: );

Line 928: hr_api.mandatory_arg_error

924: Begin
925: --
926: -- Ensure that the p_datetrack_mode argument is not null
927: --
928: hr_api.mandatory_arg_error
929: (p_api_name => l_proc
930: ,p_argument => 'datetrack_mode'
931: ,p_argument_value => p_datetrack_mode
932: );

Line 938: hr_api.mandatory_arg_error

934: -- Mode will be valid, as this is checked at the start of the upd.
935: --
936: -- Ensure the arguments are not null
937: --
938: hr_api.mandatory_arg_error
939: (p_api_name => l_proc
940: ,p_argument => 'validation_start_date'
941: ,p_argument_value => p_validation_start_date
942: );

Line 944: hr_api.mandatory_arg_error

940: ,p_argument => 'validation_start_date'
941: ,p_argument_value => p_validation_start_date
942: );
943: --
944: hr_api.mandatory_arg_error
945: (p_api_name => l_proc
946: ,p_argument => 'validation_end_date'
947: ,p_argument_value => p_validation_end_date
948: );

Line 1012: hr_api.mandatory_arg_error

1008: Begin
1009: --
1010: -- Ensure that the p_datetrack_mode argument is not null
1011: --
1012: hr_api.mandatory_arg_error
1013: (p_api_name => l_proc
1014: ,p_argument => 'datetrack_mode'
1015: ,p_argument_value => p_datetrack_mode
1016: );

Line 1021: If (p_datetrack_mode = hr_api.g_delete or

1017: --
1018: -- Only perform the validation if the datetrack mode is either
1019: -- DELETE or ZAP
1020: --
1021: If (p_datetrack_mode = hr_api.g_delete or
1022: p_datetrack_mode = hr_api.g_zap) then
1023: --
1024: --
1025: -- Ensure the arguments are not null

Line 1022: p_datetrack_mode = hr_api.g_zap) then

1018: -- Only perform the validation if the datetrack mode is either
1019: -- DELETE or ZAP
1020: --
1021: If (p_datetrack_mode = hr_api.g_delete or
1022: p_datetrack_mode = hr_api.g_zap) then
1023: --
1024: --
1025: -- Ensure the arguments are not null
1026: --

Line 1027: hr_api.mandatory_arg_error

1023: --
1024: --
1025: -- Ensure the arguments are not null
1026: --
1027: hr_api.mandatory_arg_error
1028: (p_api_name => l_proc
1029: ,p_argument => 'validation_start_date'
1030: ,p_argument_value => p_validation_start_date
1031: );

Line 1033: hr_api.mandatory_arg_error

1029: ,p_argument => 'validation_start_date'
1030: ,p_argument_value => p_validation_start_date
1031: );
1032: --
1033: hr_api.mandatory_arg_error
1034: (p_api_name => l_proc
1035: ,p_argument => 'validation_end_date'
1036: ,p_argument_value => p_validation_end_date
1037: );

Line 1039: hr_api.mandatory_arg_error

1035: ,p_argument => 'validation_end_date'
1036: ,p_argument_value => p_validation_end_date
1037: );
1038: --
1039: hr_api.mandatory_arg_error
1040: (p_api_name => l_proc
1041: ,p_argument => 'grade_spine_id'
1042: ,p_argument_value => p_grade_spine_id
1043: );

Line 1106: hr_api.validate_bus_grp_id

1102: hr_utility.set_location('Entering:'||l_proc, 10);
1103: --
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:

Line 1207: hr_api.validate_bus_grp_id

1203: hr_utility.set_location('Entering:'||l_proc, 10);
1204: --
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: