1 package hrspine AUTHID CURRENT_USER as
2 /* $Header: pespines.pkh 120.0.12010000.1 2008/07/28 05:59:19 appldev ship $ */
3 --
4 --
5 -- Copyright (c) Oracle Corporation 1991, 1992, 1993. All rights reserved.
6 --
7 /*
8 NAME
9 pyspines.pkh
10 --
11 DESCRIPTION
12 Package header for the procedure used in the spinal incrementing
13 process.
14 --
15 MODIFIED (DD-MON-YYYY)
16 mwcallag 17-JUN-1993 - created.
17 stlocke 12-DEC-2001 - Added additional params for new business rule
18 functionality.
19
20 rem Change List
21 rem ===========
22 rem
23 rem Version Date Author Comment
24 rem -------+-----------+--------------+----------------------------------------
25 rem 115.8 25-APR-2002 stlocke Added functions used by employee increment
26 rem results report.
27 rem 115.10 09-DEC-2002 eumenyio Added whenever oserror
28 */
29
30 function func_old_spinal_point (p_placement_id in number
31 ,p_effective_start_date in date
32 ,p_step_id in number
33 ,p_grade_rate in number) return VARCHAR2;
34 function func_old_spinal_value (p_placement_id in number
35 ,p_effective_start_date in date
36 ,p_step_id in number
37 ,p_grade_rate in number) return NUMBER;
38 function func_increment (p_placement_id in number
39 ,p_effective_start_date in date
40 ,p_step_id in number
41 ,p_grade_spine_id in number) return NUMBER;
42
43 procedure spine
44 (
45 P_Parent_Spine_ID in number default null,
46 P_Effective_Date in date,
47 p_id_flex_num in number default null,
48 p_concat_segs in varchar2 default null,
49 P_Business_Group_ID in number,
50 p_collective_agreement_id in number default null,
51 p_person_id in number default null,
52 p_payroll_id in number default null,
53 p_organization_id in number default null,
54 p_legal_entity in number default null,
55 p_org_structure_ver_id in number default null,
56 -- p_ass_sets in number default null,
57 p_qual_type in number default null,
58 p_qual_status in varchar2 default null,
59 p_org_structure_top_node in number default null,
60 p_rate_id in number default null,
61 p_business_rule in varchar2 default null,
62 p_dependant_date in varchar2 default null,
63 p_br_date_from in date default null,
64 p_br_date_to in date default null,
65 p_year_from in number default null,
66 p_year_to in number default null,
67 p_message_number out nocopy varchar2
68 );
69
70 end hrspine;