1 package pay_eosurvey_pkg AUTHID CURRENT_USER as
2 /* $Header: pyuseosy.pkh 120.0.12000000.1 2007/01/18 02:24:36 appldev noship $ */
3 /*Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
4 --
5 --
6 Name :This package defines the cursors needed for EO Survey report.
7
8 REM Date Author Version Comment
9 REM -----------+--------+-------+----------------------------------------------+
10 REM 28-Jun-2004 vbanner 115.1 Changed to pass GSCC
11 REM 27-Jul-2004 ynegoro 115.2 Added nocopy to out parameters
12 REM 15-OCT-2004 ynegoro 115.3 Added new parameters to hire_or_fte
13 REM 03-NOV-2004 ynegoro 115.4 Added new parameters to promotion BUG3993335
14 REM
15 */
16
17 procedure find_persons(p_pactid in pay_assignment_actions.payroll_action_id%type,
18 p_thread in number);
19
20 procedure app_fire_count (p_est_entity_id in number,
21 p_hierarchy_version_id in number,
22 p_period_start in date,
23 p_period_end in date,
24 p_seq_num in number);
25
26
27 PROCEDURE p_insert (
28 p_entity_id in number,
29 p_seq_num in number,
30 p_location_id in number,
31 p_location_name in varchar2,
32 fein in varchar2 ,
33 p_assignment_id in number ,
34 p_person_id in number ,
35 p_job_category in varchar2,
36 p_race_code in varchar2 ,
37 p_person_type in varchar2,
38 p_m_app_count in number ,
39 p_f_app_count in number ,
40 p_m_hire_count in number ,
41 p_f_hire_count in number ,
42 p_m_terminate_count in number ,
43 p_f_terminate_count in number ,
44 p_m_promotion_count in number ,
45 p_f_promotion_count in number ,
46 p_m_fte_count in number ,
47 p_f_fte_count in number ,
48 p_monetary_comp in number ,
49 p_tenure_years in number ,
50 p_tenure_months in number ,
51 p_minority_code in varchar2,
52 p_ethnic_group_code in varchar2,
53 p_est_flag in varchar2,
54 p_fte_flag in varchar2);
55
56 procedure hire_or_fte (p_assignment_id in number,
57 p_person_id in number,
58 p_period_start in date,
59 p_period_end in date,
60 p_eff_start_date in date,
61 p_eff_end_date in date,
62 p_per_actual_start_date in date,
63 p_assignment_type in varchar2,
64 p_sex in varchar2,
65 p_job in varchar2,
66 p_race in varchar2,
67 p_person_type in varchar2,
68 p_location_id in number,
69 p_hierarchy_version_id in number,
70 p_min_hours in number,
71 p_defined_balance_id in number,
72 p_max_asact_id in number,
73 p_seq_num in number
74 ,p_effective_start_date in date
75 ,p_effective_end_date in date
76 );
77
78
79
80 procedure gre_name(
81 p_entity_id in number,
82 p_version_id in number,
83 p_fein out nocopy varchar2,
84 p_location_name out nocopy varchar2);
85
86 procedure minority (p_sex in varchar2,
87 p_race_code in varchar2,
88 minority_code out nocopy number,
89 ethnic_group_code out nocopy varchar2);
90
91
92
93 procedure promotion(p_assignment_id in number,
94 p_sex in varchar2,
95 p_period_start in date,
96 p_period_end in date,
97 p_eff_start_date in date,
98 p_eff_end_date in date,
99 m_promotion_count out nocopy number,
100 f_promotion_count out nocopy number);
101
102 procedure male_female_count(p_sex in varchar2,
103 p_male_count out nocopy number,
104 p_female_count out nocopy number);
105
106 procedure job_race_insert(p_entity_id in number,
107 p_seq_num in number);
108
109 end pay_eosurvey_pkg;
110