eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_CI_DIR_COST_PUB dependencies on PA_NUM_TBL_TYPE

Line 18: p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_bvid IN NUMBER,
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,

Line 21: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

17: p_bvid IN NUMBER,
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,

Line 23: p_rlmi_id_tbl IN 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(),
27: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

Line 26: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT 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(),
30: p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(),

Line 27: p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_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(),
30: p_raw_cost_rate_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(),

Line 28: p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT 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(),
30: p_raw_cost_rate_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(),

Line 29: p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_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(),
30: p_raw_cost_rate_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(),

Line 30: p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_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(),
30: p_raw_cost_rate_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(),

Line 31: p_burden_cost_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(),
30: p_raw_cost_rate_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(),

Line 32: p_resource_assignment_id_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(),
30: p_raw_cost_rate_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

Line 44: l_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

40: l_return_status VARCHAR2(1) := PA_API.G_RET_STS_SUCCESS;
41: l_msg_count number;
42: l_msg_data varchar2(2000);
43:
44: l_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
45:
46: l_PaCiDirCostDetTbl PaCiDirCostTblType;
47: x_PaCiDirCostDetTbl PaCiDirCostTblType;
48:

Line 260: p_dc_line_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_bvid IN NUMBER,
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,

Line 263: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

259: p_bvid IN NUMBER,
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,

Line 265: p_rlmi_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,
269: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 268: p_quantity_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,
272: p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 269: p_planning_resource_rate_tbl IN SYSTEM.PA_NUM_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,
272: p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,
273: p_burden_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

Line 270: p_raw_cost_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,
272: p_raw_cost_rate_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,

Line 271: p_burdened_cost_tbl IN SYSTEM.PA_NUM_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,
272: p_raw_cost_rate_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,

Line 272: p_raw_cost_rate_tbl IN SYSTEM.PA_NUM_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,
272: p_raw_cost_rate_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,

Line 273: p_burden_cost_rate_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,
272: p_raw_cost_rate_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,

Line 274: p_resource_assignment_id_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,
272: p_raw_cost_rate_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

Line 304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

300:
301: TYPE varchar1_tbl is table of varchar2(1) index by binary_integer;
302: budget_impact_tbl varchar1_tbl;
303:
304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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();

Line 305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

301: TYPE varchar1_tbl is table of varchar2(1) index by binary_integer;
302: budget_impact_tbl varchar1_tbl;
303:
304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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();

Line 306: b_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

302: budget_impact_tbl varchar1_tbl;
303:
304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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();

Line 307: b_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

303:
304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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:

Line 308: b_res_assgn_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

304: b_task_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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

Line 309: b_rlmi_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

305: b_dc_line_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_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:

Line 555: p_dc_line_id_TBL IN SYSTEM.PA_NUM_TBL_TYPE,

551: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
552: x_return_status OUT NOCOPY VARCHAR2,
553: x_msg_count OUT NOCOPY NUMBER,
554: x_msg_data OUT NOCOPY VARCHAR2,
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,

Line 558: p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE,

554: x_msg_data OUT NOCOPY VARCHAR2,
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:

Line 560: p_rlmi_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;
564: l_api_name CONSTANT VARCHAR2(30) := 'Pub.delete_row';

Line 570: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

566: l_msg_count number;
567: l_msg_data varchar2(2000);
568: l_PaCiDirCostDetTbl PaCiDirCostTblType;
569:
570: l_resource_assignment_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
571:
572: l_bvid NUMBER;
573:
574: cursor get_bvid(c_ci_id number) is