DBA Data[Home] [Help]

APPS.PA_CI_DIR_COST_PUB dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 22: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

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(),

Line 24: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_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(),

Line 25: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_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(),

Line 35: p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_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';

Line 264: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

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,

Line 266: p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_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,

Line 267: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_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,

Line 277: p_change_reason_code IN SYSTEM.PA_VARCHAR2_30_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';

Line 310: b_currency_code_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

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;

Line 559: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE,

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;

Line 561: p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE) IS

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;