PACKAGE: APPS.GHR_SF52_POS_UPDATE

Source

1 PACKAGE GHR_SF52_POS_UPDATE AUTHID CURRENT_USER AS
2 /* $Header: ghpauppo.pkh 115.7 2004/01/28 21:37:45 ajose ship $ */
3 
4 -- create the record types here
5 type position_data_rec_type is record
6 (position_id               per_positions.position_id%TYPE,
7  organization_id           per_organization_units.organization_id%TYPE,
8  job_id           	   per_positions.job_id%TYPE,
9  agency_code_subelement    per_position_definitions.segment1%TYPE,
10  location_id               hr_locations.location_id%TYPE,
11  effective_end_date	   date,
12  effective_date            date,
13  datetrack_mode          varchar2(30)
14 );
15 
16 type org_info_rec_type is record
17         (information1   hr_organization_information.org_information1%type
18         ,information2   hr_organization_information.org_information2%type
19         ,information3   hr_organization_information.org_information3%type
20         ,information4   hr_organization_information.org_information4%type
21         ,information5   hr_organization_information.org_information5%type
22         );
23 
24  TYPE segment_tab_type IS TABLE of VARCHAR2(60) INDEX by BINARY_INTEGER;
25 
26 
27 procedure update_position_info
28 (p_pos_data_rec    IN position_data_rec_type
29 ) ;
30 
31 Function pos_return_update_mode
32   (p_position_id     IN     hr_all_positions_f.position_id%type,
33    p_effective_date  IN     date )
34  RETURN varchar2;
35 
36 -- JH Added to update Position's Location during Update to HR.
37 PROCEDURE update_positions_location
38  (p_position_id        IN       hr_all_positions_f.position_id%TYPE,
39   p_location_id        IN       hr_all_positions_f.location_id%TYPE,
40   p_effective_date     IN       date);
41 
42 end ghr_sf52_pos_update;
43