PACKAGE: APPS.HR_SPP_EXCEPTION_DATA

Source

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