APPS.CST_EAMCOST_PUB dependencies on CST_EAM_ROLLUP_COSTS

Line 9123: DELETE cst_eam_rollup_costs

9119: END IF;
9120:
9121: -- Delete existing calculations for this group id
9122: l_stmt_num := 17;
9123: DELETE cst_eam_rollup_costs
9124: WHERE group_id = p_group_id;
9125:
9126: -- Generate a warning if there are existing calculations for this group id
9127: l_stmt_num := 19;

Line 9142: INTO cst_eam_rollup_costs(

9138: -- Calculate the cumulative costs, starting from the leaf nodes.
9139: l_stmt_num := 20;
9140: FOR l_level IN REVERSE 0 .. l_max_level LOOP
9141: INSERT
9142: INTO cst_eam_rollup_costs(
9143: group_id,
9144: object_type,
9145: object_id,
9146: period_set_name,

Line 9220: cst_eam_rollup_costs CERC

9216: SUM(NVL(CERC.estimated_lab_cost,0)),
9217: SUM(NVL(CERC.estimated_eqp_cost,0))
9218: FROM cst_eam_hierarchy_snapshot CURR,
9219: cst_eam_hierarchy_snapshot CHILDREN,
9220: cst_eam_rollup_costs CERC
9221: WHERE CURR.group_id = p_group_id
9222: AND CURR.level_num = l_level
9223: AND CHILDREN.group_id = p_group_id
9224: AND CHILDREN.parent_object_type = CURR.object_type

Line 9359: DELETE cst_eam_rollup_costs

9355: );
9356: END IF;
9357:
9358: l_stmt_num := 20;
9359: DELETE cst_eam_rollup_costs
9360: WHERE group_id = NVL(p_group_id,group_id)
9361: AND program_application_id =
9362: NVL(p_prog_appl_id,program_application_id)
9363: AND last_update_date < NVL(p_last_update_date,last_update_date+1);

Line 9373: ' from CST_EAM_ROLLUP_COSTS'

9369: p_procedure_name => l_api_name,
9370: p_error_text => l_stmt_num||
9371: ': Successfully deleted '||
9372: SQL%ROWCOUNT||
9373: ' from CST_EAM_ROLLUP_COSTS'
9374: );
9375: END IF;
9376:
9377: x_return_status := FND_API.G_RET_STS_SUCCESS;