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.HR_SP_PLACEMENT_API dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 66: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

62: --
63: -- Declare cursors and local variables
64: --
65: l_effective_date date;
66: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
67: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
68: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
69: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
70: l_gsp_post_process_warning varchar2(30);

Line 67: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

63: -- Declare cursors and local variables
64: --
65: l_effective_date date;
66: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
67: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
68: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
69: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
70: l_gsp_post_process_warning varchar2(30);
71: --

Line 68: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

64: --
65: l_effective_date date;
66: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
67: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
68: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
69: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
70: l_gsp_post_process_warning varchar2(30);
71: --
72: l_proc varchar2(72) := g_package||'create_spinal_point_placement';

Line 69: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

65: l_effective_date date;
66: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
67: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
68: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
69: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
70: l_gsp_post_process_warning varchar2(30);
71: --
72: l_proc varchar2(72) := g_package||'create_spinal_point_placement';
73: --

Line 198: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

194: --
195: -- Declare cursors and local variables
196: --
197: l_effective_date date;
198: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
199: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
200: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
201: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
202: l_gsp_post_process_warning varchar2(30);

Line 199: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

195: -- Declare cursors and local variables
196: --
197: l_effective_date date;
198: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
199: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
200: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
201: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
202: l_gsp_post_process_warning varchar2(30);
203: --

Line 200: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

196: --
197: l_effective_date date;
198: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
199: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
200: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
201: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
202: l_gsp_post_process_warning varchar2(30);
203: --
204: l_proc varchar2(72) := g_package||'create_spinal_point_placement';

Line 201: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

197: l_effective_date date;
198: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
199: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
200: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
201: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
202: l_gsp_post_process_warning varchar2(30);
203: --
204: l_proc varchar2(72) := g_package||'create_spinal_point_placement';
205: --

Line 540: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

536: ) is
537: --
538: -- Declare cursors and local variables
539: --
540: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
541: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
543: l_sequence_number number;
544: l_next_sequence number;

Line 541: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

537: --
538: -- Declare cursors and local variables
539: --
540: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
541: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
543: l_sequence_number number;
544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

Line 542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

538: -- Declare cursors and local variables
539: --
540: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
541: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
543: l_sequence_number number;
544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

Line 545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

541: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
543: l_sequence_number number;
544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

Line 546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

542: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
543: l_sequence_number number;
544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

Line 547: l_step_id per_spinal_point_placements_f.step_id%TYPE;

543: l_sequence_number number;
544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
551: l_datetrack_mode varchar2(30);

Line 548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

544: l_next_sequence number;
545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
551: l_datetrack_mode varchar2(30);
552: l_temp_ovn number := p_object_version_number;

Line 549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

545: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
551: l_datetrack_mode varchar2(30);
552: l_temp_ovn number := p_object_version_number;
553: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

Line 550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

546: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
547: l_step_id per_spinal_point_placements_f.step_id%TYPE;
548: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
551: l_datetrack_mode varchar2(30);
552: l_temp_ovn number := p_object_version_number;
553: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
554: := trunc(p_effective_end_date);

Line 553: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

549: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
550: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
551: l_datetrack_mode varchar2(30);
552: l_temp_ovn number := p_object_version_number;
553: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
554: := trunc(p_effective_end_date);
555: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE
556: := trunc(p_effective_start_date);
557: l_gsp_post_process_warning varchar2(30);

Line 555: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE

551: l_datetrack_mode varchar2(30);
552: l_temp_ovn number := p_object_version_number;
553: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
554: := trunc(p_effective_end_date);
555: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE
556: := trunc(p_effective_start_date);
557: l_gsp_post_process_warning varchar2(30);
558: --
559:

Line 689: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

685: ) is
686: --
687: -- Declare cursors and local variables
688: --
689: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
690: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
692: l_sequence_number number;
693: l_next_sequence number;

Line 690: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

686: --
687: -- Declare cursors and local variables
688: --
689: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
690: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
692: l_sequence_number number;
693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

Line 691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

687: -- Declare cursors and local variables
688: --
689: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
690: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
692: l_sequence_number number;
693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

Line 694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

690: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
692: l_sequence_number number;
693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

Line 695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

691: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
692: l_sequence_number number;
693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

Line 696: l_step_id per_spinal_point_placements_f.step_id%TYPE;

692: l_sequence_number number;
693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
700: l_datetrack_mode varchar2(30);

Line 697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

693: l_next_sequence number;
694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
700: l_datetrack_mode varchar2(30);
701: l_temp_ovn number := p_object_version_number;

Line 698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

694: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
700: l_datetrack_mode varchar2(30);
701: l_temp_ovn number := p_object_version_number;
702: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

Line 699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

695: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
696: l_step_id per_spinal_point_placements_f.step_id%TYPE;
697: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;
698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
700: l_datetrack_mode varchar2(30);
701: l_temp_ovn number := p_object_version_number;
702: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
703: := trunc(p_effective_end_date);

Line 702: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

698: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;
699: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;
700: l_datetrack_mode varchar2(30);
701: l_temp_ovn number := p_object_version_number;
702: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
703: := trunc(p_effective_end_date);
704: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE
705: := trunc(p_effective_start_date);
706: l_gsp_post_process_warning varchar2(30);

Line 704: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE

700: l_datetrack_mode varchar2(30);
701: l_temp_ovn number := p_object_version_number;
702: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE
703: := trunc(p_effective_end_date);
704: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE
705: := trunc(p_effective_start_date);
706: l_gsp_post_process_warning varchar2(30);
707: --
708:

Line 762: from per_spinal_point_placements_f

758: --
759: hr_utility.set_location(l_proc,20);
760: select parent_spine_id, business_group_id, assignment_id
761: into l_parent_spine_id, l_business_group_id, l_assignment_id
762: from per_spinal_point_placements_f
763: where placement_id = p_placement_id
764: and l_effective_date between effective_start_date
765: and effective_end_date;
766: --

Line 1029: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

1025: -- Declare cursors and local variables
1026: --
1027: l_proc varchar2(72) := (g_package||'delete_spinal_point_placement');
1028: l_effective_date date := trunc(p_effective_date);
1029: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
1030: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1031: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1032: l_temp_ovn number := p_object_version_number;
1033: --

Line 1030: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

1026: --
1027: l_proc varchar2(72) := (g_package||'delete_spinal_point_placement');
1028: l_effective_date date := trunc(p_effective_date);
1029: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
1030: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1031: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1032: l_temp_ovn number := p_object_version_number;
1033: --
1034: begin

Line 1031: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

1027: l_proc varchar2(72) := (g_package||'delete_spinal_point_placement');
1028: l_effective_date date := trunc(p_effective_date);
1029: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;
1030: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;
1031: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;
1032: l_temp_ovn number := p_object_version_number;
1033: --
1034: begin
1035: --