9: | Forms and libraries cannot directly refer to PL/SQL package global|
10: | variables, these record types are used to relay API constants |
11: | to client side using a function returning a record of this type. |
12: +-------------------------------------------------------------------*/
13: TYPE fnd_api_constants_type IS RECORD (
14: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
10: | variables, these record types are used to relay API constants |
11: | to client side using a function returning a record of this type. |
12: +-------------------------------------------------------------------*/
13: TYPE fnd_api_constants_type IS RECORD (
14: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: | to client side using a function returning a record of this type. |
12: +-------------------------------------------------------------------*/
13: TYPE fnd_api_constants_type IS RECORD (
14: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL NUMBER := FND_API.G_VALID_LEVEL_FULL,
19: G_RET_STS_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS,
12: +-------------------------------------------------------------------*/
13: TYPE fnd_api_constants_type IS RECORD (
14: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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: TYPE fnd_api_constants_type IS RECORD (
14: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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_MISS_NUM NUMBER := FND_API.G_MISS_NUM,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
15: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR,
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
23: G_FALSE VARCHAR2(1) := FND_API.G_FALSE);
16: G_MISS_DATE DATE := FND_API.G_MISS_DATE,
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
23: G_FALSE VARCHAR2(1) := FND_API.G_FALSE);
24:
17: G_VALID_LEVEL_NONE NUMBER := FND_API.G_VALID_LEVEL_NONE,
18: G_VALID_LEVEL_FULL 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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
23: G_FALSE VARCHAR2(1) := FND_API.G_FALSE);
24:
25: TYPE fnd_msg_pub_constants_type IS RECORD (
18: G_VALID_LEVEL_FULL 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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
23: G_FALSE VARCHAR2(1) := FND_API.G_FALSE);
24:
25: TYPE fnd_msg_pub_constants_type IS RECORD (
26: G_FIRST NUMBER := FND_MSG_PUB.G_FIRST,
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: G_TRUE VARCHAR2(1) := FND_API.G_TRUE,
23: G_FALSE VARCHAR2(1) := FND_API.G_FALSE);
24:
25: TYPE fnd_msg_pub_constants_type IS RECORD (
26: G_FIRST NUMBER := FND_MSG_PUB.G_FIRST,
27: G_NEXT NUMBER := FND_MSG_PUB.G_NEXT,
187: Extended_total OUT NOCOPY NUMBER) RETURN BOOLEAN;
188:
189: FUNCTION GTRUE RETURN VARCHAR2;
190: FUNCTION GFALSE RETURN VARCHAR2;
191: FUNCTION get_fnd_api_constants_rec RETURN fnd_api_constants_type;
192: FUNCTION get_fnd_msg_pub_constants_rec RETURN fnd_msg_pub_constants_type;
193:
194:
195: FUNCTION revision RETURN VARCHAR2;