682:
683: ELSE
684: UPDATE okl_strm_elements
685: SET date_billed = SYSDATE
686: ,last_updated_by = FND_GLOBAL.USER_ID --Bug: 14742784 changes start here
687: ,last_update_date = sysdate
688: ,last_update_login = FND_GLOBAL.LOGIN_ID -- Bug: 14742784 changes end here
689: WHERE id = adj_streams_rec.sel_id;
690: END IF;
684: UPDATE okl_strm_elements
685: SET date_billed = SYSDATE
686: ,last_updated_by = FND_GLOBAL.USER_ID --Bug: 14742784 changes start here
687: ,last_update_date = sysdate
688: ,last_update_login = FND_GLOBAL.LOGIN_ID -- Bug: 14742784 changes end here
689: WHERE id = adj_streams_rec.sel_id;
690: END IF;
691: END IF;
692:
909: END LOOP;
910: ELSE
911: UPDATE okl_strm_elements
912: SET date_billed = SYSDATE
913: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG: 14742784 changes start here
914: ,last_update_date = sysdate
915: ,last_update_login = FND_GLOBAL.LOGIN_ID --BUG:14742784 changes end here
916: WHERE id = adj_streams_rec.sel_id;
917: END IF;
911: UPDATE okl_strm_elements
912: SET date_billed = SYSDATE
913: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG: 14742784 changes start here
914: ,last_update_date = sysdate
915: ,last_update_login = FND_GLOBAL.LOGIN_ID --BUG:14742784 changes end here
916: WHERE id = adj_streams_rec.sel_id;
917: END IF;
918:
919:
945: END LOOP;
946: ELSE
947: UPDATE okl_strm_elements
948: SET date_billed = SYSDATE
949: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG: 14742784 changes start here
950: ,last_update_date = sysdate
951: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 changes end here
952: WHERE id = adj_streams_rec.sel_id;
953: END IF;
947: UPDATE okl_strm_elements
948: SET date_billed = SYSDATE
949: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG: 14742784 changes start here
950: ,last_update_date = sysdate
951: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 changes end here
952: WHERE id = adj_streams_rec.sel_id;
953: END IF;
954: END IF;
955:
1350: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1351: ELSE
1352: UPDATE okl_strm_elements
1353: SET date_billed = SYSDATE
1354: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here
1355: ,last_update_date = sysdate
1356: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 changes end here
1357: WHERE id = adj_streams_rec.sel_id;
1358: END IF;
1352: UPDATE okl_strm_elements
1353: SET date_billed = SYSDATE
1354: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here
1355: ,last_update_date = sysdate
1356: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 changes end here
1357: WHERE id = adj_streams_rec.sel_id;
1358: END IF;
1359:
1360:
1455: FND_FILE.PUT_LINE (FND_FILE.LOG, 'ERROR Creating Billing Transactions.');
1456: ELSE
1457: UPDATE okl_strm_elements
1458: SET date_billed = SYSDATE
1459: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here
1460: ,last_update_date = sysdate
1461: ,last_update_login = FND_GLOBAL.LOGIN_ID --BUG:14742784 changes end here
1462: WHERE id = adj_streams_rec.sel_id;
1463: END IF;
1457: UPDATE okl_strm_elements
1458: SET date_billed = SYSDATE
1459: ,last_updated_by = FND_GLOBAL.USER_ID -- BUG:14742784 changes start here
1460: ,last_update_date = sysdate
1461: ,last_update_login = FND_GLOBAL.LOGIN_ID --BUG:14742784 changes end here
1462: WHERE id = adj_streams_rec.sel_id;
1463: END IF;
1464:
1465:
1549:
1550:
1551: CURSOR req_id_csr IS
1552: SELECT
1553: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID)
1554: FROM dual;
1555:
1556:
1557: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS