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_STREAMS_PUB

Line 198: p_selv_tbl IN Okl_Streams_Pub.selv_tbl_type,

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';
202: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

Line 199: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)

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

Line 243: l_selv_tbl Okl_Streams_Pub.selv_tbl_type := p_selv_tbl;

239: AND enabled_flag = 'Y'
240: AND NVL(start_date_active, SYSDATE) <= SYSDATE
241: AND NVL(end_date_active, SYSDATE) >= SYSDATE;
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

Line 1994: p_selv_tbl IN okl_streams_pub.selv_tbl_type,

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,
1998: p_currency_code IN okc_k_headers_b.currency_code%TYPE,

Line 1995: x_selv_tbl OUT NOCOPY okl_streams_pub.selv_tbl_type,

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

Line 2042: l_selv_tbl Okl_Streams_Pub.selv_tbl_type := p_selv_tbl;

2038: AND enabled_flag = 'Y'
2039: AND NVL(start_date_active, SYSDATE) <= SYSDATE
2040: AND NVL(end_date_active, SYSDATE) >= SYSDATE;
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

Line 2630: p_stmv_rec IN Okl_Streams_Pub.stmv_rec_type,

2626: -- Added by RGOOTY: Start
2627: --Modified bu kthiruva on 30-May-2005. The OUT param was made NOCOPY
2628: --Bug 4374085 - Start of Changes
2629: PROCEDURE accumulate_strm_headers(
2630: p_stmv_rec IN Okl_Streams_Pub.stmv_rec_type,
2631: x_full_stmv_tbl IN OUT NOCOPY Okl_Streams_Pub.stmv_tbl_type,
2632: x_return_status OUT NOCOPY VARCHAR2)
2633: --Bug 4374085 - End of Change
2634: AS

Line 2631: x_full_stmv_tbl IN OUT NOCOPY Okl_Streams_Pub.stmv_tbl_type,

2627: --Modified bu kthiruva on 30-May-2005. The OUT param was made NOCOPY
2628: --Bug 4374085 - Start of Changes
2629: PROCEDURE accumulate_strm_headers(
2630: p_stmv_rec IN Okl_Streams_Pub.stmv_rec_type,
2631: x_full_stmv_tbl IN OUT NOCOPY Okl_Streams_Pub.stmv_tbl_type,
2632: x_return_status OUT NOCOPY VARCHAR2)
2633: --Bug 4374085 - End of Change
2634: AS
2635: stmv_count NUMBER;

Line 2678: p_selv_tbl IN okl_streams_pub.selv_tbl_type,

2674: --Modified bu kthiruva on 30-May-2005. The OUT param was made NOCOPY
2675: --Bug 4374085 - Start of Changes
2676: PROCEDURE accumulate_strm_elements(
2677: p_stm_index_no IN NUMBER,
2678: p_selv_tbl IN okl_streams_pub.selv_tbl_type,
2679: x_full_selv_tbl IN OUT NOCOPY okl_streams_pub.selv_tbl_type,
2680: x_return_status OUT NOCOPY VARCHAR2)
2681: --Bug 4374085 - End of Changes
2682: AS

Line 2679: x_full_selv_tbl IN OUT NOCOPY okl_streams_pub.selv_tbl_type,

2675: --Bug 4374085 - Start of Changes
2676: PROCEDURE accumulate_strm_elements(
2677: p_stm_index_no IN NUMBER,
2678: p_selv_tbl IN okl_streams_pub.selv_tbl_type,
2679: x_full_selv_tbl IN OUT NOCOPY okl_streams_pub.selv_tbl_type,
2680: x_return_status OUT NOCOPY VARCHAR2)
2681: --Bug 4374085 - End of Changes
2682: AS
2683: selv_count NUMBER;