DBA Data[Home] [Help]

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_STREAMS_PUB

Line 1611: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1607: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1608: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
1609: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1610: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
1611: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1612: l_inv_item_id VARCHAR2(2000);
1613: l_line_bill_to_site VARCHAR2(2000);
1614: l_counter NUMBER;
1615: l_lty_code VARCHAR2(2000);

Line 2180: -- Okl_Streams_Pub.UPDATE_STREAM_ELEMENTS

2176:
2177: --
2178: -- Bug 4662173. Commenting below call for performance reasons.
2179: --
2180: -- Okl_Streams_Pub.UPDATE_STREAM_ELEMENTS
2181: -- (p_api_version => p_api_version
2182: -- ,p_init_msg_list => p_init_msg_list
2183: -- ,x_return_status => x_return_status
2184: -- ,x_msg_count => x_msg_count

Line 2980: lp_selv_rec Okl_Streams_pub.selv_rec_type;

2976:
2977: -- Bug 9001154 : Start
2978: l_stm_id OKL_STREAMS.ID%TYPE;
2979: l_max_se_line_no OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE;
2980: lp_selv_rec Okl_Streams_pub.selv_rec_type;
2981: lx_selv_rec Okl_Streams_pub.selv_rec_type;
2982:
2983: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
2984: SELECT max(se_line_number)

Line 2981: lx_selv_rec Okl_Streams_pub.selv_rec_type;

2977: -- Bug 9001154 : Start
2978: l_stm_id OKL_STREAMS.ID%TYPE;
2979: l_max_se_line_no OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE;
2980: lp_selv_rec Okl_Streams_pub.selv_rec_type;
2981: lx_selv_rec Okl_Streams_pub.selv_rec_type;
2982:
2983: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
2984: SELECT max(se_line_number)
2985: FROM okl_strm_elements

Line 3263: Okl_Streams_Pub.create_stream_elements(

3259: FETCH max_line_num_csr INTO l_max_se_line_no;
3260: CLOSE max_line_num_csr;
3261: lp_selv_rec.se_line_number := NVL(l_max_se_line_no,0) + 1;
3262: -- Call the create stream element API
3263: Okl_Streams_Pub.create_stream_elements(
3264: p_api_version => l_api_version
3265: ,p_init_msg_list => p_init_msg_list
3266: ,x_return_status => l_return_status
3267: ,x_msg_count => x_msg_count

Line 4782: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4778: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4779: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4780: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4781: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4782: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4783: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4784: l_trx_header_amt NUMBER :=0;
4785: l_fact_sync_code VARCHAR2(2000);
4786: l_inv_acct_code VARCHAR2(2000);

Line 4783: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4779: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4780: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4781: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4782: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4783: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4784: l_trx_header_amt NUMBER :=0;
4785: l_fact_sync_code VARCHAR2(2000);
4786: l_inv_acct_code VARCHAR2(2000);
4787: l_scs_code VARCHAR2(2000) := 'LEASE';

Line 5400: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5396: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5397: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5398: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5399: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5400: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5401: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5402: l_trx_header_amt NUMBER :=0;
5403: l_fact_sync_code VARCHAR2(2000);
5404: l_inv_acct_code VARCHAR2(2000);

Line 5401: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

5397: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5398: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
5399: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
5400: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5401: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
5402: l_trx_header_amt NUMBER :=0;
5403: l_fact_sync_code VARCHAR2(2000);
5404: l_inv_acct_code VARCHAR2(2000);
5405: l_scs_code VARCHAR2(2000) := 'LEASE';