DBA Data[Home] [Help]

APPS.OKL_INT_EXT_CSH_APP_PVT dependencies on OKL_VLR_PVT

Line 18: p_error_tbl IN okl_vlr_pvt.vlrv_tbl_type,

14: -- End of comments
15: PROCEDURE populate_error_messages (
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2,
18: p_error_tbl IN okl_vlr_pvt.vlrv_tbl_type,
19: x_return_status OUT NOCOPY VARCHAR2,
20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2
22: ) IS

Line 30: l_error_tbl okl_vlr_pvt.vlrv_tbl_type := p_error_tbl;

26: l_return_status VARCHAR2 (1);
27: l_init_msg_list VARCHAR2 (1) := p_init_msg_list;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2 (2000);
30: l_error_tbl okl_vlr_pvt.vlrv_tbl_type := p_error_tbl;
31: lx_error_tbl okl_vlr_pvt.vlrv_tbl_type;
32: BEGIN
33: -- Standard Start of API savepoint
34: SAVEPOINT pop_err_msgs_pvt;

Line 31: lx_error_tbl okl_vlr_pvt.vlrv_tbl_type;

27: l_init_msg_list VARCHAR2 (1) := p_init_msg_list;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2 (2000);
30: l_error_tbl okl_vlr_pvt.vlrv_tbl_type := p_error_tbl;
31: lx_error_tbl okl_vlr_pvt.vlrv_tbl_type;
32: BEGIN
33: -- Standard Start of API savepoint
34: SAVEPOINT pop_err_msgs_pvt;
35: l_msg_count := 0;

Line 56: okl_vlr_pvt.insert_row (p_api_version => l_api_version,

52:
53: --Step 1
54: --insert all new error stack errors
55: -- Call the TAPI to insert all the errored values
56: okl_vlr_pvt.insert_row (p_api_version => l_api_version,
57: p_init_msg_list => l_init_msg_list,
58: x_return_status => l_return_status,
59: x_msg_count => l_msg_count,
60: x_msg_data => l_msg_data,

Line 104: px_error_tbl IN OUT NOCOPY okl_vlr_pvt.vlrv_tbl_type,

100: x_msg_data := l_msg_data;
101: END populate_error_messages;
102:
103: PROCEDURE process_batch(p_batch_id IN NUMBER,
104: px_error_tbl IN OUT NOCOPY okl_vlr_pvt.vlrv_tbl_type,
105: x_trx_status_code OUT NOCOPY VARCHAR2,
106: x_return_status OUT NOCOPY VARCHAR2)
107: IS
108: --AKRANGAN ADDED FOR BATCH RECEIPTS CROSS CURR FUNCTIONALITY BEGIN

Line 799: l_error_tbl okl_vlr_pvt.vlrv_tbl_type;

795: l_appl_tbl okl_receipts_pvt.appl_tbl_type;
796: --error message table declaration
797: --added by akrangan start
798: i NUMBER := 0;
799: l_error_tbl okl_vlr_pvt.vlrv_tbl_type;
800: l_msg_index_out NUMBER;
801:
802: l_counter NUMBER;
803: --added by akrangan end

Line 804: l_old_error_tbl okl_vlr_pvt.vlrv_tbl_type;

800: l_msg_index_out NUMBER;
801:
802: l_counter NUMBER;
803: --added by akrangan end
804: l_old_error_tbl okl_vlr_pvt.vlrv_tbl_type;
805:
806: -----------------------------
807: -- DECLARE Exceptions
808: ------------------------------

Line 1231: okl_vlr_pvt.delete_row (p_api_version => l_api_version,

1227: CLOSE c_get_previous_errors;
1228:
1229: IF l_old_error_tbl.COUNT > 0 THEN
1230: -- Call the TAPI to delete all the old errored values
1231: okl_vlr_pvt.delete_row (p_api_version => l_api_version,
1232: p_init_msg_list => l_init_msg_list,
1233: x_return_status => l_return_status,
1234: x_msg_count => l_msg_count,
1235: x_msg_data => l_msg_data,