[Home] [Help]
113:
114: CURSOR get_unb_rec_csr(p_sty_id NUMBER) IS
115: SELECT NVL(SUM(ste.amount),0)
116: FROM OKL_STREAMS stm,
117: OKL_STRM_ELEMENTS ste
118: WHERE stm.khr_id = p_ctr_id
119: AND stm.sty_id = p_sty_id
120: AND stm.active_yn = 'Y'
121: AND ste.stm_id = stm.id
421: SELECT 1
422: FROM OKL_STRM_TYPE_B sty,
423: --OKL_STREAMS stm,
424: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
425: OKL_STRM_ELEMENTS ste,
426: OKL_PROD_STRM_TYPES psty,
427: OKL_K_HEADERS khr,
428: OKL_PRODUCTS pdt
429: WHERE khr.id = p_chr_id
1013: FROM OKL_STRM_TYPE_B sty,
1014: OKL_STRM_TYPE_TL stytl,
1015: --OKL_STREAMS stm,
1016: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1017: OKL_STRM_ELEMENTS ste,
1018: OKL_PROD_STRM_TYPES psty,
1019: OKL_K_HEADERS khr
1020: WHERE stm.khr_id = p_ctr_id
1021: AND khr.id = stm.khr_id
1046: FROM OKL_STRM_TYPE_B sty,
1047: OKL_STRM_TYPE_TL stytl,
1048: --OKL_STREAMS stm,
1049: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
1050: OKL_STRM_ELEMENTS ste,
1051: OKL_PROD_STRM_TYPES psty,
1052: OKL_K_HEADERS khr
1053: WHERE stm.khr_id = p_ctr_id
1054: AND khr.id = stm.khr_id
2166: END LOOP;
2167:
2168: -- Do bulk update
2169: FORALL i IN l_selv_tbl.FIRST..l_selv_tbl.LAST
2170: UPDATE okl_strm_elements
2171: SET accrued_yn = 'Y'
2172: ,last_updated_by = FND_GLOBAL.USER_ID -- bug:14742784 Change Starts here
2173: ,last_update_date = sysdate
2174: ,last_update_login = FND_GLOBAL.LOGIN_ID -- bug:14742784 change ends here
2935: -- local collections
2936: TYPE accelerate_ref_cursor IS REF CURSOR;
2937: TYPE stream_rec IS RECORD
2938: (sty_id OKL_STRM_TYPE_V.ID%TYPE,
2939: ste_id OKL_STRM_ELEMENTS_V.ID%TYPE,
2940: amount NUMBER,
2941: kle_id OKL_STREAMS.kle_ID%TYPE
2942: ,stm_id OKL_STREAMS.ID%TYPE ); -- 9001154
2943:
2975: l_counter NUMBER := 1;
2976:
2977: -- Bug 9001154 : Start
2978: l_stm_id OKL_STREAMS.ID%TYPE;
2979: l_max_se_line_no OKL_STRM_ELEMENTS.SE_LINE_NUMBER%TYPE;
2980: lp_selv_rec Okl_Streams_pub.selv_rec_type;
2981: lx_selv_rec Okl_Streams_pub.selv_rec_type;
2982:
2983: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
2981: lx_selv_rec Okl_Streams_pub.selv_rec_type;
2982:
2983: CURSOR max_line_num_csr (p_stm_id NUMBER) IS
2984: SELECT max(se_line_number)
2985: FROM okl_strm_elements
2986: WHERE stm_id = p_stm_id;
2987: -- Bug 9001154 : End
2988: -- Cursor to select the transaction type id for the accrual transaction
2989: CURSOR trx_type_id_csr IS
3081: ,stm.id stm_id -- Bug : 9001154
3082: FROM OKL_STRM_TYPE_B sty,
3083: --OKL_STREAMS stm,
3084: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3085: OKL_STRM_ELEMENTS ste,
3086: OKL_PROD_STRM_TYPES psty,
3087: OKL_K_HEADERS khr,
3088: OKL_PRODUCTS pdt
3089: WHERE sty.id = p_acceleration_rec.sty_id
3119:
3120: FROM OKL_STRM_TYPE_B sty,
3121: --OKL_STREAMS stm,
3122: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3123: OKL_STRM_ELEMENTS ste,
3124: OKL_PROD_STRM_TYPES psty,
3125: OKL_K_HEADERS khr,
3126: OKL_PRODUCTS pdt
3127: WHERE sty.id = p_acceleration_rec.sty_id
3157: ,stm.id stm_id -- Bug : 9001154
3158: FROM OKL_STRM_TYPE_B sty,
3159: --OKL_STREAMS stm,
3160: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3161: OKL_STRM_ELEMENTS ste,
3162: OKL_PROD_STRM_TYPES psty,
3163: OKL_K_HEADERS khr,
3164: OKL_PRODUCTS pdt
3165: WHERE stm.khr_id = p_acceleration_rec.khr_id
3195: ,stm.id stm_id -- Bug : 9001154
3196: FROM OKL_STRM_TYPE_B sty,
3197: --OKL_STREAMS stm,
3198: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3199: OKL_STRM_ELEMENTS ste,
3200: OKL_PROD_STRM_TYPES psty,
3201: OKL_K_HEADERS khr,
3202: OKL_PRODUCTS pdt
3203: WHERE stm.khr_id = p_acceleration_rec.khr_id
6295:
6296: --Bug# 13815781
6297: CURSOR last_accrual_date_csr(p_contract_id NUMBER) IS
6298: SELECT MAX(sel.stream_element_date)
6299: FROM okl_strm_elements sel,
6300: okl_streams stm,
6301: okl_strm_type_b sty
6302: WHERE stm.khr_id = p_contract_id
6303: AND sel.stm_id = stm.id