7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
9: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_STATUS_CHANGE_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: ---------------------------------------------------------------------------
15: -- Global var holding the User Id
8: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
9: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_STATUS_CHANGE_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: ---------------------------------------------------------------------------
15: -- Global var holding the User Id
16: user_id NUMBER;
9: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_STATUS_CHANGE_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
14: ---------------------------------------------------------------------------
15: -- Global var holding the User Id
16: user_id NUMBER;
17: