PACKAGE: APPS.HR_SPP_EXCEPTION_DATA

Source

1 PACKAGE HR_SPP_EXCEPTION_DATA AUTHID CURRENT_USER AS
2 /* $Header: pesppexc.pkh 115.11 2003/07/11 13:26:18 vramanai noship $ */
3 
4 TYPE SPPTableType is record
5   (placement_id_val		number
6   ,full_name_val 		varchar2(60)
7   ,org_name_val                 varchar2(60)
8   ,pay_scale_val		varchar2(30)
9   ,grade_name_val		per_grades.name%TYPE
10   ,start_date_val		date
11   ,end_date_val 		date
12   ,assignment_number_val	per_all_assignments_f.assignment_number%TYPE
13   ,increment_number_val		number
14   ,original_inc_number_val	number
15   ,sequence_number_val		number
16   ,next_sequence_number_val	number
17   ,spinal_point_val		number
18   ,reason_val			varchar2(100));
19 
20 TYPE SPPTable is TABLE of SPPTableType
21 Index by binary_integer;
22 --
23 SPPDATA SPPTable;
24 --
25 function get_placement_id_val (p_placement_id NUMBER) return NUMBER;
26 function get_full_name_val(p_placement_id NUMBER) return VARCHAR2;
27 function get_pay_scale_val(p_placement_id NUMBER) return VARCHAR2;
28 function get_grade_name_val(p_placement_id NUMBER) return VARCHAR2;
29 function get_start_date_val(p_placement_id NUMBER) return DATE;
30 function get_end_date_val(p_placement_id NUMBER) return DATE;
31 function get_assignment_number_val(p_placement_id NUMBER) return varchar2;
32 function get_increment_number_val(p_placement_id NUMBER) return NUMBER;
33 function get_sequence_number_val(p_placement_id NUMBER) return NUMBER;
34 function get_spinal_point_val(p_placement_id NUMBER) return NUMBER;
35 function get_original_inc_number_val(p_placement_id NUMBER) return NUMBER;
36 function get_next_sequence_number_val(p_placement_id NUMBER) return NUMBER;
37 function get_reason_val(p_placement_id NUMBER) return VARCHAR2;
38 function get_org_name_val(p_placement_id NUMBER) return VARCHAR2;
39 
40 procedure populate_spp_table
41   (p_effective_date		date
42   ,p_placement_id		number
43   ,p_effective_start_date	date
44   ,p_effective_end_date		date
45   ,p_assignment_id		number
46   ,p_parent_spine_id		number
47   ,p_increment_number		number
48   ,p_original_increment_number  number
49   ,p_sequence_number		number
50   ,p_next_sequence_number	number
51   ,p_spinal_point_id		number
52   ,p_step_id			number
53   ,p_new_step_id		number
54   ,p_grade_spine_id		number
55   ,p_update			varchar2);
56 
57 END HR_SPP_EXCEPTION_DATA;