5: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_STATUS_PVT';
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7:
8: -- Contract actions
9: G_K_NEW CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_NEW;
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
7:
8: -- Contract actions
9: G_K_NEW CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_NEW;
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
7:
8: -- Contract actions
9: G_K_NEW CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_NEW;
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
8: -- Contract actions
9: G_K_NEW CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_NEW;
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
16: G_K_ACTIVATE CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_ACTIVATE;
9: G_K_NEW CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_NEW;
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
16: G_K_ACTIVATE CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_ACTIVATE;
17:
10: G_K_EDIT CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_EDIT;
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
16: G_K_ACTIVATE CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_ACTIVATE;
17:
18: G_K_NOT_ALLOWED CONSTANT VARCHAR2(100) := 'G_K_NOT_ALLOWED';
11: G_K_QACHECK CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_QACHECK;
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
16: G_K_ACTIVATE CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_ACTIVATE;
17:
18: G_K_NOT_ALLOWED CONSTANT VARCHAR2(100) := 'G_K_NOT_ALLOWED';
19:
12: G_K_STRMGEN CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_STRMGEN;
13: G_K_JOURNAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_JOURNAL;
14: G_K_SUBMIT4APPRVL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_SUBMIT4APPRVL;
15: G_K_APPROVAL CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_APPROVAL;
16: G_K_ACTIVATE CONSTANT VARCHAR2(60) := OKL_CONTRACT_STATUS_PUB.G_K_ACTIVATE;
17:
18: G_K_NOT_ALLOWED CONSTANT VARCHAR2(100) := 'G_K_NOT_ALLOWED';
19:
20: Procedure get_contract_status(