PACKAGE: APPS.HR_SPP_WI_DATA

Source

1 PACKAGE HR_SPP_WI_DATA AUTHID CURRENT_USER AS
2 /* $Header: pesppwif.pkh 115.8 2003/05/26 12:02:38 vramanai noship $ */
3 
4 TYPE SPP_WI_TableType is record
5   (placement_id_val		number
6   ,assignment_id_val		number
7   ,assignment_number_val	per_all_assignments_f.assignment_number%TYPE
8   ,pay_scale_val		varchar2(30)
9   ,grade_name_val		per_grades.name%TYPE
10   ,old_spinal_point_val		varchar2(30)
11   ,new_spinal_point_val		varchar2(30)
12   ,old_value_val		number
13   ,new_value_val		number
14   ,difference_val		number
15   ,full_name_val		varchar2(60)
16   ,org_name_val                 varchar2(60));
17 
18 TYPE SPP_WI_Table is TABLE of SPP_WI_TableType
19 Index by binary_integer;
20 --
21 SPP_WI_DATA SPP_WI_Table;
22 --
23 function get_placement_id_val (p_placement_id NUMBER) return NUMBER;
24 function get_assignment_number_val (p_placement_id NUMBER) return VARCHAR2;
25 function get_pay_scale_val (p_placement_id NUMBER) return VARCHAR2;
26 function get_grade_name_val (p_placement_id NUMBER) return VARCHAR2;
27 function get_old_spinal_point_val (p_placement_id NUMBER) return VARCHAR2;
28 function get_new_spinal_point_val (p_placement_id NUMBER) return VARCHAR2;
29 function get_old_value_val (p_placement_id NUMBER) return NUMBER;
30 function get_new_value_val (p_placement_id NUMBER) return NUMBER;
31 function get_difference_val (p_placement_id NUMBER) return NUMBER;
32 function get_full_name_val (p_placement_id NUMBER) return VARCHAR2;
33 function get_assignment_id_val (p_placement_id NUMBER) return NUMBER;
34 function get_org_name_val (p_placement_id NUMBER) return VARCHAR2;
35 
36 procedure populate_spp_wi_table
37   (p_placement_id		number
38   ,p_assignment_id		number
39   ,p_effective_date		date
40   ,p_parent_spine_id		number
41   ,p_step_id			number
42   ,p_spinal_point_id		number
43   ,p_rate_id			number
44   );
45 
46 END HR_SPP_WI_DATA;