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_STREAM_INTERFACES

Line 1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,

1771:
1772: -- Gets the status of the stream generation request for external generator
1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )

Line 1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,

1772: -- Gets the status of the stream generation request for external generator
1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS

Line 1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,

1773: PROCEDURE get_transaction_status
1774: (
1775: p_transaction_number IN okl_stream_interfaces.transaction_number%TYPE,
1776: x_transaction_status OUT NOCOPY okl_stream_interfaces.sis_code%TYPE,
1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;

Line 1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;

1777: x_logfile_name OUT NOCOPY okl_stream_interfaces.log_file%TYPE,
1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;
1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS

Line 1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;

1778: x_return_status OUT NOCOPY VARCHAR2
1779: )
1780: IS
1781: l_transaction_status okl_stream_interfaces.sis_code%TYPE := null;
1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS
1786: SELECT sis_code, log_file FROM okl_stream_interfaces

Line 1786: SELECT sis_code, log_file FROM okl_stream_interfaces

1782: l_logfile_name okl_stream_interfaces.log_file%TYPE := null;
1783:
1784: CURSOR intf_status_csr(trx_number NUMBER)
1785: IS
1786: SELECT sis_code, log_file FROM okl_stream_interfaces
1787: WHERE transaction_number = trx_number;
1788:
1789: BEGIN
1790:

Line 2755: p_trx_number IN okl_stream_interfaces.TRANSACTION_NUMBER%TYPE,

2751: -- Version : kthiruva 1.0 Created
2752: -- End of Commnets
2753: --------------------------------------------------------------------------------
2754: PROCEDURE get_line_id(
2755: p_trx_number IN okl_stream_interfaces.TRANSACTION_NUMBER%TYPE,
2756: p_index_number IN okl_sif_ret_levels.INDEX_NUMBER%TYPE,
2757: x_kle_id OUT NOCOPY NUMBER,
2758: x_return_status OUT NOCOPY VARCHAR2)
2759: AS

Line 2767: OKL_STREAM_INTERFACES SIFB,

2763: IS
2764: SELECT SILB.KLE_ID
2765: FROM OKL_SIF_RET_LEVELS SRLB,
2766: OKL_SIF_RETS SIRB,
2767: OKL_STREAM_INTERFACES SIFB,
2768: OKL_SIF_LINES SILB
2769: WHERE SIFB.TRANSACTION_NUMBER = p_trx_number
2770: AND SIRB.TRANSACTION_NUMBER = SIFB.TRANSACTION_NUMBER
2771: AND SILB.SIF_ID = SIFB.ID

Line 2874: okl_stream_interfaces b

2870: cursor get_clob(p_contract_id IN NUMBER,
2871: p_purpose_code IN VARCHAR2) IS
2872: select length(a.transaction_state)
2873: from okl_stream_trx_data a,
2874: okl_stream_interfaces b
2875: where a.orig_khr_id = p_contract_id
2876: and a.last_trx_state = 'Y'
2877: and a.transaction_number = b.transaction_number
2878: and nvl(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line 2882: from okl_stream_interfaces

2878: and nvl(b.purpose_code, 'PRIMARY') = p_purpose_code;
2879:
2880: cursor get_trx_contract(p_trx_id IN NUMBER) IS
2881: select khr_id, nvl(purpose_code, 'PRIMARY') purpose_code
2882: from okl_stream_interfaces
2883: where transaction_number = p_trx_id;
2884:
2885: cursor is_erd_enabled(p_trx_number IN NUMBER ) IS
2886: select nvl(sao.amort_inc_adj_rev_dt_yn, 'N') erd

Line 2890: ,okl_stream_interfaces osi

2886: select nvl(sao.amort_inc_adj_rev_dt_yn, 'N') erd
2887: ,gts.deal_type
2888: ,gts.interest_calc_meth_code
2889: from okl_sys_acct_opts_all sao
2890: ,okl_stream_interfaces osi
2891: ,okc_k_headers_all_b chr
2892: ,okl_k_headers khr
2893: ,okl_products pdt
2894: ,okl_ae_tmpt_sets_all aes

Line 3005: from okl_stream_trx_data std, okl_stream_interfaces osi

3001: l_trx_number number;
3002:
3003: cursor get_prim_trx(p_khr_id number) IS
3004: select max(std.transaction_number)
3005: from okl_stream_trx_data std, okl_stream_interfaces osi
3006: where std.orig_khr_id = p_khr_id
3007: and std.transaction_number = osi.transaction_number
3008: and osi.purpose_code is NULL;
3009:

Line 3012: from okl_stream_trx_data std, okl_stream_interfaces osi

3008: and osi.purpose_code is NULL;
3009:
3010: cursor get_rep_trx(p_khr_id number) IS
3011: select max(std.transaction_number)
3012: from okl_stream_trx_data std, okl_stream_interfaces osi
3013: where std.orig_khr_id = p_khr_id
3014: and std.transaction_number = osi.transaction_number
3015: and osi.purpose_code is NOT NULL;
3016:

Line 3072: from okl_stream_interfaces b

3068: where a.orig_khr_id = p_khr_id
3069: and a.transaction_number < l_trx_number
3070: and a.last_trx_state = 'Y'
3071: and EXISTS (select b.transaction_number
3072: from okl_stream_interfaces b
3073: where b.transaction_number = a.transaction_number
3074: and b.purpose_code is NULL);
3075: end if;
3076:

Line 3096: from okl_stream_interfaces b

3092: where a.orig_khr_id = p_khr_id
3093: and a.transaction_number < l_trx_number
3094: and a.last_trx_state = 'Y'
3095: and EXISTS (select b.transaction_number
3096: from okl_stream_interfaces b
3097: where b.transaction_number = a.transaction_number
3098: and b.purpose_code is NOT NULL);
3099:
3100: end if; -- if l_trx_number is not null

Line 3112: from okl_stream_interfaces osi

3108: FUNCTION GET_ORP_CODE(p_trx_id IN number) RETURN VARCHAR2 IS
3109:
3110: cursor get_orp_code_csr(p_trx_number IN NUMBER ) IS
3111: select osi.orp_code
3112: from okl_stream_interfaces osi
3113: Where osi.transaction_number = p_trx_number;
3114:
3115: l_orp_code VARCHAR2(300);
3116: begin

Line 3146: FROM okl_stream_interfaces osi

3142: ,gts.deal_type deal_type
3143: ,gts.interest_calc_meth_code interest_calc_meth_code
3144: ,osi.date_delivery reamort_date
3145: ,siyb.target_value target_value
3146: FROM okl_stream_interfaces osi
3147: ,okl_sif_yields siyb
3148: ,okc_k_headers_all_b chr
3149: ,okl_k_headers khr
3150: ,okl_products pdt

Line 3168: okl_stream_interfaces b

3164: p_purpose_code IN VARCHAR2)
3165: IS
3166: SELECT a.transaction_state
3167: FROM okl_stream_trx_data a,
3168: okl_stream_interfaces b
3169: WHERE a.orig_khr_id = p_contract_id
3170: AND a.last_trx_state = 'Y'
3171: AND a.transaction_number = b.transaction_number
3172: AND nvl(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line 3228: FROM OKL_STREAM_INTERFACES

3224: IS
3225: CURSOR get_contract_id
3226: IS
3227: SELECT KHR_ID, DEAL_TYPE
3228: FROM OKL_STREAM_INTERFACES
3229: WHERE TRANSACTION_NUMBER = p_trx_id;
3230:
3231: CURSOR chk_rbk_rel_csr (p_contract_id IN NUMBER)
3232: IS