APPS.PA_CI_DIR_COST_PUB dependencies on PA_CI_DIRECT_COST_DETAILS

Line 9: -- Inserts data into pa_ci_direct_cost_details table at detail level

5: -- Procedure insert_row():
6: -- Called from the direct cost region of the planning UI
7: -- Calls the process_planning_lines() to rollup the planning lines,
8: -- which calls the insert/update resource assignment API
9: -- Inserts data into pa_ci_direct_cost_details table at detail level
10: --
11: procedure insert_row(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 180: update pa_ci_direct_cost_details pcdc

176: RAISE PA_API.G_EXCEPTION_ERROR;
177: END IF;
178:
179: forall i in l_dc_line_id_tbl.first..l_dc_line_id_tbl.last
180: update pa_ci_direct_cost_details pcdc
181: set (resource_assignment_id, effective_from, effective_to,
182: planning_resource_rate, burden_cost_rate,
183: raw_cost, burdened_cost) =
184: (select prac.resource_assignment_id,

Line 251: -- Updates the data in pa_ci_direct_cost_details table.

247: -- Procedure update_row():
248: -- Called from the direct cost region of the planning UI
249: -- Calls the process_planning_lines() to rollup the planning lines,
250: -- which calls the update resource assignment API.
251: -- Updates the data in pa_ci_direct_cost_details table.
252: --
253: PROCEDURE update_row(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 293: from pa_ci_direct_cost_details

289: select task_id, resource_list_member_id,
290: expenditure_type, nvl(quantity, -1) quantity,
291: nvl(raw_cost, -1) raw_cost,
292: effective_from, effective_to
293: from pa_ci_direct_cost_details
294: where ci_id = p_ci_id
295: and dc_line_id = c_dc_line_id;
296:
297: dc_line_row get_dc_line%ROWTYPE;

Line 472: update pa_ci_direct_cost_details pcdc

468: RAISE PA_API.G_EXCEPTION_ERROR;
469: END IF;
470: /*
471: forall i in b_task_id_tbl.first..b_task_id_tbl.last
472: update pa_ci_direct_cost_details pcdc
473: set ( raw_cost, burdened_cost) =
474: (select decode(pcdc.quantity, null, pcdc.raw_cost,
475: pcdc.quantity * prac.txn_average_raw_cost_rate),
476: decode(pcdc.quantity, null,

Line 488: update pa_ci_direct_cost_details pcdc

484: where ci_id = p_ci_id
485: and dc_line_id = b_dc_line_id_tbl(i);
486: */
487: forall i in b_task_id_tbl.first..b_task_id_tbl.last
488: update pa_ci_direct_cost_details pcdc
489: set raw_cost = decode(pcdc.quantity, null, pcdc.raw_cost,
490: pcdc.quantity * pcdc.planning_resource_rate),
491: burdened_cost = decode(pcdc.quantity, null,
492: pcdc.raw_cost * pcdc.burden_cost_rate,

Line 547: -- Deletes data from pa_ci_direct_cost_details table

543: -- Called from the direct cost region of the planning UI
544: -- Calls the process_planning_lines() to rollup the planning lines,
545: -- which determines if the resource assignment needs to deleted
546: -- or updated.
547: -- Deletes data from pa_ci_direct_cost_details table
548: --
549: PROCEDURE delete_row(
550: p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,