APPS.OKL_AM_UTIL_PVT dependencies on OKL_TRX_MSGS

Line 355: FROM okl_trx_msgs m

351: l_result VARCHAR2(1);
352:
353: CURSOR l_messages_csr (cp_trx_table VARCHAR2, cp_trx_id NUMBER) IS
354: SELECT count (*)
355: FROM okl_trx_msgs m
356: WHERE m.trx_source_table = cp_trx_table
357: AND m.trx_id = cp_trx_id;
358:
359: BEGIN

Line 1432: p_trx_source_table IN OKL_TRX_MSGS.trx_source_table%TYPE,

1428: -- Version : 1.0
1429: -- End of comments
1430:
1431: PROCEDURE process_messages(
1432: p_trx_source_table IN OKL_TRX_MSGS.trx_source_table%TYPE,
1433: p_trx_id IN OKL_TRX_MSGS.trx_id%TYPE,
1434: x_return_status OUT NOCOPY VARCHAR2) IS
1435:
1436: px_error_rec okl_api.error_rec_type;

Line 1433: p_trx_id IN OKL_TRX_MSGS.trx_id%TYPE,

1429: -- End of comments
1430:
1431: PROCEDURE process_messages(
1432: p_trx_source_table IN OKL_TRX_MSGS.trx_source_table%TYPE,
1433: p_trx_id IN OKL_TRX_MSGS.trx_id%TYPE,
1434: x_return_status OUT NOCOPY VARCHAR2) IS
1435:
1436: px_error_rec okl_api.error_rec_type;
1437: lp_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;

Line 1437: lp_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;

1433: p_trx_id IN OKL_TRX_MSGS.trx_id%TYPE,
1434: x_return_status OUT NOCOPY VARCHAR2) IS
1435:
1436: px_error_rec okl_api.error_rec_type;
1437: lp_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;
1438: lx_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;
1439:
1440: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1441: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 1438: lx_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;

1434: x_return_status OUT NOCOPY VARCHAR2) IS
1435:
1436: px_error_rec okl_api.error_rec_type;
1437: lp_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;
1438: lx_tmgv_tbl okl_trx_msgs_pub.tmgv_tbl_type;
1439:
1440: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1441: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1442:

Line 1486: OKL_TRX_MSGS_PUB.insert_trx_msgs (

1482: -- **************************
1483:
1484: IF (lp_tmgv_tbl.COUNT > 0) THEN
1485:
1486: OKL_TRX_MSGS_PUB.insert_trx_msgs (
1487: p_api_version => l_api_version,
1488: p_init_msg_list => OKL_API.G_FALSE,
1489: x_return_status => l_return_status,
1490: x_msg_count => l_msg_count,