eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GENERATE_ACCRUALS_PVT dependencies on OKL_STREAMS

Line 116: FROM OKL_STREAMS stm,

112: --AND language = 'US';
113:
114: CURSOR get_unb_rec_csr(p_sty_id NUMBER) IS
115: SELECT NVL(SUM(ste.amount),0)
116: FROM OKL_STREAMS stm,
117: OKL_STRM_ELEMENTS ste
118: WHERE stm.khr_id = p_ctr_id
119: AND stm.sty_id = p_sty_id
120: AND stm.active_yn = 'Y'

Line 134: OKL_STREAMS_UTIL.get_primary_stream_type(

130: -- IF get_sty_id_csr%NOTFOUND THEN
131: -- RAISE NO_DATA_FOUND;
132: -- END IF;
133: --CLOSE get_sty_id_csr;
134: OKL_STREAMS_UTIL.get_primary_stream_type(
135: p_khr_id => p_ctr_id,
136: p_primary_sty_purpose => 'RENT',
137: x_return_status => l_return_status,
138: x_primary_sty_id => l_rent_sty_id);

Line 423: --OKL_STREAMS stm,

419: WHERE id = p_chr_id
420: AND EXISTS (
421: SELECT 1
422: FROM OKL_STRM_TYPE_B sty,
423: --OKL_STREAMS stm,
424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,
427: OKL_K_HEADERS khr,

Line 424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

420: AND EXISTS (
421: SELECT 1
422: FROM OKL_STRM_TYPE_B sty,
423: --OKL_STREAMS stm,
424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,
427: OKL_K_HEADERS khr,
428: OKL_PRODUCTS pdt

Line 1015: --OKL_STREAMS stm,

1011: ste.amount,
1012: stm.kle_id
1013: FROM OKL_STRM_TYPE_B sty,
1014: OKL_STRM_TYPE_TL stytl,
1015: --OKL_STREAMS stm,
1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1017: OKL_STRM_ELEMENTS ste,
1018: OKL_PROD_STRM_TYPES psty,
1019: OKL_K_HEADERS khr

Line 1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

1012: stm.kle_id
1013: FROM OKL_STRM_TYPE_B sty,
1014: OKL_STRM_TYPE_TL stytl,
1015: --OKL_STREAMS stm,
1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1017: OKL_STRM_ELEMENTS ste,
1018: OKL_PROD_STRM_TYPES psty,
1019: OKL_K_HEADERS khr
1020: WHERE stm.khr_id = p_ctr_id

Line 1048: --OKL_STREAMS stm,

1044: ste.amount,
1045: stm.kle_id
1046: FROM OKL_STRM_TYPE_B sty,
1047: OKL_STRM_TYPE_TL stytl,
1048: --OKL_STREAMS stm,
1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1050: OKL_STRM_ELEMENTS ste,
1051: OKL_PROD_STRM_TYPES psty,
1052: OKL_K_HEADERS khr

Line 1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

1045: stm.kle_id
1046: FROM OKL_STRM_TYPE_B sty,
1047: OKL_STRM_TYPE_TL stytl,
1048: --OKL_STREAMS stm,
1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1050: OKL_STRM_ELEMENTS ste,
1051: OKL_PROD_STRM_TYPES psty,
1052: OKL_K_HEADERS khr
1053: WHERE stm.khr_id = p_ctr_id

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 2941: kle_id OKL_STREAMS.kle_ID%TYPE

2937: TYPE stream_rec IS RECORD
2938: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2939: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2940: amount NUMBER,
2941: kle_id OKL_STREAMS.kle_ID%TYPE
2942: ,stm_id OKL_STREAMS.ID%TYPE ); -- 9001154
2943:
2944: --local variables
2945: l_api_name VARCHAR2(20) := 'ACCELERATE_ACCRUALS';

Line 2942: ,stm_id OKL_STREAMS.ID%TYPE ); -- 9001154

2938: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2939: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2940: amount NUMBER,
2941: kle_id OKL_STREAMS.kle_ID%TYPE
2942: ,stm_id OKL_STREAMS.ID%TYPE ); -- 9001154
2943:
2944: --local variables
2945: l_api_name VARCHAR2(20) := 'ACCELERATE_ACCRUALS';
2946: l_api_version CONSTANT NUMBER := 1.0;

Line 2978: l_stm_id OKL_STREAMS.ID%TYPE;

2974: l_stream_rec stream_rec;
2975: l_counter NUMBER := 1;
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:

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 3083: --OKL_STREAMS stm,

3079: ste.amount amount,
3080: stm.kle_id
3081: ,stm.id stm_id -- Bug : 9001154
3082: FROM OKL_STRM_TYPE_B sty,
3083: --OKL_STREAMS stm,
3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,
3087: OKL_K_HEADERS khr,

Line 3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041

3080: stm.kle_id
3081: ,stm.id stm_id -- Bug : 9001154
3082: FROM OKL_STRM_TYPE_B sty,
3083: --OKL_STREAMS stm,
3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,
3087: OKL_K_HEADERS khr,
3088: OKL_PRODUCTS pdt

Line 3121: --OKL_STREAMS stm,

3117: stm.kle_id
3118: ,stm.id stm_id -- Bug : 9001154
3119:
3120: FROM OKL_STRM_TYPE_B sty,
3121: --OKL_STREAMS stm,
3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,
3125: OKL_K_HEADERS khr,

Line 3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041

3118: ,stm.id stm_id -- Bug : 9001154
3119:
3120: FROM OKL_STRM_TYPE_B sty,
3121: --OKL_STREAMS stm,
3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,
3125: OKL_K_HEADERS khr,
3126: OKL_PRODUCTS pdt

Line 3159: --OKL_STREAMS stm,

3155: ste.amount amount,
3156: stm.kle_id
3157: ,stm.id stm_id -- Bug : 9001154
3158: FROM OKL_STRM_TYPE_B sty,
3159: --OKL_STREAMS stm,
3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,
3163: OKL_K_HEADERS khr,

Line 3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041

3156: stm.kle_id
3157: ,stm.id stm_id -- Bug : 9001154
3158: FROM OKL_STRM_TYPE_B sty,
3159: --OKL_STREAMS stm,
3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,
3163: OKL_K_HEADERS khr,
3164: OKL_PRODUCTS pdt

Line 3197: --OKL_STREAMS stm,

3193: ste.amount amount,
3194: stm.kle_id
3195: ,stm.id stm_id -- Bug : 9001154
3196: FROM OKL_STRM_TYPE_B sty,
3197: --OKL_STREAMS stm,
3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,
3201: OKL_K_HEADERS khr,

Line 3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041

3194: stm.kle_id
3195: ,stm.id stm_id -- Bug : 9001154
3196: FROM OKL_STRM_TYPE_B sty,
3197: --OKL_STREAMS stm,
3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,
3201: OKL_K_HEADERS khr,
3202: OKL_PRODUCTS pdt

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';

Line 6300: okl_streams stm,

6296: --Bug# 13815781
6297: CURSOR last_accrual_date_csr(p_contract_id NUMBER) IS
6298: SELECT MAX(sel.stream_element_date)
6299: FROM okl_strm_elements sel,
6300: okl_streams stm,
6301: okl_strm_type_b sty
6302: WHERE stm.khr_id = p_contract_id
6303: AND sel.stm_id = stm.id
6304: AND stm.say_code = 'CURR'

Line 6642: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

6638: END IF;
6639:
6640: -- MGAAP start 7263041
6641: IF (l_multi_gaap_yn = 'Y') THEN
6642: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
6643: GET_ACCRUAL_STREAMS(x_return_status => l_return_status
6644: ,x_stream_tbl => l_stream_tbl_rep
6645: ,p_khr_id => l_contract_id
6646: ,p_product_id => l_reporting_pdt_id

Line 6650: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

6646: ,p_product_id => l_reporting_pdt_id
6647: ,p_ctr_start_date => l_start_date
6648: ,p_period_end_date => G_PERIOD_END_DATE_REP
6649: ,p_accrual_rule_yn => 'ACRL_WITH_RULE');
6650: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
6651: -- store the highest degree of error
6652: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
6653: Okl_Api.set_message(p_app_name => g_app_name,
6654: p_msg_name => 'OKL_AGN_STREAM_ERROR',

Line 8231: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

8227: -- MGAAP start 7263041
8228: IF (l_Multi_gaap_yn = 'Y') THEN
8229: l_stream_tbl_rep.DELETE(l_stream_tbl_rep.COUNT); -- MGAAP 7263041
8230:
8231: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
8232:
8233: GET_ACCRUAL_STREAMS(x_return_status => l_return_status
8234: ,x_stream_tbl => l_stream_tbl_rep
8235: ,p_khr_id => l_contract_id

Line 8242: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

8238: ,p_period_end_date => G_PERIOD_END_DATE_REP
8239: ,p_accrual_rule_yn => 'ACRL_WITHOUT_RULE');
8240: -- store the highest degree of error
8241:
8242: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
8243:
8244: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
8245: Okl_Api.set_message(p_app_name => g_app_name,
8246: p_msg_name => 'OKL_AGN_STREAM_ERROR',

Line 8368: OKL_STREAMS_UTIL.get_dependent_stream_type(

8364: -- END IF;
8365: -- CLOSE sty_id_csr;
8366:
8367: -- Get the stream type id for variable interest rate product
8368: OKL_STREAMS_UTIL.get_dependent_stream_type(
8369: p_khr_id => l_contract_id,
8370: p_primary_sty_purpose => 'VARIABLE_INTEREST',
8371: p_dependent_sty_purpose => 'VARIABLE_INTEREST_INCOME',
8372: x_return_status => l_return_status,

Line 8387: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

8383:
8384: -- MGAAP 7263041 start
8385: IF (l_multi_gaap_yn = 'Y') THEN
8386: -- Get the stream type id for variable interest rate product
8387: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
8388: p_khr_id => l_contract_id,
8389: p_primary_sty_purpose => 'VARIABLE_INTEREST',
8390: p_dependent_sty_purpose => 'VARIABLE_INTEREST_INCOME',
8391: x_return_status => l_return_status,

Line 9079: OKL_STREAMS_UTIL.get_dependent_stream_type(

9075: END IF;
9076:
9077: IF TRUNC(l_accrual_date) >= TRUNC(l_last_accrual_date) THEN
9078:
9079: OKL_STREAMS_UTIL.get_dependent_stream_type(
9080: p_khr_id => l_contract_id,
9081: p_primary_sty_purpose => 'RENT',
9082: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
9083: x_return_status => l_return_status,

Line 9096: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

9092: RAISE Okl_Api.G_EXCEPTION_ERROR;
9093: END IF;
9094:
9095: IF (l_multi_gaap_yn = 'Y') THEN
9096: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
9097: p_khr_id => l_contract_id,
9098: p_primary_sty_purpose => 'RENT',
9099: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
9100: x_return_status => l_return_status,