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_STREAMS_UTIL dependencies on FND_LOOKUPS

Line 205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';

201: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';
202: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
203: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
204: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';

202: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
203: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
204: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
210: ln_grter_amt_ind NUMBER := 0;

Line 207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';

203: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
204: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
210: ln_grter_amt_ind NUMBER := 0;
211: ln_grter_amt NUMBER := 0;

Line 208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';

204: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
210: ln_grter_amt_ind NUMBER := 0;
211: ln_grter_amt NUMBER := 0;
212: ln_tot_no_rnd_amount NUMBER := 0;

Line 220: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE;

216: ln_diff_amount NUMBER := 0;
217: ln_chr_id okc_k_headers_b.id%TYPE := p_chr_id;
218: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;
219: lv_currency_code okc_k_headers_b.currency_code%TYPE;
220: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE;
221: g_stop_round_exp EXCEPTION;
222: ln_precision1 NUMBER;
223: g_rounding_error EXCEPTION;
224: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 246: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)

242:
243: l_selv_tbl Okl_Streams_Pub.selv_tbl_type := p_selv_tbl;
244: -- Get the Rule to Adjust the amount either
245: -- top/bottom/high_value of the PL/SQL tbl record
246: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
247: IS
248: SELECT b.stm_apply_rounding_difference
249: FROM fnd_lookups a,
250: OKL_SYS_ACCT_OPTS b

Line 249: FROM fnd_lookups a,

245: -- top/bottom/high_value of the PL/SQL tbl record
246: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
247: IS
248: SELECT b.stm_apply_rounding_difference
249: FROM fnd_lookups a,
250: OKL_SYS_ACCT_OPTS b
251: WHERE a.lookup_type = p_lookup_type
252: AND a.lookup_code = b.stm_apply_rounding_difference;
253: -- get the currency_code and Authoring_org_id

Line 2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';

2002: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';
2003: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
2004: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2005: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';

2003: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
2004: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2005: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2011: ln_grter_amt_ind NUMBER := 0;

Line 2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';

2004: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2005: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2011: ln_grter_amt_ind NUMBER := 0;
2012: ln_grter_amt NUMBER := 0;

Line 2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';

2005: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2011: ln_grter_amt_ind NUMBER := 0;
2012: ln_grter_amt NUMBER := 0;
2013: ln_tot_no_rnd_amount NUMBER := 0;

Line 2021: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE := p_apply_rnd_diff;

2017: ln_diff_amount NUMBER := 0;
2018: ln_chr_id okc_k_headers_b.id%TYPE := p_chr_id;
2019: ln_org_id okc_k_headers_b.authoring_org_id%TYPE := p_org_id;
2020: lv_currency_code okc_k_headers_b.currency_code%TYPE := p_currency_code;
2021: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE := p_apply_rnd_diff;
2022: lv_rounding_rule fnd_lookups.lookup_code%TYPE := p_rounding_rule;
2023: g_stop_round_exp EXCEPTION;
2024: ln_precision1 NUMBER := p_precision;
2025: g_rounding_error EXCEPTION;

Line 2022: lv_rounding_rule fnd_lookups.lookup_code%TYPE := p_rounding_rule;

2018: ln_chr_id okc_k_headers_b.id%TYPE := p_chr_id;
2019: ln_org_id okc_k_headers_b.authoring_org_id%TYPE := p_org_id;
2020: lv_currency_code okc_k_headers_b.currency_code%TYPE := p_currency_code;
2021: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE := p_apply_rnd_diff;
2022: lv_rounding_rule fnd_lookups.lookup_code%TYPE := p_rounding_rule;
2023: g_stop_round_exp EXCEPTION;
2024: ln_precision1 NUMBER := p_precision;
2025: g_rounding_error EXCEPTION;
2026: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 2045: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)

2041:
2042: l_selv_tbl Okl_Streams_Pub.selv_tbl_type := p_selv_tbl;
2043: -- Get the Rule to Adjust the amount either
2044: -- top/bottom/high_value of the PL/SQL tbl record
2045: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
2046: IS
2047: SELECT b.stm_apply_rounding_difference
2048: FROM fnd_lookups a,
2049: OKL_SYS_ACCT_OPTS b

Line 2048: FROM fnd_lookups a,

2044: -- top/bottom/high_value of the PL/SQL tbl record
2045: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
2046: IS
2047: SELECT b.stm_apply_rounding_difference
2048: FROM fnd_lookups a,
2049: OKL_SYS_ACCT_OPTS b
2050: WHERE a.lookup_type = p_lookup_type
2051: AND a.lookup_code = b.stm_apply_rounding_difference;
2052: -- get the currency_code and Authoring_org_id

Line 2516: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)

2512: IS
2513: SELECT stm_rounding_rule
2514: FROM OKL_SYS_ACCT_OPTS;
2515:
2516: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
2517: IS
2518: SELECT b.stm_apply_rounding_difference
2519: FROM fnd_lookups a,
2520: OKL_SYS_ACCT_OPTS b

Line 2519: FROM fnd_lookups a,

2515:
2516: CURSOR get_rnd_diff_lookup(p_lookup_type fnd_lookups.lookup_type%TYPE)
2517: IS
2518: SELECT b.stm_apply_rounding_difference
2519: FROM fnd_lookups a,
2520: OKL_SYS_ACCT_OPTS b
2521: WHERE a.lookup_type = p_lookup_type
2522: AND a.lookup_code = b.stm_apply_rounding_difference;
2523:

Line 2526: l_diff_lookup_code fnd_lookups.lookup_code%type;

2522: AND a.lookup_code = b.stm_apply_rounding_difference;
2523:
2524: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
2525: l_currency_code okc_k_headers_b.currency_code%type;
2526: l_diff_lookup_code fnd_lookups.lookup_code%type;
2527: l_precision number;
2528: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%type;
2529:
2530: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

Line 2534: G_RND_DIFF_LOOKUP_TYPE CONSTANT FND_LOOKUPS.LOOKUP_TYPE%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';

2530: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2531:
2532: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2533: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2534: G_RND_DIFF_LOOKUP_TYPE CONSTANT FND_LOOKUPS.LOOKUP_TYPE%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2535: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
2536:
2537: BEGIN
2538: -- Get the Org Id, Currency Code