4: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: PROCEDURE get_computed_bill_rate (
7: p_array_size IN NUMBER,
8: p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
5:
6: PROCEDURE get_computed_bill_rate (
7: p_array_size IN NUMBER,
8: p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
6: PROCEDURE get_computed_bill_rate (
7: p_array_size IN NUMBER,
8: p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
7: p_array_size IN NUMBER,
8: p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
8: p_bill_rate_sch_id IN pa_plsql_datatypes.IdTabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
9: p_expenditure_item_id IN pa_plsql_datatypes.IdTabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
10: p_exp_sys_linkage IN pa_plsql_datatypes.Char30TabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
11: p_expenditure_type IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
12: p_expenditure_item_date IN pa_plsql_datatypes.DateTabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
13: p_fixed_date IN pa_plsql_datatypes.DateTabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
14: p_quantity IN pa_plsql_datatypes.NumTabTyp,
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
15: p_incurred_by_person_id IN pa_plsql_datatypes.IdTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
16: p_non_labor_resource IN pa_plsql_datatypes.Char20TabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
17: p_base_curr IN pa_plsql_datatypes.Char15TabTyp,
18: p_base_amt IN pa_plsql_datatypes.NumTabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
19: p_exp_uom IN pa_plsql_datatypes.Char30TabTyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
26: x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
27: x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabtyp,
20: p_compute_flag IN OUT NOCOPY pa_plsql_datatypes.Char1TabTyp,
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
26: x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
27: x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabtyp,
28: x_error_stage OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
21: x_error_code IN OUT NOCOPY pa_plsql_datatypes.Char30TabTyp,
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
26: x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
27: x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabtyp,
28: x_error_stage OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
29: )
22: x_reject_cnt OUT NOCOPY number, --File.Sql.39 bug 4440895
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
26: x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
27: x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabtyp,
28: x_error_stage OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
29: )
30: IS
23: x_computed_rate OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
24: x_computed_markup OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
25: x_computed_currency OUT NOCOPY pa_plsql_datatypes.Char15TabTyp,
26: x_computed_amount OUT NOCOPY pa_plsql_datatypes.NumTabTyp,
27: x_tp_job_id OUT NOCOPY pa_plsql_datatypes.IdTabtyp,
28: x_error_stage OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
29: )
30: IS
31: /*-----------------------------------------------------------------------------