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 634: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';

630: close csr_placement_id;
631:
632: if l_placement_id is not null then
633: -- we will be updating spp
634: l_api_name := 'HR_SP_PLACEMENT_API.UPDATE_SPP';
635:
636: get_ovn_and_mode (p_table_name => 'PER_SPINAL_POINT_PLACEMENTS_F'
637: ,p_dt_flag => 'Y'
638: ,p_pk => 'PLACEMENT_ID'

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

642: ,p_ovn => l_ovn);
643: else
644: -- we will be creating spp
645: -- problem as there are no params seeded for it!!!
646: l_api_name := 'HR_SP_PLACEMENT_API.CREATE_SPP';
647: l_switched_api := TRUE;
648: end if;
649:
650: -- build pl/sql table of all seeded api column names for the update API name

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

649:
650: -- build pl/sql table of all seeded api column names for the update API name
651: -- (as the create params are a subset of update in this case)
652: -- BUT this will be a problem should any new create params be added that are NOT updateable
653: for v_api_details in csr_api('HR_SP_PLACEMENT_API.UPDATE_SPP') loop
654: l_count := l_count+1;
655: l_api_details(l_count) := v_api_details;
656: end loop;
657: per_cagr_utility_pkg.put_log(' built api_details array of size: '||l_count);

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

685: per_cagr_utility_pkg.put_log(' built mapping array of size: '||l_map_count);
686:
687: if l_map_count > 0 then
688: BEGIN
689: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
690:
691: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
692: l_step_id := get_num_val('STEP_ID',l_mapping_table);
693: if l_step_id is null then

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

687: if l_map_count > 0 then
688: BEGIN
689: if l_api_name = 'HR_SP_PLACEMENT_API.CREATE_SPP' then
690:
691: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
692: l_step_id := get_num_val('STEP_ID',l_mapping_table);
693: if l_step_id is null then
694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);

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

691: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.CREATE_SPP',1);
692: l_step_id := get_num_val('STEP_ID',l_mapping_table);
693: if l_step_id is null then
694: -- check other mandatory params are supplied
695: per_cagr_utility_pkg.put_log(' ERROR: Cannot call HR_SP_PLACEMENT_API.CREATE_SPP with null STEP_ID',1);
696: else
697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);

Line 701: hr_sp_placement_api.create_spp

697: -- per_cagr_utility_pkg.put_log(' date: '||p_params.effective_date,1);
698: -- per_cagr_utility_pkg.put_log(' BG: '||to_char(p_params.business_group_id),1);
699: -- per_cagr_utility_pkg.put_log(' asg: '||to_char(p_params.assignment_id),1);
700: -- per_cagr_utility_pkg.put_log(' step: '||to_char(l_step_id),1);
701: hr_sp_placement_api.create_spp
702: (p_effective_date => p_params.effective_date
703: ,p_business_group_id => p_params.business_group_id
704: ,p_assignment_id => p_params.assignment_id -- current assignment
705: ,p_step_id => l_step_id

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

706: ,p_object_version_number => l_ovn
707: ,p_placement_id => l_placement_id
708: ,p_effective_start_date => l_effective_start_date
709: ,p_effective_end_date => l_effective_end_date);
710: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.CREATE_SPP',1);
711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;

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

711: -- per_cagr_utility_pkg.put_log(' placement_id: '||to_char(l_placement_id),1);
712: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_start_date,1);
713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:
717: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
718: hr_sp_placement_api.update_spp
719: (p_effective_date => p_params.effective_date

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

713: -- per_cagr_utility_pkg.put_log(' date: '||l_effective_end_date,1);
714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:
717: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
718: hr_sp_placement_api.update_spp
719: (p_effective_date => p_params.effective_date
720: ,p_datetrack_mode => l_dt_mode
721: ,p_placement_id => l_placement_id

Line 718: hr_sp_placement_api.update_spp

714: end if;
715: elsif l_api_name = 'HR_SP_PLACEMENT_API.UPDATE_SPP' then
716:
717: per_cagr_utility_pkg.put_log(' calling HR_SP_PLACEMENT_API.UPDATE_SPP',1);
718: hr_sp_placement_api.update_spp
719: (p_effective_date => p_params.effective_date
720: ,p_datetrack_mode => l_dt_mode
721: ,p_placement_id => l_placement_id
722: ,p_step_id => get_num_val('STEP_ID',l_mapping_table)

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

723: ,p_object_version_number => l_ovn
724: ,p_effective_start_date => l_effective_start_date
725: ,p_effective_end_date => l_effective_end_date);
726:
727: per_cagr_utility_pkg.put_log(' done HR_SP_PLACEMENT_API.UPDATE_SPP',1);
728: end if;
729: EXCEPTION
730: when others then -- log unexpected API error, and continue
731: per_cagr_utility_pkg.put_log(' ERROR: '||sqlerrm,1);