1 package hr_summary_api AUTHID CURRENT_USER as
2 /* $Header: hrsumapi.pkh 115.4 2002/11/26 10:37:14 sfmorris noship $ */
3 procedure lck (p_id_value in number
4 ,p_object_version_number in number );
5
6 procedure row_data (p_business_group_id in number,
7 p_type in varchar2,
8 p_text_value1 in varchar2 default null,
9 p_text_value2 in varchar2 default null,
10 p_fk_value1 in number default null,
11 p_fk_value2 in number default null,
12 l_id_value out nocopy number,
13 l_ovn out nocopy number);
14
15 function get_id (p_name in varchar2
16 ,p_type in varchar2
17 ,p_business_group_id in number) return number;
18 pragma restrict_references (get_id, WNPS, WNDS);
19
20 function get_itu_id (p_template_name in varchar2
21 ,p_item_type_name in varchar2
22 ,p_itu_name in varchar2
23 ,p_business_group_id in number) return number;
24 pragma restrict_references (get_itu_id, WNPS, WNDS);
25
26 function get_itu_id (p_template_name in varchar2
27 ,p_sequence_number in number
28 ,p_business_group_id in number) return number;
29 pragma restrict_references (get_itu_id, WNPS, WNDS);
30
31 function get_vkt_id (p_key_type_name in varchar2
32 ,p_item_type_name in varchar2
33 ,p_business_group_id in number) return number;
34 pragma restrict_references (get_vkt_id, WNPS, WNDS);
35
36 function get_ru_id (p_restriction_name in varchar2
37 ,p_item_type_name in varchar2
38 ,p_business_group_id in number) return number;
39 pragma restrict_references (get_ru_id, WNPS, WNDS);
40
41 function get_rv_id (p_template in varchar2
42 ,p_item in varchar2
43 ,p_restriction in varchar2
44 ,p_itu_name in varchar2
45 ,p_business_group_id in number) return number;
46 pragma restrict_references (get_rv_id, WNPS, WNDS);
47
48 function get_rv_id (p_template in varchar2
49 ,p_item in varchar2
50 ,p_restriction in varchar2
51 ,p_itu_seq_num in number
52 ,p_business_group_id in number) return number;
53 pragma restrict_references (get_rv_id, WNPS, WNDS);
54
55 procedure create_item_type (p_item_type_id out nocopy number
56 ,p_business_group_id in number
57 ,p_object_version_number out nocopy number
58 ,p_name in varchar2
59 ,p_units in varchar2
60 ,p_datatype in varchar2
61 ,p_count_clause1 in varchar2
62 ,p_count_clause2 in varchar2
63 ,p_where_clause in varchar2
64 ,p_seeded_data in varchar2);
65
66 procedure create_key_type (p_key_type_id out nocopy number
67 ,p_business_group_id in number
68 ,p_object_version_number out nocopy number
69 ,p_name in varchar2
70 ,p_key_function in varchar2
71 ,p_seeded_data in varchar2);
72
73 procedure create_key_value (p_key_value_id out nocopy number
74 ,p_business_group_id in number
75 ,p_object_version_number out nocopy number
76 ,p_key_type_id in number
77 ,p_item_value_id in number
78 ,p_name in varchar2 );
79
80 procedure create_item_value (p_item_value_id out nocopy number
81 ,p_business_group_id in number
82 ,p_object_version_number out nocopy number
83 ,p_process_run_id in number
84 ,p_item_type_usage_id in number
85 ,p_textvalue in varchar2
86 ,p_numvalue1 in number
87 ,p_numvalue2 in number
88 ,p_datevalue in date );
89
90 procedure create_valid_restriction (p_valid_restriction_id out nocopy number
91 ,p_business_group_id in number
92 ,p_object_version_number out nocopy number
93 ,p_item_type_id in number
94 ,p_restriction_type_id in number
95 ,p_seeded_data in varchar2);
96
97 procedure create_restriction_type (p_restriction_type_id out nocopy number
98 ,p_business_group_id in number
99 ,p_object_version_number out nocopy number
100 ,p_name in varchar2
101 ,p_data_type in varchar2
102 ,p_restriction_clause in varchar2
103 ,p_restriction_sql in varchar2
104 ,p_seeded_data in varchar2);
105
106 procedure create_restriction_usage (p_restriction_usage_id out nocopy number
107 ,p_business_group_id in number
108 ,p_object_version_number out nocopy number
109 ,p_item_type_usage_id in number
110 ,p_valid_restriction_id in number
111 ,p_restriction_type in varchar2
112 ,p_seeded_data in varchar2);
113
114 procedure create_restriction_value ( p_restriction_value_id out nocopy number
115 ,p_business_group_id in number
116 ,p_object_version_number out nocopy number
117 ,p_restriction_usage_id in number
118 ,p_value in varchar2
119 ,p_seeded_data in varchar2);
120
121 procedure create_item_type_usage ( p_item_type_usage_id out nocopy number
122 ,p_business_group_id in number
123 ,p_object_version_number out nocopy number
124 ,p_sequence_number in number
125 ,p_name in varchar2
126 ,p_template_id in number
127 ,p_item_type_id in number
128 ,p_seeded_data in varchar2);
129
130 procedure create_valid_key_type (p_valid_key_type_id out nocopy number
131 ,p_business_group_id in number
132 ,p_object_version_number out nocopy number
133 ,p_item_type_id in number
134 ,p_key_type_id in number
135 ,p_seeded_data in varchar2);
136
137 procedure create_key_type_usage (p_key_type_usage_id out nocopy number
138 ,p_business_group_id in number
139 ,p_object_version_number out nocopy number
140 ,p_item_type_usage_id in number
141 ,p_valid_key_type_id in number
142 ,p_seeded_data in varchar2);
143
144 procedure create_template (p_template_id out nocopy number
145 ,p_business_group_id in number
146 ,p_object_version_number out nocopy number
147 ,p_name in varchar2
148 ,p_seeded_data in varchar2);
149
150 procedure create_process_run (p_process_run_id out nocopy number
151 ,p_business_group_id in number
152 ,p_object_version_number out nocopy number
153 ,p_name in varchar2
154 ,p_template_id in varchar2
155 ,p_process_type in varchar2);
156
157 procedure create_parameter (p_parameter_id out nocopy number
158 ,p_business_group_id in number
159 ,p_object_version_number out nocopy number
160 ,p_process_run_id in number
161 ,p_name in varchar2
162 ,p_value in varchar2);
163
164 /*@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@*/
165
166 procedure delete_hr_summary (p_validate in boolean default false
167 ,p_id_value in number
168 ,p_object_version_number in number);
169
170
171 end hr_summary_api;