DBA Data[Home] [Help]

APPS.OKL_CREDIT_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_CREDIT_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_CREDIT_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_CREDIT_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 27: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;

23: G_OKL_LLA_INVALID_DATE_FORMAT CONSTANT VARCHAR2(30) := 'OKL_LLA_INVALID_DATE_FORMAT';
24: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
25: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
26: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
27: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
29:
30: ----------------------------------------------------------------------------
31: -- Data Structures

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

24: G_NOT_UNIQUE CONSTANT VARCHAR2(30) := 'OKL_LLA_NOT_UNIQUE';
25: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := 'OKL_REQUIRED_VALUE';
26: G_LLA_RANGE_CHECK CONSTANT VARCHAR2(30) := 'OKL_LLA_RANGE_CHECK';
27: G_INVALID_VALUE CONSTANT VARCHAR2(30) := OKL_API.G_INVALID_VALUE;
28: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKL_API.G_COL_NAME_TOKEN;
29:
30: ----------------------------------------------------------------------------
31: -- Data Structures
32: ----------------------------------------------------------------------------

Line 123: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

119: -- End of comments
120: ----------------------------------------------------------------------------------
121: PROCEDURE create_credit_chklst(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
124: ,x_return_status OUT NOCOPY VARCHAR2
125: ,x_msg_count OUT NOCOPY NUMBER
126: ,x_msg_data OUT NOCOPY VARCHAR2
127: ,p_rulv_tbl IN rulv_tbl_type

Line 144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

140: -- End of comments
141: ----------------------------------------------------------------------------------
142: PROCEDURE update_credit_chklst(
143: p_api_version IN NUMBER
144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
145: ,x_return_status OUT NOCOPY VARCHAR2
146: ,x_msg_count OUT NOCOPY NUMBER
147: ,x_msg_data OUT NOCOPY VARCHAR2
148: ,p_rulv_tbl IN rulv_tbl_type

Line 165: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

161: -- End of comments
162: ----------------------------------------------------------------------------------
163: PROCEDURE delete_credit_chklst(
164: p_api_version IN NUMBER
165: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
166: ,x_return_status OUT NOCOPY VARCHAR2
167: ,x_msg_count OUT NOCOPY NUMBER
168: ,x_msg_data OUT NOCOPY VARCHAR2
169: ,p_rulv_tbl IN rulv_tbl_type

Line 184: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

180: -- End of comments
181: ----------------------------------------------------------------------------------
182: PROCEDURE approve_credit_chklst(
183: p_api_version IN NUMBER
184: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
185: ,x_return_status OUT NOCOPY VARCHAR2
186: ,x_msg_count OUT NOCOPY NUMBER
187: ,x_msg_data OUT NOCOPY VARCHAR2
188: ,p_rulv_rec IN rulv_rec_type

Line 203: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

199: -- End of comments
200: ----------------------------------------------------------------------------------
201: PROCEDURE update_fund_chklst_tpl_hdr(
202: p_api_version IN NUMBER
203: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
204: ,x_return_status OUT NOCOPY VARCHAR2
205: ,x_msg_count OUT NOCOPY NUMBER
206: ,x_msg_data OUT NOCOPY VARCHAR2
207: ,p_rulv_tbl IN rulv_tbl_type

Line 224: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

220: -- End of comments
221: ----------------------------------------------------------------------------------
222: PROCEDURE update_fund_chklst_tpl_hdr(
223: p_api_version IN NUMBER
224: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
225: ,x_return_status OUT NOCOPY VARCHAR2
226: ,x_msg_count OUT NOCOPY NUMBER
227: ,x_msg_data OUT NOCOPY VARCHAR2
228: ,p_rulv_rec IN rulv_rec_type

Line 245: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

241: -- End of comments
242: ----------------------------------------------------------------------------------
243: PROCEDURE update_funding_chklst_tpl(
244: p_api_version IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
246: ,x_return_status OUT NOCOPY VARCHAR2
247: ,x_msg_count OUT NOCOPY NUMBER
248: ,x_msg_data OUT NOCOPY VARCHAR2
249: ,p_rulv_tbl IN rulv_tbl_type

Line 265: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

261: -- End of comments
262: ----------------------------------------------------------------------------------
263: PROCEDURE approve_funding_chklst_tpl(
264: p_api_version IN NUMBER
265: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
266: ,x_return_status OUT NOCOPY VARCHAR2
267: ,x_msg_count OUT NOCOPY NUMBER
268: ,x_msg_data OUT NOCOPY VARCHAR2
269: ,p_rulv_rec IN rulv_rec_type

Line 286: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

282: -- End of comments
283: ----------------------------------------------------------------------------------
284: PROCEDURE create_funding_chklst_tpl(
285: p_api_version IN NUMBER
286: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
287: ,x_return_status OUT NOCOPY VARCHAR2
288: ,x_msg_count OUT NOCOPY NUMBER
289: ,x_msg_data OUT NOCOPY VARCHAR2
290: ,p_rulv_tbl IN rulv_tbl_type

Line 307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

303: -- End of comments
304: ----------------------------------------------------------------------------------
305: PROCEDURE delete_funding_chklst_tpl(
306: p_api_version IN NUMBER
307: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
308: ,x_return_status OUT NOCOPY VARCHAR2
309: ,x_msg_count OUT NOCOPY NUMBER
310: ,x_msg_data OUT NOCOPY VARCHAR2
311: ,p_rulv_tbl IN rulv_tbl_type