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 OKL_SYS_ACCT_OPTS

Line 250: OKL_SYS_ACCT_OPTS b

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
254: -- from okc_k_headers_b

Line 269: lv_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;

265: p_add_precision IN NUMBER,
266: x_amount OUT NOCOPY NUMBER,
267: p_currency_code IN okc_k_headers_b.currency_code%TYPE)
268: RETURN VARCHAR2 AS
269: lv_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE;
270: ln_precision NUMBER;
271: ln_amount NUMBER := p_amount;
272: ln_rounded_amount NUMBER := 0;
273: ln_pos_dot NUMBER;

Line 280: FROM OKL_SYS_ACCT_OPTS;

276: -- g_rounding_error EXCEPTION;
277: -- Get the Rule to Round the amount
278: CURSOR get_rounding_rule IS
279: SELECT stm_rounding_rule
280: FROM OKL_SYS_ACCT_OPTS;
281: BEGIN
282: -- Get the Rule to Round the amount
283: OPEN get_rounding_rule;
284: FETCH get_rounding_rule INTO lv_rounding_rule;

Line 380: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context

376: RAISE g_stop_round_exp;
377: END IF;
378: CLOSE get_org_id;
379: -- we need to set the context since the records in
380: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
381: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
382: -- IF we have diff btw rounding amounts
383: -- now we decide by the below select stmt
384: -- As to where we need to adjust the amount

Line 1999: p_rounding_rule IN okl_sys_acct_opts.stm_rounding_rule%TYPE,

1995: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,
1996: p_org_id IN okc_k_headers_b.authoring_org_id%TYPE,
1997: p_precision IN NUMBER,
1998: p_currency_code IN okc_k_headers_b.currency_code%TYPE,
1999: p_rounding_rule IN okl_sys_acct_opts.stm_rounding_rule%TYPE,
2000: p_apply_rnd_diff IN okl_sys_acct_opts.stm_apply_rounding_difference%TYPE)
2001: RETURN VARCHAR2 IS
2002: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';
2003: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

Line 2000: p_apply_rnd_diff IN okl_sys_acct_opts.stm_apply_rounding_difference%TYPE)

1996: p_org_id IN okc_k_headers_b.authoring_org_id%TYPE,
1997: p_precision IN NUMBER,
1998: p_currency_code IN okc_k_headers_b.currency_code%TYPE,
1999: p_rounding_rule IN okl_sys_acct_opts.stm_rounding_rule%TYPE,
2000: p_apply_rnd_diff IN okl_sys_acct_opts.stm_apply_rounding_difference%TYPE)
2001: RETURN VARCHAR2 IS
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';

Line 2049: OKL_SYS_ACCT_OPTS b

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
2053: -- from okc_k_headers_b

Line 2064: FROM OKL_SYS_ACCT_OPTS;

2060:
2061: --Cursor to fetch the Stream Rounding Rule
2062: CURSOR get_rounding_rule IS
2063: SELECT stm_rounding_rule
2064: FROM OKL_SYS_ACCT_OPTS;
2065:
2066:
2067: -- Local Function to round the amount depending on the
2068: -- Currency code

Line 2074: p_rounding_rule IN okl_sys_acct_opts.ael_rounding_rule%TYPE)

2070: p_add_precision IN NUMBER,
2071: x_amount OUT NOCOPY NUMBER,
2072: p_currency_code IN okc_k_headers_b.currency_code%TYPE,
2073: p_precision IN NUMBER,
2074: p_rounding_rule IN okl_sys_acct_opts.ael_rounding_rule%TYPE)
2075: RETURN VARCHAR2 AS
2076: lv_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE := p_rounding_rule ;
2077: ln_precision NUMBER := p_precision;
2078: ln_amount NUMBER := p_amount;

Line 2076: lv_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE := p_rounding_rule ;

2072: p_currency_code IN okc_k_headers_b.currency_code%TYPE,
2073: p_precision IN NUMBER,
2074: p_rounding_rule IN okl_sys_acct_opts.ael_rounding_rule%TYPE)
2075: RETURN VARCHAR2 AS
2076: lv_rounding_rule okl_sys_acct_opts.ael_rounding_rule%TYPE := p_rounding_rule ;
2077: ln_precision NUMBER := p_precision;
2078: ln_amount NUMBER := p_amount;
2079: ln_rounded_amount NUMBER := 0;
2080: ln_pos_dot NUMBER;

Line 2152: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context

2148: CLOSE get_org_id;
2149: END IF;
2150:
2151: -- we need to set the context since the records in
2152: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
2153: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2154:
2155: --If the apply rounding diff rule is not passed to the function , only
2156: --then is the cursor executed.

Line 2491: x_rounding_rule OUT NOCOPY okl_sys_acct_opts.stm_rounding_rule%TYPE,

2487: PROCEDURE get_acc_options( p_khr_id IN okc_k_headers_b.ID%TYPE,
2488: x_org_id OUT NOCOPY okc_k_headers_b.authoring_org_id%TYPE,
2489: x_precision OUT NOCOPY NUMBER,
2490: x_currency_code OUT NOCOPY okc_k_headers_b.currency_code%TYPE,
2491: x_rounding_rule OUT NOCOPY okl_sys_acct_opts.stm_rounding_rule%TYPE,
2492: x_apply_rnd_diff OUT NOCOPY okl_sys_acct_opts.stm_apply_rounding_difference%TYPE,
2493: x_return_status OUT NOCOPY VARCHAR2 ) IS
2494:
2495: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

Line 2492: x_apply_rnd_diff OUT NOCOPY okl_sys_acct_opts.stm_apply_rounding_difference%TYPE,

2488: x_org_id OUT NOCOPY okc_k_headers_b.authoring_org_id%TYPE,
2489: x_precision OUT NOCOPY NUMBER,
2490: x_currency_code OUT NOCOPY okc_k_headers_b.currency_code%TYPE,
2491: x_rounding_rule OUT NOCOPY okl_sys_acct_opts.stm_rounding_rule%TYPE,
2492: x_apply_rnd_diff OUT NOCOPY okl_sys_acct_opts.stm_apply_rounding_difference%TYPE,
2493: x_return_status OUT NOCOPY VARCHAR2 ) IS
2494:
2495: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
2496: IS

Line 2514: FROM OKL_SYS_ACCT_OPTS;

2510:
2511: CURSOR get_rounding_rule
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

Line 2520: OKL_SYS_ACCT_OPTS b

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:
2524: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

Line 2528: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%type;

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;
2531:
2532: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';