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_CAGR_APPLY_RESULTS_PKG dependencies on HR_SP_PLACEMENT_API

Line 642: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';

638: close csr_placement_id;
639:
640: if l_placement_id is not null then
641: -- we will be updating spp
642: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';
643:
644: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
645: ,p_dt_flag => 'Y'
646: ,p_pk => 'PLACEMENT_ID'

Line 654: l_api_name := 'HR_SP_PLACEMENT_API.CREATE_SPP';

650: ,p_ovn => l_ovn);
651: else
652: -- we will be creating spp
653: -- problem as there are no params seeded for it!!!
654: l_api_name := 'HR_SP_PLACEMENT_API.CREATE_SPP';
655: l_switched_api := TRUE;
656: end if;
657:
658: -- build pl/sql table of all seeded api column names for the update API name

Line 661: for v_api_details in csr_api('HR_SP_PLACEMENT_API.UPDATE_SPP') loop

657:
658: -- build pl/sql table of all seeded api column names for the update API name
659: -- (as the create params are a subset of update in this case)
660: -- BUT this will be a problem should any new create params be added that are NOT updateable
661: for v_api_details in csr_api('HR_SP_PLACEMENT_API.UPDATE_SPP') loop
662: l_count := l_count+1;
663: l_api_details(l_count) := v_api_details;
664: end loop;
665: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);

Line 697: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then

693: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
694:
695: if l_map_count > 0 then
696: BEGIN
697: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
698:
699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
700: l_step_id := get_num_val('STEP_ID',l_mapping_table);
701: if l_step_id is null then

Line 699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);

695: if l_map_count > 0 then
696: BEGIN
697: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
698:
699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
700: l_step_id := get_num_val('STEP_ID',l_mapping_table);
701: if l_step_id is null then
702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

Line 703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

699: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
700: l_step_id := get_num_val('STEP_ID',l_mapping_table);
701: if l_step_id is null then
702: -- check other mandatory params are supplied
703: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
704: else
705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);

Line 709: hr_sp_placement_api.create_spp

705: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
706: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
707: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
708: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
709: hr_sp_placement_api.create_spp
710: (p_effective_date => p_params.effective_date
711: ,p_business_group_id => p_params.business_group_id
712: ,p_assignment_id => p_params.assignment_id -- current assignment
713: ,p_step_id => l_step_id

Line 718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);

714: ,p_object_version_number => l_ovn
715: ,p_placement_id => l_placement_id
716: ,p_effective_start_date => l_effective_start_date
717: ,p_effective_end_date => l_effective_end_date);
718: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;

Line 723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then

719: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
720: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:
725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
726: hr_sp_placement_api.update_spp
727: (p_effective_date => p_params.effective_date

Line 725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);

721: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:
725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
726: hr_sp_placement_api.update_spp
727: (p_effective_date => p_params.effective_date
728: ,p_datetrack_mode => l_dt_mode
729: ,p_placement_id => l_placement_id

Line 726: hr_sp_placement_api.update_spp

722: end if;
723: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
724:
725: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
726: hr_sp_placement_api.update_spp
727: (p_effective_date => p_params.effective_date
728: ,p_datetrack_mode => l_dt_mode
729: ,p_placement_id => l_placement_id
730: ,p_step_id => get_num_val('STEP_ID',l_mapping_table)

Line 735: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);

731: ,p_object_version_number => l_ovn
732: ,p_effective_start_date => l_effective_start_date
733: ,p_effective_end_date => l_effective_end_date);
734:
735: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
736: end if;
737: EXCEPTION
738: when others then -- log unexpected API error, and continue
739: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);