DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on FND_API

Line 1990: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 1991: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 2000: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

Line 2007: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2041: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2054: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;