1 PACKAGE IGW_OVERHEAD_CAL AUTHID CURRENT_USER as
2 -- $Header: igwbuovs.pls 115.12 2002/11/14 18:48:13 vmedikon ship $
3 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGW_OVERHEAD_CAL';
4
5
6 PROCEDURE get_date_details( p_input_date DATE
7 ,x_fiscal_year OUT NOCOPY NUMBER
8 ,x_fiscal_start_date OUT NOCOPY DATE
9 ,x_fiscal_end_date OUT NOCOPY DATE
10 ,x_return_status OUT NOCOPY VARCHAR2
11 ,x_msg_data OUT NOCOPY VARCHAR2);
12
13
14 PROCEDURE get_rate_id (p_expenditure_type VARCHAR2
15 ,p_expenditure_category_flag VARCHAR2
16 ,p_rate_class_type VARCHAR2
17 ,x_rate_class_id IN OUT NOCOPY NUMBER
18 ,x_rate_type_id OUT NOCOPY NUMBER
19 ,x_return_status OUT NOCOPY VARCHAR2
20 ,x_msg_data OUT NOCOPY VARCHAR2);
21
22
23 PROCEDURE get_rate ( p_proposal_id NUMBER
24 ,p_version_id NUMBER
25 ,p_fiscal_year NUMBER
26 ,p_activity_type_code VARCHAR2
27 ,p_location_code VARCHAR2
28 ,p_rate_class_id NUMBER
29 ,p_rate_type_id NUMBER
30 ,x_rate OUT NOCOPY NUMBER
31 ,x_rate_ov OUT NOCOPY NUMBER
32 ,x_start_date OUT NOCOPY DATE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_data OUT NOCOPY VARCHAR2);
35
36 FUNCTION get_applicable_rate (
37 p_proposal_id number
38 ,p_version_id number
39 ,p_rate_class_id number
40 ,p_rate_type_id number
41 ,p_activity_type_code varchar2
42 ,p_location_code varchar2
43 ,p_fiscal_year number) RETURN NUMBER;
44
45
46 PROCEDURE calc_oh ( p_proposal_id NUMBER
47 ,p_version_id NUMBER
48 ,p_base_amount NUMBER
49 ,p_budget_start_date DATE
50 ,p_budget_end_date DATE
51 ,x_oh_value OUT NOCOPY NUMBER
52 ,x_oh_value_ov OUT NOCOPY NUMBER
53 ,p_activity_type_code VARCHAR2
54 ,p_location_code VARCHAR2
55 ,p_rate_class_id NUMBER
56 ,p_rate_type_id NUMBER
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 ,x_msg_count OUT NOCOPY NUMBER);
60
61
62 PROCEDURE calc_oh_eb( p_proposal_id NUMBER
63 ,p_version_id NUMBER
64 ,p_base_amount NUMBER
65 ,p_budget_start_date DATE
66 ,p_budget_end_date DATE
67 ,x_oh_value OUT NOCOPY NUMBER
68 ,x_oh_value_ov OUT NOCOPY NUMBER
69 ,x_eb_value OUT NOCOPY NUMBER
70 ,x_eb_value_ov OUT NOCOPY NUMBER
71 ,p_activity_type_code VARCHAR2
72 ,p_location_code VARCHAR2
73 ,p_rate_class_id_oh NUMBER
74 ,p_rate_type_id_oh NUMBER
75 ,p_rate_class_id_eb NUMBER
76 ,p_rate_type_id_eb NUMBER
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_data OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER);
80
81 PROCEDURE calc_inflation(p_proposal_id NUMBER
82 ,p_version_id NUMBER
83 ,p_base_amount NUMBER
84 ,p_budget_start_date DATE
85 ,p_budget_end_date DATE
86 ,x_inflated_amt OUT NOCOPY NUMBER
87 ,p_activity_type_code VARCHAR2
88 ,p_location_code VARCHAR2
89 ,p_rate_class_id_inf NUMBER
90 ,p_rate_type_id_inf NUMBER
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER);
94
95 PROCEDURE calc_sal_between_months(p_end_date DATE
96 ,p_start_date DATE
97 ,p_base_amount NUMBER
98 ,x_final_sal OUT NOCOPY NUMBER
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_data OUT NOCOPY VARCHAR2);
101
102
103 PROCEDURE calc_salary(p_proposal_id NUMBER
104 ,p_version_id NUMBER
105 ,p_base_amount NUMBER
106 ,p_effective_date DATE
107 ,p_appointment_type VARCHAR2
108 ,p_line_start_date DATE
109 ,p_line_end_date DATE
110 ,x_inflated_salary OUT NOCOPY NUMBER
111 ,x_inflated_salary_ov OUT NOCOPY NUMBER
112 ,p_expenditure_type VARCHAR2
113 ,p_expenditure_category_flag VARCHAR2
114 ,p_activity_type_code VARCHAR2
115 ,p_location_code VARCHAR2
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER);
119
120
121 END IGW_OVERHEAD_CAL;