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 OKC_K_HEADERS_B

Line 197: p_chr_id IN okc_k_headers_b.id%TYPE,

193: FUNCTION Round_Streams_Amount(p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_chr_id IN okc_k_headers_b.id%TYPE,
198: p_selv_tbl IN Okl_Streams_Pub.selv_tbl_type,
199: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)
200: RETURN VARCHAR2 IS
201: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';

Line 217: ln_chr_id okc_k_headers_b.id%TYPE := p_chr_id;

213: ln_tot_rnd_amount NUMBER := 0;
214: ln_rounded_amount NUMBER := 0;
215: ln_rnd_diff_amount NUMBER := 0;
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;

Line 218: ln_org_id okc_k_headers_b.authoring_org_id%TYPE;

214: ln_rounded_amount NUMBER := 0;
215: ln_rnd_diff_amount NUMBER := 0;
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;

Line 219: lv_currency_code okc_k_headers_b.currency_code%TYPE;

215: ln_rnd_diff_amount NUMBER := 0;
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;

Line 235: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS

231: --Bug 4048047 - End of Changes
232:
233: -- Get the precision for the amounts to Round
234: -- Depending on the Currency code
235: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
236: SELECT PRECISION
237: FROM fnd_currencies_vl
238: WHERE currency_code = p_currency_code
239: AND enabled_flag = 'Y'

Line 254: -- from okc_k_headers_b

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
255: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
256: IS
257: SELECT authoring_org_id,
258: currency_code

Line 255: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

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
255: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
256: IS
257: SELECT authoring_org_id,
258: currency_code
259: FROM okc_k_headers_b

Line 259: FROM okc_k_headers_b

255: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
256: IS
257: SELECT authoring_org_id,
258: currency_code
259: FROM okc_k_headers_b
260: WHERE id = p_chr_id;
261:
262: -- Local Function to round the amount depending on the
263: -- Currency code

Line 267: p_currency_code IN okc_k_headers_b.currency_code%TYPE)

263: -- Currency code
264: FUNCTION round_amount(p_amount IN NUMBER,
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;

Line 1993: p_chr_id IN okc_k_headers_b.id%TYPE,

1989: FUNCTION round_streams_amount_esg(p_api_version IN NUMBER,
1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1991: x_msg_count OUT NOCOPY NUMBER,
1992: x_msg_data OUT NOCOPY VARCHAR2,
1993: p_chr_id IN okc_k_headers_b.id%TYPE,
1994: p_selv_tbl IN okl_streams_pub.selv_tbl_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,

Line 1996: p_org_id IN okc_k_headers_b.authoring_org_id%TYPE,

1992: x_msg_data OUT NOCOPY VARCHAR2,
1993: p_chr_id IN okc_k_headers_b.id%TYPE,
1994: p_selv_tbl IN okl_streams_pub.selv_tbl_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)

Line 1998: p_currency_code IN okc_k_headers_b.currency_code%TYPE,

1994: p_selv_tbl IN okl_streams_pub.selv_tbl_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';

Line 2018: ln_chr_id okc_k_headers_b.id%TYPE := p_chr_id;

2014: ln_tot_rnd_amount NUMBER := 0;
2015: ln_rounded_amount NUMBER := 0;
2016: ln_rnd_diff_amount NUMBER := 0;
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;

Line 2019: ln_org_id okc_k_headers_b.authoring_org_id%TYPE := p_org_id;

2015: ln_rounded_amount NUMBER := 0;
2016: ln_rnd_diff_amount NUMBER := 0;
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;

Line 2020: lv_currency_code okc_k_headers_b.currency_code%TYPE := p_currency_code;

2016: ln_rnd_diff_amount NUMBER := 0;
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;

Line 2034: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS

2030: l_max_date DATE;
2031:
2032: -- Get the precision for the amounts to Round
2033: -- Depending on the Currency code
2034: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE) IS
2035: SELECT PRECISION
2036: FROM fnd_currencies_vl
2037: WHERE currency_code = p_currency_code
2038: AND enabled_flag = 'Y'

Line 2053: -- from okc_k_headers_b

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
2054: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
2055: IS
2056: SELECT authoring_org_id,
2057: currency_code

Line 2054: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)

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
2054: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
2055: IS
2056: SELECT authoring_org_id,
2057: currency_code
2058: FROM okc_k_headers_b

Line 2058: FROM okc_k_headers_b

2054: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
2055: IS
2056: SELECT authoring_org_id,
2057: currency_code
2058: FROM okc_k_headers_b
2059: WHERE id = p_chr_id;
2060:
2061: --Cursor to fetch the Stream Rounding Rule
2062: CURSOR get_rounding_rule IS

Line 2072: p_currency_code IN okc_k_headers_b.currency_code%TYPE,

2068: -- Currency code
2069: FUNCTION round_amount(p_amount IN NUMBER,
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 ;

Line 2487: PROCEDURE get_acc_options( p_khr_id IN okc_k_headers_b.ID%TYPE,

2483: END round_streams_amount_esg;
2484: --Bug 4196515-End of Changes
2485:
2486: -- Added by RGOOTY: Start
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,

Line 2488: x_org_id OUT NOCOPY okc_k_headers_b.authoring_org_id%TYPE,

2484: --Bug 4196515-End of Changes
2485:
2486: -- Added by RGOOTY: Start
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,

Line 2490: x_currency_code OUT NOCOPY okc_k_headers_b.currency_code%TYPE,

2486: -- Added by RGOOTY: Start
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:

Line 2495: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%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
2497: SELECT authoring_org_id,
2498: currency_code
2499: FROM okc_k_headers_b

Line 2499: FROM okc_k_headers_b

2495: CURSOR get_org_id(p_chr_id okc_k_headers_b.id%TYPE)
2496: IS
2497: SELECT authoring_org_id,
2498: currency_code
2499: FROM okc_k_headers_b
2500: WHERE id = p_chr_id;
2501:
2502: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
2503: IS

Line 2502: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)

2498: currency_code
2499: FROM okc_k_headers_b
2500: WHERE id = p_chr_id;
2501:
2502: CURSOR get_precision(p_currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE)
2503: IS
2504: SELECT PRECISION
2505: FROM fnd_currencies_vl
2506: WHERE currency_code = p_currency_code

Line 2524: l_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

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

Line 2525: l_currency_code okc_k_headers_b.currency_code%type;

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