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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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,
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,
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,
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,
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
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: );
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:
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: