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

372: WHERE id = p_chr_id
373: AND EXISTS (
374: SELECT 1
375: FROM OKL_STRM_TYPE_B sty,
376: --OKL_STREAMS stm,
377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
378: OKL_STRM_ELEMENTS ste,
379: OKL_PROD_STRM_TYPES psty,
380: OKL_K_HEADERS khr,

Line 377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

373: AND EXISTS (
374: SELECT 1
375: FROM OKL_STRM_TYPE_B sty,
376: --OKL_STREAMS stm,
377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
378: OKL_STRM_ELEMENTS ste,
379: OKL_PROD_STRM_TYPES psty,
380: OKL_K_HEADERS khr,
381: OKL_PRODUCTS pdt

Line 905: --OKL_STREAMS stm,

901: ste.amount,
902: stm.kle_id
903: FROM OKL_STRM_TYPE_B sty,
904: OKL_STRM_TYPE_TL stytl,
905: --OKL_STREAMS stm,
906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
907: OKL_STRM_ELEMENTS ste,
908: OKL_PROD_STRM_TYPES psty,
909: OKL_K_HEADERS khr

Line 906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

902: stm.kle_id
903: FROM OKL_STRM_TYPE_B sty,
904: OKL_STRM_TYPE_TL stytl,
905: --OKL_STREAMS stm,
906: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
907: OKL_STRM_ELEMENTS ste,
908: OKL_PROD_STRM_TYPES psty,
909: OKL_K_HEADERS khr
910: WHERE stm.khr_id = p_ctr_id

Line 938: --OKL_STREAMS stm,

934: ste.amount,
935: stm.kle_id
936: FROM OKL_STRM_TYPE_B sty,
937: OKL_STRM_TYPE_TL stytl,
938: --OKL_STREAMS stm,
939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
940: OKL_STRM_ELEMENTS ste,
941: OKL_PROD_STRM_TYPES psty,
942: OKL_K_HEADERS khr

Line 939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041

935: stm.kle_id
936: FROM OKL_STRM_TYPE_B sty,
937: OKL_STRM_TYPE_TL stytl,
938: --OKL_STREAMS stm,
939: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
940: OKL_STRM_ELEMENTS ste,
941: OKL_PROD_STRM_TYPES psty,
942: OKL_K_HEADERS khr
943: WHERE stm.khr_id = p_ctr_id

Line 1501: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

1497: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1498: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
1499: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
1500: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
1501: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
1502: l_inv_item_id VARCHAR2(2000);
1503: l_line_bill_to_site VARCHAR2(2000);
1504: l_counter NUMBER;
1505: l_lty_code VARCHAR2(2000);

Line 2063: -- Okl_Streams_Pub.UPDATE_STREAM_ELEMENTS

2059:
2060: --
2061: -- Bug 4662173. Commenting below call for performance reasons.
2062: --
2063: -- Okl_Streams_Pub.UPDATE_STREAM_ELEMENTS
2064: -- (p_api_version => p_api_version
2065: -- ,p_init_msg_list => p_init_msg_list
2066: -- ,x_return_status => x_return_status
2067: -- ,x_msg_count => x_msg_count

Line 2766: kle_id OKL_STREAMS.kle_ID%TYPE);

2762: TYPE stream_rec IS RECORD
2763: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2764: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2765: amount NUMBER,
2766: kle_id OKL_STREAMS.kle_ID%TYPE);
2767:
2768: --local variables
2769: l_api_name VARCHAR2(20) := 'ACCELERATE_ACCRUALS';
2770: l_api_version CONSTANT NUMBER := 1.0;

Line 2895: --OKL_STREAMS stm,

2891: ste.id ste_id,
2892: ste.amount amount,
2893: stm.kle_id
2894: FROM OKL_STRM_TYPE_B sty,
2895: --OKL_STREAMS stm,
2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2897: OKL_STRM_ELEMENTS ste,
2898: OKL_PROD_STRM_TYPES psty,
2899: OKL_K_HEADERS khr,

Line 2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041

2892: ste.amount amount,
2893: stm.kle_id
2894: FROM OKL_STRM_TYPE_B sty,
2895: --OKL_STREAMS stm,
2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2897: OKL_STRM_ELEMENTS ste,
2898: OKL_PROD_STRM_TYPES psty,
2899: OKL_K_HEADERS khr,
2900: OKL_PRODUCTS pdt

Line 2931: --OKL_STREAMS stm,

2927: ste.id ste_id,
2928: ste.amount amount,
2929: stm.kle_id
2930: FROM OKL_STRM_TYPE_B sty,
2931: --OKL_STREAMS stm,
2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2933: OKL_STRM_ELEMENTS ste,
2934: OKL_PROD_STRM_TYPES psty,
2935: OKL_K_HEADERS khr,

Line 2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041

2928: ste.amount amount,
2929: stm.kle_id
2930: FROM OKL_STRM_TYPE_B sty,
2931: --OKL_STREAMS stm,
2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2933: OKL_STRM_ELEMENTS ste,
2934: OKL_PROD_STRM_TYPES psty,
2935: OKL_K_HEADERS khr,
2936: OKL_PRODUCTS pdt

Line 2968: --OKL_STREAMS stm,

2964: ste.id ste_id,
2965: ste.amount amount,
2966: stm.kle_id
2967: FROM OKL_STRM_TYPE_B sty,
2968: --OKL_STREAMS stm,
2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2970: OKL_STRM_ELEMENTS ste,
2971: OKL_PROD_STRM_TYPES psty,
2972: OKL_K_HEADERS khr,

Line 2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041

2965: ste.amount amount,
2966: stm.kle_id
2967: FROM OKL_STRM_TYPE_B sty,
2968: --OKL_STREAMS stm,
2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2970: OKL_STRM_ELEMENTS ste,
2971: OKL_PROD_STRM_TYPES psty,
2972: OKL_K_HEADERS khr,
2973: OKL_PRODUCTS pdt

Line 3005: --OKL_STREAMS stm,

3001: ste.id ste_id,
3002: ste.amount amount,
3003: stm.kle_id
3004: FROM OKL_STRM_TYPE_B sty,
3005: --OKL_STREAMS stm,
3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3007: OKL_STRM_ELEMENTS ste,
3008: OKL_PROD_STRM_TYPES psty,
3009: OKL_K_HEADERS khr,

Line 3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041

3002: ste.amount amount,
3003: stm.kle_id
3004: FROM OKL_STRM_TYPE_B sty,
3005: --OKL_STREAMS stm,
3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3007: OKL_STRM_ELEMENTS ste,
3008: OKL_PROD_STRM_TYPES psty,
3009: OKL_K_HEADERS khr,
3010: OKL_PRODUCTS pdt

Line 4535: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4531: l_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4532: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4533: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4534: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4535: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4536: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4537: l_trx_header_amt NUMBER :=0;
4538: l_fact_sync_code VARCHAR2(2000);
4539: l_inv_acct_code VARCHAR2(2000);

Line 4536: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;

4532: l_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4533: x_khrv_rec Okl_Contract_Pub.khrv_rec_type;
4534: x_chrv_rec Okl_Okc_Migration_Pvt.chrv_rec_type;
4535: l_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4536: x_selv_tbl Okl_Streams_Pub.selv_tbl_type;
4537: l_trx_header_amt NUMBER :=0;
4538: l_fact_sync_code VARCHAR2(2000);
4539: l_inv_acct_code VARCHAR2(2000);
4540: l_scs_code VARCHAR2(2000) := 'LEASE';

Line 5732: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

5728: END IF;
5729:
5730: -- MGAAP start 7263041
5731: IF (l_multi_gaap_yn = 'Y') THEN
5732: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
5733: GET_ACCRUAL_STREAMS(x_return_status => l_return_status
5734: ,x_stream_tbl => l_stream_tbl_rep
5735: ,p_khr_id => l_contract_id
5736: ,p_product_id => l_reporting_pdt_id

Line 5740: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

5736: ,p_product_id => l_reporting_pdt_id
5737: ,p_ctr_start_date => l_start_date
5738: ,p_period_end_date => G_PERIOD_END_DATE_REP
5739: ,p_accrual_rule_yn => 'ACRL_WITH_RULE');
5740: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
5741: -- store the highest degree of error
5742: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
5743: Okl_Api.set_message(p_app_name => g_app_name,
5744: p_msg_name => 'OKL_AGN_STREAM_ERROR',

Line 7452: OKL_STREAMS_UTIL.get_dependent_stream_type(

7448: -- END IF;
7449: -- CLOSE sty_id_csr;
7450:
7451: -- Get the stream type id for variable interest rate product
7452: OKL_STREAMS_UTIL.get_dependent_stream_type(
7453: p_khr_id => l_contract_id,
7454: p_primary_sty_purpose => 'VARIABLE_INTEREST',
7455: p_dependent_sty_purpose => 'VARIABLE_INTEREST_INCOME',
7456: x_return_status => l_return_status,

Line 7471: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

7467:
7468: -- MGAAP 7263041 start
7469: IF (l_multi_gaap_yn = 'Y') THEN
7470: -- Get the stream type id for variable interest rate product
7471: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
7472: p_khr_id => l_contract_id,
7473: p_primary_sty_purpose => 'VARIABLE_INTEREST',
7474: p_dependent_sty_purpose => 'VARIABLE_INTEREST_INCOME',
7475: x_return_status => l_return_status,

Line 8094: OKL_STREAMS_UTIL.get_dependent_stream_type(

8090: END IF;
8091:
8092: IF TRUNC(l_accrual_date) >= TRUNC(l_last_accrual_date) THEN
8093:
8094: OKL_STREAMS_UTIL.get_dependent_stream_type(
8095: p_khr_id => l_contract_id,
8096: p_primary_sty_purpose => 'RENT',
8097: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
8098: x_return_status => l_return_status,

Line 8111: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(

8107: RAISE Okl_Api.G_EXCEPTION_ERROR;
8108: END IF;
8109:
8110: IF (l_multi_gaap_yn = 'Y') THEN
8111: OKL_STREAMS_UTIL.get_dependent_stream_type_rep(
8112: p_khr_id => l_contract_id,
8113: p_primary_sty_purpose => 'RENT',
8114: p_dependent_sty_purpose => 'ACTUAL_INCOME_ACCRUAL',
8115: x_return_status => l_return_status,