DBA Data[Home] [Help]

APPS.OKL_AMORT_SCHED_REQ_PVT dependencies on OKC_K_HEADERS_B

Line 18: PROCEDURE populate_trx_table(p_chr_id in okc_k_headers_b.id%type,p_comments in varchar2 default null,

14: -- x_msg_data - Standard output parameter
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

Line 24: FROM OKC_K_HEADERS_B

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
24: FROM OKC_K_HEADERS_B
25: WHERE ID = p_chr_id;
26:
27: l_currency_code VARCHAR2(15);
28: l_org_id okc_k_headers_b.org_id%type;

Line 28: l_org_id okc_k_headers_b.org_id%type;

24: FROM OKC_K_HEADERS_B
25: WHERE ID = p_chr_id;
26:
27: l_currency_code VARCHAR2(15);
28: l_org_id okc_k_headers_b.org_id%type;
29: l_return_status varchar2(1) := OKL_API.G_RET_STS_SUCCESS;
30: BEGIN
31:
32: OPEN curr_code_org_id_csr(p_chr_id);

Line 72: PROCEDURE process_trx_request(p_chr_id in okc_k_headers_b.id%type,p_api_version IN NUMBER,

68: -- x_msg_count - Standard output parameter
69: -- x_msg_data - Standard output parameter
70: -- x_trx_req_id - The transaction_request_id created for this request
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: