APPS.OKL_STREAMS_UTIL dependencies on OKL_STREAM_TRX_DATA

Line 2873: from okl_stream_trx_data a,

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

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 3061: update okl_stream_trx_data

3057: open get_prim_trx(p_khr_id);
3058: fetch get_prim_trx into l_trx_number;
3059: close get_prim_trx;
3060:
3061: update okl_stream_trx_data
3062: set last_trx_state = 'Y'
3063: where orig_khr_id = p_khr_id
3064: and transaction_number = l_trx_number;
3065:

Line 3066: update okl_stream_trx_data a

3062: set last_trx_state = 'Y'
3063: where orig_khr_id = p_khr_id
3064: and transaction_number = l_trx_number;
3065:
3066: update okl_stream_trx_data a
3067: set a.last_trx_state = NULL
3068: where a.orig_khr_id = p_khr_id
3069: and a.transaction_number < l_trx_number
3070: and a.last_trx_state = 'Y'

Line 3085: update okl_stream_trx_data

3081: fetch get_rep_trx into l_trx_number;
3082: close get_rep_trx;
3083:
3084: if l_trx_number is not null then
3085: update okl_stream_trx_data
3086: set last_trx_state = 'Y'
3087: where orig_khr_id = p_khr_id
3088: and transaction_number = l_trx_number;
3089:

Line 3090: update okl_stream_trx_data a

3086: set last_trx_state = 'Y'
3087: where orig_khr_id = p_khr_id
3088: and transaction_number = l_trx_number;
3089:
3090: update okl_stream_trx_data a
3091: set a.last_trx_state = NULL
3092: where a.orig_khr_id = p_khr_id
3093: and a.transaction_number < l_trx_number
3094: and a.last_trx_state = 'Y'

Line 3167: FROM okl_stream_trx_data a,

3163: CURSOR get_clob(p_contract_id IN NUMBER,
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