DBA Data[Home] [Help]

APPS.OKL_AMORT_SCHED_REQ_PVT dependencies on OKL_TRX_REQUESTS

Line 19: p_trqv_tbl_type OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type,

15: -- p_trqv_tbl_type - The data structure containing information to be inserted
16: -- Version : 1.0
17: -- History : srsreeni created.
18: PROCEDURE populate_trx_table(p_chr_id in okc_k_headers_b.id%type,p_comments in varchar2 default null,
19: p_trqv_tbl_type OUT NOCOPY okl_trx_requests_pub.trqv_tbl_type,
20: x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,x_msg_data OUT NOCOPY VARCHAR2) IS
21:
22: CURSOR curr_code_org_id_csr(p_chr_id IN NUMBER) IS
23: SELECT currency_code,org_id

Line 75: x_msg_data OUT NOCOPY VARCHAR2,x_trx_req_id OUT NOCOPY okl_trx_requests.id%type,x_summ_flag OUT NOCOPY BOOLEAN) IS

71: -- x_summ_flag - Flag to indicate if Summary data is present or not
72: PROCEDURE process_trx_request(p_chr_id in okc_k_headers_b.id%type,p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,p_comments in varchar2 default null,p_user_id in number,
74: x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,x_trx_req_id OUT NOCOPY okl_trx_requests.id%type,x_summ_flag OUT NOCOPY BOOLEAN) IS
76:
77: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
78: x_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
79: i BINARY_INTEGER;

Line 77: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

73: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,p_comments in varchar2 default null,p_user_id in number,
74: x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,x_trx_req_id OUT NOCOPY okl_trx_requests.id%type,x_summ_flag OUT NOCOPY BOOLEAN) IS
76:
77: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
78: x_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
79: i BINARY_INTEGER;
80: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_TRX_REQUEST';
81:

Line 78: x_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;

74: x_return_status OUT NOCOPY VARCHAR2,x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,x_trx_req_id OUT NOCOPY okl_trx_requests.id%type,x_summ_flag OUT NOCOPY BOOLEAN) IS
76:
77: l_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
78: x_trqv_tbl okl_trx_requests_pub.trqv_tbl_type;
79: i BINARY_INTEGER;
80: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_TRX_REQUEST';
81:
82: BEGIN

Line 103: okl_trx_requests_pub.insert_trx_requests(p_api_version => p_api_version,

99: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
100: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
101: RAISE Okl_Api.G_EXCEPTION_ERROR;
102: END IF;
103: okl_trx_requests_pub.insert_trx_requests(p_api_version => p_api_version,
104: p_init_msg_list => p_init_msg_list,
105: x_return_status => x_return_status,
106: x_msg_count => x_msg_count,
107: x_msg_data => x_msg_data,