9: -- History
10: -- 10/01/2004 tsho Creates
11: -- ===============================================================
12:
13: -- FND_API global constant
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12:
13: -- FND_API global constant
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
13: -- FND_API global constant
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
14: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
15: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: -- AMW table/view name
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: -- AMW table/view name
24: G_AMW_USER CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
22:
23: -- AMW table/view name
24: G_AMW_USER CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER');
25: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(30) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');