DBA Data[Home] [Help]

APPS.OKL_FUNDING_CHECKLIST_PVT dependencies on OKL_API

Line 7: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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;

Line 9: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

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;

Line 10: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

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:

Line 11: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

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';

Line 26: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;

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

Line 27: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;

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: ----------------------------------------------------------------------------

Line 121: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 142: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 163: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 201: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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