1986: END get_workflow_details;
1987:
1988: PROCEDURE callCostEstimatorSS(
1989: p_api_version IN NUMBER := 1.0,
1990: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1991: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_wip_entity_id IN NUMBER,
1994: p_organization_id IN NUMBER,
1987:
1988: PROCEDURE callCostEstimatorSS(
1989: p_api_version IN NUMBER := 1.0,
1990: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1991: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_wip_entity_id IN NUMBER,
1994: p_organization_id IN NUMBER,
1995: x_return_status OUT NOCOPY VARCHAR2,
1988: PROCEDURE callCostEstimatorSS(
1989: p_api_version IN NUMBER := 1.0,
1990: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1991: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: p_wip_entity_id IN NUMBER,
1994: p_organization_id IN NUMBER,
1995: x_return_status OUT NOCOPY VARCHAR2,
1996: x_msg_count OUT NOCOPY NUMBER,
1996: x_msg_count OUT NOCOPY NUMBER,
1997: x_msg_data OUT NOCOPY VARCHAR2
1998: ) IS
1999:
2000: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2001: l_msg_count NUMBER ;
2002: l_msg_data VARCHAR2(2000) ;
2003:
2004: BEGIN
2003:
2004: BEGIN
2005:
2006: -- Initialize API return status to success
2007: x_return_status := FND_API.G_RET_STS_SUCCESS;
2008:
2009: UPDATE WIP_DISCRETE_JOBS
2010: SET estimation_status = 2
2011: WHERE wip_entity_id = p_wip_entity_id
2037: x_error_message OUT NOCOPY VARCHAR2
2038: )IS
2039: l_maint_objid_tbl EAM_WORKORDER_UTIL_PKG.REPLACE_REBUILD_TBL_TYPE;
2040: BEGIN
2041: x_return_status := FND_API.G_RET_STS_SUCCESS;
2042:
2043:
2044: SELECT wdj.maintenance_object_id
2045: bulk collect into l_maint_objid_tbl
2050: AND wdj.maintenance_object_type = 3;
2051:
2052: EXCEPTION WHEN NO_DATA_FOUND THEN
2053: null;
2054: x_return_status := FND_API.G_RET_STS_SUCCESS;
2055: WHEN OTHERS THEN
2056:
2057: x_return_status := EAM_ERROR_MESSAGE_PVT.G_STATUS_ERROR;
2058: x_error_message := sqlerrm;