1: PACKAGE OKS_RENEW_CONTRACT_PUB AUTHID CURRENT_USER AS
2: /* $Header: OKSPRENKS.pls 120.1 2005/09/27 14:31 anjkumar noship $*/
3:
4: SUBTYPE validation_rec_type IS OKS_RENEW_CONTRACT_PVT.validation_rec_type;
5: SUBTYPE validation_tbl_type IS OKS_RENEW_CONTRACT_PVT.validation_tbl_type;
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_RENEW_CONTRACT_PUB';
8: G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
1: PACKAGE OKS_RENEW_CONTRACT_PUB AUTHID CURRENT_USER AS
2: /* $Header: OKSPRENKS.pls 120.1 2005/09/27 14:31 anjkumar noship $*/
3:
4: SUBTYPE validation_rec_type IS OKS_RENEW_CONTRACT_PVT.validation_rec_type;
5: SUBTYPE validation_tbl_type IS OKS_RENEW_CONTRACT_PVT.validation_tbl_type;
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_RENEW_CONTRACT_PUB';
8: G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
9:
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_RENEW_CONTRACT_PUB';
8: G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
9:
10: G_VALIDATE_ALL CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ALL; --A
11: G_VALIDATE_ERRORS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ERRORS; --E
12:
13: G_VALID_STS_SUCCESS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_SUCCESS; --S
14: G_VALID_STS_WARNING CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_WARNING; --W
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_RENEW_CONTRACT_PUB';
8: G_OKS_APP_NAME CONSTANT VARCHAR2(3) := 'OKS'; --all new nessages should use this
9:
10: G_VALIDATE_ALL CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ALL; --A
11: G_VALIDATE_ERRORS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ERRORS; --E
12:
13: G_VALID_STS_SUCCESS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_SUCCESS; --S
14: G_VALID_STS_WARNING CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_WARNING; --W
15: G_VALID_STS_ERROR CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_ERROR; --E
9:
10: G_VALIDATE_ALL CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ALL; --A
11: G_VALIDATE_ERRORS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ERRORS; --E
12:
13: G_VALID_STS_SUCCESS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_SUCCESS; --S
14: G_VALID_STS_WARNING CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_WARNING; --W
15: G_VALID_STS_ERROR CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_ERROR; --E
16:
17:
10: G_VALIDATE_ALL CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ALL; --A
11: G_VALIDATE_ERRORS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ERRORS; --E
12:
13: G_VALID_STS_SUCCESS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_SUCCESS; --S
14: G_VALID_STS_WARNING CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_WARNING; --W
15: G_VALID_STS_ERROR CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_ERROR; --E
16:
17:
18: /*
11: G_VALIDATE_ERRORS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALIDATE_ERRORS; --E
12:
13: G_VALID_STS_SUCCESS CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_SUCCESS; --S
14: G_VALID_STS_WARNING CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_WARNING; --W
15: G_VALID_STS_ERROR CONSTANT VARCHAR2(1) := OKS_RENEW_CONTRACT_PVT.G_VALID_STS_ERROR; --E
16:
17:
18: /*
19: From R12 onwards, this procedure should be used to renew service contracts.