1 PACKAGE pa_bill_schedule AUTHID CURRENT_USER AS
2 /*$Header: PAXBILAS.pls 120.1 2005/08/19 17:09:12 mwasowic noship $ */
3
4 -- Table type definitions to hold host array that will be passed from Pro *c
5 --
6
7 PROCEDURE get_computed_bill_rate (
8 p_array_size IN NUMBER,
9 p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
10 p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
11 p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
12 p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
13 p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
14 p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
15 p_quantity IN pa_plsql_datatypes.NumTabTyp,
16 p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
17 p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
18 p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
19 p_base_amt IN pa_plsql_datatypes.NumTabTyp,
20 p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
21 p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
22 x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
23 x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
24 x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25 x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
26 x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
27 x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
28 x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabTyp,
29 x_error_stage OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
30 );
31
32
33 END pa_bill_schedule;