APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_MSGS

Line 325: FROM OKL_TRX_MSGS TMG

321:
322: -- Get the last run for TRX_MSGS
323: CURSOR get_last_run_csr ( p_trx_id IN NUMBER) IS
324: SELECT NVL(MAX(TMG.tmg_run),0) last_run
325: FROM OKL_TRX_MSGS TMG
326: WHERE TMG.trx_id = p_trx_id;
327:
328: l_last_run NUMBER := 0;
329: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_last_run';

Line 391: FROM OKL_TRX_MSGS TMG

387: -- Get the unfilled TMG_RUN rows for the trx_id
388: CURSOR get_empty_tmg_run_csr ( p_trx_id IN NUMBER) IS
389: SELECT TMG.id,
390: TMG.object_version_number
391: FROM OKL_TRX_MSGS TMG
392: WHERE TMG.trx_id = p_trx_id
393: AND TMG.tmg_run IS NULL;
394:
395: l_last_run NUMBER;

Line 396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

392: WHERE TMG.trx_id = p_trx_id
393: AND TMG.tmg_run IS NULL;
394:
395: l_last_run NUMBER;
396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
398:
399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
400:

Line 397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;

393: AND TMG.tmg_run IS NULL;
394:
395: l_last_run NUMBER;
396: lp_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
397: lx_tmgv_tbl OKL_TRX_MSGS_PUB.tmgv_tbl_type;
398:
399: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
400:
401: l_api_version CONSTANT NUMBER := 1;

Line 441: -- Update the TMG_RUN of OKL_TRX_MSGS with l_last_run+1 for the TRX_ID with null TMG_RUN

437: i := i + 1;
438:
439: END LOOP;
440:
441: -- Update the TMG_RUN of OKL_TRX_MSGS with l_last_run+1 for the TRX_ID with null TMG_RUN
442: IF (lp_tmgv_tbl.COUNT > 0) THEN
443:
444: IF (is_debug_statement_on) THEN
445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');

Line 445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');

441: -- Update the TMG_RUN of OKL_TRX_MSGS with l_last_run+1 for the TRX_ID with null TMG_RUN
442: IF (lp_tmgv_tbl.COUNT > 0) THEN
443:
444: IF (is_debug_statement_on) THEN
445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
446: END IF;
447: OKL_TRX_MSGS_PUB.update_trx_msgs (
448: p_api_version => l_api_version,
449: p_init_msg_list => OKL_API.G_FALSE,

Line 447: OKL_TRX_MSGS_PUB.update_trx_msgs (

443:
444: IF (is_debug_statement_on) THEN
445: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_MSGS_PUB.update_trx_msgs');
446: END IF;
447: OKL_TRX_MSGS_PUB.update_trx_msgs (
448: p_api_version => l_api_version,
449: p_init_msg_list => OKL_API.G_FALSE,
450: x_return_status => l_return_status,
451: x_msg_count => l_msg_count,

Line 456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_MSGS_PUB.update_trx_msgs , return status: ' || l_return_status);

452: x_msg_data => l_msg_data,
453: p_tmgv_tbl => lp_tmgv_tbl,
454: x_tmgv_tbl => lx_tmgv_tbl);
455: IF (is_debug_statement_on) THEN
456: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_MSGS_PUB.update_trx_msgs , return status: ' || l_return_status);
457: END IF;
458:
459: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;