2242: VALUES
2243: (
2244: l_idh_id,
2245: 1,
2246: Fnd_Global.USER_ID,
2247: SYSDATE,
2248: Fnd_Global.USER_ID,
2249: SYSDATE,
2250: Fnd_Global.LOGIN_ID,
2244: l_idh_id,
2245: 1,
2246: Fnd_Global.USER_ID,
2247: SYSDATE,
2248: Fnd_Global.USER_ID,
2249: SYSDATE,
2250: Fnd_Global.LOGIN_ID,
2251: inv_lease_k_rec.Investor_Agreement_id,
2252: share_rec.TOP_LINE_ID,
2246: Fnd_Global.USER_ID,
2247: SYSDATE,
2248: Fnd_Global.USER_ID,
2249: SYSDATE,
2250: Fnd_Global.LOGIN_ID,
2251: inv_lease_k_rec.Investor_Agreement_id,
2252: share_rec.TOP_LINE_ID,
2253: rcpts_rec.tld_id,
2254: rcpts_rec.receivable_application_id,
2338: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.1 ### ');
2339: --ssiruvol Bug 5000886 start
2340: UPDATE okl_strm_elements
2341: SET date_billed = SYSDATE
2342: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2343: ,last_update_date = sysdate
2344: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2345: WHERE id = tld_succ_log_table(i).proc_sel_id;
2346:
2340: UPDATE okl_strm_elements
2341: SET date_billed = SYSDATE
2342: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2343: ,last_update_date = sysdate
2344: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2345: WHERE id = tld_succ_log_table(i).proc_sel_id;
2346:
2347: UPDATE OKL_TXD_AR_LN_DTLS_B
2348: SET investor_disb_status = 'PROCESSED'
2362: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 43.3 ### ');
2363:
2364: UPDATE okl_strm_elements
2365: SET date_billed = SYSDATE
2366: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2367: ,last_update_date = sysdate
2368: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2369: WHERE id = tld_succ_log_table(i).proc_sel_id;
2370:
2364: UPDATE okl_strm_elements
2365: SET date_billed = SYSDATE
2366: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2367: ,last_update_date = sysdate
2368: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2369: WHERE id = tld_succ_log_table(i).proc_sel_id;
2370:
2371: UPDATE OKL_TXD_AR_LN_DTLS_B
2372: SET investor_disb_status = 'PROCESSED'
2413: IF l_strm_ele_id_tbl.COUNT > 0 THEN
2414: FORALL indx in l_strm_ele_id_tbl.FIRST .. l_strm_ele_id_tbl.LAST
2415: UPDATE okl_strm_elements
2416: SET date_billed = SYSDATE--l_date_billed_tbl(indx);
2417: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 Change start here
2418: ,last_update_date = sysdate
2419: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2420: WHERE id = l_strm_ele_id_tbl(indx);
2421: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2415: UPDATE okl_strm_elements
2416: SET date_billed = SYSDATE--l_date_billed_tbl(indx);
2417: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 Change start here
2418: ,last_update_date = sysdate
2419: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2420: WHERE id = l_strm_ele_id_tbl(indx);
2421: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2422: strm_ele_idx:=1;
2423: END IF;
2452: IF l_strm_ele_id_tbl.COUNT > 0 THEN
2453: FORALL indx in l_strm_ele_id_tbl.FIRST .. l_strm_ele_id_tbl.LAST
2454: UPDATE okl_strm_elements
2455: SET date_billed = SYSDATE
2456: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2457: ,last_update_date = sysdate
2458: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 Change end here
2459: WHERE id = l_strm_ele_id_tbl(indx);
2460: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2454: UPDATE okl_strm_elements
2455: SET date_billed = SYSDATE
2456: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 change start here
2457: ,last_update_date = sysdate
2458: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 Change end here
2459: WHERE id = l_strm_ele_id_tbl(indx);
2460: l_strm_ele_id_tbl:=l_temp_ele_id_tbl;
2461: strm_ele_idx:=1;
2462: END IF;