APPS.PA_PROCESS_CI_LINES_PKG dependencies on PA_CI_DIRECT_COST_DETAILS

Line 172: from pa_ci_direct_cost_details

168: cursor get_dc_burden_cost_rate(c_task_id number,
169: c_rlmi_id number,
170: c_currency_code varchar2) IS
171: select distinct burden_cost_rate
172: from pa_ci_direct_cost_details
173: where task_id = c_task_id
174: and resource_list_member_id = c_rlmi_id
175: and currency_code = c_currency_code
176: and ci_id = (select ci_id from pa_budget_versions where budget_version_id = p_bvid)

Line 1038: from pa_ci_direct_cost_details

1034: max(effective_to),
1035: sum(quantity),
1036: sum(raw_cost),
1037: count(*)
1038: from pa_ci_direct_cost_details
1039: where ci_id = p_ci_id
1040: and task_id = p_task_id
1041: and resource_list_member_id = p_resource_list_member_id
1042: and currency_code = p_currency_code;

Line 1543: from pa_ci_direct_cost_details

1539: i_burden_cost_rate := null;
1540:
1541: select planning_resource_rate, burden_cost_rate
1542: into i_resource_rate, i_burden_cost_rate
1543: from pa_ci_direct_cost_details
1544: where ci_id = p_ci_id
1545: and task_id = p_task_id_tbl(j)
1546: and resource_list_member_id = p_rlmi_id_tbl(j)
1547: and currency_code = l_rate_based_res_curr

Line 1554: insert into pa_ci_direct_cost_details(

1550: when no_data_found then
1551: null;
1552: end;
1553:
1554: insert into pa_ci_direct_cost_details(
1555: dc_line_id
1556: ,ci_id
1557: ,project_id
1558: ,task_id

Line 1601: from pa_ci_direct_cost_details pc,

1597: ,pc.creation_date
1598: ,pc.last_update_by
1599: ,pc.last_update_date
1600: ,pc.last_update_login
1601: from pa_ci_direct_cost_details pc,
1602: pa_resource_assignments pra,
1603: pa_resource_asgn_curr prc
1604: where pc.ci_id = p_ci_id
1605: and pc.dc_line_id = p_line_id_tbl(j)

Line 1613: update pa_ci_direct_cost_details a

1609: and pra.resource_assignment_id = prc.resource_assignment_id
1610: and prc.txn_currency_code = l_rate_based_res_curr
1611: and pra.budget_version_id = p_bvid;
1612:
1613: update pa_ci_direct_cost_details a
1614: set quantity = NULL
1615: where a.ci_id = p_ci_id
1616: and dc_line_id = p_line_id_tbl(j);
1617:

Line 1620: update pa_ci_direct_cost_details a

1616: and dc_line_id = p_line_id_tbl(j);
1617:
1618: exception
1619: when dup_val_on_index then
1620: update pa_ci_direct_cost_details a
1621: set (quantity, raw_cost, burdened_cost) =
1622: (select sum(quantity) + a.quantity,
1623: (sum(quantity) + a.quantity) * a.planning_resource_rate,
1624: (sum(quantity) + a.quantity) * a.burden_cost_rate

Line 1625: from pa_ci_direct_cost_details b

1621: set (quantity, raw_cost, burdened_cost) =
1622: (select sum(quantity) + a.quantity,
1623: (sum(quantity) + a.quantity) * a.planning_resource_rate,
1624: (sum(quantity) + a.quantity) * a.burden_cost_rate
1625: from pa_ci_direct_cost_details b
1626: where b.ci_id = p_ci_id
1627: and b.dc_line_id = p_line_id_tbl(j))
1628: where a.ci_id = p_ci_id
1629: and currency_code = l_rate_based_res_curr

Line 1633: from pa_ci_direct_cost_details

1629: and currency_code = l_rate_based_res_curr
1630: and task_id = rollup_task_tbl(i)
1631: and resource_list_member_id = rollup_rlmi_tbl(i)
1632: and expenditure_type = (select expenditure_type
1633: from pa_ci_direct_cost_details
1634: where dc_line_id = p_line_id_tbl(j));
1635:
1636: update pa_ci_direct_cost_details a
1637: set quantity = NULL

Line 1636: update pa_ci_direct_cost_details a

1632: and expenditure_type = (select expenditure_type
1633: from pa_ci_direct_cost_details
1634: where dc_line_id = p_line_id_tbl(j));
1635:
1636: update pa_ci_direct_cost_details a
1637: set quantity = NULL
1638: where a.ci_id = p_ci_id
1639: and dc_line_id = p_line_id_tbl(j);
1640: