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 539: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

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

Line 540: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

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

Line 541: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

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

Line 544: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

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

Line 545: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

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

Line 546: l_step_id per_spinal_point_placements_f.step_id%TYPE;

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

Line 547: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

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

Line 548: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

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

Line 549: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

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

Line 552: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

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

Line 554: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE

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

Line 688: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

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

Line 689: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

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

Line 690: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

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

Line 693: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

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

Line 694: l_next_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;

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

Line 695: l_step_id per_spinal_point_placements_f.step_id%TYPE;

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

Line 696: l_placement_id per_spinal_point_placements_f.placement_id%TYPE;

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

Line 697: l_assignment_id per_spinal_point_placements_f.assignment_id%TYPE;

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

Line 698: l_business_group_id per_spinal_point_placements_f.business_group_id%TYPE;

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

Line 701: l_effective_end_date_temp per_spinal_point_placements_f.effective_end_date%TYPE

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

Line 703: l_effective_start_date_temp per_spinal_point_placements_f.effective_start_date%TYPE

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

Line 761: from per_spinal_point_placements_f

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

Line 1028: l_object_version_number per_spinal_point_placements_f.object_version_number%TYPE;

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

Line 1029: l_effective_start_date per_spinal_point_placements_f.effective_start_date%TYPE;

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

Line 1030: l_effective_end_date per_spinal_point_placements_f.effective_end_date%TYPE;

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