3: ----------------------------------------------------------------------------
4: -- GLOBAL VARIABLES
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
5: ----------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FUNDING_CHECKLIST_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
8:
9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
12: G_EXCEPTION_ERROR EXCEPTION;
13: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
14:
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKL_UNEXPECTED_ERROR';
22: G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: ----------------------------------------------------------------------------
30: -- Data Structures
23: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
24: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
25: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
28:
29: ----------------------------------------------------------------------------
30: -- Data Structures
31: ----------------------------------------------------------------------------
117: -- End of comments
118: ----------------------------------------------------------------------------------
119: PROCEDURE create_funding_chklst(
120: p_api_version IN NUMBER
121: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
122: ,x_return_status OUT NOCOPY VARCHAR2
123: ,x_msg_count OUT NOCOPY NUMBER
124: ,x_msg_data OUT NOCOPY VARCHAR2
125: ,p_rulv_tbl IN rulv_tbl_type
138: -- End of comments
139: ----------------------------------------------------------------------------------
140: PROCEDURE update_funding_chklst(
141: p_api_version IN NUMBER
142: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
143: ,x_return_status OUT NOCOPY VARCHAR2
144: ,x_msg_count OUT NOCOPY NUMBER
145: ,x_msg_data OUT NOCOPY VARCHAR2
146: ,p_rulv_tbl IN rulv_tbl_type
159: -- End of comments
160: ----------------------------------------------------------------------------------
161: PROCEDURE delete_funding_chklst(
162: p_api_version IN NUMBER
163: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
164: ,x_return_status OUT NOCOPY VARCHAR2
165: ,x_msg_count OUT NOCOPY NUMBER
166: ,x_msg_data OUT NOCOPY VARCHAR2
167: ,p_rulv_tbl IN rulv_tbl_type
178: -- End of comments
179: ----------------------------------------------------------------------------------
180: PROCEDURE approve_funding_request(
181: p_api_version IN NUMBER
182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER
185: ,x_msg_data OUT NOCOPY VARCHAR2
186: ,p_fund_req_id IN okl_trx_ap_invoices_b.id%TYPE
197: -- End of comments
198: ----------------------------------------------------------------------------------
199: PROCEDURE approve_funding_chklst(
200: p_api_version IN NUMBER
201: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
202: ,x_return_status OUT NOCOPY VARCHAR2
203: ,x_msg_count OUT NOCOPY NUMBER
204: ,x_msg_data OUT NOCOPY VARCHAR2
205: ,p_rulv_rec IN rulv_rec_type