18: p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
19: p_ci_id IN NUMBER,
20: p_project_id IN NUMBER,
21: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
22: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
23: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
24: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
25: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
26: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
20: p_project_id IN NUMBER,
21: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
22: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
23: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
24: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
25: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
26: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
27: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
28: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
21: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
22: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
23: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
24: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
25: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
26: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
27: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
28: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
29: p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
31: p_burden_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
32: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),
33: p_effective_from_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(),
34: p_effective_to_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE(),
35: p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(),
36: p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_2000_TBL_TYPE()) IS
37:
38: l_api_version number := 1;
39: l_api_name CONSTANT VARCHAR2(30) := 'PUB.insert_row';
260: p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
261: p_ci_id IN NUMBER,
262: p_project_id IN NUMBER,
263: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
264: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
265: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
266: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
267: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
268: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
262: p_project_id IN NUMBER,
263: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
264: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
265: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
266: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
267: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
268: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
269: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
270: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
263: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
264: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
265: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
266: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
267: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
268: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
269: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
270: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
271: p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
273: p_burden_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
274: p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
275: p_effective_from_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
276: p_effective_to_tbl IN SYSTEM.PA_DATE_TBL_TYPE,
277: p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
278: p_change_description IN SYSTEM.PA_VARCHAR2_2000_TBL_TYPE) IS
279:
280: l_api_version number := 1;
281: l_api_name CONSTANT VARCHAR2(30) := 'Pub.update_row';
306: b_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
307: b_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
308: b_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
309: b_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
310: b_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
311:
312: begin
313:
314: budget_impact_tbl.delete;
555: p_dc_line_id_TBL IN SYSTEM.PA_NUM_TBL_TYPE,
556: p_ci_id IN NUMBER,
557: p_project_id IN NUMBER,
558: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
559: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
560: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
561: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE) IS
562:
563: l_api_version number := 1;
557: p_project_id IN NUMBER,
558: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
559: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,
560: p_rlmi_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
561: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE) IS
562:
563: l_api_version number := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'Pub.delete_row';
565: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;