82: unexpected error.
83:
84: */
85:
86: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
88: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: --- WHO columns
83:
84: */
85:
86: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
88: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: --- WHO columns
91: ---
84: */
85:
86: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
87: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
88: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: --- WHO columns
91: ---
92: G_CONC_REQUEST_ID CONSTANT FND_CONCURRENT_REQUESTS.REQUEST_ID%TYPE := FND_GLOBAL.CONC_REQUEST_ID;
101: ---
102: G_SET_PROCESS_ID NUMBER(15) := NULL;
103:
104: G_PARTY_ID EGO_USER_V.party_id%TYPE;
105: G_MISS_NUM CONSTANT NUMBER := FND_API.G_NULL_NUM;
106: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_NULL_CHAR;
107: G_MISS_DATE CONSTANT DATE := FND_API.G_NULL_DATE;
108: G_MAX_FETCH_SIZE CONSTANT NUMBER := 2000;
109:
102: G_SET_PROCESS_ID NUMBER(15) := NULL;
103:
104: G_PARTY_ID EGO_USER_V.party_id%TYPE;
105: G_MISS_NUM CONSTANT NUMBER := FND_API.G_NULL_NUM;
106: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_NULL_CHAR;
107: G_MISS_DATE CONSTANT DATE := FND_API.G_NULL_DATE;
108: G_MAX_FETCH_SIZE CONSTANT NUMBER := 2000;
109:
110: --- Record and table datatypes used for the entity processing
103:
104: G_PARTY_ID EGO_USER_V.party_id%TYPE;
105: G_MISS_NUM CONSTANT NUMBER := FND_API.G_NULL_NUM;
106: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_NULL_CHAR;
107: G_MISS_DATE CONSTANT DATE := FND_API.G_NULL_DATE;
108: G_MAX_FETCH_SIZE CONSTANT NUMBER := 2000;
109:
110: --- Record and table datatypes used for the entity processing
111: ---