1 PACKAGE per_ca_ee_extract_pkg AUTHID CURRENT_USER AS
2 /* $Header: pecaeerp.pkh 120.0.12020000.1 2012/06/29 00:49:52 appldev ship $ */
3 --
4 k number := 1;
5 --
6 -- if check_gre_without_naic returns -1 then error
7 -- out the report mentioning the GRE name which doesn't
8 -- have a NAIC mentioned, else in the report we call
9 -- the other functions
10 --
11 TYPE tab_varchar2 IS TABLE OF VARCHAR2(100)
12 INDEX BY BINARY_INTEGER;
13
14 TYPE person_tab IS TABLE OF per_assignments_f.person_id%type
15 INDEX BY BINARY_INTEGER;
16 TYPE softcoding_tab IS TABLE OF per_assignments_f.soft_coding_keyflex_id%type
17 INDEX BY BINARY_INTEGER;
18
19 TYPE org_info8_tab IS TABLE OF hr_organization_information.org_information8%type
20 INDEX BY BINARY_INTEGER;
21 TYPE organization_id_tab IS TABLE OF hr_organization_information.organization_id%type
22 INDEX BY BINARY_INTEGER;
23
24 TYPE segment1_tab IS TABLE OF hr_soft_coding_keyflex.segment1%type
25 INDEX BY BINARY_INTEGER;
26 TYPE segment6_tab IS TABLE OF hr_soft_coding_keyflex.segment6%type
27 INDEX BY BINARY_INTEGER;
28
29 TYPE naic_tab IS TABLE OF VARCHAR2(60) INDEX BY BINARY_INTEGER;
30 TYPE naic_count_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
31
32 TYPE job_id_tab IS TABLE OF per_jobs.job_id%type
33 INDEX BY BINARY_INTEGER;
34 TYPE job_tab IS TABLE OF hr_lookups.meaning%type
35 INDEX BY BINARY_INTEGER;
36
37 TYPE person_type_tab IS TABLE OF per_person_types.person_type_id%type
38 INDEX BY BINARY_INTEGER;
39
40 function employee_promotions (p_assignment_id in number,
41 p_person_id in number,
42 p_business_group_id in number,
43 p_start_date in date,
44 p_end_date in date,
45 p_boolean in varchar2)
46 return number;
47
48 function job_exists (p_job_id in number)
49 return varchar2;
50 --
51 function person_type_exists (p_person_type in number)
52 return varchar2;
53
54 function check_gre_without_naic(p_business_group_id in number,
55 p_gre_name OUT NOCOPY tab_varchar2)
56 return number;
57 --
58 function form1(p_business_group_id in number,
59 p_request_id in number,
60 p_year in varchar2,
61 p_naic_code in varchar2,
62 p_date_all_emp in date,
63 p_date_tmp_emp in date) return number;
64 --
65 function form2n(p_business_group_id in number,
66 p_request_id in number,
67 p_year in varchar2,
68 p_date_tmp_emp in date) return number;
69 --
70 function form2(p_business_group_id in number,
71 p_request_id in number,
72 p_year in varchar2,
73 p_date_tmp_emp in date) return number;
74 --
75 function form3(p_business_group_id in number,
76 p_request_id in number,
77 p_year in varchar2,
78 p_date_tmp_emp in date) return number;
79 --
80 function form4(p_business_group_id in number,
81 p_request_id in number,
82 p_year in varchar2,
83 p_date_tmp_emp in date) return number;
84 --
85 function form5(p_business_group_id in number,
86 p_request_id in number,
87 p_year in varchar2,
88 p_date_tmp_emp in date) return number;
89 --
90 function form6(p_business_group_id in number,
91 p_request_id in number,
92 p_year in varchar2,
93 p_date_tmp_emp in date) return number;
94 --
95 function update_rec(p_request_id number) return number;
96 --
97
98 end per_ca_ee_extract_pkg;