12: -- 05/13/2005 tsho introduce Cocurrent Program, Incomapatible Sets, Revalidation, (Role, GLOBAL Grant/USER Grant) in AMW.E
13: -- 12/01/2005 tsho add Purge_Violation_Before_Date (for bug 4673154)
14: -- ===============================================================
15:
16: -- FND_API global constant
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
20: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13: -- 12/01/2005 tsho add Purge_Violation_Before_Date (for bug 4673154)
14: -- ===============================================================
15:
16: -- FND_API global constant
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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;
14: -- ===============================================================
15:
16: -- FND_API global constant
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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;
15:
16: -- FND_API global constant
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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:
16: -- FND_API global constant
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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;
18: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
19: G_VALID_LEVEL_FULL CONSTANT NUMBER := FND_API.G_VALID_LEVEL_FULL;
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;