1 PACKAGE per_pay_proposals_populate AS
2 /* $Header: pepaprpo.pkh 120.0.12000000.1 2007/01/22 00:42:58 appldev ship $*/
3
4
5 PROCEDURE GET_GRADE(p_date DATE,
6 p_assignment_id NUMBER,
7 p_business_group_id NUMBER,
8 p_grade OUT NOCOPY VARCHAR2,
9 p_minimum_salary OUT NOCOPY NUMBER,
10 p_maximum_salary OUT NOCOPY NUMBER,
11 p_midpoint_salary OUT NOCOPY NUMBER,
12 p_grade_uom OUT NOCOPY VARCHAR2);
13
14 PROCEDURE GET_ELEMENT_ID(p_assignment_id IN NUMBER,
15 p_business_group_id IN NUMBER,
16 p_change_date IN DATE,
17 p_payroll_value OUT NOCOPY NUMBER,
18 p_element_entry_id OUT NOCOPY NUMBER);
19
20 PROCEDURE GET_CURRENCY_FORMAT(curcode VARCHAR2,
21 fstring IN OUT NOCOPY VARCHAR2);
22
23 PROCEDURE GET_NUMBER_FORMAT(fstring IN OUT NOCOPY VARCHAR2);
24
25 PROCEDURE GET_DEFAULTS(p_assignment_id IN NUMBER
26 ,p_date IN OUT NOCOPY DATE
27 ,p_business_group_id OUT NOCOPY NUMBER
28 ,p_currency OUT NOCOPY VARCHAR2
29 ,p_format_string OUT NOCOPY VARCHAR2
30 ,p_salary_basis_name OUT NOCOPY VARCHAR2
31 ,p_pay_basis_name OUT NOCOPY VARCHAR2
32 ,p_pay_basis OUT NOCOPY VARCHAR2
33 ,p_pay_annualization_factor OUT NOCOPY NUMBER
34 ,p_grade OUT NOCOPY VARCHAR2
35 ,p_grade_annualization_factor OUT NOCOPY NUMBER
36 ,p_minimum_salary OUT NOCOPY NUMBER
37 ,p_maximum_salary OUT NOCOPY NUMBER
38 ,p_midpoint_salary OUT NOCOPY NUMBER
39 ,p_prev_salary OUT NOCOPY NUMBER
40 ,p_last_change_date OUT NOCOPY DATE
41 ,p_element_entry_id OUT NOCOPY NUMBER
42 ,p_basis_changed OUT NOCOPY BOOLEAN
43 ,p_uom OUT NOCOPY VARCHAR2
44 ,p_grade_uom OUT NOCOPY VARCHAR2);
45
46 PROCEDURE GET_BASIS_DETAILS(p_effective_date DATE
47 ,p_assignment_id NUMBER
48 ,p_currency OUT NOCOPY VARCHAR2
49 ,p_salary_basis_name OUT NOCOPY VARCHAR2
50 ,p_pay_basis_name OUT NOCOPY VARCHAR2
51 ,p_pay_basis OUT NOCOPY VARCHAR2
52 ,p_pay_annualization_factor OUT NOCOPY NUMBER
53 ,p_grade_basis OUT NOCOPY VARCHAR2
54 ,p_grade_annualization_factor OUT NOCOPY NUMBER
55 ,p_element_type_id OUT NOCOPY NUMBER
56 ,p_uom OUT NOCOPY VARCHAR2);
57
58 PROCEDURE GET_PREV_SALARY(p_date IN OUT NOCOPY DATE
59 ,p_assignment_id IN NUMBER
60 ,p_prev_salary OUT NOCOPY NUMBER
61 ,p_last_change_date OUT NOCOPY DATE
62 ,p_basis_changed OUT NOCOPY BOOLEAN);
63
64 PROCEDURE GET_PAYROLL(p_assignment_id NUMBER
65 ,p_date DATE
66 ,p_payroll OUT NOCOPY VARCHAR2
67 ,p_payrolls_per_year OUT NOCOPY NUMBER);
68
69 procedure get_hours(p_assignment_id NUMBER
70 ,p_date DATE
71 ,p_hours_per_year OUT NOCOPY NUMBER);
72 procedure get_asg_hours(p_assignment_id NUMBER
73 ,p_date DATE
74 ,p_hours_per_year OUT NOCOPY NUMBER);
75 procedure get_norm_hours(p_assignment_id NUMBER
76 ,p_date DATE
77 ,p_hours_per_year OUT NOCOPY NUMBER);
78
79 END per_pay_proposals_populate;