APPS.CST_EAMCOST_PUB dependencies on CST_EAM_ROLLUP_COSTS

Line 9836: DELETE cst_eam_rollup_costs

9832: END IF;
9833:
9834: -- Delete existing calculations for this group id
9835: l_stmt_num := 17;
9836: DELETE cst_eam_rollup_costs
9837: WHERE group_id = p_group_id;
9838:
9839: -- Generate a warning if there are existing calculations for this group id
9840: l_stmt_num := 19;

Line 9855: INTO cst_eam_rollup_costs(

9851: -- Calculate the cumulative costs, starting from the leaf nodes.
9852: l_stmt_num := 20;
9853: FOR l_level IN REVERSE 0 .. l_max_level LOOP
9854: INSERT
9855: INTO cst_eam_rollup_costs(
9856: group_id,
9857: object_type,
9858: object_id,
9859: period_set_name,

Line 9933: cst_eam_rollup_costs CERC

9929: SUM(NVL(CERC.estimated_lab_cost,0)),
9930: SUM(NVL(CERC.estimated_eqp_cost,0))
9931: FROM cst_eam_hierarchy_snapshot CURR,
9932: cst_eam_hierarchy_snapshot CHILDREN,
9933: cst_eam_rollup_costs CERC
9934: WHERE CURR.group_id = p_group_id
9935: AND CURR.level_num = l_level
9936: AND CHILDREN.group_id = p_group_id
9937: AND CHILDREN.parent_object_type = CURR.object_type

Line 10072: DELETE cst_eam_rollup_costs

10068: );
10069: END IF;
10070:
10071: l_stmt_num := 20;
10072: DELETE cst_eam_rollup_costs
10073: WHERE group_id = NVL(p_group_id,group_id)
10074: AND program_application_id =
10075: NVL(p_prog_appl_id,program_application_id)
10076: AND last_update_date < NVL(p_last_update_date,last_update_date+1);

Line 10086: ' from CST_EAM_ROLLUP_COSTS'

10082: p_procedure_name => l_api_name,
10083: p_error_text => l_stmt_num||
10084: ': Successfully deleted '||
10085: SQL%ROWCOUNT||
10086: ' from CST_EAM_ROLLUP_COSTS'
10087: );
10088: END IF;
10089:
10090: x_return_status := FND_API.G_RET_STS_SUCCESS;