[Home] [Help]
PACKAGE: APPS.GHR_MTO_INT
Source
1 PACKAGE ghr_mto_int AUTHID CURRENT_USER AS
2 /* $Header: ghmtoint.pkh 115.7 2003/08/04 07:33:18 ajose ship $ */
3
4 g_package constant varchar2(33) := ' ghr_mto_int.';
5 g_log_enabled boolean := TRUE;
6
7 -- when true some debugging goes through dbms_output, when false all
8 -- goes through hr_utility.set_location
9 g_dbms_output boolean := FALSE;
10
11 procedure get_transfer_parameters(
12 p_mass_transfer_id in number,
13 p_transfer_name out nocopy varchar2,
14 p_effective_date out nocopy date,
15 p_inter_bg_transfer out nocopy varchar2
16 );
17
18 procedure set_log_program_name(
19 p_log_program_name in varchar2
20 );
21
22 procedure log_message(
23 p_procedure in varchar2,
24 p_message in varchar2
25 );
26
27 procedure mass_transfer_out(
28 p_errbuf out nocopy varchar2,
29 p_retcode out nocopy number,
30 p_transfer_id in number,
31 p_person_id in per_all_people_f.person_id%type
32 );
33
34 procedure insert_people_f(
35 p_transfer_name varchar2,
36 p_inter_bg_transfer varchar2,
37 p_effective_date date,
38 ppf per_all_people_f%rowtype
39 );
40
41 procedure insert_people_ei(
42 p_transfer_name varchar2,
43 p_effective_date date,
44 pp_ei per_people_extra_info%rowtype
45 );
46
47 procedure insert_special_info(
48 p_transfer_name varchar2,
49 p_effective_date date,
50 p_person_id number,
51 p_flex_name varchar2,
52 p_si ghr_api.special_information_type
53 );
54
55 /*
56 * The parameters, p_contact_name, and p_contact_type should contain values
57 * when the address inserted is that of the contact, and be null otherwise
58 */
59 procedure insert_address(
60 p_transfer_name in varchar2,
61 p_effective_date in date,
62 p_a in per_addresses%rowtype,
63 p_contact_name in varchar2 default null,
64 p_contact_type in varchar2 default null
65 );
66
67 procedure insert_assignment_f(
68 p_transfer_name varchar2,
69 p_effective_date date,
70 p_a per_all_assignments_f%rowtype
71 );
72
73 procedure insert_assignment_ei(
74 p_transfer_name varchar2,
75 p_person_id number,
76 p_effective_date date,
77 p_a_ei per_assignment_extra_info%rowtype
78 );
79
80 procedure insert_position(
81 p_transfer_name varchar2,
82 p_person_id number,
83 p_effective_date date,
84 p_pos hr_all_positions_f%rowtype
85 );
86
87 procedure insert_position_ei(
88 p_transfer_name varchar2,
89 p_person_id number,
90 p_effective_date date,
91 p_pos_ei per_position_extra_info%rowtype
92 );
93
94 procedure insert_position_defs(
95 p_transfer_name varchar2,
96 p_effective_date date,
97 p_person_id number,
98 p_flex_name varchar2,
99 p_pos_defs per_position_definitions%rowtype
100 );
101
102 procedure insert_element_entries(
103 p_transfer_name varchar2,
104 p_person_id number,
105 p_effective_date date,
106 p_element in out nocopy ghr_mt_element_entries_v%rowtype
107 );
108
109 procedure insert_misc(
110 p_transfer_name varchar2,
111 p_person_id number,
112 p_effective_date date,
113 p_misc ghr_mt_misc_v%rowtype
114 );
115
116 procedure update_people_f(
117 p_transfer_name varchar2,
118 p_inter_bg_transfer varchar2,
119 p_effective_date date,
120 ppf per_all_people_f%rowtype
121 );
122
123 procedure update_people_ei(
124 p_transfer_name varchar2,
125 p_effective_date date,
126 pp_ei per_people_extra_info%rowtype
127 );
128
129 procedure update_special_info(
130 p_transfer_name varchar2,
131 p_effective_date date,
132 p_person_id number,
133 p_flex_name varchar2,
134 p_si ghr_api.special_information_type
135 );
136
137 procedure update_address(
138 p_transfer_name in varchar2,
139 p_effective_date in date,
140 p_a in per_addresses%rowtype,
141 p_contact_name in varchar2 default null,
142 p_contact_type in varchar2 default null
143 );
144
145 procedure update_assignment_f(
146 p_transfer_name varchar2,
147 p_effective_date date,
148 p_a per_all_assignments_f%rowtype
149 );
150
151 procedure update_assignment_ei(
152 p_transfer_name varchar2,
153 p_person_id number,
154 p_effective_date date,
155 p_a_ei per_assignment_extra_info%rowtype
156 );
157
158 procedure update_position(
159 p_transfer_name varchar2,
160 p_person_id number,
161 p_effective_date date,
162 p_pos hr_all_positions_f%rowtype
163 );
164
165 procedure update_position_ei(
166 p_transfer_name varchar2,
167 p_person_id number,
168 p_effective_date date,
169 p_pos_ei per_position_extra_info%rowtype
170 );
171
172 procedure update_position_defs(
173 p_transfer_name varchar2,
174 p_effective_date date,
175 p_person_id number,
176 p_flex_name varchar2,
177 p_pos_defs per_position_definitions%rowtype
178 );
179
180 procedure update_element_entries(
181 p_transfer_name varchar2,
182 p_person_id number,
183 p_effective_date date,
184 p_element in out nocopy ghr_mt_element_entries_v%rowtype
185 );
186
187 procedure update_misc(
188 p_transfer_name varchar2,
189 p_person_id number,
190 p_effective_date date,
191 p_misc ghr_mt_misc_v%rowtype
192 );
193
194 procedure put(
195 p_message varchar2
196 );
197
198 procedure put_line(
199 p_message varchar2 default null
200 );
201
202 end ghr_mto_int;