20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: -- FND_GLOBAL
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_PARTY_ID NUMBER := NULL;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
21: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
22: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
23:
24: -- FND_GLOBAL
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_PARTY_ID NUMBER := NULL;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
29:
23:
24: -- FND_GLOBAL
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_PARTY_ID NUMBER := NULL;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
29:
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
24: -- FND_GLOBAL
25: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
26: G_PARTY_ID NUMBER := NULL;
27: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
28: G_SECURITY_GROUP_ID NUMBER := FND_GLOBAL.SECURITY_GROUP_ID;
29:
30: -- AMW table/view name
31: G_AMW_USER CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER');
32: G_AMW_USER_RESP_GROUPS CONSTANT VARCHAR2(240) := FND_PROFILE.VALUE('AMW_USER_RESP_GROUPS');