20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
22: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','RISK');
23:
24: -- FND_API global constant
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
22: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','RISK');
23:
24: -- FND_API global constant
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_OBJ_TYPE CONSTANT VARCHAR2(80) := AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_OBJECT_TYPE','RISK');
23:
24: -- FND_API global constant
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
30: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: -- FND_API global constant
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
30: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
31:
24: -- FND_API global constant
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
30: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
31:
32:
25: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
30: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
31:
32:
33: -- Operate_Risk with global p_operate_mode
26: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
27: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
28: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
29: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
30: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
31:
32:
33: -- Operate_Risk with global p_operate_mode
34: G_OP_CREATE CONSTANT NUMBER := 10;
361: -- check the requireness of the items which have been marked
362: -- as NOT NULL in table
363: -- Note
364: -- since the standard default with
365: -- FND_API.G_MISS_XXX v.s. NULL has been changed to:
366: -- if user want to update to Null, pass in G_MISS_XXX
367: -- else if user want to update to some value, pass in value
368: -- else if user doesn't want to update, pass in NULL.
369: -- Reference